public static void approveVoucherDetailItemsByManager(List <AdjustmentVoucherDetail> list) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); foreach (AdjustmentVoucherDetail detail in list) { var query = from x in CONTEXT.AdjustmentVoucherDetails where x.VoucherNumber == detail.VoucherNumber && detail.ItemNumber == x.ItemNumber && x.ApprovalStatus == detail.ApprovalStatus select x; AdjustmentVoucherDetail voucherDetailObject = query.First(); int qnty = Convert.ToInt32(voucherDetailObject.Quantity); voucherDetailObject.ApprovalStatus = APPROVAL_STATUS_APPROVED; var q = from x in CONTEXT.Products where x.ItemNumber == detail.ItemNumber select x; Product prod = q.First <Product>(); if (voucherDetailObject.Status == STATUS_INCREASE) { ProductDAO.UpdateStock(prod.ItemNumber, qnty); } else { ProductDAO.UpdateStockReduce(prod.ItemNumber, qnty); } CONTEXT.SaveChanges(); } }
public static void updateStationaryCollection(string itemNum, int[] actualQty, string[] depCode) { List <string> itemList = new List <string>(); List <Product> plist = ConsolidatedRequisitionListEFFacade.getAllProductsToCollect(); foreach (Product p in plist) { itemList.Add(p.ItemNumber); } List <string> depCodeList = depCode.ToList <string>(); List <int> qtyList = ConsolidatedRequisitionListEFFacade.getQtyNeedeOfDep(depCodeList, itemNum); if (itemList.Contains(itemNum)) { for (int j = 0; j < actualQty.Length; j++) { int i = ConsolidatedRequisitionListEFFacade.getDepOpenConsolidatedIDfromProd(itemNum, depCode[j]); ConsolidatedRequisitionListEFFacade.updateStationaryCollection(i, itemNum, actualQty[j]); int deff = qtyList[j] - actualQty[j]; if (deff > 0) { UnfulfilledDAO.raiseAdjustmentFromCollection(itemNum, depCode[j], deff); } } } int stockRed = 0; for (int i = 0; i < actualQty.Length; i++) { stockRed = actualQty[i] + stockRed; } ProductDAO.UpdateStockReduce(itemNum, stockRed); }
public static void UpdatenegativeStock(String Pid, int qnt) { ProductDAO.UpdateStockReduce(Pid, qnt); }