private void btnSearchPatient_Click(object sender, EventArgs e)
{
if (textName.Text.Trim().Equals(""))
{
Integrity.ShowNoKeywordDialog();
}
else
{
dgvSearch.Rows.Clear();
string sql = "SELECT strPatientID, strIDNumber, strPatientLastName, strPatientFirstName, strGender, strPatientContactNumber " +
"FROM tblPatient " +
"WHERE boolIsActive AND " +
"(strPatientLastName LIKE '%" + textName.Text.Trim() + "%' OR " +
"strPatientFirstName LIKE '%" + textName.Text.Trim() + "%');";
int resultCounter = 0;
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
patientList[0].Add(reader.GetString("strPatientID"));
patientList[1].Add(reader.GetString("strIDNumber"));
patientList[2].Add(reader.GetString("strPatientLastName"));
patientList[3].Add(reader.GetString("strPatientFirstName"));
patientList[4].Add(reader.GetString("strGender"));
patientList[5].Add(reader.GetString("strPatientContactNumber"));
dgvSearch.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPatientContactNumber"),
reader.GetString("strGender"));
resultCounter++;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
if (resultCounter < 1)
{
MessageBox.Show("Search Done!\nNo matching results found!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Search Done!\n" + resultCounter + " matching results found!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (textName.Text.Trim().Equals(""))
{
Integrity.ShowNoKeywordDialog();
}
else
{
this.ClearList();
string sql = "SELECT a.strStaffID, a.strLastName, a.strFirstName, a.strContactNumber, a.strGender, " +
"b.strAppointmentCode, c.dtmDateTimeStart, " +
"d.strPatientID, d.strIDNumber, d.strPatientLastName, d.strPatientFirstName, d.strPatientContactNumber, " +
"d.strGender AS 'strPatGender' " +
"FROM tblStaff a, tblAppointment b, tblAppointmentDetails c, tblPatient d " +
"WHERE a.strPositionCode = 'DOCT' AND " +
"b.strAppointmentCode = c.strAppointmentCode AND " +
"b.strStaffID = a.strStaffID AND " +
"b.strPatientID = d.strPatientID AND " +
"c.strAppointmentStatus = 'APPR' AND " +
"a.boolIsActive AND d.boolIsActive AND " +
"(d.strPatientFirstName LIKE '%" + textName.Text.Trim() + "%' OR " +
"d.strPatientLastName LIKE '%" + textName.Text.Trim() + "%' OR " +
"a.strLastName LIKE '%" + textName.Text.Trim() + "%' OR " +
"a.strFirstName LIKE '%" + textName.Text.Trim() + "%');";
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
appointmentList[0].Add(reader.GetString("strAppointmentCode"));
appointmentList[1].Add(reader.GetDateTime("dtmDateTimeStart").ToString());
appointmentList[2].Add(reader.GetString("strStaffID"));
appointmentList[3].Add(reader.GetString("strLastName"));
appointmentList[4].Add(reader.GetString("strFirstName"));
appointmentList[5].Add(reader.GetString("strContactNumber"));
appointmentList[6].Add(reader.GetString("strGender"));
appointmentList[7].Add(reader.GetString("strPatientID"));
appointmentList[8].Add(reader.GetString("strIDNumber"));
appointmentList[9].Add(reader.GetString("strPatientLastName"));
appointmentList[10].Add(reader.GetString("strPatientFirstName"));
appointmentList[11].Add(reader.GetString("strPatientContactNumber"));
appointmentList[12].Add(reader.GetString("strPatGender"));
dgvResults.Rows.Add(reader.GetDateTime("dtmDateTimeStart").ToString(),
reader.GetString("strLastName"),
reader.GetString("strFirstName"),
reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
