public ActionResult EditFunctionGet(int id) { AddNewFunction custcls = new AddNewFunction(); Bookingdata cust = custcls.Updatefunction(id); return(View(cust)); }
public ActionResult MyValues(AddNewFunction function, string BasicStage, string Dj, string Electricity, string AcHeating, string FullHall) { try { if (function.bookingDate > DateTime.Today && function.functionDate > function.bookingDate) { MehriamarqueeEntities mqe = new MehriamarqueeEntities(); Bookingdata bookdata = new Bookingdata(); List <Bookingdata> checkdate = new List <Bookingdata>(); checkdate = mqe.Bookingdatas.Where(X => X.functionDate == function.functionDate).ToList(); foreach (var item in checkdate) { if (item.functionDate == function.functionDate) { TempData["message"] = " Function Date Already Exisit"; goto ended; } } Customer cust = new Customer(); cust = mqe.Customers.Where(X => X.CnicNo == function.CnicNo).FirstOrDefault(); bookdata.bookingDate = function.bookingDate; bookdata.functionDate = function.functionDate; bookdata.noofGuest = function.noofGuest; bookdata.rateperGuest = function.rateperGuest; var totalrate = function.noofGuest * function.rateperGuest; bookdata.AdvancePayment = function.AdvancePayment; bookdata.RemainingPayment = function.RemainingPayment; bookdata.Extras = function.Extras; bookdata.CnicNo = function.CnicNo; bookdata.timeShift = function.timeShift; bookdata.MenuId = function.MenuId; bookdata.customerID = cust.customerID; bookdata.ProgramId = 1; bookdata.RequestStatus = "false"; Nullable <int> additionalTotal = 0; if (function.stagePrice != null) { additionalTotal = additionalTotal + function.stagePrice; } if (function.DjPrice != null) { additionalTotal = additionalTotal + function.DjPrice; } if (function.electriccityPrice != null) { additionalTotal = additionalTotal + function.electriccityPrice; } if (function.FullHallPrice != null) { additionalTotal = additionalTotal + function.FullHallPrice; } if (function.AcHeatingPrice != null) { additionalTotal = additionalTotal + function.AcHeatingPrice; } var fullTotal = totalrate + function.AdvancePayment + function.RemainingPayment + function.Extras + additionalTotal; bookdata.TotalCharges = fullTotal ?? default(int); ViewBag.fullTotal = fullTotal; mqe.Bookingdatas.Add(bookdata); mqe.SaveChanges(); functionId = bookdata.functionID; AdditionalFacilitiesandFunction facility = new AdditionalFacilitiesandFunction(); if (BasicStage == "true") { facility.functionID = functionId; facility.additionalID = 1; facility.additionalFacilityPrice = function.stagePrice; mqe.AdditionalFacilitiesandFunctions.Add(facility); mqe.SaveChanges(); } if (Dj == "true") { facility.functionID = functionId; facility.additionalID = 2; facility.additionalFacilityPrice = function.DjPrice; mqe.AdditionalFacilitiesandFunctions.Add(facility); mqe.SaveChanges(); } if (Electricity == "true") { facility.functionID = functionId; facility.additionalID = 3; facility.additionalFacilityPrice = function.electriccityPrice; mqe.AdditionalFacilitiesandFunctions.Add(facility); mqe.SaveChanges(); } if (AcHeating == "true") { facility.functionID = functionId; facility.additionalID = 4; facility.additionalFacilityPrice = function.AcHeatingPrice; mqe.AdditionalFacilitiesandFunctions.Add(facility); mqe.SaveChanges(); } if (FullHall == "true") { facility.functionID = functionId; facility.additionalID = 5; facility.additionalFacilityPrice = function.FullHallPrice; mqe.AdditionalFacilitiesandFunctions.Add(facility); mqe.SaveChanges(); } TempData["message"] = "Record Added Successfully"; } else { TempData["message"] = "Booking Date Must be greater than today Date and Function Date must be Greater than Booking Date"; } } catch (Exception) { } ended: ; return(RedirectToAction("CustomerInfoGet")); }