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