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 HistoryofRequests()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Bookingdata> Book = meh.Bookingdatas.Where(X => X.RequestStatus == "true").ToList();
return(View(Book));
}
public ActionResult general()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Account> account = meh.Accounts.ToList();
return(View(account));
}
public ActionResult MehndiEvents()
{
MehriamarqueeEntities objforcontext = new MehriamarqueeEntities();
List <Bookingdata> booklist = objforcontext.Bookingdatas.Where(X => X.Program.programName == "Mehndi").ToList();
//BookingViewModel bookmodel = new BookingViewModel();
//List<BookingViewModel> bookmodellist = booklist.Select(x => new BookingViewModel
//{
// functionId = x.functionID,
// bookingDate = x.bookingDate,
// functionDate = x.functionDate,
// noofGuest = x.noofGuest,
// rateperGuest = x.rateperGuest,
// stagesCharges = x.AdvancePayment,
// basics_others = x.RemainingPayment,
// Extras = x.Extras,
// TotalCharges = x.TotalCharges,
// timeShift = x.timeShift,
// Menuname = x.Menu.menuName,
// ProgramName = x.Program.programName,
// CnicNo = x.CnicNo,
// customerName = x.Customer.customerName,
// Address = x.Customer.address,
// mobileNo = x.Customer.mobileNo,
// remarks = x.Customer.remarks,
//}).ToList();
return(View(booklist));
}
public ActionResult Alldetailoffunction(DateTime?SearchtermDate = null, long SearchtermCnic = 0)
{
MehriamarqueeEntities objforcontext = new MehriamarqueeEntities();
if (SearchtermDate == null && SearchtermCnic == 0)
{
TempData["message"] = " Function Date and CNIC No can't be Empty";
RedirectToAction("Alldetailoffunction");
}
if (SearchtermDate == null)
{
List <Bookingdata> booklist = objforcontext.Bookingdatas.Where(X => X.Customer.CnicNo == SearchtermCnic).ToList();
return(View(booklist));
}
if (SearchtermCnic == 0)
{
List <Bookingdata> booklist = objforcontext.Bookingdatas.Where(X => X.functionDate == SearchtermDate).ToList();
return(View(booklist));
}
else
{
List <Bookingdata> booklist = objforcontext.Bookingdatas.Where(X => X.functionDate == SearchtermDate && X.Customer.CnicNo == SearchtermCnic).ToList();
return(View(booklist));
}
}
public ActionResult AccountPayable(DateTime FromDate, DateTime ToDate)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
long creditbalance = 0;
long debitblance = 0;
long totaaccountpayable = 0;
List <SubAccountBalance> accountpayable = meh.SubAccountBalances.Where(X => X.subID == 16 && X.Date >= FromDate && X.Date <= ToDate).ToList();
foreach (var i in accountpayable)
{
if (i.Credit != 0)
{
creditbalance = creditbalance + i.Credit;
}
else
{
debitblance = debitblance + i.Debit;
}
}
totaaccountpayable = creditbalance - debitblance;
ViewBag.totaaccountpayable = totaaccountpayable;
ViewBag.FromDate = FromDate;
ViewBag.ToDate = ToDate;
return(View());
}
public ActionResult CheckFunctionRequest()
{
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
List <FunctionRequestedTable> request = meh.FunctionRequestedTables.ToList();
List <CheckFunctionRequestViewModel> Requestlist = new List <CheckFunctionRequestViewModel>();
List <CheckFunctionRequestViewModel> Request = request.Select(X => new CheckFunctionRequestViewModel
{
requestID = X.requestID,
functionID = X.functionID,
requestDate = X.requestDate,
bookingDate = X.Bookingdata.bookingDate,
functionDate = X.Bookingdata.functionDate,
noofGuests = X.Bookingdata.noofGuest,
rateperGuest = X.Bookingdata.rateperGuest,
menuID = X.Bookingdata.MenuId,
menuName = X.Bookingdata.Menu.menuName,
RequestStatus = X.Status
}).ToList();
var Model = new NameofItem();
return(View(Request));
}
}
// GET: Deserts
public ActionResult ViewDeserts()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Desert> its = new List <Desert>();
its = meh.Deserts.ToList();
return(View(its));
}
public ActionResult TrailBalance()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Account> acctr = meh.Accounts.ToList();
return(View(acctr));
}
public ActionResult Creategeneralledger()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <AccountTransaction> acctr = meh.AccountTransactions.ToList();
return(View(acctr));
}
public ActionResult EditBeverages(Beverage beve)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(beve).State = System.Data.Entity.EntityState.Modified;
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();
}
}
// GET: Berverages
public ActionResult ViewBeverages()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Beverage> its = new List <Beverage>();
its = meh.Beverages.ToList();
return(View(its));
}
// GET: Vegetable
public ActionResult ViewVegetable()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <Item> its = new List <Item>();
its = meh.Items.Where(x => x.category.Equals("Vegetable")).ToList();
return(View(its));
}
// GET: Test
public ActionResult CustomerInfoGet()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
ViewData["CustomerInfo"] = meh.Customers.ToList();
return(View());
}
public ActionResult EditBeverages(int idofbeve)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
Beverage its = new Beverage();
its = meh.Beverages.Where(X => X.beverageId == idofbeve).FirstOrDefault();
return(View(its));
}
public ActionResult UpdateVegetable(int idofitem)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
Item its = new Item();
its = meh.Items.Where(x => x.category == "Vegetable" && x.itemId == idofitem).FirstOrDefault();
return(View(its));
}
public ActionResult UpdateDeserts(int idofDese)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
Desert its = new Desert();
its = meh.Deserts.Where(X => X.desertId == idofDese).FirstOrDefault();
return(View(its));
}
public ActionResult EditVegetable(Item it)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(it).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(RedirectToAction("ViewVegetable"));
}
public List <Bookingdata> GetBookingdetail()
{
List <Bookingdata> bookdatas = new List <Bookingdata>();
using (MehriamarqueeEntities db = new MehriamarqueeEntities())
{
bookdatas = db.Bookingdatas.ToList();
}
return(bookdatas);
}
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 ActionResult EditDeserts(Desert de)
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
meh.Entry(de).State = System.Data.Entity.EntityState.Modified;
meh.SaveChanges();
return(RedirectToAction("ViewDeserts"));
}
// GET: StocksDetail
public ActionResult Index()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
var totalrequests = meh.FunctionRequestedTables.Where(x => x.Status == "SENDED").Count();
ViewBag.totalrequests = totalrequests;
return(View());
}
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 List <Customer> FindCustomer(long searchterm)
{
List <Customer> custmer = new List <Customer>();
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
custmer = meh.Customers.Where(X => X.CnicNo.Equals(searchterm)).ToList();
}
return(custmer);
}
public Customer UpdateCustomer(long id)
{
Customer cust = new Customer();
using (MehriamarqueeEntities meh = new MehriamarqueeEntities())
{
cust = meh.Customers.Where(X => X.customerID == id).FirstOrDefault();
}
return(cust);
}
public List <Customer> GetCustomers()
{
List <Customer> Custmer = new List <Customer>();
using (MehriamarqueeEntities db = new MehriamarqueeEntities())
{
Custmer = db.Customers.ToList();
}
return(Custmer);
}
public ActionResult additionalINFoprint(int id)
{
MehriamarqueeEntities objforcontext = new MehriamarqueeEntities();
AdditionalfacilitiesINFO addi = new AdditionalfacilitiesINFO();
List <Bookingdata> book = objforcontext.Bookingdatas.Where(X => X.functionID == id).ToList();
List <AdditionalFacilitiesandFunction> bookmodellist = objforcontext.AdditionalFacilitiesandFunctions.Where(x => x.functionID.Equals(id)).ToList();
ViewData["book"] = book;
return(View(bookmodellist));
}
public ActionResult History()
{
MehriamarqueeEntities meh = new MehriamarqueeEntities();
List <QuantityupdatedItemtable> quaitem = meh.QuantityupdatedItemtables.ToList();
List <QuantityupdateBeveragestable> quaBeve = meh.QuantityupdateBeveragestables.ToList();
List <QuantityupdatedDeserttable> quaDese = meh.QuantityupdatedDeserttables.ToList();
ViewData["quaBeve"] = quaBeve;
ViewData["quaDese"] = quaDese;
return(View(quaitem));
}
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();
}
}
