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