// [Route] public ActionResult Manage(string options, string search) { string hotelName = HotelName.GetHotelName(User.Identity.GetUserName()); var all = db.Customer.Where(x => x.HotelName == hotelName).ToList(); if (options == "1") { all = db.Customer.Where(x => x.Name.StartsWith(search) && x.HotelName == hotelName || search == null).ToList(); } else if (options == "2") { all = db.Customer.Where(x => x.Surname.StartsWith(search) && x.HotelName == hotelName || search == null).ToList(); } else if (options == "3") { all = db.Customer.Where(x => x.Date_from.ToString() == search && x.HotelName == hotelName || search == null).ToList(); } else if (options == "4") { all = db.Customer.Where(x => x.Date_to.ToString() == search && x.HotelName == hotelName || search == null).ToList(); } else if (options == "5") { all = db.Customer.Where(x => x.Room.ToString() == search && x.HotelName == hotelName || search == null).ToList(); } ManageViewModel vm = new ManageViewModel() { Tuples = all }; return(View(vm)); }
public ActionResult Add(Customer customer) { customer.HotelName = HotelName.GetHotelName(User.Identity.GetUserName()); ViewBag.Number = 0; if (customer.Date_from.CompareTo(customer.Date_to) == 1) { ViewBag.Message = "Invalid date! The starting date cannot be later than the ending date."; return(View("Add", customer)); } else { if (!CheckAndAdd.CheckDays(customer.Date_from, customer.Date_to, customer.Room, customer.HotelName)) { ViewBag.Message = "The chosen date is already resereved for this room."; return(View("Add", customer)); } else { if (!ModelState.IsValid) { return(View("Add", customer)); } else { db.Customer.Add(customer); db.SaveChanges(); ViewBag.Message = "Reservation has been added successfully!"; ViewBag.Number = 1; return(View("Add")); } } } }
public ActionResult Edit(int id) { var customer = db.Customer.Single(x => x.CustomerId == id); string hotelName = HotelName.GetHotelName(User.Identity.GetUserName()); if (customer.HotelName == hotelName) { return(View(customer)); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Delete(int id) { string hotelName = HotelName.GetHotelName(User.Identity.GetUserName()); var customer = db.Customer.Single(x => x.CustomerId == id); if (customer.HotelName == hotelName) { HSSContext db = new HSSContext(); var x = db.Customer.First(u => u.CustomerId == id); db.Customer.Remove(x); db.SaveChanges(); return(View()); } else { return(RedirectToAction("Manage")); } }