public void EditRoom(Hotel_Info hotel)
{
using (SqlConnection con = new SqlConnection(config))
{
string command = "update Hotel_Info set Room_type=@Room_type, IsBooked=@IsBooked where Room_No=@Room_No";
SqlCommand cmd = new SqlCommand(command, con);
SqlParameter paramNo = new SqlParameter();
paramNo.ParameterName = "@Room_No";
paramNo.Value = hotel.Room_No;
cmd.Parameters.Add(paramNo);
SqlParameter paramType = new SqlParameter();
paramType.ParameterName = "@Room_type";
paramType.Value = hotel.Room_type;
cmd.Parameters.Add(paramType);
SqlParameter paramBook = new SqlParameter();
paramBook.ParameterName = "@IsBooked";
paramBook.Value = hotel.IsBooked;
cmd.Parameters.Add(paramBook);
con.Open();
cmd.ExecuteNonQuery();
}
}
public void AddRoom(Hotel_Info hotel)
{
using (SqlConnection con = new SqlConnection(config))
{
string command = "Insert into Hotel_Info(Room_No, Room_type, IsBooked) values(@Room_No,@Room_type,@IsBooked)";
SqlCommand cmd = new SqlCommand(command, con);
SqlParameter paramNo = new SqlParameter();
paramNo.ParameterName = "@Room_No";
paramNo.Value = hotel.Room_No;
cmd.Parameters.Add(paramNo);
SqlParameter paramType = new SqlParameter();
paramType.ParameterName = "@Room_type";
paramType.Value = hotel.Room_type;
cmd.Parameters.Add(paramType);
SqlParameter paramBook = new SqlParameter();
paramBook.ParameterName = "@IsBooked";
paramBook.Value = hotel.IsBooked;
cmd.Parameters.Add(paramBook);
con.Open();
cmd.ExecuteNonQuery();
}
}
public ActionResult EditRoom(int?id)
{
if (Session["Admin_Name"] != null)
{
Hotel_Info hotel = db.hotel_Info.Single(x => x.Room_No == id);
return(View(hotel));
}
return(RedirectToAction("LogIn", "User"));
}
public ActionResult AddRoom(Hotel_Info hotel)
{
if (ModelState.IsValid)
{
UserClass user = new UserClass();
user.AddRoom(hotel);
return(RedirectToAction("LogIn", "User"));
}
else
{
return(View(hotel));
}
}
//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 EditRoom(Hotel_Info hotel)
{
if (ModelState.IsValid)
{
Hotel_Info h = db.hotel_Info.Where(x => x.Room_No == hotel.Room_No).FirstOrDefault();
if (h == null)
{
UserClass user = new UserClass();
user.EditRoom(hotel);
}
else
{
ModelState.AddModelError("", "Room is already exist.");
return(View(hotel));
}
return(RedirectToAction("Index"));
}
else
{
return(View(hotel));
}
}
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));
}
