private static void LoadTables(Server server, DataTable openTables, sqlController sqc)
{
foreach (DataRow r in openTables.Rows)
{
server.EnterExistingTable((int)r["TableNumber"], (int)r["NumGuests"]);
Table table = server.getTable((int)r["TableNumber"]);
table.ID = (int)r["ID"];
int billsCount = sqc.getBillCount(table);
while (billsCount > 0)
{
table.AddNewList();
billsCount -= 1;
}
DataTable billDT = sqc.getBills(table);
int count = billDT.Rows.Count;
List <Bill> bills = table.GetBills();
foreach (Bill bill in bills)
{
var query = from mRow in billDT.AsEnumerable()
where mRow.Field <int>("CheckNum") == bill.CheckNum
select mRow;
DataView njview = query.AsDataView();
bill.ID = Int32.Parse(njview[0]["ID"].ToString());
bill.Payment = Decimal.Parse(njview[0]["Payment"].ToString());
}
}
}
