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
30 freelancers are bidding on average $213 for this job
I can able give you with ASP.net authentication and authorisation with auth2 tokens also can deliver the applications with latest bootstrap and entity framework.
hello .... i am expert with 5 year of work experience. I am interested in your project, please message me to discuss further. Relevant Skills and Experience ASP.NET Proposed Milestones $25 USD - Final