public ActionResult ConstructionBuilder() { //this will return 1 row from db with id 0f 2 var context = new ConstructionEntities(); var container = new ConstructionPrice(); container = context.ConstructionPrice.Where(m => m.Id == 2).FirstOrDefault(); //this will return multiple rows eg dispaly all users in the company var listOfQuotes = new List <ConstructionPrice>(); listOfQuotes = context.ConstructionPrice.ToList(); var vm = new ConWork(); return(View(vm)); }
public ActionResult ConstructionBuilder(ConWork vm) { var DbContext = new ConstructionEntities(); var row = new ConstructionPrice(); decimal DemCostPrice = 50; decimal SiteClearCost = 50; vm.PreConTotal = (vm.DemMetre * DemCostPrice) + (vm.SiteClearMetre * SiteClearCost); decimal SubStruc = 120; vm.StructureCost = (vm.FloorLength * SubStruc) * vm.Stories; decimal BuildSize = vm.FloorLength * vm.Stories; decimal Walls; //int Roof = 100; if (vm.ExternalWall == "brick") { Walls = 450 * BuildSize; } else if (vm.ExternalWall == "stone") { Walls = 500 * BuildSize; } else if (vm.ExternalWall == "wood") { Walls = 325 * BuildSize; } else { Walls = 0; } vm.SuperStructCost = Walls; //+ (Roof + vm.RoofStructure); decimal door = 400; decimal window = 600; decimal Rooftiles; if (vm.RoofTiles == "crt") { Rooftiles = 500 * vm.FloorLength; } else if (vm.RoofTiles == "nsrt") { Rooftiles = 700 * vm.FloorLength; } else if (vm.RoofTiles == "crt2") { Rooftiles = 550 * vm.FloorLength; } else if (vm.RoofTiles == "asrt") { Rooftiles = 400 * vm.FloorLength; } else { Rooftiles = 0; } vm.ExternalCost = (door * vm.NoDoors) + (window * vm.NoWindows) + Rooftiles; decimal plumbingCost; decimal heatingCost; decimal electricCost; decimal plasteringCost; decimal decorCost; if (vm.Plumbing == true) { plumbingCost = 100 * BuildSize; } else { plumbingCost = 0; } if (vm.Heating == true) { heatingCost = 100 * BuildSize; } else { heatingCost = 0; } if (vm.Electrics == true) { electricCost = 100 * BuildSize; } else { electricCost = 0; } if (vm.Plastering == true) { plasteringCost = 100 * BuildSize; } else { plasteringCost = 0; } if (vm.Decor == true) { decorCost = 100 * BuildSize; } else { decorCost = 0; } decimal PatioCost = 50; decimal DriveWayCost = 50; vm.ServicesCost = plumbingCost + heatingCost + electricCost + plasteringCost + decorCost + (PatioCost * vm.PatioMetre) + (DriveWayCost * vm.DriveWayMetre); vm.Extra = 250 * BuildSize; vm.TotalCost = vm.PreConTotal + vm.StructureCost + vm.SuperStructCost + vm.ExternalCost + vm.ServicesCost + vm.Extra; row.Demolition = vm.Demolition; row.DemMetre = vm.DemMetre; row.SiteClear = vm.SiteClear; row.SiteClearMetre = vm.SiteClearMetre; row.PreConTotal = vm.PreConTotal; row.Stories = vm.Stories; row.FloorLength = vm.FloorLength; row.StructureCost = vm.StructureCost; row.ExternalWall = vm.ExternalWall; row.RoofStructure = vm.RoofStructure; row.SuperStructCost = vm.SuperStructCost; row.RoofTiles = vm.RoofTiles; row.NoDoors = vm.NoDoors; row.NoWindows = vm.NoWindows; row.ExternalCost = vm.ExternalCost; row.Plumbing = vm.Plumbing; row.Heating = vm.Heating; row.Electrics = vm.Electrics; row.Plastering = vm.Plastering; row.Decor = vm.Decor; row.Patio = vm.Patio; row.PatioMetre = vm.PatioMetre; row.DriveWay = vm.DriveWay; row.DriveWayMetre = vm.DriveWayMetre; row.ServicesCost = vm.ServicesCost; row.Extra = vm.Extra; row.TotalCost = vm.TotalCost; int UserVal = Convert.ToInt32(Session["userId"]); row.UserId = UserVal; DbContext.ConstructionPrice.Add(row); var rowsCount = DbContext.SaveChanges(); return(RedirectToAction("ConstructionBuilderSummary", "ConstructionSummary")); //return View(vm); }
public ActionResult ConstructionBuilderSummary(ConWork vm) { return(View(vm)); }