//Details
public ActionResult Details(int?id)
{
if (Session["User_Name"] != null)
{
Guest_Info guest = db.guest_Info.Where(x => x.Room_No == id).FirstOrDefault();
return(View(guest));
}
else
{
return(RedirectToAction("LogIn"));
}
}
public static void CreatGuest(string Name, string Address, string Mobile, string Home_Phone)
{
using (var context = new HotelDatabaseEntities())
{
var New_Guest = new Guest_Info();
New_Guest.Name = Name;
New_Guest.Address = Address;
New_Guest.Mobile = Mobile;
New_Guest.Home_Phone = Home_Phone;
context.Guest_Info.Add(New_Guest);
context.SaveChanges();
ClearValues();
}
}
public ActionResult Leave(int?id)
{
if (Session["User_Name"] != null)
{
Guest_Info guest = db.guest_Info.Where(x => x.Room_No == id).FirstOrDefault();
List <Guest_Info> multipleguest = db.guest_Info.Where(x => x.Guest_name == guest.Guest_name && x.Guest_addr == guest.Guest_addr && x.Guest_phone == guest.Guest_phone && x.Country == guest.Country && x.City == guest.City && x.age == guest.age).ToList();
if (multipleguest.Count() > 1)
{
ViewBag.multipleRoomLeave = multipleguest.Count();
}
return(View(guest));
}
else
{
return(RedirectToAction("LogIn"));
}
}
public ActionResult multipleRoomLeave(Guest_Info Guest)
{
if (Session["User_Name"] != null)
{
if (userclassobject.removeMultipleUser(Guest) == true)
{
return(RedirectToAction("Index"));
}
else
{
return(View(Guest));
}
}
else
{
return(RedirectToAction("LogIn"));
}
}
//Http Get for Delete
public ActionResult DeleteRoom(int id)
{
if (Session["Admin_Name"] != null)
{
Guest_Info guest = db.guest_Info.Where(x => x.Room_No == id).FirstOrDefault();
if (guest == null)
{
Hotel_Info hotel = db.hotel_Info.Find(id);
db.hotel_Info.Remove(hotel);
db.SaveChanges();
TempData["SuccessMessage"] = "Are you sure to delete this record?";
return(RedirectToAction("Index"));
}
TempData["AlertMessage"] = "You can't delete this data";
return(RedirectToAction("Index"));
}
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"));
}
}
public ActionResult singleBooking(Guest_Info guest)
{
string paramID = RouteData.Values["id"].ToString();
if (paramID == guest.Room_No.ToString())
{
if (ModelState.IsValid)
{
db.guest_Info.Add(guest);
Hotel_Info hotel = db.hotel_Info.Where(x => x.Room_No == guest.Room_No).FirstOrDefault();
hotel.IsBooked = true;
db.SaveChanges();
int RoomNo;
if (guest.Room_No.HasValue)
{
RoomNo = (int)guest.Room_No;
userclassobject.addAllGuestInfo(RoomNo);
}
return(RedirectToAction("Index"));
}
}
ModelState.AddModelError("", "Room No should not be changed. Input '" + paramID + "'");
return(View(guest));
}
//Remove Multiple User
public bool removeMultipleUser(Guest_Info Guest)
{
int i = 0;
SqlConnection con = new SqlConnection(config);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
//Hotel Info
string command = "update Hotel_Info set IsBooked = @IsBooked WHERE Room_No IN(SELECT Room_No FROM Guest_Info WHERE Guest_name = @Guest_name and Guest_addr = @Guest_addr and Guest_phone = @Guest_phone and Country = @Country and City = @City and age = @age)";
SqlCommand com = new SqlCommand(command, con);
com.Parameters.AddWithValue("@IsBooked", false);
com.Parameters.AddWithValue("@Guest_name", Guest.Guest_name);
com.Parameters.AddWithValue("@Guest_addr", Guest.Guest_addr);
com.Parameters.AddWithValue("@Guest_phone", Guest.Guest_phone);
com.Parameters.AddWithValue("@Country", Guest.Country);
com.Parameters.AddWithValue("@City", Guest.City);
com.Parameters.AddWithValue("@age", Guest.age);
i += com.ExecuteNonQuery();
com.Parameters.Clear();
//Guest Info
string command1 = "update Guest_Info set Room_No = @Room_No where Guest_name = @Guest_name and Guest_addr = @Guest_addr and Guest_phone = @Guest_phone and Country = @Country and City = @City and age = @age";
SqlCommand cmd = new SqlCommand(command1, con);
cmd.Parameters.AddWithValue("@Room_No", DBNull.Value);
cmd.Parameters.AddWithValue("@Guest_name", Guest.Guest_name);
cmd.Parameters.AddWithValue("@Guest_addr", Guest.Guest_addr);
cmd.Parameters.AddWithValue("@Guest_phone", Guest.Guest_phone);
cmd.Parameters.AddWithValue("@Country", Guest.Country);
cmd.Parameters.AddWithValue("@City", Guest.City);
cmd.Parameters.AddWithValue("@age", Guest.age);
i += cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
//AllGuestInfo
string command2 = "update AllGuestInfo set IsBooked = @IsBooked where Guest_name = @Guest_name and Guest_addr = @Guest_addr and Guest_phone = @Guest_phone and Country = @Country and City = @City and age = @age";
SqlCommand cmd1 = new SqlCommand(command2, con);
cmd1.Parameters.AddWithValue("@IsBooked", false);
cmd1.Parameters.AddWithValue("@Guest_name", Guest.Guest_name);
cmd1.Parameters.AddWithValue("@Guest_addr", Guest.Guest_addr);
cmd1.Parameters.AddWithValue("@Guest_phone", Guest.Guest_phone);
cmd1.Parameters.AddWithValue("@Country", Guest.Country);
cmd1.Parameters.AddWithValue("@City", Guest.City);
cmd1.Parameters.AddWithValue("@age", Guest.age);
i += cmd1.ExecuteNonQuery();
cmd1.Parameters.Clear();
con.Close();
if (i < 3)
{
return(false);
}
else
{
return(true);
}
}
