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(); } }