public List <THUCUONG> THONGKETHUCUONG()
{
List <THUCUONG> danhsachthucuong = new List <THUCUONG>();
string query = "SELECT * FROM DBO.DRINK ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
THUCUONG dsthucuong = new THUCUONG(item);
danhsachthucuong.Add(dsthucuong);
}
return(danhsachthucuong);
}
public List <THUCUONG> LayCBDanhSachThucUong(int id)
{
List <THUCUONG> danhsachthucuong = new List <THUCUONG>();
string query = "select * from DRINK where iddrinklist = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
THUCUONG dsthucuong = new THUCUONG(item);
danhsachthucuong.Add(dsthucuong);
}
return(danhsachthucuong);
}
public List <THUCUONG> TimKiemThucUong(string drinkname)
{
List <THUCUONG> danhsachthucuong = new List <THUCUONG>();
string query = string.Format("SELECT * FROM DBO.DRINK WHERE drinkname LIKE N'%{0}%'", drinkname);
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
THUCUONG drink = new THUCUONG(item);
danhsachthucuong.Add(drink);
}
return(danhsachthucuong);
}
