public ActionResult CustomerInfoPost(AddCustomerClass customer)
{
MehriamarqueeEntities mqe = new MehriamarqueeEntities();
Customer cust = new Customer();
Customer getcust = new Customer();
getcust = mqe.Customers.Where(X => X.CnicNo == customer.CnicNo).FirstOrDefault();
if (getcust == null)
{
cust.CnicNo = customer.CnicNo;
cust.customerName = customer.customerName;
cust.mobileNo = customer.mobileNo;
cust.address = customer.address;
cust.remarks = customer.remarks;
mqe.Customers.Add(cust);
mqe.SaveChanges();
TempData["message"] = "Record Added Successfully";
return(RedirectToAction("CustomerInfoGet"));
}
else
{
ModelState.AddModelError("", "User already Exisit with this CNIC NO");
}
return(View("CustomerInfoGet"));
}
public ActionResult UpdateVegetable(Item it, string UpdatedQuantity)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
it.quantity = it.quantity + int.Parse(UpdatedQuantity);
meh.Entry(it).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Now;
quant.Quantity = int.Parse(UpdatedQuantity);
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
return(RedirectToAction("ViewVegetable"));
}
public ActionResult EditBeverages(Beverage beve)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(beve).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(RedirectToAction("ViewBeverages"));
}
public ActionResult UpdateBeverages(Beverage beve, string UpdatedQuantity)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
beve.quantityOfBeverages = beve.quantityOfBeverages + int.Parse(UpdatedQuantity);
meh.Entry(beve).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
QuantityupdateBeveragestable quant = new QuantityupdateBeveragestable();
quant.beverageID = beve.beverageId;
quant.Date = DateTime.Now;
quant.Quantity = int.Parse(UpdatedQuantity);
meh.QuantityupdateBeveragestables.Add(quant);
meh.SaveChanges();
return(RedirectToAction("ViewBeverages"));
}
public void UpdateCustomerSave(Customer cus)
{
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
meh.Entry(cus).State = System.Data.Entity.EntityState.Modified;
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 UpdateDeserts(Desert de, string UpdatedQuantity)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
de.quantityOfdesert = de.quantityOfdesert + int.Parse(UpdatedQuantity);
meh.Entry(de).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
QuantityupdatedDeserttable quant = new QuantityupdatedDeserttable();
quant.desertID = de.desertId;
quant.Date = DateTime.Now;
quant.Quantity = int.Parse(UpdatedQuantity);
meh.QuantityupdatedDeserttables.Add(quant);
meh.SaveChanges();
return(RedirectToAction("ViewDeserts"));
}
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 EditVegetable(Item it)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(it).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(RedirectToAction("ViewVegetable"));
}
public ActionResult EditDeserts(Desert de)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(de).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(RedirectToAction("ViewDeserts"));
}
public void DeleteCustomerbyID(long id)
{
Customer cus = new Customer();
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
cus = meh.Customers.Where(X => X.customerID == id).FirstOrDefault();
meh.Entry(cus).State = System.Data.Entity.EntityState.Deleted;
meh.SaveChanges();
}
}
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 AddingnewaccountsPost(AddnewAccounts account)
{
MehriamarqueeEntities mqe = new MehriamarqueeEntities();
Account acc = new Account();
acc.accountName = account.accountName;
acc.Address = account.Address;
acc.Description = account.Description;
acc.mobileNo = account.mobileNo;
mqe.Accounts.Add(acc);
mqe.SaveChanges();
TempData["message"] = "Account Added Successfully";
return(RedirectToAction("Addingnewaccounts"));
}
public void Deleteadditional(int id)
{
List <AdditionalFacilitiesandFunction> addi = new List <AdditionalFacilitiesandFunction>();
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
addi = meh.AdditionalFacilitiesandFunctions.Where(x => x.functionID.Equals(id)).ToList();
foreach (var item in addi)
{
meh.Entry(item).State = System.Data.Entity.EntityState.Deleted;
meh.SaveChanges();
}
}
}
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 addgeneraljenrnalPost(AddGeneralJournalClass general)
{
MehriamarqueeEntities mqe = new MehriamarqueeEntities();
AccountTransaction acctr = new AccountTransaction();
acctr.accountNo = general.accountNo;
acctr.transactionDate = general.transactionDate;
acctr.transactionName = general.transactionName;
acctr.Debit_Credit = general.Debit_Credit;
acctr.amount = general.amount;
acctr.subtypeID = general.subtype;
mqe.AccountTransactions.Add(acctr);
mqe.SaveChanges();
SubAccountBalance sub = new SubAccountBalance();
sub.subID = general.subtype;
sub.accountNo = general.accountNo;
sub.Date = general.transactionDate;
if (general.Debit_Credit == "Debit")
{
sub.Debit = general.amount;
sub.Credit = 0;
}
else
{
sub.Debit = 0;
sub.Credit = general.amount;
}
mqe.SubAccountBalances.Add(sub);
mqe.SaveChanges();
TempData["message"] = "General journal Added Successfully";
return(RedirectToAction("general"));
}
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 addNewStocksPost(NewItemsadding add, string Categorylist, string Unitlist)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
try
{
if (Categorylist == "Vegetable")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Meats")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Grossory")
{
Item it = new Item();
it.itemName = add.itemName;
it.quantity = add.itemQuantity;
it.salesPrice = add.itemSalePrice;
it.purchasePrice = add.itemPurchasePrice;
it.category = Categorylist;
it.unit = Unitlist;
meh.Items.Add(it);
meh.SaveChanges();
QuantityupdatedItemtable quant = new QuantityupdatedItemtable();
quant.itemID = it.itemId;
quant.Date = DateTime.Today;
quant.Quantity = it.quantity;
meh.QuantityupdatedItemtables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Beverages")
{
Beverage beverage = new Beverage();
beverage.beveragesName = add.itemName;
beverage.quantityOfBeverages = add.itemQuantity;
beverage.beveragesSalePrice = add.itemSalePrice;
beverage.beveragesPurchasePrice = add.itemPurchasePrice;
meh.Beverages.Add(beverage);
meh.SaveChanges();
QuantityupdateBeveragestable quant = new QuantityupdateBeveragestable();
quant.beverageID = beverage.beverageId;
quant.Date = DateTime.Today;
quant.Quantity = beverage.quantityOfBeverages;
meh.QuantityupdateBeveragestables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
if (Categorylist == "Deserts")
{
Desert desert = new Desert();
desert.desertName = add.itemName;
desert.quantityOfdesert = add.itemQuantity;
desert.desertSalePrice = add.itemSalePrice;
desert.desertPurchasePrice = add.itemPurchasePrice;
meh.Deserts.Add(desert);
meh.SaveChanges();
QuantityupdatedDeserttable quant = new QuantityupdatedDeserttable();
quant.desertID = desert.desertId;
quant.Date = DateTime.Today;
quant.Quantity = desert.quantityOfdesert;
meh.QuantityupdatedDeserttables.Add(quant);
meh.SaveChanges();
TempData["message"] = "Stock Added Successfully";
}
}
catch (Exception)
{
TempData["message"] = "Server problem !Try Again";
}
return(RedirectToAction("addNewStocksGet"));
}
public ActionResult GetItemsForDish(List <string> items, List <string> Beve, List <string> Desert, int idofrequest)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Item> itemes = meh.Items.ToList();
List <Beverage> Beveitems = meh.Beverages.ToList();
List <Desert> Desetitems = meh.Deserts.ToList();
List <Dish> dihes = meh.Dishes.ToList();
for (int i = 0; i < items.Count; i++)
{
foreach (var itemcoun in dihes)
{
if (items[i] == itemcoun.dishName)
{
foreach (var getitems in itemes)
{
int count = 0;
if (items[i + 1] == "true")
{
DishWithItem dishofitem = new DishWithItem();
dishofitem.dishId = itemcoun.dishID;
dishofitem.itemId = getitems.itemId;
dishofitem.priceOfItems = int.Parse(items[i + 3]);
dishofitem.qunatityOfItems = int.Parse(items[i + 4]);
dishofitem.requestID = idofrequest;
Item getid = new Item();
using (MehriamarqueeEntities mh = new MehriamarqueeEntities())
{
getid = mh.Items.Where(X => X.itemId == getitems.itemId).FirstOrDefault();
if (getid.quantity >= int.Parse(items[i + 4]))
{
getid.quantity = getid.quantity - int.Parse(items[i + 4]);
mh.Entry(getid).State = System.Data.Entity.EntityState.Modified;
mh.SaveChanges();
}
else
{
TempData["message"] = "Quantity is low for required quantity";
goto exit
;
}
}
meh.DishWithItems.Add(dishofitem);
meh.SaveChanges();
i = i + 4;
count++;
}
if (count == 0)
{
i = i + 3;
}
}
}
}
}
for (int i = 0; i < Beve.Count; i++)
{
foreach (var itemcoun in dihes)
{
if (Beve[i] == itemcoun.dishName)
{
foreach (var getitems in Beveitems)
{
int count = 0;
if (Beve[i + 1] == "true")
{
beveragesWithFunctionWithMenu dishofitem = new beveragesWithFunctionWithMenu();
dishofitem.dishID = itemcoun.dishID;
dishofitem.beverageID = getitems.beverageId;
dishofitem.PriceBeverages = int.Parse(Beve[i + 3]);
dishofitem.quantityBeverages = int.Parse(Beve[i + 4]);
dishofitem.requestID = idofrequest;
Beverage getid = new Beverage();
using (MehriamarqueeEntities mh = new MehriamarqueeEntities())
{
getid = mh.Beverages.Where(X => X.beverageId == getitems.beverageId).FirstOrDefault();
if (getid.quantityOfBeverages >= int.Parse(Beve[i + 4]))
{
getid.quantityOfBeverages = getid.quantityOfBeverages - int.Parse(Beve[i + 4]);
mh.Entry(getid).State = System.Data.Entity.EntityState.Modified;
mh.SaveChanges();
}
else
{
TempData["message"] = "Quantity is low for required quantity";
goto exit
;
}
}
meh.beveragesWithFunctionWithMenus.Add(dishofitem);
meh.SaveChanges();
i = i + 4;
count++;
}
if (count == 0)
{
i = i + 3;
}
}
}
}
}
for (int i = 0; i < Desert.Count; i++)
{
foreach (var itemcoun in dihes)
{
if (Desert[i] == itemcoun.dishName)
{
foreach (var getitems in Desetitems)
{
int count = 0;
if (Desert[i + 1] == "true")
{
DesertWithFunctionWithMenu dishofitem = new DesertWithFunctionWithMenu();
dishofitem.dishID = itemcoun.dishID;
dishofitem.desertID = getitems.desertId;
dishofitem.PriceDesert = int.Parse(Desert[i + 3]);
dishofitem.quantityDesert = int.Parse(Desert[i + 4]);
dishofitem.requestID = idofrequest;
Desert getid = new Desert();
using (MehriamarqueeEntities mh = new MehriamarqueeEntities())
{
getid = mh.Deserts.Where(X => X.desertId == getitems.desertId).FirstOrDefault();
if (getid.quantityOfdesert >= int.Parse(Desert[i + 4]))
{
getid.quantityOfdesert = getid.quantityOfdesert - int.Parse(Desert[i + 4]);
mh.Entry(getid).State = System.Data.Entity.EntityState.Modified;
mh.SaveChanges();
}
else
{
TempData["message"] = "Quantity is low for required quantity";
goto exit
;
}
}
meh.DesertWithFunctionWithMenus.Add(dishofitem);
meh.SaveChanges();
i = i + 4;
count++;
}
if (count == 0)
{
i = i + 3;
}
}
}
}
}
exit:
FunctionRequestedTable func = meh.FunctionRequestedTables.Where(X => X.requestID == idofrequest).FirstOrDefault();
func.Status = "SERVED";
meh.Entry(func).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(View("Index"));
}
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"));
}