Vilas Gite

Vilas Gite

  • 525
  • 2.5k
  • 541.6k

Helps required for application

Mar 26 2012 2:14 AM

I am going to develop small application for Parts Management System in C# Language with backend SQL Server 2000.

I have three tables,

Parts_Stock_Table

 Parts_Allotment_table

 Parts_Status_Table

 

Scenario,

I have added & Actual part no 'KPL-900'  is 10 Qty in Parts_Stock_Table, I have allotted 2 out of them to such a Jobwork, now I want deduct 2 qty from Parts_Stock_Table and shown Actual 8 in Parts_Stock_Table and another one process will be done same time in Parts_Status_Table that  part no 'KPL-900' is available if, parts Qty lower than 5 then show 'Qty Lower Position' and when its goes 0 then show 'Parts not available' .

These messages look like in colours 'Parts Available' for Green, 'Qty Lower Position'  for Orange and 'Parts not available' for Red.     I want urgent solutions, Please do needful my friends…


Answers (1)