Build small asp.net MVC app using bootstrap and SQL Server as back end database with following features:
1. User authetnication: role based (with password change and forgetten password retrieve). Authetnnication done through table "Employee
" using EmployeeID or Email + password(Hashed)
2. CRUD: Create, Retrieve, Update and delete (Ajax based) (all operations on "customer" table)
Valiadtions shoule be exist basedon Roles specified below + regular validations for values like email should be correct.
3. Search on customer columns: Name (Partial), Account Code (Partial), Branch (Drop List) and Employee (DropList). Default for dropboxes is "All" (when selecting Branch, only employees in that branch will be shown).
The database contains the following tables:
1. Employee (EmployeeID,Name,Email,Password, BranchID,LastLogin), Role (RoleID,Name), EmployeeRole(EmployeeId,RoleID) (the employee has multiple roles). Employee, Role and UserRole will be entred through database directly (no need for development)
2. Customer (CustomerID,Name,Account Code,Credit Limit,Credit Days,SalesmanID=EmployeeID, CreatedOn, CreatedBy, LastUpdated, UpdatedBy), Branch (BranchID,Name)
When the employee login, he will see list of customers related to his branch (also, he will be able to add/edit for his branch)
There are two main roles: accountant and sales
Sales can do all operations except he can't edit/update Account Code,Credit Limit and Credit Days.
Accountant can do search and edit Account Code,Credit Limit and Credit Days.
See attached database scripts
28 freelancers are bidding on average $218 for this job
i have 3yr experience in C#,.NET,MVC and i have done more projects in .NET . Relevant Skills and Experience C#,.NET,MVC Proposed Milestones $15 USD - starting project