Quote Generator
$30-5000 USD
Paid on delivery
Creation of a Quote Generator in ASP.NET.
The application will be approximately 5 pages and needs to be written using Visual Studio 2005 or 2008, C#, and Sql Express 2005 or 2008.
## Deliverables
Required Tables:
| **TABLE? ** | **FIELDS**? all are varchar unless noted |
| ? Products | ? CatalogNum, ProductName, ProductDescrip, Manufac, Vendor, SystemCatNum, Required, Type, Comment |
| ? QuoteHdr | ? QuoteNum, Date, QuoteTitle, CustName, CustAddr, CustContact, CustPhone, CustFax, CustEmail, CustDept, BillTo, ShipTo, CreatedBy, DateRequestedDelivery |
| ? QuoteDet | ? QuoteNum,? CatalogNum, ProductName, ProductDescrip, Manufac, Vendor, SystemCatNum, Required, Type, Comment, NetCost(decimal for money), AdditionalCharge(decimal for money), MiscCharge(decimal for money), ExpanationMiscCharge |
Required Pages:
| **Page** **? ** | **Description**? |
| ? [login to view URL] | ? Simple login page, one shared password for all users |
| ? [login to view URL] | ? Page to collect all of the information required to create a row in the QuoteHdr table and related row(s) in the QuoteDet table. ?
The Product table is used to lookup products to fill the QuoteDet rows. |
| ? [login to view URL] | ? A page to allow the user to search for, and edit an existing quote. ? It also needs to allow them to clone an existing quote to a new one. |
| ? [login to view URL] | ? The page to view and/or print a quote |
| ? [login to view URL] | ? A page to allow the user ? to create, update, and delete rows in the Products table |
Notes:
* The generated QuoteNum needs to be CustName+yyMMddhhmmss (i.e. JoesCompany100901110521), this is also true when a quote gets cloned.
* The total on the quote can just be the total of all the money fields (We will change this later).
Project ID: #3695592