protected void SelectButton_Click(object sender, EventArgs e)
{
patientDB.PatientTables.Load();
testResultDB.TestsTables.Load();
medicationDB.MedicationListTables.Load();
historyDB.AppointmentTables.Load();
var patientInfo = from item in patientDB.PatientTables.Local
where item.PatientID == Convert.ToInt32(GridView1.SelectedDataKey[0])
select item;
var patientTestResults = (from item in testResultDB.TestsTables.Local
where item.PatientID == Convert.ToInt32(GridView1.SelectedDataKey[0])
select item);
var patientMedications = (from item in medicationDB.MedicationListTables.Local
where item.PatientID == Convert.ToInt32(GridView1.SelectedDataKey[0])
select item);
var patientHistory = from item in historyDB.AppointmentTables.Local
where item.PatientID == Convert.ToInt32(GridView1.SelectedDataKey[0])
select item;
patietnInfoGridView.DataSource = patientInfo;
patietnInfoGridView.DataBind();
patientTestGridVeiw.DataSource = patientTestResults;
patientTestGridVeiw.DataBind();
MedicationGridView.DataSource = patientMedications;
MedicationGridView.DataBind();
historyGridView.DataSource = patientHistory;
historyGridView.DataBind();
//ListBox1.Items.Add(patientTestResults.ToList().First().ToString());
}
protected void SearchButton_Click(object sender, EventArgs e)
{
patientDB.PatientTables.Load();
testResultDB.TestsTables.Load();
medicationDB.MedicationListTables.Load();
historyDB.AppointmentTables.Load();
var inputString = TextBox1.Text;
int idValue;
if (int.TryParse(inputString, out idValue))
{
// if input was an ID
var patientInfo = (from item in patientDB.PatientTables.Local
where item.PatientID == idValue
select item);
if (patientInfo.FirstOrDefault() == null)
{
Response.Redirect("~/DoctorPages/PatientList.aspx");
}
var patientTestResults = (from item in testResultDB.TestsTables.Local
where item.PatientID == idValue
select item);
var patientMedications = (from item in medicationDB.MedicationListTables.Local
where item.PatientID == idValue
select item);
var patientHistory = from item in historyDB.AppointmentTables.Local
where item.PatientID == idValue
select item;
patietnInfoGridView.DataSource = patientInfo;
patietnInfoGridView.DataBind();
patientTestGridVeiw.DataSource = patientTestResults;
patientTestGridVeiw.DataBind();
MedicationGridView.DataSource = patientMedications;
MedicationGridView.DataBind();
historyGridView.DataSource = patientHistory;
historyGridView.DataBind();
}
else
{
var patientInfo = (from item in patientDB.PatientTables.Local
where item.LastName.Trim() == inputString
select item);
if (patientInfo.FirstOrDefault() == null)
{
Response.Redirect("~/DoctorPages/PatientList.aspx");
}
// other tables are only accessable by patient id
int patId = patientInfo.FirstOrDefault().PatientID;
var patientTestResults = (from item in testResultDB.TestsTables.Local
where item.PatientID == patId
select item);
var patientMedications = (from item in medicationDB.MedicationListTables.Local
where item.PatientID == patId
select item);
var patientHistory = from item in historyDB.AppointmentTables.Local
where item.PatientID == patId
select item;
patietnInfoGridView.DataSource = patientInfo;
patietnInfoGridView.DataBind();
patientTestGridVeiw.DataSource = patientTestResults;
patientTestGridVeiw.DataBind();
MedicationGridView.DataSource = patientMedications;
MedicationGridView.DataBind();
historyGridView.DataSource = patientHistory;
historyGridView.DataBind();
}
}