public bool takeReceipt(int tableID)
{
profileDataContext myContext = new profileDataContext();
tableOrder tOrder = new tableOrder();
if (getTableOrder(tableID) != null)
{
// Query the database for the row to be updated.
var query =
from tord in myContext.tableOrders
where tord.tableID == tableID
select tord;
// Execute the query, and change the column values
// you want to change.
foreach (tableOrder tord in query)
{
tord.isPaid = true;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
myContext.SubmitChanges();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
// Provide for exceptions.
return(false);
}
}
return(false);
}
private void detach_tableOrders(tableOrder entity)
{
this.SendPropertyChanging();
entity.restaurantTable = null;
}
partial void DeletetableOrder(tableOrder instance);
partial void UpdatetableOrder(tableOrder instance);
partial void InserttableOrder(tableOrder instance);