I am trying to develop one application, which will serve the
purpose of estimation and job process management system. For estimation, I have
category, subcategory and product. Estimate has different types. Each product
has different properties.
At the time of estimation, user selects the product based on
subcategory. Based on criteria and input, new value generated for each time for
same product. Now I have to save this all products into estimate table. One estimate has multiple products.
After estimate approved, job will be created based on
estimate. Job will take input all the items/products from estimate and then
process each item.
My question is what is best way to do this?
Should I keep only one table estimate-detail(like order-order
details scenario) which has all selected products and use it at the time of job
process? Or Should I create another table for job detail?
I am novice in asp.net and searching best practices for this
kind of application? Please try to describe in detail.
Thank you for your time!!!
View Complete Post