public List <LoaiSanPham_DTO> Retrieve_LoaiSanPham()
{
List <LoaiSanPham_DTO> dsLSP = new List <LoaiSanPham_DTO>();
string sql = @"select * from LoaiSanPham";
SqlDataReader dr = DataProvider.Retrieve_Table(sql);
while (dr.Read())
{
LoaiSanPham_DTO lsp = new LoaiSanPham_DTO();
if (!dr.IsDBNull(0))
{
lsp.MaLoaiSP = (string)dr["MaLoaiSP"];
}
if (!dr.IsDBNull(1))
{
lsp.TenLoaiSP = (string)dr["TenLoaiSP"];
}
if (!dr.IsDBNull(2))
{
lsp.TrangThai = (Boolean)dr["TrangThai"];
}
dsLSP.Add(lsp);
}
return(dsLSP);
}
public List <LoaiSanPham_DTO> LoadToanBoLoaiSanPham()
{
List <LoaiSanPham_DTO> lstLoaiSP = new List <LoaiSanPham_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("LoadToanBoLoaiSanPham");
foreach (DataRow item in data.Rows)
{
LoaiSanPham_DTO loaiSP = new LoaiSanPham_DTO(item);
lstLoaiSP.Add(loaiSP);
}
return(lstLoaiSP);
}
public List <LoaiSanPham_DTO> TimKiemLSP(string str)
{
List <LoaiSanPham_DTO> DanhSachLSP = new List <LoaiSanPham_DTO>();
string query = "select * from LoaiSanPham where TenLoai like N'%" + str + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
LoaiSanPham_DTO LSP = new LoaiSanPham_DTO(item);
DanhSachLSP.Add(LSP);
}
return(DanhSachLSP);
}
public List <LoaiSanPham_DTO> LayTatCaLoaiSanPham()
{
List <LoaiSanPham_DTO> DanhSachLSP = new List <LoaiSanPham_DTO>();
string query = "select * from LoaiSanPham";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
LoaiSanPham_DTO LSP = new LoaiSanPham_DTO(item);
DanhSachLSP.Add(LSP);
}
return(DanhSachLSP);
}
