public void UpdateAyer() { var hoy = DateTime.Today; var ayer = BD.Shipping_Records.Where(w=>w.RecordDate<hoy).Distinct() .OrderByDescending(des=>des.RecordDate.Month) .ThenByDescending(des=>des.RecordDate.Day) .Select(d=>d.RecordDate) .FirstOrDefault(); var registroAyer = BD.GraficaAirGround.Where(w => w.FechaDia.Day == ayer.Day && w.FechaDia.Year == ayer.Year && w.FechaDia.Month == ayer.Month) .Select(sel => new AirGroundViewModel() { id = sel.id, FechaDia = sel.FechaDia, FedExAir = sel.actualAir, FedExGround = sel.actualGround, FedexAirGraundAyer = sel.FedexAirGraundAyer, NewScans = sel.NewScans, Porcentaje = sel.Porcentaje, TotalinShip = sel.TotalinShip }).FirstOrDefault(); var UltimoAir = (from consulta1 in BD.Shipping_Records where consulta1.RecordDate.Day == ayer.Day && consulta1.RecordDate.Month == ayer.Month && consulta1.RecordDate.Year == ayer.Year && consulta1.RecordServiceType.Contains("Air") && consulta1.Shipping_Catalog_Products.AreaID != 1 && consulta1.Shipping_Catalog_Products.AreaID != 33 select (int?)consulta1.RecordQuantity).Sum() ?? 0; var UltimoGround = (from consulta2 in BD.Shipping_Records where consulta2.RecordDate.Day == ayer.Day && consulta2.RecordDate.Month == ayer.Month && consulta2.RecordDate.Year == ayer.Year && consulta2.RecordServiceType.Contains("Ground") && consulta2.Shipping_Catalog_Products.AreaID != 1 && consulta2.Shipping_Catalog_Products.AreaID != 33 select (int?)consulta2.RecordQuantity).Sum() ?? 0; if (registroAyer != null) { if (UltimoGround != 0 || UltimoAir != 0) { var entity = new GraficaAirGround { id = registroAyer.id, FedexAirGraundAyer = registroAyer.FedexAirGraundAyer, TotalinShip = registroAyer.TotalinShip, NewScans = registroAyer.NewScans, FechaDia = registroAyer.FechaDia, actualAir = UltimoAir, actualGround = UltimoGround, Porcentaje = (int)Math.Round(((decimal)UltimoGround / (decimal)(UltimoAir + UltimoGround) * 100)) }; BD.GraficaAirGround.Attach(entity); BD.Entry(entity).State = EntityState.Modified; BD.SaveChanges(); } else { Debug.WriteLine("No hay registros para hoy"); } } }
public void Update(AirGroundViewModel model) { var entity = new GraficaAirGround { id = model.id, FedexAirGraundAyer = model.FedexAirGraundAyer, TotalinShip = model.TotalinShip, FechaDia = model.FechaDia, Porcentaje=model.Porcentaje, actualAir=model.FedExAir, NewScans =model.NewScans, actualGround=model.FedExGround }; BD.GraficaAirGround.Add(entity); BD.Entry(entity).State = EntityState.Modified; BD.SaveChanges(); }
//Ingresa un valor para el dia de hoy public void Create(int Parametro) { var hoy = DateTime.Today; var TotalAyer = (from total in BD.GraficaAirGround orderby total.FechaDia descending select new { total.TotalinShip, total.FechaDia }).First(); var ayerAir = (from consulta1 in BD.Shipping_Records where consulta1.RecordDate == TotalAyer.FechaDia && consulta1.RecordServiceType.Contains("Air") && consulta1.Shipping_Catalog_Products.AreaID != 1 && consulta1.Shipping_Catalog_Products.AreaID != 33 select (int?)consulta1.RecordQuantity).Sum() ?? 0; var ayerGround = (from consulta2 in BD.Shipping_Records where consulta2.RecordDate == TotalAyer.FechaDia && consulta2.RecordServiceType.Contains("Ground") && consulta2.Shipping_Catalog_Products.AreaID != 1 && consulta2.Shipping_Catalog_Products.AreaID != 33 select (int?)consulta2.RecordQuantity).Sum() ?? 0; var FedexAirGraundAyer = (ayerAir + ayerGround); var entity = new GraficaAirGround() { FechaDia = DateTime.Today, NewScans = ((TotalAyer.TotalinShip - FedexAirGraundAyer) - Parametro) * -1, TotalinShip = Parametro, FedexAirGraundAyer = FedexAirGraundAyer }; BD.GraficaAirGround.Add(entity); BD.SaveChanges(); }