public IQueryable <LensHistory> GetTodaysHistory() { var today = DateTime.Now.Date; return (LensHistory.Where(x => x.InsertDate >= today && x.InsertDate <= DateTime.Today.AddDays(1).Date).OrderByDescending(x => x.InsertDate).Include(m => m.Material)); }
public void UpdateHistory(string productLabel, int quantity) { var lens = Lenses.Where(l => l.ProductLabel == productLabel).Include(m => m.Material).ToList(); LensHistory lensHistoryToUpdate = new LensHistory { ProductLabel = lens[0].ProductLabel, Sphere = lens[0].Sphere, Cylinder = lens[0].Cylinder, AntiReflectiveCoating = lens[0].AntiReflectiveCoating, Transitions = lens[0].Transitions, Material = lens[0].Material, Quantity = quantity, RemainingCount = lens[0].RemainingCount, InsertDate = DateTime.Now }; LensHistory.Add(lensHistoryToUpdate); SaveChanges(); }