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);
}
