public List <ClsDrink> getListDrink()
{
List <ClsDrink> listDrink = new List <ClsDrink>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC SP_listDrink");
foreach (DataRow item in data.Rows)
{
ClsDrink drink = new ClsDrink(item);
listDrink.Add(drink);
}
return(listDrink);
}
//tim kiem drink
public List <ClsDrink> timkiem(string name)
{
List <ClsDrink> listDrink = new List <ClsDrink>();
DataTable data = DataProvider.Instance.ExcuteQuery("SELECT * FROM drink WHERE dbo.GetUnsignString(name) LIKE N'%' + dbo.GetUnsignString(N'" + name + "') + '%'");
foreach (DataRow item in data.Rows)
{
ClsDrink drink = new ClsDrink(item);
listDrink.Add(drink);
}
return(listDrink);
}
public List <ClsDrink> listDrink(int id)
{
List <ClsDrink> list = new List <ClsDrink>();
DataTable data = DataProvider.Instance.ExcuteQuery("EXEC SP_getDrinkbyIdTypeDrink " + id);
foreach (DataRow item in data.Rows)
{
ClsDrink drink = new ClsDrink(item);
list.Add(drink);
}
return(list);
}
