private void button1_Click(object sender, EventArgs e)
{
string SearchedName = textBox1.Text;
ParentDBAccess pdba = new ParentDBAccess(db);
SelectAllWhereName(pdba.SelectAllParentsWhereName(SearchedName));
}
private void button3_Click(object sender, EventArgs e)
{
//Shows all the data for the parent table which matches the searched for parent name
if (comboBox1.Text == "Parent Name")
{
ParentDBAccess pdba = new ParentDBAccess(db);
string name = searchBox.Text;
createTable(pdba.SelectAllParentsWhereName(name));
}
//Shows all the data for the parent table which matches the searched for parent town
else if (comboBox1.Text == "Town")
{
ParentDBAccess pdba = new ParentDBAccess(db);
string townName = searchBox.Text;
createTable(pdba.SelectAllParentsWhereTown(townName));
}
//Shows all the data for the parent table when the 'View' button is clicked
else if (comboBox1.Text == "Show All")
{
ParentDBAccess pdba = new ParentDBAccess(db);
createTable(pdba.SelectAllParents());
}
//If a problem arises, display this error message
else
{
MessageBox.Show("ERROR");
this.Hide();
new MainApp(db).Show();
}
}
//when the modify data button is clicked, the highlighted entry will be changed in the database to whatever the user has entered into the grid
private void button4_Click(object sender, EventArgs e)
{
ParentDBAccess pdba = new ParentDBAccess(db);
pdba.updateProject(parentId, parentName, parentPhone, parentEmail, parentAddress, parentOccupation);
MessageBox.Show("The row in the database has been updated.", "Success");
parentGridView.DataSource = null;
}
private void button2_Click_1(object sender, EventArgs e)
{
//Create an object of type ParentDBAccess, this allows the user to get access to the methods
ParentDBAccess pdba = new ParentDBAccess(db);
//Update the table tp show all the parents
createTableToChooseParents(pdba.SelectAllParents());
}
public SelectAParentForm(Database db)
{
InitializeComponent();
CenterToScreen();
this.FormBorderStyle = FormBorderStyle.None;
Region = System.Drawing.Region.FromHrgn(CreateRoundRectRgn(0, 0, Width, Height, 20, 20));
this.db = db;
ParentDBAccess pdba = new ParentDBAccess(db);
createTableToChooseParents(pdba.SelectAllParents());
}
private void button1_Click_1(object sender, EventArgs e)
{
//Take the entered text and pass it into a variable
string SearchedName = textBox1.Text;
//Create a new ParentDBAcccess, giving access to the methods in that class
ParentDBAccess pdba = new ParentDBAccess(db);
//If the textbox is left empty diplay an error message
if (SearchedName == "")
{
MessageBox.Show("Error, SearchBox Must Not Be Left Blank ");
}
//If it's not empty, update the table to show all the names in the database that match the searched for parents name
else
{
SelectAllWhereName(pdba.SelectAllParentsWhereName(SearchedName));
}
}
private void button1_Click(object sender, EventArgs e)
{
//Try to fill these variables using the data the user enters into the textboxes
try
{
string parentName = ParentName.Text;
string parentNumber = ParentNumber.Text;
string parentEmail = ParentEmail.Text;
string parentAddress = ParentAddress.Text;
string parentOccupation = ParentOccupation.Text;
ParentDBAccess pdba = new ParentDBAccess(db);
//Populate a new entry with entered data
pdba.InsertParent(parentName, parentNumber, parentEmail, parentAddress, parentOccupation);
//Show the message box to check if the user wants to add another child
using (var form = new AddAChildMessage())
{
var result = form.ShowDialog();
//If they do want to add another child, show the SelectAParentForm
if (result == DialogResult.Yes)
{
this.Hide();
new SelectAParentForm(db).Show();
}
//If they don't want to register another child, take the user back to the main application
else if (result == DialogResult.No)
{
this.Hide();
new MainApp(db).Show();
}
}
}
//If there's an error, display it a new form
catch (SqlException ex)
{
new ErrorBox(ex).Show();
}
}
//The constrcutor has the database and selected table passed in
public SearchForm(Database db, string WhichTable)
{
InitializeComponent();
this.db = db;
//Assign which table is being selected
Table = WhichTable;
//Makes border disappear and the form curved
this.FormBorderStyle = FormBorderStyle.None;
Region = System.Drawing.Region.FromHrgn(CreateRoundRectRgn(0, 0, Width, Height, 20, 20));
CenterToScreen();
//Fill the combo boxes
InitComboBox();
comboBox3.Items.Add("=");
comboBox3.Items.Add(">");
comboBox3.Items.Add("<");
comboBox1.Text = Table;
//Check the selected table
switch (Table)
{
//If it's this table. Fill the grid with data from the chosen database table
case "Parent & Child": InnerJoinDBAccess parentChild = new InnerJoinDBAccess(db); CreateTableToShowChildAndParent(parentChild.GetChildAndParent()); break;
case "Bookings": InnerJoinDBAccess booking = new InnerJoinDBAccess(db); createTableToShowBookings(booking.GetAllBooking()); break;
case "Bus": BusDBAccess BusdbAcess = new BusDBAccess(db); createTableToShowBus(BusdbAcess.getAllBus()); break;
case "Cancellation": CancellationDBAccess cdba = new CancellationDBAccess(db); CreateTableToShowCancellation(cdba.getAllCancellation()); break;
case "Children": ChildrenDBAccess chdba = new ChildrenDBAccess(db); CreateTableToShowChildren(chdba.GetAllChildren()); break;
case "Parent": ParentDBAccess pdba = new ParentDBAccess(db); CreateTableToShowParent(pdba.SelectAllParents()); break;
case "Schools": SchoolDBAccess sdba = new SchoolDBAccess(db); CreateTableToShowSchools(sdba.getAllSchools()); break;
case "Staff": StaffDBAccess stdba = new StaffDBAccess(db); CreateTableToShowStaff(stdba.getAllStaff()); break;
}
}
//When the user changes the selected combobox index
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//Clear the data in the second combobox
comboBox2.Items.Clear();
//Switch the selected table
switch (comboBox1.Text)
{
//If the selected table is this value: populate the second combobox with these values
case "Bookings": comboBox2.Items.Add("Name"); comboBox2.Items.Add("Paid"); InnerJoinDBAccess booking = new InnerJoinDBAccess(db); createTableToShowBookings(booking.GetAllBooking()); break;
case "Bus": comboBox2.Items.Add("Driver"); comboBox2.Items.Add("Route"); comboBox2.Items.Add("Time"); BusDBAccess BusdbAcess = new BusDBAccess(db); createTableToShowBus(BusdbAcess.getAllBus()); break;
case "Cancellation": comboBox2.Items.Add("Reason"); CancellationDBAccess cdba = new CancellationDBAccess(db); CreateTableToShowCancellation(cdba.getAllCancellation()); break;
case "Children": comboBox2.Items.Add("Child Name"); comboBox2.Items.Add("Age"); comboBox2.Items.Add("Medical Problems"); ChildrenDBAccess chdba = new ChildrenDBAccess(db); CreateTableToShowChildren(chdba.GetAllChildren()); break; break;
case "Parent": comboBox2.Items.Add("Parent Name"); comboBox2.Items.Add("Parent Phone"); comboBox2.Items.Add("Parent Email"); comboBox2.Items.Add("Parent Address"); comboBox2.Items.Add("Parent Occupation"); ParentDBAccess pdba = new ParentDBAccess(db); CreateTableToShowParent(pdba.SelectAllParents()); break;
case "Schools": comboBox2.Items.Add("School Name"); comboBox2.Items.Add("School Location"); comboBox2.Items.Add("School Number"); SchoolDBAccess sdba = new SchoolDBAccess(db); CreateTableToShowSchools(sdba.getAllSchools()); break;
case "Staff": comboBox2.Items.Add("Staff Name"); comboBox2.Items.Add("Staff Voluntary"); StaffDBAccess stdba = new StaffDBAccess(db); CreateTableToShowStaff(stdba.getAllStaff()); break;
case "Parent & Child": comboBox2.Items.Add("Parent Name"); comboBox2.Items.Add("Child Name"); InnerJoinDBAccess injdba = new InnerJoinDBAccess(db); CreateTableToShowChildAndParent(injdba.GetChildAndParent()); break;
}
}
//When the 'Search' button is clicked
private void button1_Click(object sender, EventArgs e)
{
//The searched for name goes into the searcher variable
string searcher = textBox1.Text;
//If the user is searching for a child name in the Parent & Child table
if (comboBox2.Text == "Child Name" && comboBox1.Text == "Parent & Child")
{
//display the data which matches the searched for childs name
InnerJoinDBAccess injdba = new InnerJoinDBAccess(db);
CreateTableToShowChildAndParent(injdba.GetChildrenAndParentWhereChildName(searcher));
}
//If the user is searching for the Parents name in the parent & child table
if (comboBox2.Text == "Parent Name" && comboBox1.Text == "Parent & Child")
{
//diaplay the data which matches the searched for parents name
InnerJoinDBAccess injdba = new InnerJoinDBAccess(db);
CreateTableToShowChildAndParent(injdba.GetChildrenAndParentWhereParentName(searcher));
}
//If the user is searching for Driver
if (comboBox2.Text == "Driver")
{
//display the data which matches the searched for Bus drivers name
BusDBAccess bdba = new BusDBAccess(db);
createTableToShowBus(bdba.getWhereDriverIs(searcher));
}
// This repeats for the rest of the IF statements, the program will update the grid to show where the data in the table matches the value that the user is searching for
if (comboBox2.Text == "Route")
{
BusDBAccess bdba = new BusDBAccess(db);
createTableToShowBus(bdba.getWhereRouteIs(searcher));
}
if (comboBox2.Text == "Time")
{
BusDBAccess bdba = new BusDBAccess(db);
createTableToShowBus(bdba.getWhereTimeIs(comboBox3.Text, searcher));
}
if (comboBox2.Text == "Reason")
{
CancellationDBAccess cdba = new CancellationDBAccess(db);
CreateTableToShowCancellation(cdba.GetCancellByName(searcher));
}
if (comboBox2.Text == "Child Name")
{
ChildrenDBAccess cdba = new ChildrenDBAccess(db);
CreateTableToShowChildren(cdba.GetChildByName(searcher));
}
if (comboBox2.Text == "Age")
{
ChildrenDBAccess cdba = new ChildrenDBAccess(db);
CreateTableToShowChildren(cdba.GetChildByAge(comboBox3.Text, searcher));
}
if (comboBox2.Text == "Medical Problems")
{
ChildrenDBAccess cdba = new ChildrenDBAccess(db);
CreateTableToShowChildren(cdba.getChildByMedicalDetails());
}
if (comboBox2.Text == "Parent Name")
{
ParentDBAccess pdba = new ParentDBAccess(db);
CreateTableToShowParent(pdba.SelectAllParentsWhereName(searcher));
}
if (comboBox2.Text == "Parent Phone")
{
ParentDBAccess pdba = new ParentDBAccess(db);
CreateTableToShowParent(pdba.getParentWithPhone(searcher));
}
if (comboBox2.Text == "Parent Email")
{
ParentDBAccess pdba = new ParentDBAccess(db);
CreateTableToShowParent(pdba.getAllParentByEmail(searcher));
}
if (comboBox2.Text == "Parent Address")
{
ParentDBAccess pdba = new ParentDBAccess(db);
CreateTableToShowParent(pdba.getParentByAddress(searcher));
}
if (comboBox2.Text == "Parent Occupation")
{
ParentDBAccess pdba = new ParentDBAccess(db);
CreateTableToShowParent(pdba.getParentByOccupation(searcher));
}
if (comboBox2.Text == "School Name")
{
SchoolDBAccess sdba = new SchoolDBAccess(db);
CreateTableToShowSchools(sdba.getSchoolByName(searcher));
}
if (comboBox2.Text == "School Location")
{
SchoolDBAccess sdba = new SchoolDBAccess(db);
CreateTableToShowSchools(sdba.getSchoolByLocation(searcher));
}
if (comboBox2.Text == "School Number")
{
SchoolDBAccess sdba = new SchoolDBAccess(db);
CreateTableToShowSchools(sdba.getSchoolByNumber(searcher));
}
if (comboBox2.Text == "Paid")
{
string reason = textBox1.Text.ToLower();
int num = 0;
//If the user types in false or true, the program creates a variable called num which stores 0/1 depeneding on if the user has typed true or false
switch (reason)
{
case "false": num = 0; break;
case "true": num = 1; break;
}
InnerJoinDBAccess injdba = new InnerJoinDBAccess(db);
createTableToShowBookings(injdba.GetBookingWithPaid(num));
}
if (comboBox2.Text == "Name")
{
string name = textBox1.Text;
InnerJoinDBAccess injdba = new InnerJoinDBAccess(db);
createTableToShowBookings(injdba.GetBookingWithName(name));
}
}
//When the label is clicked, the table will update to show all the data for parents
private void label7_Click(object sender, EventArgs e)
{
ParentDBAccess pdba = new ParentDBAccess(db);
createTableShowAllParents(pdba.SelectAllParents());
}
