public int GetAvailableStock(DateTime date, int catalogItemId) { CatalogItemsStock s = ents.CatalogItemsStocks.Where(x => x.CatalogItemId == catalogItemId).ToList().Where(y => y.Date.Date == date.Date).FirstOrDefault(); if (s != null) { return(s.AvailableStock); } else { return(0); } }
public void CreateAvailableStock(CatalogItemsStock cat) { CatalogItemsStock s = catalogItemsStock.Where(x => x.CatalogItemId == cat.CatalogItemId).ToList() .Where(y => y.Date.Date == cat.Date.Date).FirstOrDefault(); /* Overwrite the existing stock item for that date if we already have one for this item. Otherwise, make a new entry*/ if (s != null) { s.AvailableStock = cat.AvailableStock; } else { var maxId = catalogItemsStock.Max(i => i.StockId); cat.StockId = ++maxId; catalogItemsStock.Add(cat); } }
public void CreateAvailableStock(CatalogItemsStock catalogItemsStock) { CatalogItemsStock s = ents.CatalogItemsStocks.Where(x => x.CatalogItemId == catalogItemsStock.CatalogItemId).ToList() .Where(y => y.Date.Date == catalogItemsStock.Date.Date).FirstOrDefault(); /* Overwrite the existing stock item for that date if we already have one for this item. Otherwise, make a new entry*/ if (s != null) { s.AvailableStock = catalogItemsStock.AvailableStock; ents.Entry(s).State = EntityState.Modified; ents.SaveChanges(); } else { var maxId = ents.CatalogItemsStocks.Max(i => i.StockId); catalogItemsStock.StockId = ++maxId; ents.CatalogItemsStocks.Add(catalogItemsStock); ents.SaveChanges(); } }
public void CreateAvailableStock(CatalogItemsStock catalogItemsStock) { throw new NotImplementedException(); }