private void cbPatient_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbPatient.SelectedIndex != 0)
{
PatientHistory objPatientHistory = new PatientHistory();
objPatient.Firstname = cbPatient.SelectedItem.ToString().Split(' ')[0];
objPatient.Lastname = cbPatient.SelectedItem.ToString().Split(' ')[1];
objPatientHistory.Patientid = objPatient.GetPatientId(objPatient);
DataSet dsPatientHistory = objPatientHistory.GetPatientDetails(objPatientHistory);
if (dsPatientHistory.Tables[0].Rows.Count > 0)
{
lblFirstnameValue.Text = dsPatientHistory.Tables[0].Rows[0]["PATIENT_NAME"].ToString();
lblAppartmentNoValue.Text = dsPatientHistory.Tables[0].Rows[0]["ADDRESS_LINE_1"].ToString();
lblStreetNameValue.Text = dsPatientHistory.Tables[0].Rows[0]["ADDRESS_LINE_2"].ToString();
lblCityValue.Text = dsPatientHistory.Tables[0].Rows[0]["CITY"].ToString();
lblProvienceValue.Text = dsPatientHistory.Tables[0].Rows[0]["PROVIENCE_DESCRIPTION"].ToString();
lblPostalCodeValue.Text = dsPatientHistory.Tables[0].Rows[0]["POSTAL_CODE"].ToString();
lblDateofBirthValue.Text = dsPatientHistory.Tables[0].Rows[0]["DOB"].ToString();
lblEmailValue.Text = dsPatientHistory.Tables[0].Rows[0]["EMAIL"].ToString();
lblContactNoValue.Text = dsPatientHistory.Tables[0].Rows[0]["CONTACT_NO"].ToString();
panelPatientDetails.Visible = true;
panelAppointment.Visible = true;
}
}
else
{
ClearPatientDetails();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (valid())
{
PatientHistory objPatientHistory = new PatientHistory();
objPatient.Firstname = cbPatient.SelectedItem.ToString().Split(' ')[0];
objPatient.Lastname = cbPatient.SelectedItem.ToString().Split(' ')[1];
objPatientHistory.Patientid = objPatient.GetPatientId(objPatient);
DataSet dsPatientHistory = objPatientHistory.GetPatientDetails(objPatientHistory);
//dgvPatientHistory.DataSource = dsPatientHistory.Tables[0];
DataTable dtPatientHistory = new DataTable("PATIENT_HISTORY");
dtPatientHistory.Columns.Add("APPOINTMENT_ID");
dtPatientHistory.Columns.Add("APPOINTMENT_DATE");
dtPatientHistory.Columns.Add("PROCEDURE_DESCRIPTION");
dtPatientHistory.Columns.Add("PAID");
for (int i = 0; i < dsPatientHistory.Tables[0].Rows.Count; i++)
{
DataRow row = dtPatientHistory.NewRow();
row["APPOINTMENT_ID"] = dsPatientHistory.Tables[0].Rows[i]["APPOINTMENT_ID"].ToString();
row["APPOINTMENT_DATE"] = dsPatientHistory.Tables[0].Rows[i]["APPOINTMENT_DATE"].ToString();
row["PROCEDURE_DESCRIPTION"] = dsPatientHistory.Tables[0].Rows[i]["PROCEDURE_DESCRIPTION"].ToString();
row["PAID"] = dsPatientHistory.Tables[0].Rows[i]["PAID"].ToString();
dtPatientHistory.Rows.Add(row);
}
dgvPatientHistory.DataSource = dtPatientHistory;
}
}