public AdjustmentVoucherManagerController() { LogicUniStoreModel db = new LogicUniStoreModel(); adj = new AdjustmentItemDao(); adao = new AdjustmentDao(db); idao = new ItemDao(); sdao = new StockCardDao(); }
public ProcessReqController() { LogicUniStoreModel db = new LogicUniStoreModel(); RequisitionDao = new RequisitionDao(db); StockCardDao = new StockCardDao(db); RequisitionItemDao = new RequisitionItemDao(db); mainList = new Dictionary <Requisition, double>(); LockedItem = new Dictionary <int, int>(); }
public PurchaseOrderController() { ItemDao = new ItemDao(); StockCardDao = new StockCardDao(); SupplierItemDao = new SupplierItemDao(); POBatchDao = new PoBatchDao(); StockReorder = new Dictionary <Item, List <SupplierItem> >(); PODao = new PurchaseOrderDao(); POItemDao = new PurchaseOrderItemDao(); }
public List <Requisition> GetReqItemForProcess(List <Requisition> reqs) { LogicUniStoreModel db = new LogicUniStoreModel(); if (reqs == null) { reqs = db.Requisitions.Where(r => r.Status == RequisitionStatus.Approved.ToString()).ToList(); } int pId, stockCount, approveQnty; double progrssMeter; List <Requisition> reqList = new List <Requisition>(); foreach (var req in reqs.ToList()) { progrssMeter = 0.0; foreach (var item in req.RequisitionItems.ToList()) { pId = item.SupplierItem.ItemID; approveQnty = item.NeededQuantity.Value; stockCount = StockCardDao.GetProductCountInStock(pId); if (!LockedItem.ContainsKey(pId)) { if (approveQnty > stockCount) { approveQnty = (stockCount - approveQnty > 0)? stockCount - approveQnty : stockCount; } LockedItem.Add(pId, approveQnty); } else { stockCount = (stockCount - LockedItem[pId]); if (approveQnty > stockCount) { approveQnty = (stockCount - approveQnty > 0)? stockCount - approveQnty : stockCount; } LockedItem[pId] += approveQnty; } item.ApprovedQuantity = approveQnty; if (item.ApprovedQuantity == item.NeededQuantity) { progrssMeter += 1; // add 1 on scale of item.count() } else { progrssMeter += (double)item.ApprovedQuantity / (double)item.NeededQuantity; // add fraction on scale of item.count() } } meter[req.ReqID] = (progrssMeter / req.RequisitionItems.Count) * 100; reqList.Add(req); } return(reqList); }
public List <Item> GetItems() { List <Item> reorderItem = new List <Item>(); List <StockCard> allItemsInStock = StockCardDao.GetAllInStock(); foreach (StockCard item in allItemsInStock) { if (item.OnHandQuantity < item.Item.ReorderLevel) { List <SupplierItem> suppliersItems = SupplierItemDao.GetSuppliersOfItem(item.Item); StockReorder.Add(item.Item, suppliersItems); reorderItem.Add(item.Item); } } return(reorderItem); }
public StockCardController() { supplierItemDao = new SupplierItemDao(); poItemDao = new PurchaseOrderItemDao(); stockCardDao = new StockCardDao(); }
public List <StockCard> GetAllStockCard() { return(StockCardDao.GetAllInStock()); }
public ProcessReqAlterController(List <Requisition> reqs, Dictionary <int, int> lockedItem) { ProcessedRequistions = reqs; LockedItem = lockedItem; StockCardDao = new StockCardDao(new LogicUniStoreModel()); }