A simple database application for products and subparts composing the product
project must be done in Visual Studio 2013 c#, database SQL server.
Full source code and database must be provided.
The purpose is to have a small application that stores information about a product and its composing parts (which are products as well).
To give you an idea let’s start with a sample product: a car.
Product: CAR
PN: 11220
Description: Ferrari
Serial No: 1
Composing parts
Product: Engine
PN: 11230
Description: The best Engine
Serial No: 1123
Composing parts
Product: chassis
PN: 12230
Description: Aluminum die
Serial No: 1323
------------------------------------
Product: piston block
PN: 1234
Description: complete piston section
Serial No: 1343
-----------------------------------------------
Product: chassis
PN: 143530
Description: Red Ferrari chassis
Serial No: 145
-----------------------------------------------
Product: front wheel block
PN: 1434230
Description: front wheel block complete
Serial No: 14345
-----------------------------------------------
Product: rear wheel block
PN: 1434430
Description: rear wheel block complete
Serial No: 1433345
Database structure
The database shall follow the following structure or if you have a better alternative you can propose it before bidding.
Main table
Field type
PARTID text 30
Father like partID
Description text 60
Field 2 text 60
Field 3 text 60
Notes table
Field Type
PARTID text 30 used to link to the main table
Date date
Description text 60
Who text 30
The field Father contains the PARTID of the container product if any.
Application behavior
By entering a PARTID, the application shall search in the database and if there is already a record whith that PARTID it shall simply retrieve all the related information and display them or edit.
If it is not present, after a confirmation it shall create a new record and allow the user to fill in its information.
In the subparts section it shall always display all the matching subparts, this means all the other records which Father field matches the current PARTID.
It shall be possible to add subparts at any time by simply entering the PARTID in the subpart section. If the PARTID is found it shall simply update (after a confirmation) its father field to the current PARTID.
If it is not found for the moment it shall simply do nothing.
Notes Section
Just contains notes related to the current product.
Notes are stored in a different table of the database. It shall be possible to add notes.
Hello,
I am very much interested to do this work as i am experienced a lot in C# and ms sql server. I understand your requirements and i think i can do this work efficiently. Looking forward to have a positive response from you.
Thanks
$96 USD en 2 días
5,0 (213 comentarios)
7,7
7,7
10 freelancers están ofertando un promedio de $133 USD por este trabajo
Hello sir. I have great experience with c# programming. I can do your job very fast and very good. if you are interested, we can discuss more about price and time.
regards
vladang
hi
i have 5 + years of exp n .net development please visit my profile once to know about my past project and reviews.
i can handle this project and deliver it on time
thanks
arpit
Hello, I'm a professional Microsoft .NET Developer with more than 2.5 years of commercial experience.
I can get your task done within 2 days ( will be working on evenings part-time) + couple of hours to test it.
Project seems clear to me. Worked on such tasks lots of time.
Feel free to contact me anytime.
Thanks,
Pavlo Sobchuk