I want you to create basic mrp scripts for me according to multi level BOM.
Requirements:
1- No components with fee is accepted.
2- It should be written in asp.net with C# code behind
3- There will be a SQL table named StockItems which will keep all items that are used in any final or semi product with Picture+Documents(with pdf,doc,dwg, jpg, xls extensions)+Stock level as qty+ qty unit(meter,cm, kg,gr etc.)+Critical Stock Level+Future Stock level. User should able to add /edit/delete components
4- There will be a SQL table named StocktemCategories which will keep name of categories of stockitems. User should able to add /edit/delete
5- There will be some SQL tables which will keep Bill of meterials from StockItems table. User should able to add /edit/delete BOM lists as he want.
6- A part of script named "Production" which show / inserts /deletes orders of products with status "future order,under production, completed". User should able to add /edit/delete orders.
7- a script should calculate needed components of any BOM with stock levels according to sellected period of production plan and report if additional component items needed to be purchased or not. it
8- if a product is selleced as completed script will degrease stock level qty.
9- ProductionSchedule is also needed according to production module user can select start and finish dates of manufacturing of a product on a calendar.(as current week, current month, current year)