I wish a simple ASPX website with the following specifications:
- user login/registration Users will be 2 categories: normal user and Supplier
If NORMAL USER is logged in:
- insert content of an invoice received from a supplier (supplier name,.., item names, quantities, prices,...(items in a ajax grid))
- iten name column in grid will be as lookup combobox with a solution to fast insert is new entrry
- when a row is saved:
- seek a similar item, on name, (on "databaseGeneral" and show a small box with grid with: supplier name, product name, price, update date
- when invoice will be saved
- save data to userDatabase
- save to "databaseGeneral" columns that should be shown (suplier name,.., item names, quantities, prices,...)
- ask to print/save PDF/email PDF (format is like as an invoice, with some small differents)
UserDatabase is a SQLCompact4 database and "databaseGeneral" is a MySQL database
If logged user is a supplier :
- insert its data contact: name, www, email, phone, e.g.
- insert its products offer (item name, packing mode, item price, validity date)
This user insert data into DatabaseGeneral
On "normal" user registration, automatically create UserDatabase.
App with be AJAX enabled, will be made with VS>=2010.
SQL structure with be supplied to winner.