public BookingsManage() : base() { InitializeComponent(); staffs = staffAccess.getAllStaff().FindAll(e => e.Deleted == 0); orders = orderAccess.getAllOrders().FindAll(e => Convert.ToDateTime(e.Date) > DateTime.Now); services = serviceAccess.getAllServices(); serv = services.ToArray()[0]; dogs = dogAccess.getAllDogs(); custs = custAccess.getAllCustomers().FindAll(e => e.Deleted == 0); dtpRoomView.MaxDate = DateTime.Today.AddYears(1).AddDays(-1); dtpRoomView.MinDate = DateTime.Today.AddYears(-1); dtpRoomView.Value = DateTime.Today; dtpDateTime.MaxDate = DateTime.Today.AddYears(1); dtpDateTime.MinDate = DateTime.Today.AddYears(-1); dtpDateTime.Value = DateTime.Today; Text = "JD Dog Care - Manage Bookings"; changeMode("view"); populateComboBox(); type = "orders"; populateDataGrid(); txtStaff.Enabled = false; txtTime.Enabled = false; txtDate.Enabled = false; txtCost.Text = ""; }
private void button3_Click(object sender, EventArgs e) { //shows the data for the staff table which matches the searched for staff name if (comboBox1.Text == "Staff Name") { StaffDBAccess sdba = new StaffDBAccess(db); string selectedName = searchBox.Text; createTable(sdba.GetStaffByName(selectedName)); } //Shows all the data for the staff table when the 'View' button is clicked if (comboBox1.Text == "Show All") { StaffDBAccess sdba = new StaffDBAccess(db); createTable(sdba.getAllStaff()); } //Shows the data for the staff table which mathes whether the the user is searching for voluntary or non-voluntary staff if (comboBox1.Text == "Voluntary") { bool decider = false; StaffDBAccess sdba = new StaffDBAccess(db); switch (searchBox.Text) { case "False": decider = false; break; case "True": decider = true; break; } createTable(sdba.getStaffByVoluntary(decider)); } }
private void label4_Click(object sender, EventArgs e) { //If the label is clicked, fill the table with all the data in the staff table StaffDBAccess sdba = new StaffDBAccess(db); createTableToShowStaff(sdba.getAllStaff()); SelectedTable = "Staff"; }
//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; } }
//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; } }