ASP.NET/MSSQL/ MVC completing backend solution + integrating with frontend.
Project Description:
System is used for tracking company's activities through several projects by keeping track of incomes and expenses per project.
This project is fairly simple but is time critical so If you do not have the time to work fully from tomorrow do not respond to this project.
If you have not read the project description - do not respond to this project - Auto answer will not be accepted because I want the hardworking freelancers that really take the time to read project descriptions to be honored. This project will not be done in PHP, only mvc/ asp.net so please do not respond if you can't do that.
Important: I will give a 40% done backend solution + a working frontend/css/html/jquery/ajax.
What you require to do is to get the backend solution up and integrate and running it with the frontend.
General description
- System will hold number of Companies. Each Company will have number of Projects assigned to it. Every Project will have number of Incomes (stuff sold) and a number of Expenses (stuff purchased). Also, Projects will be explained by some general info (name, dates, notes, etc.) and Users could be able to save Projects snapshots at any point of time.
- Users could be able to create and edit: Projects, Companies, Incomes, Expenses.
- Users should be able to view several reports/comparisons/ charts (incomes/expenses for Projects over some period of time, e.g.)
Detailed Feature list will be provided to you when we have talked about the project.
Technology notes
System should be done using:
- server side: MVC 3, Microsoft ASP.NET, MS SQL 2008 R2 or MS SQL 2012 R2
- client side: jquery (and jquery widgets if needed)
- there could be no SQL queries in application code. Stored procedures should be used instead
- there could be no datasets used. Business layer should be used instead and stored procedures results bound to business objects
- mvc pattern should be deliveries and follow should contain separate DLLs for web presentation layer and for business layer. Data access layer and business layer will be merged into one
Db Structure
I may supply a proposed DB structure but you will propose different structure if you have better ideas.
Skills required:
ASP, .NET, MVC