This should be a small software to manage a computer shop goods.
All items that is buyed from the reseller should be loaded into goods table, and when are sold to its customer should be downloaded from the table. Some additional table to contain data are needed like distibutor, vendor, customer, vat table and so on.
Some reports should be generated to help computer shopper to print its data (about 5).
The project is based on creation of 10 main forms (4 forms are used to supply data rarely) and 2 details forms to link data beetween data (that can be done upon two of the previous forms). May be some forms can be added, but actually there are 10.
There are few parameters that we can discuss along the way.
Solution should be provided in this way:
- Winform project with data insert check constraints.
- c# 2.0 code with full source code released
- 3 tier infrastructure built in separate dll, data should pass between the DataLayer dll and the ObjectDataSource .net provider, so a future database switch can be done without problems.
- use only .net 2005 components.
On your side the payment will be done via escrow so you can be sure to get your money when the works end.
Attached there is the db structure (SQL 2005 express) that should be used to create the project. That is just the structure, no trigger as well as no constraints has been created except the relationship.
Project it's a very small project.
Since the previous provider said me that he was able to complete the project, but she misunderstanded the environment that would have to use, I post another project, so meanwhile staff unlock the old one, I can have the possibility to look for a new service provider and start the project with him/her.
Payment will do via escrow that will be upload as soon as the old project will be closed and GAF's staff explain me how to get back money and transfer to the new project.