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 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);
}
}
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);
}
}
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 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 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 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);
}
}
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);
}
}
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);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (!textStaffID.Text.Trim().Equals("") && !textStaffLastName.Text.Trim().Equals(""))
{
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' ";
if (!textStaffID.Text.Trim().Equals(""))
{
sql += " AND ";
sql += "a.strStaffID LIKE '%" + textStaffID.Text.Trim() + "%' ";
}
if (!textStaffLastName.Text.Trim().Equals(""))
{
sql += " AND ";
sql += "(a.strLastName LIKE '%" + textStaffLastName.Text.Trim() + "%' OR " +
"a.strFirstName LIKE '%" + textStaffLastName.Text.Trim() + "%')";
}
sql += ";";
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);
}
}
else
{
MessageBox.Show("Please enter a valid search keyword!",
"Error",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void videoTimer_Tick(object sender, EventArgs e)
{
BarcodeReader bReader = new BarcodeReader();
Result result = null;
try
{
if (pboReader.Image == null)
{
}
else
{
result = bReader.Decode(new Bitmap(pboReader.Image));
string decoded = result.ToString().Trim();
if (decoded == string.Empty)
{
MessageBox.Show("Empty String");
}
else
{
videoTimer.Stop();
videoTimer.Enabled = false;
// proceed to log in
try
{
string sql = "SELECT * " +
"FROM tblPatient " +
"WHERE strPatientID = '" + decoded + "' AND " +
"boolIsActive;";
int resultCounter = 0;
MessageBox.Show(sql);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
resultCounter++;
}
reader.Close();
if (resultCounter >= 1)
{
string logID = "";
lblPatID.Text = decoded;
resultCounter = 0;
sql = "SELECT a.strLogID " +
"FROM tblPatientLogs a, tblPatientLogDetails b " +
"WHERE a.strPatientID = '" + decoded + "' AND a.strLogID = b.strLogID AND " +
"b.dtmDateTimeOut IS NULL ORDER BY b.dtmDateTimeLog ASC LIMIT 1;";
cmd = new MySqlCommand(sql, conn);
cmd.Prepare();
try
{
reader = cmd.ExecuteReader();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
while (reader.Read())
{
logID = reader.GetString("strLogID");
resultCounter++;
}
reader.Close();
if (resultCounter == 1)
{
sql = "UPDATE tblPatientLogDetails " +
"SET dtmDateTimeOut = NOW(), " +
"strLogType = 'OUT' " +
"WHERE strLogID = '" + logID + "';";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "SELECT strQueueNumber " +
"FROM tblQueue " +
"WHERE strPatientID = '" + decoded + "' AND " +
"strQueueStatus = 'WAITING';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
int resCount = 0;
string queueNumber = "";
while (reader.Read())
{
queueNumber = reader.GetString("strQueueNumber");
resCount++;
}
reader.Close();
if (resCount > 0)
{
sql = "UPDATE tblQueue " +
"SET strQueueStatus = 'CANCELLED' " +
"WHERE strQueueNumber = '" + queueNumber + "';";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Successfully logged out!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
videoTimer.Start();
videoTimer.Enabled = true;
}
else
{
bool valid = true;
int cboIndex = 0;
string logType = "";
DialogResult dr = ExternalForm.InputComboBox(ref cboIndex, ref logType);
if (dr == DialogResult.OK)
{
if (cboIndex >= 5)
{
MessageBox.Show("Please select a valid log type!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
valid = false;
videoTimer.Start();
videoTimer.Enabled = true;
}
else
{
switch (cboIndex)
{
case 1:
logType = "APPT";
break;
case 2:
logType = "WALK";
break;
case 3:
logType = "EMER";
break;
case 4:
logType = "OTHER";
break;
}
}
}
else
{
valid = false;
}
if (valid)
{
string dateToday = TimeHandler.GetCurrentDateTime() + "-LOGS";
sql = "INSERT INTO tblPatientLogs(strLogID, strPatientID, strStaffID) " +
"VALUES('" + dateToday + "', '" + decoded + "', '" + userID + "');";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "INSERT INTO tblPatientLogDetails(strLogID, dtmDateTimeLog, strLogPurposeCode, strLogType) " +
"VALUES('" + dateToday + "', NOW(), '" + logType + "', 'IN');";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
switch (cboIndex)
{
case 1:
formQueue.AddQueue(patientList[dgvSearch.CurrentRow.Index][0], 1);
break;
case 2:
formQueue.AddQueue(patientList[dgvSearch.CurrentRow.Index][0], 1);
break;
}
MessageBox.Show("Successfully logged in!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
lblPatID.Text = "Scanning";
videoTimer.Start();
videoTimer.Enabled = true;
eDesktopAlertColor color = eDesktopAlertColor.Green;
eAlertPosition position = eAlertPosition.BottomRight;
string report = "Patient # <b>" + decoded + "</b><br />" +
"has logged!";
DesktopAlert.Show(report,
"\uf005",
eSymbolSet.Awesome,
Color.Blue,
color,
position,
6,
_RunningAlertId,
AlertClicked);
}
}
}
else
{
MessageBox.Show("QR Code not recognized!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
videoTimer.Start();
videoTimer.Enabled = true;
}
}
catch (MySqlException me)
{
MessageBox.Show("Exception Caught!\n" + me.Message);
videoTimer.Start();
videoTimer.Enabled = true;
}
}
}
}
catch (Exception)
{
//MessageBox.Show(ex.Message + "\n" + ex.StackTrace);
//vdeoTimer.Stop();
}
}
public CtrlLogs(FormStaff formStaff, FormQueue formQueue, MySqlConnection conn, string userID)
{
InitializeComponent();
this.conn = conn;
this.userID = userID;
this.formStaff = formStaff;
this.formQueue = formQueue;
this.patientList = new List <string> [6];
for (int count = 0; count < patientList.GetLength(0); count++)
{
patientList[count] = new List <string>();
}
try
{
captureDevice = new FilterInfoCollection(FilterCategory.VideoInputDevice);
foreach (FilterInfo device in captureDevice)
{
cboCapture.Items.Add(device.Name);
}
cboCapture.SelectedIndex = 0;
finalFrame = new VideoCaptureDevice();
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
try
{
dgvSearch.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"));
dgvSearch.Rows.Add(reader.GetString("strPatientLastName"),
reader.GetString("strPatientFirstName"),
reader.GetString("strGender"),
reader.GetString("strPatientContactNumber"));
resultCount++;
}
reader.Close();
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
}
