public void AddQueue(string patientID, int level)
{
if (level < 3)
{
try
{
string key = TimeHandler.GetCurrentDateTime();
string sql = "INSERT INTO tblQueue(strPatientID, strQueueNumber, strQueueStatus, strPriority) " +
"VALUES('" + patientID + "', '" + key + "', 'WAITING', ";
if (level == 2)
{
sql += "'HIGH');";
}
else
{
sql += "'NORMAL');";
}
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
private void toggleStatus_CheckedChanged(object sender, EventArgs e)
{
try
{
string sql = "UPDATE tblLogIn " +
"SET strDoctStatus = ";
if (toggleStatus.Checked)
{
sql += "'ON' ";
}
else
{
sql += "'OFF' ";
}
sql += "WHERE strStaffID = '" + userID + "' AND " +
"dtmDateTimeLogOut IS NULL;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void btnAdmit_Click(object sender, EventArgs e)
{
if (dgvTagged.Rows.Count > 0)
{
try
{
string sql = "UPDATE tblTag " +
"SET strStatus = 'APPROVED' " +
"WHERE strStatus = 'PENDING' AND " +
"strStaffID = '" + userID + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "UPDATE tblLogIn " +
"SET strDoctStatus = 'OFF'" +
"WHERE strStaffID = '" + userID + "';";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
FormAdmission admission = new FormAdmission(conn, userID, patientList[0][dgvTagged.CurrentRow.Index]);
admission.ShowDialog();
dgvTagged.Rows.Clear();
}
}
private void btnAdmit_Click(object sender, EventArgs e)
{
if (dgvAppointment.Rows.Count >= 1)
{
DialogResult dr = MessageBox.Show("Are you sure you want to admit this patient?",
"Confirmation",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
try
{
string sql = "UPDATE tblAppointmentDetails " +
"SET strAppointmentStatus = 'DONE' " +
"WHERE tblAppointmentDetails.strAppointmentCode = '" + patientList[6][dgvAppointment.CurrentRow.Index] + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
FormAdmission admission = new FormAdmission(conn, userID, patientList[0][dgvAppointment.CurrentRow.Index]);
admission.ShowDialog();
}
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure you want to remove this staff?",
"Confirm",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
string sql = "UPDATE tblStaff " +
"SET strPositionCode = 'NULL' " +
"WHERE strStaffID = '" + dgvList.SelectedCells[0].Value.ToString() + "';";
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
MessageBox.Show("Staff has successfully been removed!",
"Success",
MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
btnReset_Click(null, null);
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
public CtrlViewTags(MySqlConnection conn, string userID)
{
InitializeComponent();
this.conn = conn;
this.userID = userID;
this.patientList = new List <string> [6];
for (int count = 0; count < patientList.GetLength(0); count++)
{
patientList[count] = new List <string>();
}
this.threadTimer.Interval = 10000;
this.threadTimer.Tick += new EventHandler(UpdateTag);
this.threadTimer.Enabled = true;
ClearPatientList();
dgvTagged.Rows.Clear();
try
{
string sql = "SELECT a.strPatientID, a.strIDNumber, a.strPatientLastName, a.strPatientFirstName, a.strGender, " +
"a.strPatientContactNumber " +
"FROM tblPatient a, tblStaff b, tblTag c " +
"WHERE a.strPatientID = c.strPatientID AND " +
"c.strStaffID = '" + userID + "' AND " +
"c.strStatus = 'PENDING';";
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"));
dgvTagged.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPatientContactNumber"),
reader.GetString("strGender"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void calendar_DateSelected(object sender, DateRangeEventArgs e)
{
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 " +
"MONTH(c.dtmDateTimeStart) = " + calendar.SelectionEnd.ToString("MM") + " AND " +
"DAY(c.dtmDateTimeStart) = " + calendar.SelectionEnd.ToString("dd") + " AND " +
"YEAR(c.dtmDateTimeStart) = " + calendar.SelectionEnd.ToString("yyy") + ";";
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);
}
}
private void UpdateHeader()
{
string sql = "SELECT strLastName, strFirstName, strStaffID, strPositionCode " +
"FROM tblStaff " +
"WHERE strStaffID = @staffID;";
string userPosition = "";
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@staffID", userID);
cmd.Prepare();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
firstName = reader.GetString("strFirstName");
lastName = reader.GetString("strLastName");
userPosition = reader.GetString("strPositionCode");
}
reader.Close();
sql = "SELECT strPositionDescription " +
"FROM tblPositionDetails " +
"WHERE strPositionCode = @posCode;";
cmd = new MySqlCommand(sql, conn);
/* Prepare statements */
cmd.Parameters.AddWithValue("@posCode", userPosition);
cmd.Prepare();
reader = cmd.ExecuteReader();
while (reader.Read())
{
userType = reader.GetString("strPositionDescription");
}
reader.Close();
this.lblLastName.Text = lastName;
this.lblFirstName.Text = firstName;
this.lblUserID.Text = userID;
this.lblUserType.Text = userType;
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
public void UpdateList(string sql)
{
this.ClearList();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int resultCount = 0;
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"));
resultCount++;
}
reader.Close();
if (resultCount > 0)
{
MessageBox.Show("Search Done!\nFound " + resultCount + " matches!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Search Done! No found matches!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void UpdateDoctorInfo()
{
string position = "";
string sql = "SELECT a.strStaffID, a.strFirstName, a.strMiddleName, a.strLastName, " +
"a.strGender, a.strContactNumber, a.strUsername, " +
"b.strPositionCode, b.strPositionDescription " +
"FROM tblStaff a, tblPositionDetails b " +
"WHERE a.strPositionCode = b.strPositionCode AND " +
"a.strStaffID = '" + this.doctorID + "';";
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lblIDVal.Text = reader.GetString("strStaffID");
lblNameVal.Text = reader.GetString("strFirstName") + " " + reader.GetString("strMiddleName") +
" " + reader.GetString("strLastName");
lblGenderVal.Text = reader.GetString("strGender");
lblContactVal.Text = reader.GetString("strContactNumber");
lblUsernameVal.Text = reader.GetString("strUsername");
lblPositionVal.Text = reader.GetString("strPositionDescription");
position = reader.GetString("strPositionCode");
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
if (position.Equals("DOCT"))
{
string doctorName = lblNameVal.Text.Trim();
lblNameVal.Text = "Dr. " + doctorName;
}
else if (position.Equals("ADMIN"))
{
lblDocID.Text = "Admin ID:";
lblDrName.Text = "Admin Name:";
}
else
{
lblDocID.Text = "Staff ID:";
lblDrName.Text = "Staff Name:";
}
}
private void textRelation_TextChanged(object sender, EventArgs e)
{
if (textRelation.Text.Trim().Length > 0)
{
if (!Integrity.LetterOnly(textRelation.Text.Trim()))
{
textRelation.Text = textRelation.Text.Substring(0, textRelation.Text.Trim().Length - 1);
textRelation.Select(textRelation.Text.Trim().Length, 1);
}
}
}
private void textGuardContactNumber_TextChanged(object sender, EventArgs e)
{
if (textGuardContactNumber.Text.Trim().Length > 0)
{
if (!Integrity.NumberOnly(textGuardContactNumber.Text.Trim()))
{
textGuardContactNumber.Text = textGuardContactNumber.Text.Substring(0, textGuardContactNumber.Text.Trim().Length - 1);
textGuardContactNumber.Select(textGuardContactNumber.Text.Trim().Length, 1);
}
}
}
private void UpdatePatientID()
{
/* SQL Query Variable(s) */
string sql = "SELECT strPatientID " +
"FROM tblPatient " +
"ORDER BY strPatientID DESC " +
"LIMIT 1;";
bool first = true;
MySqlCommand cmd = null;
MySqlDataReader reader = null;
/* Function Member Variable(s) */
string lastID = "";
try
{
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lastID = reader.GetString("strPatientID");
first = false;
}
reader.Close();
if (first)
{
this.isPrime = true;
lblPatIDVal.Visible = false;
}
else
{
this.isPrime = false;
textPatID.Visible = false;
lblPatIDVal.Visible = true;
lblPatIDVal.Text = SmartCounter.NextInt(lastID);
pboQR.BackgroundImage = QuickRead.GenerateQR(lblPatIDVal.Text.Trim());
pboQR.Visible = true;
}
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception me)
{
Integrity.GetExceptionDetails(me);
}
} // private void UpdatePatientID()
private void finalFrameEvent(Object sender, NewFrameEventArgs nfea)
{
try
{
ResizeBicubic filter = new ResizeBicubic(pboReader.Width, pboReader.Height);
pboReader.Image = filter.Apply((Bitmap)nfea.Frame.Clone());
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
this.CloseCam();
}
}
} // Action[Click]: btnLogIn
private void textUsername_TextChanged(object sender, EventArgs e)
{
try
{
if (!Integrity.NoSpaceOnly(textUsername.Text.Trim()))
{
textUsername.Text = textUsername.Text.Substring(0, textUsername.Text.Trim().Length - 1);
textUsername.Select(textUsername.Text.Trim().Length, 1);
}
TextBox t = sender as TextBox;
if (t != null)
{
try
{
int resultCount = 0;
string sql = "SELECT strUsername " +
"FROM tblStaff " +
"WHERE strUsername LIKE '%" + textUsername.Text.Trim() + "%';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
List <string> listCollect = new List <string>();
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
while (reader.Read())
{
//listCollect.Add(reader.GetString("strUsername"));
collection.Add(reader.GetString("strUsername"));
resultCount++;
}
reader.Close();
collection.AddRange(listCollect.ToArray());
textUsername.AutoCompleteCustomSource = collection;
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
catch (Exception)
{
}
}
private void btnPatSearch_Click(object sender, EventArgs e)
{
if (textName.Text.Trim().Equals(""))
{
MessageBox.Show("Please enter a valid search key!", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
ClearPatientList();
try
{
string sql = "SELECT strPatientID, strIDNumber, strPatientFirstName, strPatientLastName, strPatientContactNumber, strGender " +
"FROM tblPatient " +
"WHERE boolIsActive AND (strPatientFirstName LIKE '%" + textName.Text.Trim() + "%' OR " +
"strPatientLastName LIKE '%" + textName.Text.Trim() + "%');";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int resultCount = 0;
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"));
dgvPatient.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPatientContactNumber"),
reader.GetString("strGender"));
resultCount++;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
private void textContact_TextChanged(object sender, EventArgs e)
{
Integrity.TextChange_Number(sender);
/*
* if (textContact.Text.Trim().Length > 0)
* {
* if (!Integrity.NumberOnly(textContact.Text.Trim()))
* {
* textContact.Text = textContact.Text.Substring(0, textContact.Text.Trim().Length - 1);
* textContact.Select(textContact.Text.Trim().Length, 1);
* }
* }
*/
}
private void UpdateHeader()
{
string lastName = "";
string firstName = "";
string userType = "";
string sql = "SELECT strLastName, strFirstName, strPositionCode " +
"FROM tblStaff " +
"WHERE strStaffID = @staffID " +
"LIMIT 1;";
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@staffID", this.userID);
cmd.Prepare();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lastName = reader.GetString("strLastName");
firstName = reader.GetString("strFirstName");
userType = reader.GetString("strPositionCode");
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
try
{
lblLastName.Text = lastName;
lblFirstName.Text = firstName;
lblUserID.Text = userID;
lblUserType.Text = userType;
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void UpdateAppt(object sender, EventArgs e)
{
ClearPatientList();
dgvAppointment.Rows.Clear();
string sql = "SELECT a.strPatientID, a.strIDNumber, a.strPatientLastName, a.strPatientFirstName, a.strGender, " +
"a.strPatientContactNumber, b.strAppointmentCode, c.dtmDateTimeStart " +
"FROM tblPatient a, tblAppointment b, tblAppointmentDetails c " +
"WHERE a.strPatientID = b.strPatientID AND " +
"b.strStaffID = '" + userID + "' AND " +
"b.strAppointmentCode = c.strAppointmentCode AND " +
"c.strAppointmentStatus = 'APPR';";
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"));
patientList[6].Add(reader.GetString("strAppointmentCode"));
dgvAppointment.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPatientContactNumber"),
reader.GetString("strGender"),
reader.GetString("dtmDateTimeSTart"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void UpdatePatient()
{
dgvPatient.Rows.Clear();
try
{
dgvPatient.Rows.Clear();
this.ClearPatientList();
string sql = "SELECT strPatientID, strIDNumber, strPatientLastName, strPatientFirstName, strGender, strPatientContactNumber " +
"FROM tblPatient " +
"WHERE boolIsActive;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int resultCount = 0;
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"));
dgvPatient.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strGender"),
reader.GetString("strPatientContactNumber"));
resultCount++;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void btnClear_Click(object sender, EventArgs e)
{
textDocFirst.Clear();
textDocMiddle.Clear();
textStaffLast.Clear();
cboGender.SelectedIndex = 0;
textContact.Clear();
textUsername.Clear();
textPassword.Clear();
cboUserType.SelectedIndex = 0;
try
{
string sql = "SELECT strStaffID " +
"FROM tblStaff " +
"ORDER BY strStaffID DESC " +
"LIMIT 1;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textDocID.Text = SmartCounter.NextInt(reader.GetString("strStaffID"));
textDocID.ReadOnly = true;
isFirst = false;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
if (isFirst)
{
textDocID.Clear();
}
}
private void UpdateTag(object sender, EventArgs e)
{
ClearPatientList();
dgvTagged.Rows.Clear();
try
{
string sql = "SELECT DISTINCT a.strPatientID, a.strIDNumber, a.strPatientLastName, a.strPatientFirstName, a.strGender, " +
"a.strPatientContactNumber " +
"FROM tblPatient a, tblStaff b, tblTag c " +
"WHERE a.strPatientID = c.strPatientID AND " +
"c.strStaffID = '" + userID + "' AND " +
"c.strStatus = 'PENDING';";
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"));
//patientList[7].Add(reader.GetString("strAppointmentCode"));
dgvTagged.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPatientContactNumber"),
reader.GetString("strGender"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void UpdateDoctor()
{
try
{
dgvDoctor.Rows.Clear();
this.ClearDoctorList();
string sql = "SELECT a.strStaffID, a.strFirstName, a.strLastName, a.strContactNumber, a.strGender " +
"FROM tblStaff a, tblPositionDetails b " +
"WHERE a.strPositionCode = b.strPositionCode AND " +
"b.strPositionCode = 'DOCT' AND " +
"a.boolIsActive;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int resultCount = 0;
while (reader.Read())
{
doctorList[0].Add(reader.GetString("strStaffID"));
doctorList[1].Add(reader.GetString("strFirstName"));
doctorList[2].Add(reader.GetString("strLastName"));
doctorList[3].Add(reader.GetString("strGender"));
doctorList[4].Add(reader.GetString("strContactNumber"));
dgvDoctor.Rows.Add(reader.GetString("strLastName"),
reader.GetString("strFirstName"),
reader.GetString("strContactNumber"),
reader.GetString("strGender"));
resultCount++;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
public void UpdateDoctor(string sql)
{
dgvDoctor.Rows.Clear();
ClearDoctorList();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int resultCount = 0;
while (reader.Read())
{
doctorList[0].Add(reader.GetString("strStaffID"));
doctorList[1].Add(reader.GetString("strLastName"));
doctorList[2].Add(reader.GetString("strFirstName"));
doctorList[3].Add(reader.GetString("strGender"));
doctorList[4].Add(reader.GetString("strContactNumber"));
dgvDoctor.Rows.Add(reader.GetString("strLastName"),
reader.GetString("strFirstName"),
reader.GetString("strContactNumber"),
reader.GetString("strGender"));
resultCount++;
}
reader.Close();
if (resultCount > 0)
{
MessageBox.Show("Search Done!\nFound " + resultCount + " matches!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Search Done! No matching record found!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void btnReset_Click(object sender, EventArgs e)
{
string sql = "SELECT a.strStaffID, a.strLastName, a.strFirstName, " +
"a.strGender, a.strContactNumber, a.strUserName, " +
"a.strUsername, a.strPassword, b.strPositionDescription " +
"FROM tblStaff a, tblPositionDetails b " +
"WHERE a.strPositionCode = b.strPositionCode AND " +
"b.strPositionCode <> 'NULL';";
dgvList.Rows.Clear();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
dgvList.Rows.Add(reader.GetString("strStaffID"),
reader.GetString("strLastName"),
reader.GetString("strFirstName"),
reader.GetString("strGender"),
reader.GetString("strContactNumber"),
reader.GetString("strUsername"),
reader.GetString("strPassword"),
reader.GetString("strPositionDescription"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
if (dgvResults.SelectedRows.Count > 0)
{
try
{
DialogResult dr = MessageBox.Show("Are you sure you want to cancel this appointment?",
"Confirm",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
string appointmentID = appointmentList[0][dgvResults.CurrentRow.Index];
string sql = "UPDATE tblAppointmentDetails " +
"SET strAppointmentStatus = 'CANC' " +
"WHERE strAppointmentCode = '" + appointmentID + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
dgvResults.Rows.Remove(dgvResults.CurrentRow);
MessageBox.Show("Appointment Successfully Cancelled!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.ClearList();
this.btnReset_Click(null, null);
}
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
else
{
MessageBox.Show("Please select a valid entry!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
private void UpdateQueueThread(object sender, EventArgs e)
{
dgvQueue.Rows.Clear();
patientID.Clear();
try
{
string sql = "SELECT b.strQueueNumber, a.strPatientID, a.strIDNumber, a.strPatientLastName, " +
"a.strPatientFirstName, b.strPriority " +
"FROM tblPatient a, tblQueue b " +
"WHERE b.strPatientID = a.strPatientID AND " +
"b.strQueueStatus = 'WAITING' " +
"ORDER BY b.strPriority ASC;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
patientID.Enqueue(reader.GetString("strPatientID"));
dgvQueue.Rows.Add(reader.GetString("strQueueNumber"),
reader.GetString("strPatientID"),
reader.GetString("strIDNumber"),
reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strPriority"));
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
if (dgvPatient.Rows.Count <= 0)
{
MessageBox.Show("Please select a valid patient first!",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
DialogResult dr = MessageBox.Show("Are you sure you want to remove this patient?\n" +
"This is undoable, do you want to continue?",
"CONFIRMATION WARNING",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
try
{
string sql = "UPDATE tblPatient " +
"SET boolIsActive = false " +
"WHERE strPatientID = '" + patientList[dgvPatient.CurrentRow.Index][0] + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
}
}
public CtrlAddStaff(MySqlConnection conn, string userID)
{
InitializeComponent();
this.cboGender.SelectedIndex = 0;
this.cboUserType.SelectedIndex = 0;
this.conn = conn;
this.userID = userID;
try
{
string sql = "SELECT strStaffID " +
"FROM tblStaff " +
"ORDER BY strStaffID DESC " +
"LIMIT 1;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textDocID.Text = SmartCounter.NextInt(reader.GetString("strStaffID"));
textDocID.ReadOnly = true;
isFirst = false;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
private void UpdateList()
{
dgvDoctor.Rows.Clear();
dgvPatient.Rows.Clear();
datSchedule.MinDate = DateTime.Now.AddDays(3);
try
{
datSchedule.MinDate = DateTime.Now.AddDays(4);
this.Dock = DockStyle.Fill;
UpdateDoctor();
UpdatePatient();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
}
