public static bool DeleteDT_TheoLoaiPhong(DT_TheoLoaiPhong dttlp)
{
var cm = CreateCommand();
cm.CommandText = @"Exec delete_row_DT_THEOLOAIPHONG @ID";
cm.Parameters.Add(new SqlParameter("@ID", dttlp.ID));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static DT_TheoLoaiPhong Read(SqlDataReader reader)
{
var bc = new DT_TheoLoaiPhong()
{
ID = reader.GetString(iID),
MaLoaiPhong = reader.GetString(iMaLoaiPhong),
NgayBatDau = reader.GetDateTime(iNgayBatDau),
NgayKetThuc = reader.GetDateTime(iNgayKetThuc),
DoanhThu = reader.GetInt32(iDoanhThu)
};
return(bc);
}
public static bool ThemDT_TheoLoaiPhong(DT_TheoLoaiPhong dttlp)
{
var cm = CreateCommand();
cm.CommandText = @"Exec add_row_DT_THEOLOAIPHONG @ID, @MaLoaiPhong, @NgayBatDau, @NgayKetThuc, @DoanhThu";
cm.Parameters.Add(new SqlParameter("@ID", dttlp.ID));
cm.Parameters.Add(new SqlParameter("@MaLoaiPhong", dttlp.MaLoaiPhong));
cm.Parameters.Add(new SqlParameter("@NgayBatDau", dttlp.NgayBatDau));
cm.Parameters.Add(new SqlParameter("@NgayKetThuc", dttlp.NgayKetThuc));
cm.Parameters.Add(new SqlParameter("@DoanhThu", dttlp.DoanhThu));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static bool UpdateDT_TheoLoaiPhong(DT_TheoLoaiPhong dttlp)
{
var cm = CreateCommand();
cm.CommandText = @"Exec update_row_DT_THEOLOAIPHONG @ID, @MLP, @NBD, @NKT, @DT";
cm.Parameters.Add(new SqlParameter("@ID", dttlp.ID));
cm.Parameters.Add(new SqlParameter("@MLP", dttlp.MaLoaiPhong));
cm.Parameters.Add(new SqlParameter("@NBD", dttlp.NgayBatDau));
cm.Parameters.Add(new SqlParameter("@NKT", dttlp.NgayKetThuc));
cm.Parameters.Add(new SqlParameter("@DT", dttlp.DoanhThu));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static List <DT_TheoLoaiPhong> DSDT_TheoLoaiPhong()
{
var ldttlp = new List <DT_TheoLoaiPhong>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM DT_THEOLOAIPHONG";
var reader = cm.ExecuteReader();
while (reader.Read())
{
ldttlp.Add(DT_TheoLoaiPhong.Read(reader));
}
cn.Close();
return(ldttlp);
}