//Create a new entry in the table using the entered data private void button1_Click(object sender, EventArgs e) { //Try to fill these variables using the data the user enters into the textboxes int ParentId = Convert.ToInt32(parentId.Text); int SchoolId = Convert.ToInt32(schoolId.Text); string ChildName = childName.Text; string MedicalDetails = medicalDetails.Text; int Age = Convert.ToInt32(age.Text); //Try populating a new entry with entered data try { ChildrenDBAccess chDBA = new ChildrenDBAccess(db); chDBA.InsertChild(ParentId, SchoolId, ChildName, MedicalDetails, Age); this.Hide(); //If it works, display the success form with the childs name new SuccessForm(db, ChildName + "\nSuccesfully Registered").Show(); } //If there's an error, show the exact error on the ErrorForm catch (SqlException ex) { new ErrorBox(ex).Show(); } }
private void button3_Click(object sender, EventArgs e) { //shows the data for the Child table which matches the searched for Child name if (comboBox1.Text == "Child Name") { ChildrenDBAccess cdba = new ChildrenDBAccess(db); string name = searchBox.Text; createTableShowAll(cdba.GetChildByName(name)); } //shows the data for the Child table which matches the searched for child age else if (comboBox1.Text == "Age") { ChildrenDBAccess cdba = new ChildrenDBAccess(db); string name = searchBox.Text; createTableShowAll(cdba.GetChildByAge("=", name)); } //Shows all the data for the Child table when the 'View' button is clicked else if (comboBox1.Text == "Show All") { ChildrenDBAccess cdba = new ChildrenDBAccess(db); createTableShowAll(cdba.GetAllChildren()); SelectedTable = "Child"; } //Shows all the data for the School table which matches the searched for school name else if (comboBox1.Text == "School Name") { string name = searchBox.Text; SchoolDBAccess scdba = new SchoolDBAccess(db); createTableShowAllSchools(scdba.getSchoolByName(name)); } }
private void button3_Click(object sender, EventArgs e) { //Shows all the data for bookings when the 'View' button is clicked if (comboBox1.Text == "Show All") { BookingDBAccess bdba = new BookingDBAccess(db); createTable(bdba.getAllBook()); } //Shows the data for the bookings which matches the searched for BookingId else if (comboBox1.Text == "Booking ID") { BookingDBAccess bdba = new BookingDBAccess(db); int BookNo = Convert.ToInt32(searchBox.Text); createTable(bdba.getBookWithID(BookNo)); } //shows the data for the bookings which matches the searched for Childs name else if (comboBox1.Text == "Child Name") { ChildrenDBAccess cdba = new ChildrenDBAccess(db); string name = searchBox.Text; createTableShowAllChild(cdba.GetChildByName(name)); selectedTable = "Children"; } //Shows the data for the bookings which matches the searched for childs age else if (comboBox1.Text == "Child Age") { ChildrenDBAccess cdba = new ChildrenDBAccess(db); int age = Convert.ToInt32(searchBox.Text); createTableShowAllChild(cdba.GetChildByAge("=", age.ToString())); selectedTable = "Children"; } }
//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) { ChildrenDBAccess cdba = new ChildrenDBAccess(db); cdba.updateProject(ChildId, ParentId, SchoolId, ChildName, MedicalDetails, Age); MessageBox.Show("The row in the database has been updated.", "Success"); childResults.DataSource = null; }
private void label5_Click(object sender, EventArgs e) { //If the user clicks the show all children label, the grid will be updated to show all the children stored in the database ChildrenDBAccess cdba = new ChildrenDBAccess(db); createTableShowAllChild(cdba.GetAllChildren()); selectedTable = "Children"; }
//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)); } }