public ActionResult ViewCustomerEstimate() { var estId = Convert.ToInt32(RouteData.Values["id"]); CustomerEstimates model = db.CustomerEstimates.FirstOrDefault(x => x.CustomerEstimatesId == estId); return(View(model)); }
public static void CreateCustomerEstimate(int estimateId) { var existing = db.CustomerEstimates.FirstOrDefault(x => x.EstimateId == estimateId); if (existing == null) { var model = new CustomerEstimates() { EstimateId = estimateId }; db.CustomerEstimates.Add(model); db.SaveChanges(); } }
public ActionResult SaveCustomerEstimate(CreateCustomerEstimate estimate) { var existing = db.CustomerEstimates.FirstOrDefault(x => x.EstimateId == estimate.EstimateFormId); if (existing != null) { existing.CreateDate = estimate.CreateDate; existing.Start = estimate.Start; existing.End = estimate.End; existing.CustomerEstimatesId = existing.CustomerEstimatesId; existing.EstimateId = estimate.EstimateFormId; existing.ArrivalText = estimate.ArrivalText; existing.ArrivalTime = estimate.ArrivalTime; existing.CancellationText = estimate.CancellationText; existing.CustomerName = estimate.CustomerName; existing.ElevatorText = estimate.ElevatorText; existing.Fuel = estimate.Fuel; existing.HourlyRateText = estimate.HourlyRateText; existing.HoursEstimate = estimate.HoursEstimate; existing.IntroText = estimate.IntroText; existing.MattressCoverText = estimate.MattressCoverText; existing.MoveDate = estimate.MoveDate; existing.ParkingPermits = estimate.ParkingPermits; existing.ParkingPermitsText = estimate.ParkingPermitsText; existing.PaymentsText = estimate.PaymentsText; existing.PhoneNumber = estimate.PhoneNumber; existing.ReadPoliciesText = estimate.ReadPoliciesText; existing.ResponsibleText = estimate.ResponsibleText; existing.StormText = estimate.StormText; existing.Tolls = estimate.Tolls; existing.TotalEstimate = estimate.TotalEstimate; existing.TravelTimeText = estimate.TravelTimeText; existing.RepName = estimate.RepName; db.Entry(existing).State = EntityState.Modified; db.SaveChanges(); } var model = new CustomerEstimates() { CreateDate = DateTime.Now, Start = estimate.Start, End = estimate.End, EstimateId = estimate.EstimateFormId, ArrivalText = estimate.ArrivalText, ArrivalTime = estimate.ArrivalTime, CancellationText = estimate.CancellationText, CustomerName = estimate.CustomerName, ElevatorText = estimate.ElevatorText, Fuel = estimate.Fuel, HourlyRateText = estimate.HourlyRateText, HoursEstimate = estimate.HoursEstimate, IntroText = estimate.IntroText, MattressCoverText = estimate.MattressCoverText, MoveDate = estimate.MoveDate, ParkingPermits = estimate.ParkingPermits, ParkingPermitsText = estimate.ParkingPermitsText, PaymentsText = estimate.PaymentsText, PhoneNumber = estimate.PhoneNumber, ReadPoliciesText = estimate.ReadPoliciesText, ResponsibleText = estimate.ResponsibleText, StormText = estimate.StormText, Tolls = estimate.Tolls, TotalEstimate = estimate.TotalEstimate, TravelTimeText = estimate.TravelTimeText, RepName = estimate.RepName }; db.CustomerEstimates.Add(model); db.SaveChanges(); return(RedirectToAction("ViewCustomerEstimate", new { id = model.CustomerEstimatesId })); }