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;
}
