private void ShowAppointments()
{
dbh.OpenConnection();
DataTable dt = dbh.GetAppointments();
appointmentsPanel.Controls.Clear();
int amount = dt.Rows.Count;
if (!showallAppointments && amount > 5)
{
amount = 5;
Button btn_showAllAppointments = new Button();
btn_showAllAppointments.Text = "Show all appointments";
btn_showAllAppointments.Dock = DockStyle.Bottom;
btn_showAllAppointments.Click += new System.EventHandler(this.ShowAllAppointments);
appointmentsPanel.Controls.Add(btn_showAllAppointments);
}
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.Dispose();
}
dbh.CloseConnection();
}
private void SearchAppointmentOnCo_Name(object sender, KeyEventArgs e)
{
string filter = tstxtb_Appointments_CoName.Text;
if (e.KeyCode == Keys.Return)
{
dbh.OpenConnection();
appointmentsPanel.Controls.Clear();
DataTable dt = dbh.FilterAppointments(filter, "tbl_customers.company_name");
int amount = dt.Rows.Count;
if (!showallAppointments && amount > 5)
{
amount = 5;
}
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.AccessibleName = dt.Rows[i]["appointment_id"].ToString();
appointmentInfoPanel[i].btn_Edit.Click += new System.EventHandler(this.FillEditAppointmentItems);
}
dbh.CloseConnection();
}
}
private void SearchAppointmentOnResidence(object sender, KeyEventArgs e)
{
string filter = tstxtb_Appointments_Residence.Text;
if (e.KeyCode == Keys.Return)
{
dbh.OpenConnection();
appointmentsPanel.Controls.Clear();
DataTable dt = dbh.FilterAppointments(filter, "tbl_customers.residence");
int amount = dt.Rows.Count;
if (!showallAppointments && amount > 5)
{
amount = 5;
}
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.Dispose();
}
dbh.CloseConnection();
}
}
private void SearchAppointmentOnDate(object sender, EventArgs e)
{
string fromDate = lbl_Appointment_DateFrom.Text;
string tillDate = lbl_Appointment_DateTill.Text;
dbh.OpenConnection();
appointmentsPanel.Controls.Clear();
DataTable dt = dbh.FilterAppointmentsBetweenDate(fromDate, tillDate, "appointment_datetime");
int amount = dt.Rows.Count;
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.AccessibleName = dt.Rows[i]["appointment_id"].ToString();
appointmentInfoPanel[i].btn_Edit.Click += new System.EventHandler(this.FillEditAppointmentItems);
}
dbh.CloseConnection();
}
private void SearchAppointmentsOnSummary(object sender, EventArgs e)
{
if (tscmb_Appointments_Summary.Text == "All")
{
appointmentsPanel.Controls.Clear();
dbh.OpenConnection();
DataTable dt = dbh.GetAppointments();
int amount = dt.Rows.Count;
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.AccessibleName = dt.Rows[i]["appointment_id"].ToString();
appointmentInfoPanel[i].btn_Edit.Dispose();
}
dbh.CloseConnection();
}
else if (tscmb_Appointments_Summary.Text == "Has summary")
{
dbh.OpenConnection();
appointmentsPanel.Controls.Clear();
DataTable dt = dbh.FilterAppointmentsHasSummary();
int amount = dt.Rows.Count;
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.AccessibleName = dt.Rows[i]["appointment_id"].ToString();
appointmentInfoPanel[i].btn_Edit.Dispose();
}
dbh.CloseConnection();
}
else
{
dbh.OpenConnection();
appointmentsPanel.Controls.Clear();
DataTable dt = dbh.FilterAppointmentsHasNoSummary();
int amount = dt.Rows.Count;
AppointmentPanel[] appointmentInfoPanel = new AppointmentPanel[amount];
for (int i = 0; i < appointmentInfoPanel.Length; i++)
{
appointmentInfoPanel[i] = new AppointmentPanel(i, dt);
appointmentInfoPanel[i].BorderStyle = BorderStyle.FixedSingle;
appointmentInfoPanel[i].Dock = DockStyle.Top;
appointmentsPanel.Controls.Add(appointmentInfoPanel[i]);
appointmentInfoPanel[i].btn_Edit.AccessibleName = dt.Rows[i]["appointment_id"].ToString();
appointmentInfoPanel[i].btn_Edit.Dispose();
}
dbh.CloseConnection();
}
}
