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); } }