public ActionResult Edit(LVGquote lVGquote) { Type = (from b in db.section1Model where b.id == lVGquote.Section1ModelId select b.ProjectType).SingleOrDefault(); ViewBag.LiftTypes = GetLiftType1(lVGquote.CodeComplence, lVGquote.id); ViewBag.LiftModels = GetLiftModel1(lVGquote.LiftType, lVGquote.EntranceType); ViewBag.CarWallsLHSS = car.getCarWalls(); ViewBag.powers = Getpower1(lVGquote.LiftType, "fake"); ViewBag.CodeComp = car.getobj(Type); ViewBag.Phone = car.getPhone(Type); ViewBag.Ceilings = car.getCeiling(); ViewBag.Floors = car.getFloors(); ViewBag.Profiles = car.getProfiles(); ViewBag.COP = car.getCOP(); ViewBag.HandrailTypes = car.getHandRailType(Type); ViewBag.LDFDoorType = car.LDFDoorType(lVGquote.LiftType); ViewBag.LDFDoorFinishs1 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType1.Substring(0, 1)); ViewBag.LDFDoorFinishs2 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType2.Substring(0, 1)); ViewBag.LDFDoorFinishs3 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType3.Substring(0, 1)); ViewBag.LDFDoorFinishs4 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType4.Substring(0, 1)); ViewBag.LDFDoorFinishs5 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType5.Substring(0, 1)); ViewBag.LDFDoorFinishs6 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType6.Substring(0, 1)); ViewBag.LDFDoorFinishs7 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType7.Substring(0, 1)); ViewBag.LDFDoorFinishs8 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType8.Substring(0, 1)); ViewBag.LDFDoorFinishs9 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType9.Substring(0, 1)); ViewBag.LDFDoorFinishs10 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType10.Substring(0, 1)); ViewBag.StructureFinish = car.getStructureFinish(lVGquote.StructureType); ViewBag.Claddings = car.getCladding(lVGquote.StructureType); ViewBag.entrancetypes = car.getEntranceTypes(lVGquote.EntranceType); try { var actualValue = Convert.ToDecimal(lVGquote.TotalSellingPrice, CultureInfo.CurrentCulture); } catch (FormatException e) { ModelState.AddModelError(e.Message, "Name is required."); } if (ModelState.IsValid) { lVGquote.MyType = "LVGquote"; db.Entry(lVGquote).State = EntityState.Modified; db.SaveChanges(); return View(lVGquote); } return View(lVGquote); }
public ActionResult Create(LVGquote lVGquote) { if (ModelState.IsValid) { lVGquote.MyType = "LVGquote"; db.MainQuote.Add(lVGquote); db.SaveChanges(); var model = (from r in db.section1Model where r.id == lVGquote.Section1ModelId select r).SingleOrDefaultAsync(); // return View(model); return RedirectToAction("Edit", "LVGquotes", new { id = lVGquote.id }); } ViewBag.ProductId = lVGquote.Section1ModelId; ViewBag.CodeComp = car.getobj(Type); ViewBag.LiftTypes = GetLiftType1(lVGquote.CodeComplence, lVGquote.id); ViewBag.LiftModels = GetLiftModel1(lVGquote.LiftType, lVGquote.EntranceType); ViewBag.CarWallsLHSS = car.getCeiling(); ViewBag.powers = Getpower1(lVGquote.LiftType, "fake"); ViewBag.Phone = car.getPhone(Type); ViewBag.Ceilings = car.getCeiling(); ViewBag.Floors = car.getFloors(); ViewBag.Profiles = car.getProfiles(); ViewBag.COP = car.getCOP(); ViewBag.HandrailTypes = car.getHandRailType(Type); ViewBag.LDFDoorType = car.LDFDoorType(lVGquote.LiftType); ViewBag.LDFDoorFinishs1 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType1.Substring(0, 1)); ViewBag.LDFDoorFinishs2 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType2.Substring(0, 1)); ViewBag.LDFDoorFinishs3 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType3.Substring(0, 1)); ViewBag.LDFDoorFinishs4 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType4.Substring(0, 1)); ViewBag.LDFDoorFinishs5 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType5.Substring(0, 1)); ViewBag.LDFDoorFinishs6 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType6.Substring(0, 1)); ViewBag.LDFDoorFinishs7 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType7.Substring(0, 1)); ViewBag.LDFDoorFinishs8 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType8.Substring(0, 1)); ViewBag.LDFDoorFinishs9 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType9.Substring(0, 1)); ViewBag.LDFDoorFinishs10 = car.LDFDoorFinish(lVGquote.LiftType, lVGquote.LDFDoorType10.Substring(0, 1)); ViewBag.StructureFinish = car.getStructureFinish(lVGquote.StructureType); ViewBag.Claddings = car.getCladding(lVGquote.StructureType); ViewBag.entrancetypes = car.getEntranceTypes(lVGquote.EntranceType); return View(lVGquote); }
public ActionResult CreateQuoteWithSave(LVGquote lvgquote, string nameOfSubmit) { if (nameOfSubmit == "Save and Create Pdf") { { Type = (from b in db.section1Model where b.id == lvgquote.Section1ModelId select b.ProjectType).SingleOrDefault(); Branch = (from b in db.section1Model where b.id == lvgquote.Section1ModelId select b.Branch).SingleOrDefault(); ViewBag.LiftTypes = GetLiftType1(lvgquote.CodeComplence, lvgquote.id); ViewBag.LiftModels = GetLiftModel1(lvgquote.LiftType, lvgquote.EntranceType); ViewBag.CarWallsLHSS = car.getCarWalls(); // ViewBag.CarWallsRHS = car.getCarWalls(); //ViewBag.CarWallsRear = car.getCarWalls(); ViewBag.powers = Getpower1(lvgquote.LiftType, "fake"); ViewBag.CodeComp = car.getobj(Type); ViewBag.Phone = car.getPhone(Type); ViewBag.Ceilings = car.getCeiling(); ViewBag.Floors = car.getFloors(); ViewBag.Profiles = car.getProfiles(); ViewBag.COP = car.getCOP(); ViewBag.HandrailTypes = car.getHandRailType(Type); ViewBag.LDFDoorType = car.LDFDoorType(lvgquote.LiftType); ViewBag.LDFDoorFinishs1 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType1.Substring(0, 1)); ViewBag.LDFDoorFinishs2 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType2.Substring(0, 1)); ViewBag.LDFDoorFinishs3 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType3.Substring(0, 1)); ViewBag.LDFDoorFinishs4 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType4.Substring(0, 1)); ViewBag.LDFDoorFinishs5 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType5.Substring(0, 1)); ViewBag.LDFDoorFinishs6 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType6.Substring(0, 1)); ViewBag.LDFDoorFinishs7 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType7.Substring(0, 1)); ViewBag.LDFDoorFinishs8 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType8.Substring(0, 1)); ViewBag.LDFDoorFinishs9 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType9.Substring(0, 1)); ViewBag.LDFDoorFinishs10 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType10.Substring(0, 1)); ViewBag.StructureFinish = car.getStructureFinish(lvgquote.StructureType); ViewBag.Claddings = car.getCladding(lvgquote.StructureType); ViewBag.entrancetypes = car.getEntranceTypes(lvgquote.EntranceType); // if (lVGquote.TotalSellingPrice == 0) // ModelState.AddModelError("Name", "Name is required."); try { var actualValue = Convert.ToDecimal(lvgquote.TotalSellingPrice, CultureInfo.CurrentCulture); } catch (FormatException e) { //ModelState.Errors.Add(e); ModelState.AddModelError(e.Message, "Name is required."); } if (ModelState.IsValid) { lvgquote.MyType = "LVGquote"; db.Entry(lvgquote).State = EntityState.Modified; db.SaveChanges(); // return View(lvgquote); } } if (lvgquote.id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } MainQuote lVGquote = db.MainQuote.Find(lvgquote.id); if (lVGquote == null) { return HttpNotFound(); } PdfDocument paragraph1 = new PdfDocument(); string QuoteRoot = System.Configuration.ConfigurationManager.AppSettings["QuoteRoot"]; string filename = "C:\\" + QuoteRoot + "\\" + Branch+"\\" + lVGquote.LiftType + "_P" + lVGquote.Section1ModelId + "-" + lVGquote.id + ".pdf"; PdfGenerator pdfg = new PdfGenerator(); paragraph1 = pdfg.CreatePdf(lVGquote); paragraph1.Save(filename); //// ...and start a viewer // Process.Start(filename); var email = new NewCommentEmail { To = "*****@*****.**", UserName = lVGquote.id.ToString(), //Comment = "Hello,There is a new comment from " + UserName; }; // email.Attach(new Attachment(filename)); // email.Send(); var filesavename = lVGquote.LiftType + "_P" + lVGquote.Section1ModelId + "-" + lVGquote.id + ".pdf"; return File(filename, "Application/pdf", filesavename); } else { { Type = (from b in db.section1Model where b.id == lvgquote.Section1ModelId select b.ProjectType).SingleOrDefault(); ViewBag.LiftTypes = GetLiftType1(lvgquote.CodeComplence, lvgquote.id); ViewBag.LiftModels = GetLiftModel1(lvgquote.LiftType, lvgquote.EntranceType); ViewBag.CarWallsLHSS = car.getCarWalls(); // ViewBag.CarWallsRHS = car.getCarWalls(); //ViewBag.CarWallsRear = car.getCarWalls(); ViewBag.powers = Getpower1(lvgquote.LiftType, "fake"); ViewBag.CodeComp = car.getobj(Type); ViewBag.Phone = car.getPhone(Type); ViewBag.Ceilings = car.getCeiling(); ViewBag.Floors = car.getFloors(); ViewBag.Profiles = car.getProfiles(); ViewBag.COP = car.getCOP(); ViewBag.HandrailTypes = car.getHandRailType(Type); ViewBag.LDFDoorType = car.LDFDoorType(lvgquote.LiftType); ViewBag.LDFDoorFinishs1 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType1.Substring(0, 1)); ViewBag.LDFDoorFinishs2 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType2.Substring(0, 1)); ViewBag.LDFDoorFinishs3 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType3.Substring(0, 1)); ViewBag.LDFDoorFinishs4 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType4.Substring(0, 1)); ViewBag.LDFDoorFinishs5 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType5.Substring(0, 1)); ViewBag.LDFDoorFinishs6 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType6.Substring(0, 1)); ViewBag.LDFDoorFinishs7 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType7.Substring(0, 1)); ViewBag.LDFDoorFinishs8 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType8.Substring(0, 1)); ViewBag.LDFDoorFinishs9 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType9.Substring(0, 1)); ViewBag.LDFDoorFinishs10 = car.LDFDoorFinish(lvgquote.LiftType, lvgquote.LDFDoorType10.Substring(0, 1)); ViewBag.StructureFinish = car.getStructureFinish(lvgquote.StructureType); ViewBag.Claddings = car.getCladding(lvgquote.StructureType); ViewBag.entrancetypes = car.getEntranceTypes(lvgquote.EntranceType); // if (lVGquote.TotalSellingPrice == 0) // ModelState.AddModelError("Name", "Name is required."); try { var actualValue = Convert.ToDecimal(lvgquote.TotalSellingPrice, CultureInfo.CurrentCulture); } catch (FormatException e) { //ModelState.Errors.Add(e); ModelState.AddModelError(e.Message, "Name is required."); } if (ModelState.IsValid) { lvgquote.MyType = "LVGquote"; db.Entry(lvgquote).State = EntityState.Modified; db.SaveChanges(); //return View(lvgquote); } return RedirectToAction("Edit", "LVGquotes", new { id = lvgquote.id }); } } }
// GET: LVGquotes/Create public ActionResult Create(int section_1) { Type = (from b in db.section1Model where b.id == section_1 select b.ProjectType).SingleOrDefault(); ViewBag.SectionType = Type; ViewBag.ProductId = section_1; LVGquote model = new LVGquote(); var lifttypes = car.getLiftTypes(Type); var lift = GetLift(lifttypes, 0); ViewBag.LiftTypes = GetLiftType1(lifttypes, 0); ViewBag.LiftModels = GetLiftModel1(lift, "Front entrance"); if (lift == "DomusLift") { model.IntCarSizeDeep = "1300"; model.IntCarSizeWide = "1000"; model.ShaftSizeDeep = "1450"; model.ShaftSizeWide = "1400"; model.Door1SizeWide = "950"; model.Doo1SizeDeep = "2000"; model.Headroom = 2450; model.Pit = 130; model.Travel = 3000; model.CarHeight = 2000; model.ConCabSize = "600mm W x 280mm D x 1000mm H"; model.ConCabLocVer = "0"; model.ConCabLocHor = "2500"; model.Speed = "0.25"; } else { model.IntCarSizeDeep = "1400"; model.IntCarSizeWide = "1100"; model.ShaftSizeDeep = "1550"; if (lift == "Domus Evolution") { model.ShaftSizeWide = "1550"; } else { model.ShaftSizeWide = "1500"; } model.Door1SizeWide = "900"; model.Doo1SizeDeep = "2000"; model.Headroom = 2500; model.Pit = 130; model.Travel = 3000; model.CarHeight = 2000; model.ConCabSize = "720 mm W x 360 mm D x 1500 mm H"; model.ConCabLocVer = "0"; model.ConCabLocHor = "2500"; model.Speed = "0.15"; } ViewBag.CarWallsLHSS = car.getCarWalls(); // ViewBag.CarWallsRHS = car.getCarWalls(); //ViewBag.CarWallsRear = car.getCarWalls(); ViewBag.powers = Getpower1(lift, "fake"); ViewBag.CodeComp = car.getobj(Type); ViewBag.Phone = car.getPhone(Type); ViewBag.Ceilings = car.getCeiling(); ViewBag.Floors = car.getFloors(); ViewBag.Profiles = car.getProfiles(); ViewBag.COP = car.getCOP(); ViewBag.HandrailTypes = car.getHandRailType(Type); ViewBag.LDFDoorType = car.LDFDoorType(lift); ViewBag.LDFDoorFinish = car.LDFDoorFinish(lift, "B"); ViewBag.StructureFinish = car.getStructureFinish("Aluminium"); ViewBag.Claddings = car.getCladding("Aluminium"); ViewBag.entrancetypes = car.getEntranceTypes("Front entrance"); return View(model); }