Helps required for application

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…

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

SQL Query support Case when

I think this will help you to write query.

example

Select case when (ISNULL(ps.Qty,0) - ISNULL(pa.qty,0)) > 5 then 'Parts Available' when (ISNULL(ps.Qty,0) - ISNULL(pa.qty,0))<=5 then 'Qty Lower Position'
when (ISNULL(ps.Qty,0) - ISNULL(pa.qty,0)) =0 then 'Parts not available' end as stock from Parts_Stock_Table ps
Left Outer join Parts_Allotment_table pa on ps.tableId = pa.tableId

hope this help.
0