public static int GetRemainingStock(Item item, Warehouse warehouse) { using (var context = new ERPContext()) { var stock = context.Stocks.SingleOrDefault(e => e.ItemID.Equals(item.ID) && e.WarehouseID.Equals(warehouse.ID)); return(stock?.Pieces ?? 0); } }
public static int GetRemainingStock(Item item, Warehouse warehouse) { using (var context = new ERPContext()) { var stock = context.Stocks.SingleOrDefault(e => e.ItemID.Equals(item.ID) && e.WarehouseID.Equals(warehouse.ID)); return stock?.Pieces ?? 0; } }
public static DateTime GetCurrentDate() { DateTime currentDate; using (var context = new ERPContext()) { var date = context.Dates.SingleOrDefault(e => e.Name.Equals("Current")); if (date != null) currentDate = date.DateTime; else { currentDate = DateTime.Now.Date; context.Dates.Add(new Date {DateTime = DateTime.Now.Date, Name = "Current"}); context.SaveChanges(); } } return currentDate; }
public static DateTime GetCurrentDate() { DateTime currentDate; using (var context = new ERPContext()) { var date = context.Dates.SingleOrDefault(e => e.Name.Equals("Current")); if (date != null) { currentDate = date.DateTime; } else { currentDate = DateTime.Now.Date; context.Dates.Add(new Date { DateTime = DateTime.Now.Date, Name = "Current" }); context.SaveChanges(); } } return(currentDate); }