public static bool DeleteLoaiKhachHang(LoaiKhachHang lkh)
{
var cm = CreateCommand();
cm.CommandText = @"Exec delete_row_LoaiKhachHang @ID";
cm.Parameters.Add(new SqlParameter("@ID", lkh.ID));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static LoaiKhachHang Read(SqlDataReader reader)
{
var lkh = new LoaiKhachHang()
{
ID = reader.GetString(iID),
TenLoai = reader.GetString(iTenLoai)
};
//byte[] bytes = Encoding.Default.GetBytes(lkh.TenLoai);
//lkh.TenLoai = Encoding.UTF8.GetString(bytes);
return(lkh);
}
public static List <LoaiKhachHang> DSLoaiKhachHang()
{
var llkh = new List <LoaiKhachHang>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM LOAIKHACHHANG";
var reader = cm.ExecuteReader();
while (reader.Read())
{
llkh.Add(LoaiKhachHang.Read(reader));
}
cn.Close();
return(llkh);
}
