Beispiel #1
0
        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"));
        }
Beispiel #2
0
 //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"));
     }
 }