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;
}
}