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