// GET: ConcreteFactoryReports public ActionResult ConcreteFactoryReports(int id) { var factory = db.Factory11.Where(f => f.Id == id).FirstOrDefault(); var samples = db.ConcreteSample1.OrderByDescending(s => s.ReportNo).ToList(); var lastSample = samples.Count() == 0 ? null : samples.FirstOrDefault(); ConcreteSamplesWithPath sample = new ConcreteSamplesWithPath(); //sample.FactoryId = factory.Id; sample.SampleNumber = lastSample == null ? 5001 : lastSample.SampleNumber + 1; sample.ReportNo = lastSample == null ? 6001 : lastSample.ReportNo + 1; sample.VisitNumber = lastSample == null ? 3001 : lastSample.VisitNumber + 1; sample.FactoryName = factory.Name; sample.FactoryLocation = factory.Location; //sample.ClientName = factory.OwnerName; return(View(sample)); }
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 })); }