public string GetTenLoaiKMByID(int idLKM)
{
string query = "SELECT * FROM LoaiKhuyenMai WHERE id=" + idLKM;
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
LoaiKhuyenMaiDTO lkm = new LoaiKhuyenMaiDTO(item);
return(lkm.TenLoaiKM);
}
return(string.Empty);
}
public int GetIDByTenLoaiKM(string tenKM)
{
string query = "SELECT * FROM LoaiKhuyenMai WHERE TenLoaiKM = N'" + tenKM + "'";
DataTable table = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in table.Rows)
{
LoaiKhuyenMaiDTO lkm = new LoaiKhuyenMaiDTO(item);
return(lkm.Id);
}
return(-1);
}
public List <LoaiKhuyenMaiDTO> GetListLoaiSP()
{
List <LoaiKhuyenMaiDTO> dsKM = new List <LoaiKhuyenMaiDTO>();
string query = ("SELECT * From LoaiKhuyenMai");
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
LoaiKhuyenMaiDTO lkm = new LoaiKhuyenMaiDTO(item);
dsKM.Add(lkm);
}
return(dsKM);
}
