Example #1
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);
     }
 }
Example #2
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;
     }
 }
Example #3
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;
 }
Example #4
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);
        }