public static void UpdateItemSupplier(string ItemID, int p1, int p2, int p3) { using (StationeryStoreEntities context = new StationeryStoreEntities()) { CatalogueInventory s = context.CatalogueInventory. Where(p => p.ItemID == ItemID).ToList <CatalogueInventory>().First(); s.Priority1 = p1; s.Priority2 = p2; s.Priority3 = p3; context.SaveChanges(); } }
//Confirm delivery public void ConfirmDeliveryToDep(int EmployeeID, int DepartmentID) { using (StationeryStoreEntities context = new StationeryStoreEntities()) { //select today's delivery and set "Delivered" //select today's delivery and set "Delivered" DateTime today = DateTime.Now.Date; List <Delivery> deliveryList = context.Deliveries.Where(x => x.DepartmentID == DepartmentID && x.DeliveryDate <= today).ToList <Delivery>(); foreach (Delivery d in deliveryList) { d.Status = "Delivered"; List <Disbursement> clist = context.Disbursements.Where(x => x.DeliveryID == d.DeliveryID).ToList <Disbursement>(); foreach (Disbursement dis in clist) { //update catalogueInventory CatalogueInventory c = context.CatalogueInventories.Where(x => x.ItemID == dis.ItemID).FirstOrDefault <CatalogueInventory>(); c.ActualQty = c.ActualQty - dis.DisbursedQty; //update stockCard StockCard sc = new StockCard(); sc.ItemID = dis.ItemID; sc.SCCatID = 18002; sc.Description = dis.Department.Description; sc.AdjustedQty = -dis.DisbursedQty; sc.TransactionDate = DateTime.Now.Date; context.StockCards.Add(sc); } } List <Request> requests = context.Requests.Where(x => x.Employee.DepartmentID == DepartmentID && x.Status == "Scheduled").ToList <Request>(); foreach (Request r in requests) { r.Status = "Delivered"; } List <Outstanding> outsList = context.Outstandings.Where(x => x.DepartmentID == DepartmentID).ToList <Outstanding>(); foreach (Outstanding o in outsList) { if (o.Status == "Processed") { context.Outstandings.Remove(o); } else if (o.Status == null) { o.Status = "Pending"; } } context.SaveChanges(); } }
public static List <String> ValueCatalogue(string id) { using (StationeryStoreEntities context = new StationeryStoreEntities()) { CatalogueInventory item = context.CatalogueInventory.Where(x => x.ItemID == id).First(); string itemId = item.ItemID; string desc = item.Item_Description; string cat = item.Category.Category_Description; string uom = item.UnitOfMeasure; List <String> list = new List <String>(); list.Add(desc); list.Add(cat); list.Add(uom); list.Add(itemId); return(list); } }
//ListSup(): return a supplier list List<Supplier> public static List <Supplier> ListSup(string ItemID) { CatalogueInventory c = context.CatalogueInventory.Where(x => x.ItemID == ItemID).FirstOrDefault <CatalogueInventory>(); if (c != null) { List <Supplier> slist = new List <Supplier>(); slist.Add(c.Supplier); slist.Add(c.Supplier1); slist.Add(c.Supplier2); return(slist); } else { return(null); } //return context.Supplier.ToList<Supplier>(); }
public static void AddItem(string ItemID, int CatID, string Item_Description, string UnitOfMeasure, double UnitCost, int Priority1, int Priority2, int Priority3) { using (StationeryStoreEntities context = new StationeryStoreEntities()) { CatalogueInventory i = new CatalogueInventory() { ItemID = ItemID, CatID = CatID, Item_Description = Item_Description, UnitOfMeasure = UnitOfMeasure, UnitCost = Convert.ToDecimal(UnitCost), Priority1 = Priority1, Priority2 = Priority2, Priority3 = Priority3, ActualQty = 0 }; context.CatalogueInventory.Add(i); context.SaveChanges(); } }
//Confirm Delivery public static void ConfirmDeliveryFromSupplier(int EmployeeID, int POID) { //update PO PO p = context.PO.Where(f => f.POID == POID).ToList().First(); p.DeliveryDate = DateTime.Now.Date; p.Status = "Delivered"; //update Inventory CatalogueInventory c = context.CatalogueInventory.Where(x => x.ItemID == p.ItemID).ToList <CatalogueInventory>().FirstOrDefault(); c.ActualQty += p.Qty; //update Stockcard StockCard sc = new StockCard(); sc.ItemID = p.ItemID; sc.SCCatID = 18003; sc.Description = p.Supplier.Name; sc.AdjustedQty = p.Qty; sc.TransactionDate = DateTime.Now.Date; context.StockCard.Add(sc); context.SaveChanges(); }