public LoaiPhongInfo LoaiPhong_GetItem(int LoaiPhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@LoaiPhongID", LoaiPhongID);
SqlDataReader rd = SQLDB.executereader("sp_LoaiPhong_GetItem", CommandType.StoredProcedure);
LoaiPhongInfo item=null;
while (rd.Read())
{
item = new LoaiPhongInfo();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.LoaiPhongName = rd["LoaiPhongName"].ToString();
}
return item;
}
public List<LoaiPhongInfo> LoaiPhong_GetItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_LoaiPhong_GetItems", CommandType.StoredProcedure);
List<LoaiPhongInfo> list = new List<LoaiPhongInfo>();
LoaiPhongInfo item = null;
while (rd.Read())
{
item = new LoaiPhongInfo();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.LoaiPhongName = rd["LoaiPhongName"].ToString();
list.Add(item);
}
return list;
}
