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); }