public ActionResult EditFunctionGet(int id) { AddNewFunction custcls = new AddNewFunction(); Bookingdata cust = custcls.Updatefunction(id); return(View(cust)); }
public Bookingdata Updatefunction(int id) { Bookingdata cust = new Bookingdata(); using (MehriamarqueeEntities meh = new MehriamarqueeEntities()) { cust = meh.Bookingdatas.Where(X => X.functionID == id).FirstOrDefault(); } return(cust); }
public void DeleteFunctionbyID(int id) { Bookingdata book = new Bookingdata { functionID = id }; using (MehriamarqueeEntities meh = new MehriamarqueeEntities()) { meh.Entry(book).State = System.Data.Entity.EntityState.Deleted; meh.SaveChanges(); } }
public ActionResult DeleteAdditional(int id) { MehriamarqueeEntities objforcontext = new MehriamarqueeEntities(); AdditionalFacilitiesandFunction addi = new AdditionalFacilitiesandFunction(); Bookingdata book = new Bookingdata(); addi = objforcontext.AdditionalFacilitiesandFunctions.Where(x => x.additionalID.Equals(id)).FirstOrDefault(); book = objforcontext.Bookingdatas.Where(x => x.functionID.Equals(addi.functionID)).FirstOrDefault(); value = addi.additionalFacilityPrice ?? default(int); book.TotalCharges = book.TotalCharges - value; objforcontext.Entry(book).State = System.Data.Entity.EntityState.Modified; objforcontext.SaveChanges(); objforcontext.Entry(addi).State = System.Data.Entity.EntityState.Deleted; objforcontext.SaveChanges(); return(View("Index")); }
public ActionResult RequestFunction(int ID) { MehriamarqueeEntities meh = new MehriamarqueeEntities(); Bookingdata book = meh.Bookingdatas.Where(X => X.functionID == ID).FirstOrDefault(); book.RequestStatus = "true"; meh.Entry(book).State = System.Data.Entity.EntityState.Modified; meh.SaveChanges(); FunctionRequestedTable funcls = new FunctionRequestedTable(); funcls.functionID = ID; funcls.requestDate = DateTime.Today; funcls.Status = "SENDED"; meh.FunctionRequestedTables.Add(funcls); meh.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult EditFunctionGet(EditNewFunction function) { MehriamarqueeEntities mqe = new MehriamarqueeEntities(); Bookingdata bookdata = new Bookingdata(); List <AdditionalFacilitiesandFunction> addi = new List <AdditionalFacilitiesandFunction>(); addi = mqe.AdditionalFacilitiesandFunctions.Where(X => X.functionID == function.functionID).ToList(); bookdata.functionID = function.functionID; 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.timeShift = function.timeShift; bookdata.CnicNo = function.CnicNO; bookdata.customerID = function.customerID; bookdata.RequestStatus = function.RequestStatus; bookdata.MenuId = function.MenuId; bookdata.ProgramId = function.ProgramId; int totalpriceoffacility = 0; foreach (var item in addi) { totalpriceoffacility = totalpriceoffacility + item.additionalFacilityPrice ?? default(int); } var fullTotal = totalrate + function.AdvancePayment + function.RemainingPayment + function.Extras + totalpriceoffacility; bookdata.TotalCharges = fullTotal ?? default(int); mqe.Entry(bookdata).State = System.Data.Entity.EntityState.Modified; mqe.SaveChanges(); return(RedirectToAction("Index", "ReservationEventsmain")); }
public ActionResult EditAdditional(EditAdditionalFacilities addfacility) { MehriamarqueeEntities objforcontext = new MehriamarqueeEntities(); AdditionalFacilitiesandFunction addi = new AdditionalFacilitiesandFunction(); Bookingdata book = new Bookingdata(); book = objforcontext.Bookingdatas.Where(x => x.functionID.Equals(addfacility.functionID)).FirstOrDefault(); addi = objforcontext.AdditionalFacilitiesandFunctions.Where(x => x.functionID.Equals(addfacility.functionID)).FirstOrDefault(); value = addi.additionalFacilityPrice ?? default(int); book.TotalCharges = book.TotalCharges - value; objforcontext.Entry(book).State = System.Data.Entity.EntityState.Modified; objforcontext.SaveChanges(); addi.additionalandfunctionID = addfacility.additionalandfunctionID; addi.additionalID = addfacility.additionalID; addi.functionID = addfacility.functionID; addi.additionalFacilityPrice = addfacility.additionalFacilityPrice; objforcontext.Entry(addi).State = System.Data.Entity.EntityState.Modified; objforcontext.SaveChanges(); book.TotalCharges = book.TotalCharges + addfacility.additionalFacilityPrice ?? default(int); objforcontext.Entry(book).State = System.Data.Entity.EntityState.Modified; objforcontext.SaveChanges(); return(RedirectToAction("Alldetailoffunction", "ReservationEventsmain")); }
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")); }