public ActionResult UpdateMixingDesign(AddMixDesign mix) { try { // TODO: Add insert logic here int uId = Convert.ToInt32(Session["UserId"].ToString()); ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int)); ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string)); db.AddUpdateConcMixDesing(mix.Id, mix.FactoryId, mix.ConcreteRank, mix.CementWeight, mix.WaterWeight, mix.WashedSand, mix.Rubble3by4, mix.Rubble3by8, mix.WhiteSand, mix.Cement, mix.Water, mix.WashedSand2, mix.Rubble3by42, mix.Rubble3by82, mix.WhiteSand2, mix.C28Day, mix.Landing, mix.Status, null, mix.Comments, mix.CreatedBy, mix.CreatedDate, uId, null, statusCode, statusMessage); if (mix.Status == "Waiting") { TempData["AlertMessage"] = "Waiting"; } return(RedirectToAction("ApproveMixingDesign", "MixingDesign", new { id = 1 })); } catch { return(View()); } }
public ActionResult AddMixingDesign(AddMixDesign mix) { try { // TODO: Add insert logic here ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int)); ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string)); db.AddUpdateConcMixDesing(0, mix.FactoryId, mix.ConcreteRank, mix.CementWeight, mix.WaterWeight, mix.WashedSand, mix.Rubble3by4, mix.Rubble3by8, mix.WhiteSand, "Pending", null, mix.Comments, null, null, null, null, statusCode, statusMessage); return(View("MixingDesign")); } catch { return(View()); } }
public ActionResult AddMixingDesign(AddMixDesign mix) { try { // TODO: Add insert logic here int uId = Convert.ToInt32(Session["UserId"].ToString()); ObjectParameter statusCode = new ObjectParameter("StatusCode", typeof(int)); ObjectParameter statusMessage = new ObjectParameter("StatusMessage", typeof(string)); ConcreteMixingDesign mixD = new ConcreteMixingDesign() { C28Day = mix.C28Day, Cement = mix.Cement, CementWeight = mix.CementWeight, Comments = mix.Comments, ConcreteRank = mix.ConcreteRank, CreatedBy = uId, CreatedDate = DateTime.Now, ExpiryDate = DateTime.Now, FactoryId = mix.FactoryId, Landing = mix.Landing, Rubble3by4 = mix.Rubble3by4, Rubble3by42 = mix.Rubble3by42, Rubble3by8 = mix.Rubble3by8, Rubble3by82 = mix.Rubble3by82, Status = "Pending", UpdatedBy = uId, UpdatedDate = DateTime.Now, WashedSand = mix.WashedSand, WashedSand2 = mix.WashedSand2, Water = mix.Water, WaterWeight = mix.WaterWeight, WhiteSand = mix.WhiteSand, WhiteSand2 = mix.WhiteSand2 }; db.ConcreteMixingDesigns.Add(mixD); db.SaveChanges(); foreach (HttpPostedFileBase file in mix.files) { //Checking file is available to save. 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); MaterialResultsPdf mPdf = new MaterialResultsPdf() { MixingDesignId = mixD.Id, PdfPath = InputFileName + fi.Extension, FileName = file.FileName }; db.MaterialResultsPdfs.Add(mPdf); db.SaveChanges(); } } TempData["AlertMessage"] = "Design Added Successfully"; return(RedirectToAction("MixingDesign", "MixingDesign", new { id = 1 })); } catch { return(View()); } }