public static LoaiPhong Read(SqlDataReader reader)
{
var lp = new LoaiPhong()
{
ID = reader.GetString(iID),
DonGia = reader.GetInt32(iDonGia)
};
return(lp);
}
public static bool DeleteLoaiPhong(LoaiPhong lp)
{
var cm = CreateCommand();
cm.CommandText = @"Exec delete_row_LoaiPhong @ID";
cm.Parameters.Add(new SqlParameter("@ID", lp.ID));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static bool ThemLoaiPhong(LoaiPhong lp)
{
var cm = CreateCommand();
cm.CommandText = @"Exec add_row_LoaiPhong @ID, @DonGia";
cm.Parameters.Add(new SqlParameter("@ID", lp.ID));
cm.Parameters.Add(new SqlParameter("@DonGia", lp.DonGia));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static List <LoaiPhong> DSLoaiPhong()
{
var llp = new List <LoaiPhong>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM LOAIPHONG";
var reader = cm.ExecuteReader();
while (reader.Read())
{
llp.Add(LoaiPhong.Read(reader));
}
cn.Close();
return(llp);
}
