// Use this for initialization
void Start()
{
if (instance == null)
{
instance = this;
}
else if (instance != this)
{
Destroy(gameObject);
}
}
public List <Mennu> GetListMenuByTable(int id)
{
List <Mennu> listMenu = new List <Mennu>();
string query = "SELECT f.name, bi.count, f.price, f.price*bi.count AS totalPrice FROM dbo.BillInfo AS bi, dbo.Bill AS b, dbo.Food AS f WHERE bi.idBill = b.id AND bi.idFood = f.id AND b.status = 0 AND b.idTable = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Mennu menu = new Mennu(item);
listMenu.Add(menu);
}
return(listMenu);
}
