private int ChangeTableIsActive(int tableNumber)
{
// Setting up a variable for the datatable from the database
RestaurantDataSet.TablesDataTable tables = new RestaurantDataSet.TablesDataTable();
// Setting up a tables adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.TablesTableAdapter tablesTableAdap = new RestaurantDataSetTableAdapters.TablesTableAdapter();
// Getting the table data from the database
tablesTableAdap.GetData();
// Filling the data to the datatable
tablesTableAdap.Fill(tables);
// Going and looking in the datatable for a given table number and returning the row
RestaurantDataSet.TablesRow tablesRow = tables.FindBytableNumber(activeTableNumber);
// Get data from record
string oldNumberofGuest = tablesRow.numberOfGuests;
int oldEmployeeId = tablesRow.employeeNumber;
if (tablesRow.isActive == "0")
{
// Set table to active and set the employee id
tablesTableAdap.Update(oldNumberofGuest, "1", activeEmployeeNumber, activeTableNumber, oldEmployeeId);
return(1);
}
else
{
MessageBox.Show("Table is already occupied; Clear table to start new order");
return(0);
}
}
private void btnClearTable_Click(object sender, EventArgs e)
{
int tableNumber;
// Validate that the item number is a integer
if (int.TryParse(txtTableNumber.Text, out tableNumber) == false)
{
MessageBox.Show("Please enter a valid item number.");
}
else
{
// Setting up a variable for the datatable from the database
RestaurantDataSet.TablesDataTable tables = new RestaurantDataSet.TablesDataTable();
// Setting up a tables adaptor and it's to fill in the datatable
RestaurantDataSetTableAdapters.TablesTableAdapter tablesTableAdap = new RestaurantDataSetTableAdapters.TablesTableAdapter();
// Getting the table data from the database
tablesTableAdap.GetData();
// Filling the data to the datatable
tablesTableAdap.Fill(tables);
// Going and looking in the datatable for a given table number and returning the row
RestaurantDataSet.TablesRow tablesRow = tables.FindBytableNumber(tableNumber);
if (tablesRow == null)
{
MessageBox.Show("Could not find item number, please try again.");
tableNumber = 0;
}
else
{
// Get data from record
string oldNumberofGuest = tablesRow.numberOfGuests;
int oldEmployeeId = tablesRow.employeeNumber;
// Set table to active and set the employee id
tablesTableAdap.Update(oldNumberofGuest, "0", 19, tableNumber, oldEmployeeId);
// Close window and notify user
MessageBox.Show("Table " + tableNumber + " cleared.");
this.Close();
}
}
}