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()
} // Action[Validate]: CtrlRegi
private void textPatID_Leave(object sender, EventArgs e)
{
if (!textPatID.Text.Trim().Equals(""))
{
if (isPrime)
{
pboQR.BackgroundImage = QuickRead.GenerateQR(textPatID.Text.Trim());
pboQR.Visible = true;
}
else
{
pboQR.BackgroundImage = QuickRead.GenerateQR(lblPatID.Text.Trim());
pboQR.Visible = true;
}
}
} // Action[Leave] : textPatID
public void UpdatePatientInfo()
{
string patientType = "";
string guardID = "";
string sql = "SELECT * FROM tblPatient WHERE strPatientID = '" + patientID + "';";
try
{
/* Patient Main Info */
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Prepare();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lblPatIDVal.Text = reader.GetString("strPatientID");
lblIDNoVal.Text = reader.GetString("strIDNumber");
lblPatNameVal.Text = reader.GetString("strPatientLastName") + ", " +
reader.GetString("strPatientFirstName") + " " +
reader.GetString("strPatientMiddleName");
lblBirthdateVal.Text = reader.GetDateTime("dtmDateOfBirth").ToString("MM / dd / yyyy");
lblGenderVal.Text = reader.GetString("strGender");
lblContactNoVal.Text = reader.GetString("strPatientContactNumber");
guardID = reader.GetString("strGuardianID");
textPatNo.Text = reader.GetString("strIDNumber");
textPatFirstName.Text = reader.GetString("strPatientFirstName");
textPatLastName.Text = reader.GetString("strPatientLastName");
textPatMiddleName.Text = reader.GetString("strPatientMiddleName");
datBirthdate.Value = reader.GetDateTime("dtmDateOfBirth");
cboGender.SelectedText = reader.GetString("strGender");
textPatCont.Text = reader.GetString("strPatientContactNumber");
cboGender.SelectedIndex = 0;
}
reader.Close();
/* Patient Address Info */
sql = "SELECT * FROM tblHomeAddress WHERE strPatientID = '" + patientID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblAddressVal.Text = reader.GetString("strHomeAddress") + ", " +
reader.GetString("strCity") + ", " +
reader.GetString("strProvince") + ", " +
reader.GetString("strRegion");
textHomeAddress.Text = reader.GetString("strHomeAddress");
textCity.Text = reader.GetString("strCity");
textProvince.Text = reader.GetString("strProvince");
textRegion.Text = reader.GetString("strRegion");
}
reader.Close();
/* Guardian Info */
sql = "SELECT * FROM tblGuardian WHERE strGuardianID = '" + guardID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblGuardNameVal.Text = reader.GetString("strLastName") + ", " +
reader.GetString("strFirstName") + " " +
reader.GetString("strMiddleName");
lblGuardContactNoVal.Text = reader.GetString("strContact");
lblRelationVal.Text = reader.GetString("strRelation");
textGuardFirst.Text = reader.GetString("strFirstName");
textGuardMiddle.Text = reader.GetString("strMiddleName");
textGuardLast.Text = reader.GetString("strLastName");
textGuardCont.Text = reader.GetString("strContact");
textRelation.Text = reader.GetString("strRelation");
}
reader.Close();
/* Get Patient Sub Info */
sql = "SELECT * FROM tblPatientType WHERE strPatientID = '" + patientID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
patientType = reader.GetString("strTypeDesc");
lblPatientTypeVal.Text = reader.GetString("strTypeDesc");
}
reader.Close();
if (patientType.ToUpper().Equals("STUDENT"))
{
lblCourse.Text = "Course:";
sql = "SELECT a.strCollegeDesc, b.strCourseDesc " +
"FROM tblCollege a, tblCourse b, tblPatientType c " +
"WHERE a.strCollegeCode = c.strCollegeCode AND " +
"b.strCourseCode = c.strCourseCode AND " +
"c.strPatientID = '" + patientID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblCollegeVal.Text = reader.GetString("strCollegeDesc");
lblCourseVal.Text = reader.GetString("strCourseDesc");
//cboCollege.SelectedText = reader.GetString("strCollegeDesc");
//cboCourse.SelectedText = reader.GetString("strCourseDesc");
}
reader.Close();
}
else if (patientType.ToUpper().Equals("PROFESSOR"))
{
lblCourse.Text = "Department:";
sql = "SELECT a.strCollegeDesc, b.strDeptDesc " +
"FROM tblCollege a, tblDepartment b, tblPatientType c " +
"WHERE a.strCollegeCode = c.strCollegeCode AND " +
"b.strDeptCode = c.strDeptCode AND " +
"c.strPatientID = '" + patientID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblCollegeVal.Text = reader.GetString("strCollegeDesc");
lblCourseVal.Text = reader.GetString("strDeptDesc");
//cboCollege.SelectedText = reader.GetString("strCollegeDesc");
//cboCourse.SelectedText = reader.GetString("strDeptDesc");
}
reader.Close();
}
else
{
lblCollege.Visible = false;
lblCollegeVal.Visible = false;
lblCourse.Text = "Department:";
sql = "SELECT a.strDesc " +
"FROM tblStaffDepartment a, tblPatientType b " +
"WHERE a.strStaffDeptCode = b.strStaffDeptCode AND " +
"b.strPatientID = '" + patientID + "';";
cmd = new MySqlCommand(sql, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
lblCourseVal.Text = reader.GetString("strDesc");
//cboCourse.SelectedText(reader.GetString("strDesc"));
}
reader.Close();
lblCourse.Text = "Department:";
}
pboQR.BackgroundImage = QuickRead.GenerateQR(patientID.Trim());
pboPrintQR.BackgroundImage = QuickRead.GenerateQR(patientID.Trim());
}
catch (MySqlException me)
{
Integrity.GetExceptionDetails(me);
}
catch (Exception ex)
{
Integrity.GetExceptionDetails(ex);
}
lblPrintName.Text = textPatLastName.Text + "\n" + textPatFirstName.Text + " " + textPatMiddleName.Text;
lblPrintID.Text = lblIDNoVal.Text;
lblPrintPatID.Text = lblPatIDVal.Text;
}
