Looking for web application that can uses a sql server database as backend and webpages on frontend to track clients and contracts sold by clients.
1. Setup SQL database and IIS so that data is captured in database and webpages function on jschmuck.com. I have Windows 2008 R2 server setup on rackspace account you can use.
2. Create webpage so that users login and see items based on roles.
3. Track clients
a. Create webpage where user with role “Manage Clients” can do the following:
i. Add new client to client table
ii. Update client in the client table
iii. Delete client in the client table
4. Track contracts sold by clients
a. Create webpage where user with role “Import Contract Data” can do the following
i. Force user to specify source of file – 4 sources, each source gives file in unique format. Must build SSIS package for each.
ii. Allow user to select file and attempt to upload the data in file to contracts table
iii. If file not in correct format, or if data doesn’t match expected types, reject upload and tell user of error.
iv. If file uploads successfully, display successful upload message and store the original uploaded file in directory on server.
v. Database should keep table showing upload attempts, file attempted, and result, who, datetime
vi. Database should keep table(s) of contract data uploaded
b. Create webpage where users can search contracts in database
i. Should let users search on contract ID, customer lastname, or last 6 of VIN
ii. Role comes into play – users can only search client codes assigned to them
24 freelancer đang chào giá trung bình $1477 cho công việc này
Hello, thank you for the invitation! We have very rich experience in .NET Framework based software development and would be very glad to work with you again. Please, check PM for more details!
Hello Sir/Mam We can do this project for you. Our bid is tentative right now, we will finalize bid amount once specifications are discussed and finalized.