public static List <RoomStyleViewModel> GetAllRoomStyleViewModel()
{
List <RoomStyleViewModel> list = new List <RoomStyleViewModel>();
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
SqlCommand cm = new SqlCommand("SELECT RoomStyleID FROM RoomStyle", conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
RoomStyleViewModel model = GetRoomStyleViewModel(rs.GetInt32(0));
list.Add(model);
}
}
conn.Close();
}
}
return(list);
}
public static RoomStyleViewModel GetRoomStyleViewModel(int roomstyleid)
{
RoomStyleViewModel model = null;
RoomStyle style = GetRoomStyle(roomstyleid);
if (style != null)
{
model = new RoomStyleViewModel();
model.RoomStyle = style;
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 RoomStyleID = @roomstyleid";
SqlCommand cm = new SqlCommand(sql, conn);
cm.Parameters.AddWithValue("@roomstyleid", roomstyleid);
var rs = cm.ExecuteReader();
if (rs.Read())
{
model.Count = rs.GetInt32(0);
}
conn.Close();
}
}
}
return(model);
}
