public ActionResult SevenDaysResult(threeCubeOfSevenDaysSample cubeOfOneSample) { QCEntities qc = new QCEntities(); cubeOfOneSample.SamplePart1.sampleNumber = int.Parse(RouteData.Values["id"].ToString()); cubeOfOneSample.SamplePart1.volume = 5302; cubeOfOneSample.SamplePart1.areaLoaded = 17674; cubeOfOneSample.SamplePart1.testDate = DateTime.Now; cubeOfOneSample.SamplePart1.age = 7; cubeOfOneSample.SamplePart2.sampleNumber = int.Parse(RouteData.Values["id"].ToString()); cubeOfOneSample.SamplePart2.volume = 5302; cubeOfOneSample.SamplePart2.areaLoaded = 17674; cubeOfOneSample.SamplePart2.testDate = DateTime.Now; cubeOfOneSample.SamplePart2.age = 7; cubeOfOneSample.SamplePart3.sampleNumber = int.Parse(RouteData.Values["id"].ToString()); cubeOfOneSample.SamplePart3.volume = 5302; cubeOfOneSample.SamplePart3.areaLoaded = 17674; cubeOfOneSample.SamplePart3.testDate = DateTime.Now; cubeOfOneSample.SamplePart3.age = 7; cubeOfOneSample.SamplePart1.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; cubeOfOneSample.SamplePart2.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; cubeOfOneSample.SamplePart3.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; qc.sevenDaysResults.Add(cubeOfOneSample.SamplePart1); qc.sevenDaysResults.Add(cubeOfOneSample.SamplePart2); qc.sevenDaysResults.Add(cubeOfOneSample.SamplePart3); qc.SaveChanges(); return(RedirectToAction("SevenDaysTest", "Laboratory", new { id = 1 })); }
public ActionResult MonthlyResult(threeCubeOfMonthlySample cubeOfOneSample) { QCEntities qc = new QCEntities(); int SampleNumberFromUrl = int.Parse(RouteData.Values["id"].ToString()); cubeOfOneSample.SamplePart1.sampleNumber = SampleNumberFromUrl; cubeOfOneSample.SamplePart1.volume = 5302; cubeOfOneSample.SamplePart1.areaLoaded = 17674; cubeOfOneSample.SamplePart1.testDate = DateTime.Now; cubeOfOneSample.SamplePart1.age = 28; cubeOfOneSample.SamplePart2.sampleNumber = SampleNumberFromUrl; cubeOfOneSample.SamplePart2.volume = 5302; cubeOfOneSample.SamplePart2.areaLoaded = 17674; cubeOfOneSample.SamplePart2.testDate = DateTime.Now; cubeOfOneSample.SamplePart2.age = 28; cubeOfOneSample.SamplePart3.sampleNumber = SampleNumberFromUrl; cubeOfOneSample.SamplePart3.volume = 5302; cubeOfOneSample.SamplePart3.areaLoaded = 17674; cubeOfOneSample.SamplePart3.testDate = DateTime.Now; cubeOfOneSample.SamplePart3.age = 28; cubeOfOneSample.SamplePart1.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; cubeOfOneSample.SamplePart2.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; cubeOfOneSample.SamplePart3.averageCompressiveStrength = (cubeOfOneSample.SamplePart1.CompressiveStrength + cubeOfOneSample.SamplePart2.CompressiveStrength + cubeOfOneSample.SamplePart3.CompressiveStrength) / 3; qc.monthlyResults.Add(cubeOfOneSample.SamplePart1); qc.monthlyResults.Add(cubeOfOneSample.SamplePart2); qc.monthlyResults.Add(cubeOfOneSample.SamplePart3); var cRank = qc.ConcreteSample1.Where(s => s.SampleNumber == SampleNumberFromUrl).Select(c => c.ConcreteRank).FirstOrDefault(); int concRanck = int.Parse((cRank.Split('-'))[1]); var qInfrac = qc.Infractions.Where(inf => inf.SampleNo == SampleNumberFromUrl).FirstOrDefault(); var fact = (from conSamp in qc.ConcreteSample1 join fac in qc.Factory11 on conSamp.FactoryName equals fac.Name where conSamp.SampleNumber == SampleNumberFromUrl select new { FactoryId = fac.Id, createdDate = conSamp.CreatedDate }).FirstOrDefault(); switch (concRanck) { case 35: { if (cubeOfOneSample.SamplePart1.averageCompressiveStrength < 34.5) { if (qInfrac == null) { Infraction infraction = new Infraction(); { infraction.FactoryId = fact.FactoryId; infraction.Temperature = false; infraction.Landing = false; infraction.C8Day = true; infraction.VisitDate = fact.createdDate; infraction.SampleNo = SampleNumberFromUrl; infraction.AdminApproved = false; infraction.MonitorApproved = false; infraction.IsCleanLocation = false; infraction.NotUsingMixtureofClass = false; infraction.AbsenceofDevice = false; infraction.HardwareNotCalibrated = false; infraction.InsufficientRecords = false; } qc.Infractions.Add(infraction); qc.SaveChanges(); } else { qInfrac.C8Day = true; qc.SaveChanges(); } } break; } case 30: { if (cubeOfOneSample.SamplePart1.averageCompressiveStrength < 29.5) { if (qInfrac == null) { Infraction infraction = new Infraction(); { infraction.FactoryId = fact.FactoryId; infraction.Temperature = false; infraction.Landing = false; infraction.C8Day = true; infraction.VisitDate = fact.createdDate; infraction.SampleNo = SampleNumberFromUrl; infraction.AdminApproved = false; infraction.MonitorApproved = false; infraction.IsCleanLocation = false; infraction.NotUsingMixtureofClass = false; infraction.AbsenceofDevice = false; infraction.HardwareNotCalibrated = false; infraction.InsufficientRecords = false; } qc.Infractions.Add(infraction); qc.SaveChanges(); } else { qInfrac.C8Day = true; qc.SaveChanges(); } } break; } case 20: { if (cubeOfOneSample.SamplePart1.averageCompressiveStrength < 19.5) { if (qInfrac == null) { Infraction infraction = new Infraction(); { infraction.FactoryId = fact.FactoryId; infraction.Temperature = false; infraction.Landing = false; infraction.C8Day = true; infraction.VisitDate = fact.createdDate; infraction.SampleNo = SampleNumberFromUrl; infraction.AdminApproved = false; infraction.MonitorApproved = false; infraction.IsCleanLocation = false; infraction.NotUsingMixtureofClass = false; infraction.AbsenceofDevice = false; infraction.HardwareNotCalibrated = false; infraction.InsufficientRecords = false; } qc.Infractions.Add(infraction); qc.SaveChanges(); } else { qInfrac.C8Day = true; qc.SaveChanges(); } } break; } case 15: { if (cubeOfOneSample.SamplePart1.averageCompressiveStrength < 14.5) { if (qInfrac == null) { Infraction infraction = new Infraction(); { infraction.FactoryId = fact.FactoryId; infraction.Temperature = false; infraction.Landing = false; infraction.C8Day = true; infraction.VisitDate = fact.createdDate; infraction.SampleNo = SampleNumberFromUrl; infraction.AdminApproved = false; infraction.MonitorApproved = false; infraction.IsCleanLocation = false; infraction.NotUsingMixtureofClass = false; infraction.AbsenceofDevice = false; infraction.HardwareNotCalibrated = false; infraction.InsufficientRecords = false; } qc.Infractions.Add(infraction); qc.SaveChanges(); } else { qInfrac.C8Day = true; qc.SaveChanges(); } } break; } default: break; } qc.SaveChanges(); return(RedirectToAction("MonthTest", "Laboratory", new { id = 1 })); }