public ActionResult SubmitConcreateTests2(ConcreateTests con)
{
foreach (var item in con.Tests)
{
foreach (var file in item.files)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
ConcretePath t = new ConcretePath()
{
MixingID = con.MixingId,
ConcreateID = item.ID,
Path = InputFileName + fi.Extension,
FileName = file.FileName
};
db.ConcretePaths.Add(t);
db.SaveChanges();
}
//
}
}
return(RedirectToAction("AddTestsMixingDesign2", "MixingDesign", new
{
id = 1
}));
}
public ActionResult attachCircular(CircularsPath circularsPath)
{
foreach (var file in circularsPath.circularFileName)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = fi.Name;
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
circularsPath.fileName = InputFileName;
}
}
Circular circular = new Circular()
{
fileName = circularsPath.fileName,
fileDate = DateTime.Today,
factoryId = int.Parse(circularsPath.factId),
download = false
};
context.Circulars.Add(circular);
context.SaveChanges();
return(RedirectToAction("Home", "Home", new { id = 1 }));
}
public ActionResult Create([Bind(Include = "Title,QualityLab,LevelOfImportanc")] EquipmentRequirementsType equipmentRequirementsType)
{
if (ModelState.IsValid)
{
db.EquipmentRequirementsTypes.Add(equipmentRequirementsType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(equipmentRequirementsType));
}
public ActionResult Create([Bind(Include = "ID,SubType_Arabic,SubType_English,InputFieldType,Description,EquipmentRequirementsTypeId")] CheckEquipmentRequirement checkEquipmentRequirement)
{
if (ModelState.IsValid)
{
db.CheckEquipmentRequirements.Add(checkEquipmentRequirement);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EquipmentRequirementsTypeId = new SelectList(db.EquipmentRequirementsTypes, "ID", "Title", checkEquipmentRequirement.EquipmentRequirementsTypeId);
return(View(checkEquipmentRequirement));
}
public ActionResult Index(PledgeM rev)
{
Pledge review = new Pledge();
review.FactoryID = rev.FactoryId;
review.LocationID = rev.LocationId;
review.Date = DateTime.Now;
db.Pledges.Add(review);
db.SaveChanges();
TempData["AlertMessage"] = "Done";
return(RedirectToAction("Index", "Pledge"));
}
public ActionResult Addtemp(tempretureClass temp)
{
try
{
temp.tempruture.date_time = DateTime.Now;
db.temprutureChecks.Add(temp.tempruture);
db.SaveChanges();
return(RedirectToAction("Temprature"));
}
catch (Exception ex)
{
return(RedirectToAction("Addtemp"));
}
}
public ActionResult ReceiveSample(VisitDetailsModel fact, string id)
{
var yesterday = DateTime.Now;
var factname = id;
var report = db.ConcreteSample1.Where(s => s.FactoryName == factname && DbFunctions.DiffDays(s.ReportDate, yesterday) == 1).FirstOrDefault();
report.IsReceived = true;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(RedirectToAction("ReceiveSample"));
}
var userId = Convert.ToInt32(Session["UserId"].ToString());
VisitDetailsModel model = new VisitDetailsModel();
VisitService visitService = new VisitService();
model.ReceiveSamples = visitService.ReceiveSample(userId);
return(RedirectToAction("ReceiveSample"));
}
public ActionResult Create([Bind(Include = "laboTechStaff,ProductQuality,FactoryWarnings,ProceduresRequired,FactoryId")] TechnicalReport technicalReport)
{
if (ModelState.IsValid)
{
Factory11 factory = db.Factory11.Find(technicalReport.FactoryId);
technicalReport.FactoryName = factory.Name;
db.TechnicalReports.Add(technicalReport);
technicalReport.Approval = "Draft";
technicalReport.CreationDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Home", "Home", new { id = 1 }));
}
ViewBag.FactoryId = new SelectList(db.Factory11, "Id", "Name", technicalReport.FactoryId);
return(View(technicalReport));
}
public ActionResult StartFactory(ReportResultVM vm)
{
try
{
var factory = db.Factory11.FirstOrDefault(p => p.Id == vm.FactoryId);
db.OpenCloseFactories.Add(new OpenCloseFactory()
{
Comment = vm.Comment, FactoryId = factory.Id, Opened = true
});
factory.Status = "Opened";
factory.IsActive = true;
db.SaveChanges();
return(RedirectToAction("Home", "Home", new { Id = 1 }));
}
catch (Exception ex)
{
return(View());
}
}
//function for create new visit
public Boolean CreateVisits(VisitDetail model)
{
db.VisitDetails.Add(new VisitDetail
{
FactoryId = model.FactoryId,
MonitorId = model.MonitorId,
Status = model.Status,
VisitDate = model.VisitDate
});
try
{
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Index(REviewMaterials rev)
{
ReviewMaterial review = new ReviewMaterial();
review.FactoryID = rev.FactoryID;
review.Date = rev.Date;
review.LocationID = rev.LocationID;
review.Message = rev.Message;
db.ReviewMaterials.Add(review);
db.SaveChanges();
TempData["AlertMessage"] = "Done";
return(RedirectToAction("Index", "ReviewMaterial"));
}
public ActionResult Laboratory(string id)
{
int number = int.Parse(id);
var updated = db.ConcreteSample1.Where(s => s.SampleNumber == number).FirstOrDefault();
updated.labdeliver = true;
db.SaveChanges();
LaboratoryModel model = new LaboratoryModel();
model.TodaySamples = db.ConcreteSample1.Where(s => s.IsReceived == true && DbFunctions.DiffDays(s.CreatedDate, DateTime.Now) == 1 && s.labdeliver == false).ToList();
return(View(model));
}
public ActionResult ReportResult(ReportResultVM vm)
{
try
{
if (vm.ReportId == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FactoryEvaluationReport factoryEvaluationReport = db.FactoryEvaluationReports.Find(vm.ReportId);
if (factoryEvaluationReport == null)
{
return(HttpNotFound());
}
db.ReportResults.Add(new ReportResult()
{
Comment = vm.Comment, Status = (int)vm.Status == 1, FactoryId = factoryEvaluationReport.FactoryId, FactoryReportId = vm.ReportId
});
var factory = db.Factory11.FirstOrDefault(p => p.Id == factoryEvaluationReport.FactoryId);
if ((int)vm.Status != 1)
{
factory.Status = "Closed";
factory.IsActive = false;
}
else
{
factory.Status = "Opened";
factory.IsActive = true;
}
db.SaveChanges();
return(RedirectToAction("Home", "Home", new { Id = 1 }));
}
catch (Exception ex)
{
return(View());
}
}
public void ApproveAlert(int InfId, int num)
{
var Inf = db.Infractions.Where(al => al.ID == InfId).FirstOrDefault();
if (num == 0)
{
Inf.AdminApproved = true;
}
else if (num == 1)
{
Inf.MonitorApproved = true;
}
else if (num == 2)
{
Inf.Monitor2Approved = true;
}
db.SaveChanges();
}
public ActionResult CreateFactory(Factory11 factory)
{
ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int));
ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string));
db.AddUpdateFactory(0, factory.Name, factory.Type, factory.ProductionCapacity,
factory.DailyProductionRate, factory.NumberofMixers, factory.NumberofTrucks,
factory.PhoneNumber, factory.FaxNumber, factory.MailBox, factory.Email, factory.Status, factory.Latitude,
factory.Longitude, factory.OwnerName, factory.OwnerEmail, factory.OwnerPhoneNumber,
factory.ManagerName, factory.ManagerEmail, factory.ManagerPhoneNumber, factory.ManagerExperience,
factory.EngineerName, factory.EngineerEmail, factory.EngineerPhoneNumber, factory.EngineerExperience, factory.Comments,
null, null, null, null, null, statusCode, statusMessage);
db.SaveChanges();
Console.Write(statusMessage);
return(View("~/Views/CreateFactory/CreateFactory.cshtml"));
}
public ActionResult CreateBlockFactory(BlockFactory factory)
{
int uId = Convert.ToInt32(Session["UserId"].ToString());
try
{
db.BlockFactories.Add(factory);
db.SaveChanges();
TempData["AlertMessage"] = "Factory created successfully";
return(RedirectToAction("BlockFactoriesList", "Factory", new
{
id = 2
}));
}
catch (Exception ex)
{
TempData["AlertMessage"] = "Factory not created";
return(RedirectToAction("CreateBlockFactory", "Factory"));
}
}
public void SaveAll(List <PressureResistanceTestforFactorySamplePhoto> press)
{
foreach (var item in press)
{
PressureResistanceTestforFactorySample p = new PressureResistanceTestforFactorySample()
{
Age = item.Age,
AreaLoaded = item.AreaLoaded,
AvgCompressiveStrength = item.AvgCompressiveStrength,
CompressiveStrength = item.CompressiveStrength,
ConcreteRank = item.ConcreteRank,
CrushingLoad = item.CrushingLoad,
Result = item.Result,
SampleNo = item.SampleNo,
TestDate = item.TestDate,
UnitWeight = item.UnitWeight,
Volume = item.Volume,
Weight = item.Weight
};
context.PressureResistanceTestforFactorySamples.Add(p);
}
context.SaveChanges();
}
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 int GenerateAlerts()
{
foreach (var item in db.Factory11.ToList())
{
int counter = 0;
List <int> Samples = new List <int>();
int Range = 0;
DateTime LastDate;
var sMonth = DateTime.Now.Month;
if (sMonth >= 7)
{
Range = sMonth - 6;
}
else
{
Range = (sMonth - 6) + 12;
}
var FirstDate = DateTime.Now;
if (Range <= 6)
{
LastDate = new DateTime(DateTime.Now.Year, Range, 1);
}
else
{
LastDate = new DateTime((DateTime.Now.Year) - 1, Range, 1);
}
var infractions = db.Infractions.Where(i => i.FactoryId == item.Id).Where(inf => inf.VisitDate >= LastDate && inf.VisitDate <= FirstDate).ToList();
if (infractions != null)
{
foreach (var inf in infractions)
{
if (inf.C8Day == true)
{
Samples.Add(inf.ID);
counter++;
}
}
if (counter >= 3)
{
Alert alert = new Alert();
alert.FactoryID = item.Id;
alert.Date = DateTime.Now;
alert.Approved = false;
db.Alerts.Add(alert);
db.SaveChanges();
foreach (var sam in Samples)
{
AlertInfraction AltInf = new AlertInfraction();
AltInf.AlertID = alert.ID;
AltInf.InfractionID = sam;
db.AlertInfractions.Add(AltInf);
}
db.SaveChanges();
}
else
{
bool Flag = false;
foreach (var query in infractions)
{
if (query.AbsenceofDevice == true)
{
counter++;
Flag = true;
}
if (query.C8Day == true)
{
Flag = true;
counter++;
}
if (query.HardwareNotCalibrated == true)
{
Flag = true;
counter++;
}
if (query.InsufficientRecords == true)
{
Flag = true;
counter++;
}
if (query.IsCleanLocation == true)
{
Flag = true;
counter++;
}
if (query.Landing == true)
{
Flag = true;
counter++;
}
if (query.NotUsingMixtureofClass == true)
{
Flag = true;
counter++;
}
if (query.Temperature == true)
{
Flag = true;
counter++;
}
if (Flag == true)
{
Samples.Add(query.ID);
}
if (counter >= 5)
{
break;
}
}
if (counter >= 5)
{
Alert alert = new Alert();
alert.FactoryID = item.Id;
alert.Date = DateTime.Now;
alert.Approved = false;
db.Alerts.Add(alert);
db.SaveChanges();
foreach (var sam in Samples.Distinct())
{
AlertInfraction AltInf = new AlertInfraction();
AltInf.AlertID = alert.ID;
AltInf.InfractionID = sam;
db.AlertInfractions.Add(AltInf);
}
db.SaveChanges();
}
}
}
}
return(0);
}
public ActionResult AddConcreteSample(ConcreteSamplesWithPath sample)
{
ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int));
ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string));
if (sample.ConcreteTemperture >= 34 || sample.DownAmount <= 100)
{
bool Flag = false;
Infraction infra = db.Infractions.Where(s => s.SampleNo == sample.SampleNumber).FirstOrDefault();
if (infra == null)
{
Flag = true;
infra = new Infraction();
infra.AdminApproved = false;
infra.MonitorApproved = false;
infra.VisitDate = DateTime.Now;
}
//infra.FactoryId = sample.FactoryId;
infra.SampleNo = sample.SampleNumber;
if (sample.ConcreteTemperture >= 34)
{
infra.Temperature = true;
}
if (sample.DownAmount <= 100)
{
infra.Landing = true;
}
if (sample.IsCleanLocation == false)
{
infra.IsCleanLocation = false;
}
if (Flag == true)
{
db.Infractions.Add(infra);
}
db.SaveChanges();
}
foreach (var file in sample.files)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.InvoicePhoto = InputFileName + fi.Extension;
}
}
foreach (var file in sample.CleanDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.CleanDocPath = InputFileName + fi.Extension;
}
}
foreach (var file in sample.DustDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.DustDocPath = InputFileName + fi.Extension;
}
}
foreach (var file in sample.LabDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.LabDocPath = InputFileName + fi.Extension;
}
}
foreach (var file in sample.SafteyDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.SafteyDocPath = InputFileName + fi.Extension;
}
}
foreach (var file in sample.SummerDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.SummerDocPath = InputFileName + fi.Extension;
}
}
foreach (var file in sample.TruckDocfiles)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.TruckDocPath = InputFileName + fi.Extension;
}
}
if (sample.Reason1 == null)
{
sample.OtherReason = sample.Reason2;
}
else
{
sample.OtherReason = sample.Reason1;
}
var uId = Convert.ToInt32(Session["UserId"].ToString());
db.AddUpdateConcreteSample(sample.ReportNo, sample.ReportDate, sample.FactoryName, sample.FactoryLocation, sample.MixerNumber, sample.VisitNumber,
sample.SampleNumber, sample.TruckNumber, sample.InvoiceNumber, sample.ClientName, sample.VisitLocation, sample.Latitude,
sample.Longitude, sample.ConcreteRank, sample.ConcreteTemperture, sample.WaterTemperature, sample.WeatherTemperture,
sample.DownAmount, sample.CementType, sample.CementSource, sample.AdditionType, sample.AdditionAmount, sample.CementWeight,
sample.WaterWieght, sample.WashedSandWeight, sample.WhiteSandWeight, sample.Rubble3by4, sample.Rubble3by8, sample.IsCleanUsage,
sample.IsBasicUsage, sample.IsColumnUsage, sample.IsRoofUsage, sample.IsOtherUsage, sample.IsCleanLocation, sample.CleanDocPath,
sample.IsDustControlInStation, sample.DustDocPath, sample.IsRokamSummer, sample.SummerDocPath, sample.IsLabEngineer, sample.LabDocPath,
sample.IsMoldanatInTrucks, sample.TruckDocPath, sample.IsPeopleSafty, sample.SafteyDocPath, uId, null, statusCode, statusMessage, sample.InvoicePhoto
, sample.CleanDocNote, sample.DustDocNote, sample.SummerDocNote, sample.LabDocNote, sample.TruckDocNote, sample.SafteyDocNote, sample.OtherReason);
TempData["AlertMessage1"] = "Success";
return(RedirectToAction("Home", "Home", 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
}));
}
public ActionResult ConcreteSample(CubeSamplesWithPath sample)
{
foreach (var file in sample.Cube1P1Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube1P1 = InputFileName + fi.Extension;
}
}
foreach (var file in sample.Cube1P2Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube1P2 = InputFileName + fi.Extension;
}
}
foreach (var file in sample.Cube2P1Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube2P1 = InputFileName + fi.Extension;
}
}
foreach (var file in sample.Cube2P2Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube2P2 = InputFileName + fi.Extension;
}
}
foreach (var file in sample.Cube3P1Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube3P1 = InputFileName + fi.Extension;
}
}
foreach (var file in sample.Cube3P2Path)
{
if (file != null)
{
Random random = new Random();
FileInfo fi = new FileInfo(file.FileName);
DateTime d = DateTime.Now;
var InputFileName = d.Ticks + random.Next(100, 100000000).ToString();
var ServerSavePath = System.IO.Path.Combine(Server.MapPath("~/Content"), InputFileName + fi.Extension);
//Save file to server folder
file.SaveAs(ServerSavePath);
sample.Cube3P2 = InputFileName + fi.Extension;
}
}
SampleCubePath s = new SampleCubePath()
{
SampleNumber = sample.SampleNumber,
Cube1P1 = sample.Cube1P1,
Cube1P2 = sample.Cube1P2,
Cube2P1 = sample.Cube2P1,
Cube2P2 = sample.Cube2P2,
Cube3P1 = sample.Cube3P1,
Cube3P2 = sample.Cube3P2
};
context.SampleCubePaths.Add(s);
context.SaveChanges();
return(RedirectToAction("BrokenSample", "Home", new
{
id = 1
}));
}
