public ActionResult EditAdditional(int idofadditional)
{
MehriamarqueeEntities objforcontext = new MehriamarqueeEntities();
AdditionalFacilitiesandFunction addi = new AdditionalFacilitiesandFunction();
EditAdditionalFacilities edit = new EditAdditionalFacilities();
addi = objforcontext.AdditionalFacilitiesandFunctions.Where(x => x.additionalandfunctionID == idofadditional).FirstOrDefault();
return(View(addi));
}
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 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"));
}
