public static RoomViewModel GetRoomViewModel(int roomid)
{
RoomViewModel model = null;
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
SqlCommand cm = new SqlCommand("select * from Room where RoomID = @roomid", conn);
cm.Parameters.AddWithValue("@roomid", roomid);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
rs.Read();
model = new RoomViewModel();
model.RoomID = rs.GetInt32(0);
model.RoomType = RoomTypeDAO.GetRoomTypeModel(rs.GetInt32(1));
model.Status = rs.GetString(2);
Booking CurrentBooking = BookingDAO.GetCurrentBookingOfRoom(model.RoomID);
if (CurrentBooking != null)
{
model.Guests = StayDAO.GetALLGuestsOfBooking(CurrentBooking.BookingID);
model.RemainingTime = BookingDAO.GetRemainingTimeOfBooking(CurrentBooking.BookingID);
}
else
{
model.Guests = new List <Guest>();
model.RemainingTime = TimeSpan.Zero;
}
}
conn.Close();
}
}
return(model);
}
public static List <Stay> GetStaysOfBooking(int bookingid)
{
List <Stay> stays = new List <Stay>();
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
SqlCommand cm = new SqlCommand("select * from Stay WHERE BookingID = @bookingid", conn);
cm.Parameters.AddWithValue("@bookingid", bookingid);
var rs = cm.ExecuteReader();
while (rs.Read())
{
Stay s = StayDAO.GetStay(rs.GetInt32(0));
stays.Add(s);
}
}
}
return(stays);
}
