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