public InfractionDetail Infraction1(int id, User user) { var query = db.Infractions.Where(f => f.SampleNo == id).FirstOrDefault(); InfractionDetail Details = new InfractionDetail(); Details.InfractionCount = 0; Details.infraction = query; Details.User = user; var sMonth = DateTime.Now.AddMonths(-1).Month.ToString(); var qq = db.VisitDetails.Where(v => v.FactoryId == query.FactoryId); foreach (var item in qq) { if (item.VisitDate.Month.ToString() == sMonth) { Details.VisitsCount++; } } var Factory = db.Factory11.Where(f => f.Id == query.FactoryId).Select(ff => new { ff.Name, ff.Location }).FirstOrDefault(); var Samples = db.ConcreteSample1.Where(v => v.FactoryName == Factory.Name).ToList(); List <ConcreteSample1> samples = new List <ConcreteSample1>(); foreach (var item in Samples) { if (item.ReportDate.Value.Month.ToString() == sMonth) { samples.Add(item); } } Details.infractions = samples; Details.FactoryName = Factory.Name; Details.Location = Factory.Location; if (query.AbsenceofDevice == true) { Details.InfractionCount++; } if (query.C8Day == true) { Details.InfractionCount++; } if (query.HardwareNotCalibrated == true) { Details.InfractionCount++; } if (query.InsufficientRecords == true) { Details.InfractionCount++; } if (query.IsCleanLocation == true) { Details.InfractionCount++; } if (query.Landing == true) { Details.InfractionCount++; } if (query.NotUsingMixtureofClass == true) { Details.InfractionCount++; } if (query.Temperature == true) { Details.InfractionCount++; } return(Details); }
public InfractionDetailVo(InfractionDetail infractionDetail) { InfractionDetail = infractionDetail; }
public VehicleInfractionDetailVo(InfractionDetail infractionDetail) { InfractionDetail = infractionDetail; }