public static RoomSizeViewModel GetRoomSizeViewModel(int roomsizeid)
{
RoomSizeViewModel model = null;
RoomSize size = GetRoomSize(roomsizeid);
if (size != null)
{
model = new RoomSizeViewModel();
model.RoomSize = size;
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
string sql = "SELECT COUNT(DISTINCT RoomID) count FROM Room, dbo.RoomType WHERE Room.RoomTypeID = RoomType.RoomTypeID AND RoomSizeID = @roomsizeid";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@roomsizeid", roomsizeid);
var rs = cm.ExecuteReader();
if (rs.Read())
{
model.Count = rs.GetInt32(0);
}
conn.Close();
}
}
}
return model;
}
public static List<RoomSizeViewModel> GetAllRoomSizeViewModel()
{
List<RoomSizeViewModel> list = new List<RoomSizeViewModel>();
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
SqlCommand cm = new SqlCommand("SELECT RoomSizeID FROM RoomSize", conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
RoomSizeViewModel model = GetRoomSizeViewModel(rs.GetInt32(0));
list.Add(model);
}
}
conn.Close();
}
}
return list;
}
