private static void updateStockForItems(List <AdjustmentVoucherDetail> list) { foreach (AdjustmentVoucherDetail voucherDetail in list) { ProductDAO.UpdateStock(voucherDetail.ItemNumber, (int)voucherDetail.Quantity); } }
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(); } }
/** end by ashwin * */ /** added by lee * */ public static bool acknowledgeCollectItems(List <ConsolidatedRequisitionListDetail> detailsList) { List <int> listIDs = new List <int>(); foreach (ConsolidatedRequisitionListDetail detailItem in detailsList) { ConsolidatedRequisitionListDetail item = ConsolidatedRequisitionListEFFacade.getItemWithMatchingListIDAndItemCode(detailItem.ConsolidatedListID, detailItem.ItemNumber); if (detailItem.ActualQuantity < item.ActualQuantity) { int difference = (int)item.ActualQuantity - (int)detailItem.ActualQuantity; ConsolidatedRequisitionListEFFacade.setActualQuantityForItem(detailItem.ConsolidatedListID, detailItem.ItemNumber, (int)detailItem.ActualQuantity); //raise voucher and update unfulfilled here //1. update unfulfilled items table updateUnfulfilledList(detailItem, difference); //2. raise adjustment voucher raiseNewAdjustmentVoucher(detailItem, difference); //3. update stock ProductDAO.UpdateStock(detailItem.ItemNumber, difference); } if (!listIDs.Contains(detailItem.ConsolidatedListID)) { listIDs.Add(detailItem.ConsolidatedListID); } } foreach (int id in listIDs) { ConsolidatedRequisitionListEFFacade.setListStatusToClosed(id); } return(true); }
public static void UpdatePositiveStock(String Pid, int qnt) { ProductDAO.UpdateStock(Pid, qnt); }