/// <summary> /// Closes Main form, opens Appointments form /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Appointments_ViewAll_Click(object sender, EventArgs e) { this.Hide(); AppointmentForm frmAppointments = new AppointmentForm(); frmAppointments.ShowDialog(); }
/// <summary> /// Closes Add Appointment form, opens Appointment form /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCancel_Click(object sender, EventArgs e) { this.Hide(); AppointmentForm frmAppointment = new AppointmentForm(); frmAppointment.ShowDialog(); }
/// <summary> /// Updates an existing appointments information and the /// corresponding customer's next appointment /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUpdateAppointment_Click(object sender, EventArgs e) { int customerID; //Check input isn't blank foreach (Control c in Controls) { if (c is TextBox) { TextBox t = (TextBox)c; if (t.Equals("")) { lblStatus.Text = t.Tag + " can't be blank"; return; } } } if (!(int.TryParse(txtCustID.Text, out customerID))) { lblStatus.Text = "ID must be numerical"; txtCustID.Focus(); return; } if (cboAppReason.SelectedIndex == -1) { lblStatus.Text = "Appointment reason must be selected"; cboAppReason.Focus(); return; } //Hold date of appointment DateTime date = dtpDate.Value; //Hold time of appointment DateTime time = dtpTime.Value; //Hold combinted date and time of appointment DateTime combined = date.Date.Add(time.TimeOfDay); //Get appointment reason string reason = cboAppReason.Text; //Update appointment information appAdapter.UpdateAppointment(customerID, reason, combined, appointmentID); //Update customer's next appointment custAdapter.UpdateNextAppointment(combined, customerID); //Close form, display Appointment form this.Hide(); AppointmentForm frmAppointment = new AppointmentForm(); frmAppointment.ShowDialog(); }
/// <summary> /// Validates input and adds a new appointment to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddAppointment_Click(object sender, EventArgs e) { //Hold customer ID int customerID; //Check input isn't blank foreach (Control c in Controls) { if (c is TextBox) { TextBox t = (TextBox)c; if (t.Text == "") { lblStatus.Text = t.Tag + " can't be blank"; t.Focus(); return; } } } //Check input is numerical if (!(int.TryParse(txtCustID.Text, out customerID))) { lblStatus.Text = "ID must be numerical"; txtCustID.Focus(); return; } //Check customer exists if (custAdapter.FindByCustID(customerID).Rows.Count < 1) { lblStatus.Text = "Customer ID does not exist"; txtCustID.Focus(); return; } //Check combobox has selection if (cboAppReason.SelectedIndex == -1) { lblStatus.Text = "Appointment reason must be selected"; cboAppReason.Focus(); return; } //Hold date of appointment DateTime date = dtpDate.Value; //Hold time of appointment DateTime time = dtpTime.Value; //Hold combined date and time DateTime combined = date.Date.Add(time.TimeOfDay); //Convert to string string combinedstuff = combined.ToString(); //Set reason string reason = cboAppReason.SelectedItem.ToString(); //Add appointment try { adapter.Insert(customerID, reason, combined); } catch { lblStatus.Text = "Error adding appointment"; } if (adapter.FindByCustID(customerID).Rows.Count < 1) { try { //Assign appointment to corresponding customer custAdapter.UpdateNextAppointment(combined, customerID); } catch { lblStatus.Text = "Error updating customer's next appointment"; } } //Close form, open appointment form this.Hide(); AppointmentForm frmAppointment = new AppointmentForm(); frmAppointment.ShowDialog(); }