public List <RoomTypeInfo> getReservation(string id)
{
// kode get data from sql server..
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
List <RoomTypeInfo> objList = new List <RoomTypeInfo>();
using (sqlcon)
{
sqlcon.Open();
string sql = "select * from tb_room_type where id_room_type = @id";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
sqlcom.Parameters.AddWithValue("@id", id);
SqlDataReader dr = sqlcom.ExecuteReader();
while (dr.Read())
{
RoomTypeInfo obj = new RoomTypeInfo();
obj.IDRoomType = dr.GetString(1);
obj.TipeRoomType = dr.GetString(2);
obj.PriceRoomType = (int)dr.GetInt64(3);
obj.InfoRoomType = dr.GetString(4);
objList.Add(obj);
}
}
sqlcon.Close();
}
return(objList);
}
public List <RoomTypeInfo> getTotalRoomType()
{
// kode get data from sql server..
Koneksi kon = new Koneksi();
SqlConnection sqlcon = kon.getConnection();
List <RoomTypeInfo> objList = new List <RoomTypeInfo>();
using (sqlcon)
{
sqlcon.Open();
string sql = "select b.name,COUNT(b.name) as jumlah from tb_room a inner join tb_room_type b on a.id_room_type = b.id_room_type where a.status = 'Available' group by b.name";
SqlCommand sqlcom = new SqlCommand(sql, sqlcon);
using (sqlcom)
{
SqlDataReader dr = sqlcom.ExecuteReader();
while (dr.Read())
{
RoomTypeInfo obj = new RoomTypeInfo();
obj.TipeRoomType = dr.GetString(0);
obj.TotalRoomType = (int)dr.GetInt32(1);
objList.Add(obj);
}
}
sqlcon.Close();
}
return(objList);
}