public void OrderProductModify(int id, OrderProduct orp) { DataTable dt = new DataTable(); dt = db.execQuery("Sp_OrderProductSelById", new Object[] { id, orp.product_id }); if (dt.Rows.Count > 0) { int qtt_product_master = Convert.ToInt32(dt.Rows[0]["qty"]); if (orp.qty != Convert.ToInt16(dt.Rows[0]["qty"])) { if (orp.qty > Convert.ToInt16(dt.Rows[0]["qty"])) // berarti penambahan stok { int qtt_update = orp.qty - qtt_product_master; db.execUpdate("sp_ProductStockPlus", new object[] { orp.product_id, qtt_update }); db.execUpdate("Sp_OrderProductModify", new object[] { id, orp.product_id, orp.qty, orp.product_price }); } else //berarti pengurangan stok { DataTable dt_prod = new DataTable(); dt_prod = db.execQuery("Sp_ProductSelById", new Object[] { orp.product_id }); if (Convert.ToInt16(dt.Rows[0]["qty_stock"].ToString()) >= orp.qty) { db.execUpdate("sp_ProductStockMinus", new object[] { orp.product_id, orp.qty }); } else { // jika stok pada data produk tidak mencukupi maka tidak proses tidak dilakukan throw (new MyException.OutOfStock(orp.product_id + ": Out Of Stock")); } } } } else { db.execUpdate("Sp_OrderProductAdd", new object[] { id, orp.product_id, orp.qty, orp.product_price }); db.execUpdate("sp_ProductStockPlus", new object[] { orp.product_id, orp.qty }); } }
public void OrderProductAdd(int id, OrderProduct orp) { db.execUpdate("Sp_OrderProductAdd", new object[] { id, orp.product_id, orp.qty, orp.product_price }); db.execUpdate("sp_ProductStockPlus", new object[] { orp.product_id, orp.qty }); }