protected void addDetailsButtonClick(object sender, EventArgs e)
{
String titleText = "";
String firstText = "";
String lastText = "";
String dateOfBirth = "";
String sexText = "";
String clinicText = "";
String mrnText = "";
String billingText = "";
titleText = titleBox.Text;
firstText = firstNameBox.Value;
lastText = lastNameBox.Value;
dateOfBirth = dobBox.Value;
sexText = gender.Text;
clinicText = clinicBox.Value;
mrnText = MRNBox.Value;
billingText = billingBox.Value;
using (var db = new UniversityMHIProjectContext())
{
var patientDet = new PatientDetails {
BillingDetails = billingText, Clinic = clinicText, DateOfBirth = dateOfBirth, FirstName = firstText, LastName = lastText, Gender = sexText, MRN = mrnText, ReferringPhyscian = "", Signature = ""
};
db.PatientDetails.Add(patientDet);
db.SaveChanges();
}
Response.Redirect("ReturningPatient.aspx");
}
protected void dropDrownSelectionIndexChanged(object sender, EventArgs e)
{
patientTestJunc.Clear();
int selectedIndex = ddlMainPatient.SelectedIndex - 1;
PatientDetails ptDet = null;
using (var db = new UniversityMHIProjectContext())
{
List <PatientDetails> list = db.PatientDetails.ToList();
ptDet = list.ElementAt(selectedIndex);
foreach (PatientTestJunction ptJunc in db.PatientTestJunction)
{
if (ptJunc.PatientId == ptDet.PatientId)
{
ptJunc.Diagnosis = db.DiagnosisTest.Where(x => x.DiagnosisTestID == ptJunc.DiagnosisTestID).FirstOrDefault();
patientTestJunc.Add(ptJunc);
}
}
}
if (ptDet != null)
{
aspGenderTextBox.Text = ptDet.Gender;
aspBillingTextBox.Text = ptDet.BillingDetails;
aspClinicTextBox.Text = ptDet.Clinic;
aspDOBTextBox.Text = ptDet.DateOfBirth;
aspFirstNameTextBox.Text = ptDet.FirstName;
aspLastNameTextBox.Text = ptDet.LastName;
aspMRNTextBox.Text = ptDet.MRN;
aspTitleTextBox.Text = "Mr.";
}
}
protected void orderConfirmation(object sender, EventArgs e)
{
String Date = System.DateTime.Today.ToString();
int patientID = ddlMainPatient.SelectedIndex;
String diagnosticType = "MRI";
String subType = DropDownListMRI.SelectedValue;
String reasonTest = StudyReasonDropdown.SelectedValue;
String DiagnosisProblem = DiagnosisProblemDropDon.SelectedValue;
using (var db = new UniversityMHIProjectContext())
{
int diagnosticID = db.DiagnosisTest.Where(x => x.TestType == diagnosticType && x.TestSubType == subType).FirstOrDefault().DiagnosisTestID;
db.PatientTestJunction.Add(new PatientTestJunction {
PatientId = patientID, DiagnosisTestID = diagnosticID, Date = Date, DiagnosticProblem = DiagnosisProblem, ReasonStudy = reasonTest
});
db.SaveChanges();
}
Response.Redirect("ReturningPatient.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownListMRI.Items.Clear();
DropDownListMRI.Items.Add("Select one");
DropDownListCT.Items.Clear();
DropDownListCT.Items.Add("Select one");
DropDownListXRAY.Items.Clear();
DropDownListXRAY.Items.Add("Select one");
DropDownListUltrasound.Items.Clear();
DropDownListUltrasound.Items.Add("Select one");
ddlMainPatient.Items.Clear();
patientTestJunc.Clear();
ddlMainPatient.Items.Add("----Select One----");
List <PatientDetails> patientDetailsList = new List <PatientDetails>();
using (var db = new UniversityMHIProjectContext())
{
//var patientDet = new PatientDetails { BillingDetails = billingText, Clinic = clinicText, DateOfBirth = dateOfBirth, FirstName = firstText, LastName = lastText, Gender = sexText, MRN = mrnText, ReferringPhyscian = "", Signature = "" };
//db.PatientDetails.Add(patientDet);
//db.SaveChanges();
foreach (PatientDetails ptDet in db.PatientDetails)
{
patientDetailsList.Add(ptDet);
}
foreach (StudyReason resStu in db.StudyReason)
{
StudyReasonDropdown.Items.Add(resStu.Reason);
}
foreach (DiagnosisProblem prb in db.DiagnosisProblem)
{
DiagnosisProblemDropDon.Items.Add(prb.Problem);
}
foreach (DiagnosisTest test in db.DiagnosisTest)
{
if (test.TestType == "MRI")
{
DropDownListMRI.Items.Add(test.TestSubType);
}
else if (test.TestType == "CT")
{
DropDownListCT.Items.Add(test.TestSubType);
}
else if (test.TestType == "XRAY")
{
DropDownListXRAY.Items.Add(test.TestSubType);
}
else if (test.TestType == "Ultrasound")
{
DropDownListUltrasound.Items.Add(test.TestSubType);
}
}
}
foreach (PatientDetails pt in patientDetailsList)
{
ddlMainPatient.Items.Add(pt.FirstName + " " + pt.LastName + " - " + pt.MRN);
}
}
}