//If the show all busbooking label is clicked, the grid will update to show all the current bus bookings in the database
private void label6_Click(object sender, EventArgs e)
{
BusBookingDBAccess bdba = new BusBookingDBAccess(db);
createTableShowAllBusBooking(bdba.getAllBusBooking());
selectedTable = "Bus";
}
private void button3_Click(object sender, EventArgs e)
{
//When the button has been hit change the data in the database depending on what has been entered into the gird
//Create access to the BusBooking table
BusBookingDBAccess bbdba = new BusBookingDBAccess(db);
//Call the UpdateBooking method and pass in the values you want to change
bbdba.UpdateBooking(BusBookingId, BusId, StaffId);
//Display an error message and make the grid empty
MessageBox.Show("The row in the database has been updated.", "Success");
busResults.DataSource = null;
}
private void button4_Click(object sender, EventArgs e)
{
try
{
//If the user selects show all, display all the entries for the Bus Booking
if (comboBox1.Text == "Show All")
{
BusBookingDBAccess bdba = new BusBookingDBAccess(db);
createTableToShowAllBusBooking(bdba.getAllBusBooking());
SelectedTable = "";
}
//If the user searchs for a Booking ID, Show all the entries where their entered ID matches ones in the database
else if (comboBox1.Text == "Booking ID")
{
BusBookingDBAccess bdba = new BusBookingDBAccess(db);
createTableToShowAllBusBooking(bdba.SelectWhereBookingID(Convert.ToInt32(textBox1.Text)));
SelectedTable = "BusBooking";
}
//If the user searchs for a Driver Name, Show all the entries where their entered name matches the one stored in the database
else if (comboBox1.Text == "Driver Name")
{
BusDBAccess bdba = new BusDBAccess(db);
string driverName = textBox1.Text;
createTableToShowBus(bdba.getWhereDriverIs(driverName));
SelectedTable = "Bus";
}
//If the user searchs for a Staff Name, Show all the entries where their entered name matches the one stored in the database
else if (comboBox1.Text == "Staff Name")
{
StaffDBAccess sdba = new StaffDBAccess(db);
string staffName = textBox1.Text;
createTableToShowStaff(sdba.GetStaffByName(staffName));
SelectedTable = "Staff";
}
}
catch { }
}
private void button1_Click(object sender, EventArgs e)
{
try
{
//This adds the new entry to the database
//Creates acces to the BusBooking table
BusBookingDBAccess bbda = new BusBookingDBAccess(db);
int _staffId = Convert.ToInt32(StaffBox.Text);
int _busId = Convert.ToInt32(BusBox.Text);
//Calls the InsertBusBook method and passes in the changed variables
bbda.InsertBusBook(_busId, _staffId);
//The succesform appears
this.Hide();
new SuccessForm(db, "Success, BusBooking Registered").Show();
}
//If there's a problem, show an error
catch
{
new ErrorBox(null).Show();
}
}
