public ActionResult AllInfo() { if (Session["Admin_Name"] != null) { List <AllGuestInfo> alreadyIn = db.allGuestInfo.Where(x => x.IsBooked == true).ToList(); List <AllGuestInfo> leave = db.allGuestInfo.Where(x => x.IsBooked == false).ToList(); List <AllGuestInfo> totalGuest = db.allGuestInfo.ToList(); AllGuestInfo context = new AllGuestInfo(); ViewBag.alreadyIn = alreadyIn.Count(); ViewBag.leave = leave.Count(); ViewBag.TotalGuest = alreadyIn.Count() + leave.Count(); List <Hotel_Info> booked = db.hotel_Info.Where(x => x.IsBooked == true).ToList(); List <Hotel_Info> notbooked = db.hotel_Info.Where(x => x.IsBooked == false).ToList(); ViewBag.Booked = booked.Count(); ViewBag.notBooked = notbooked.Count(); List <AuthenticateUser> admin = db.authenticateUser.Where(x => x.UserLevel == "Level1").ToList(); List <AuthenticateUser> user = db.authenticateUser.Where(x => x.UserLevel == "Level2").ToList(); ViewBag.Admin = admin.Count(); ViewBag.User = user.Count(); return(View()); } return(RedirectToAction("LogIn", "User")); }
//Details of a guest public ActionResult GuestDetails(int id) { if (Session["Admin_Name"] != null) { AllGuestInfo guest = new AllGuestInfo(); guest = db.allGuestInfo.Single(x => x.ID == id); return(View(guest)); } return(RedirectToAction("LogIn", "User")); }
public ActionResult SingleRoomLeave(Guest_Info guest) { if (Session["User_Name"] != null) { UserClass user = new UserClass(); int id = guest.Guest_Id; if (user.removeUser(id)) { Hotel_Info hotel = db.hotel_Info.Where(x => x.Room_No == guest.Room_No).FirstOrDefault(); AllGuestInfo guestInfo = db.allGuestInfo.Where(x => x.Guest_Id == guest.Guest_Id).FirstOrDefault(); hotel.IsBooked = false; guestInfo.IsBooked = false; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(guest)); } else { return(RedirectToAction("LogIn")); } }