/** 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 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 approveVoucherDetailItemsBySupervisor(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(); } //foreach (AdjustmentVoucherDetail detail in itemsApproved) //{ // AdjustmentVoucherDetail d = CONTEXT.AdjustmentVoucherDetails.Where(x => x.VoucherNumber == detail.VoucherNumber).First(); // d.ApprovalStatus = APPROVAL_STATUS_APPROVED; // CONTEXT.SaveChanges(); //} }
//public static UniversityStoreEntities context = new UniversityStoreEntities(); public static List <Product> ProductWithLowStock() { List <Product> pr = ProductDAO.StockIsLow(); return(pr); }
public static List <Object> populateAll() { return(ProductDAO.selectAll()); }
//////****************Sreeja********************/////// public static List <object> findStockByDescp(string descp) { return(ProductDAO.populateStockByDescp(descp)); }
public static List <object> findStock(string cat) { return(ProductDAO.populateStock(cat)); }
public static List <Object> acceptAllProducts() { return(ProductDAO.populateAllProduct()); }
public static List <Object> displaySerachResults(string searchString) { return(ProductDAO.getSearchResultbyname(searchString)); }
public ProductWCF[] searchProduct(string searchTerm) { List <Product> searchResults = new List <Product>(); Product idSearchResult = null; try { idSearchResult = ProductDAO.getSearchProductbyid(searchTerm); } catch (InvalidOperationException ex) { } List <Product> nameSearchResults = ProductDAO.getSearchProductbyname(searchTerm); List <Product> categorySearchResults = ProductDAO.getSearchProductbyCategory(searchTerm); if (idSearchResult != null) { searchResults.Add(idSearchResult); } foreach (Product p in nameSearchResults) { //searchResults.Add(p); if (searchResults.Count > 0) { bool isrepeat = false; foreach (Product p1 in searchResults) { if (p.ItemNumber.Equals(p1.ItemNumber)) { isrepeat = true; } } if (!isrepeat) { searchResults.Add(p); } } else { searchResults.Add(p); } } foreach (Product p in categorySearchResults) { if (searchResults.Count > 0) { bool isrepeat = false; foreach (Product p1 in searchResults) { if (!p.ItemNumber.Equals(p1.ItemNumber)) { isrepeat = true; } } if (!isrepeat) { searchResults.Add(p); } } else { searchResults.Add(p); } } List <ProductWCF> searchResultWCF = new List <ProductWCF>(); foreach (Product p in searchResults) { Console.WriteLine(p.ItemNumber); Console.WriteLine(p.Description); Console.WriteLine("------"); ProductWCF pwcf = new ProductWCF(); pwcf.ItemNumber = p.ItemNumber; pwcf.Description = p.Description; pwcf.Category = p.Category; pwcf.ReorderLevel = p.ReorderLevel != null ? (int)p.ReorderLevel : 0; pwcf.ReorderQuantity = p.ReorderQuantity != null ? (int)p.ReorderQuantity : 0; pwcf.UnitofMeasure = p.UnitOfMeasure; pwcf.Bin = p.Bin != null ? (int)p.Bin : 0; pwcf.Supplier1ID = p.Supplier1ID; pwcf.Supplier2ID = p.Supplier2ID; pwcf.Supplier3ID = p.Supplier3ID; pwcf.AdjustmentVoucherPrice = p.AdjustmentVoucherPrice != null ? (double)p.AdjustmentVoucherPrice : 0.0; pwcf.Stock = p.Stock.TotalInventoryBalance != null ? (int)p.Stock.TotalInventoryBalance : 0; pwcf.ConsolidatedListID = 0; pwcf.ActualQuantityAccepted = 0; pwcf.QuantityRequested = 0; searchResultWCF.Add(pwcf); } return(searchResultWCF.ToArray <ProductWCF>()); }
public static void UpdatePositiveStock(String Pid, int qnt) { ProductDAO.UpdateStock(Pid, qnt); }
public static void UpdatenegativeStock(String Pid, int qnt) { ProductDAO.UpdateStockReduce(Pid, qnt); }