protected void btn_Register_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.doctor_profile dbProfile = new Entity.doctor_profile(); // dbProfile.DoctorLocation = textbox_clinic.Text; dbProfile.doctor_name = textbox_fullname.Text; dbProfile.DoctorMail = textbox_mail.Text; dbProfile.DoctorMobile = textbox_mobile.Text; // dbProfile.DoctorAcademicDegree = Select_AcademicDegree.Text; dbProfile.doctor_degree = Select_Degree.Text; dbProfile.doctor_precense = Select_DoctorPresence.Text; dbProfile.doctor_title = Select_Title.Text; // dbProfile.doctor_other_degrees = TextArea_otherQualifications.InnerText; dbProfile.doctor_other_qualifications = TextArea_otherQualifications.InnerText; // dbProfile.doctor_PHD_year = DateTime.Parse(date_PHD.Value); dbProfile.doctor_MCS_year = DateTime.Parse(date_MCS.Value); dbProfile.doctor_bach_year = DateTime.Parse(date_BCH.Value); dbProfile.doctor_birthdate = DateTime.Parse(date_birthday.Value); db.doctor_profile.Add(dbProfile); db.SaveChanges(); }
protected void Unnamed1_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.Gynacology gynacology = new Entity.Gynacology(); ///insert ( mapping ) /// // gynacology.patientName = textbox_PatientName.Text.Trim(); gynacology.patientAge = DropDown_PatientAge.Text.Trim(); gynacology.ticketId = textbox_TicketNumber.Text.Trim(); gynacology.AdmissionDate = Date_AdmissionDate.Value; gynacology.ParityValue = textbox_Parity.Text.Trim(); gynacology.AddedValue = textboxPlus.Text.Trim(); gynacology.Dynamics = ""; gynacology.Dynamics += "Parity 1:" + dropdown_parity1.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 2:" + dropdown_parity2.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 3:" + dropdown_parity3.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 4:" + dropdown_parity4.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 5:" + dropdown_parity5.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 6:" + dropdown_parity6.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 7:" + dropdown_parity7.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 8:" + dropdown_parity8.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 9:" + dropdown_parity9.Value.Replace("Select", "NA").Trim(); gynacology.Dynamics += ",Parity 10:" + dropdown_parity10.Value.Replace("Select", "NA").Trim(); gynacology.Presentation = DropDown_Diagnosis_Presentation.Text.Trim().Replace("Select", "NA").Trim(); gynacology.ChildState = DropDown_Diagnosis_State.Text.Trim().Replace("Select", "NA").Trim(); gynacology.NumberOfLivingMale = Convert.ToInt32(textbox_LivingMale.Text.Trim()); gynacology.NumberOfLivingFemale = Convert.ToInt32(textbox_LivingFemale.Text.Trim()); gynacology.OperativeDate = DateTime_OperativeDate.Value; gynacology.Intervention = DropDown_Intervention.Text.Trim().Replace("Select", "NA").Trim(); gynacology.OtherIntervention = DropDown_OtherIntervention.Text.Trim().Replace("Select", "NA").Trim(); gynacology.Surgeons = DropDown_Staff_Surgeon.Text.Trim().Replace("Select", "NA").Trim(); gynacology.Assistants = DropDown_Staff_Assistant.Text.Trim().Replace("Select", "NA").Trim(); gynacology.Supervisors = DropDown_Staff_Supervisor.Text.Trim().Replace("Select", "NA").Trim(); gynacology.AdditionalNotes = TextArea_Others_Notes.InnerText.Trim(); try { db.Gynacologies.Add(gynacology); db.SaveChanges(); } catch (Exception ex) { throw; } }
protected void Unnamed1_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.Lecture lecture = new Entity.Lecture(); lecture.Lecture_Date = DateTime.Parse(DateTime_Lecutre.Value); lecture.Lecturer_Name = DropDown_Lecturer.Text.Trim().Replace("Select", "NA").Trim(); lecture.Substitute_Name = DropDown_Substitute.Text.Trim().Replace("Select", "NA").Trim(); lecture.Topic = textbox_Topic.Text.Trim(); lecture.Students_Flag = "P"; try { db.Lectures.Add(lecture); db.SaveChanges(); } catch (Exception ex) { throw; } }
protected void Unnamed1_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.Clinical_Rounds CR = new Entity.Clinical_Rounds(); CR.Lecture_date = DateTime.Parse(DateTime_Lecutre.Value); CR.Lecturer_name = DropDown_Lecturer.Text.Trim().Replace("Select", "NA").Trim(); CR.First_Subsitute_name = DropDown_firstSubstitute.Text.Trim().Replace("Select", "NA").Trim(); CR.Second_Subsitute_name = DropDownList_secondsubstitue.Text.Trim().Replace("Select", "NA").Trim(); CR.group = DropDownList_Group.Text.Trim().Replace("Select", "NA").Trim(); CR.Time = DropDownList_Time.Text.Trim().Replace("Select", "NA").Trim(); CR.Student_flag = "P"; try { db.Clinical_Rounds.Add(CR); db.SaveChanges(); } catch (Exception ex) { throw; } }
protected void Unnamed1_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.Research research = new Entity.Research(); research.Registration_date = DateTime.Parse(Registration_DateTime.Value); research.Researcher_External = textbox_Researcher.Text.Trim(); research.Researcher_Staff = DropDown_Researcher.Text.Trim().Replace("Select", "NA").Trim(); research.Super1 = DropDownList_FirstSupervisor.Text.Trim().Replace("Select", "NA").Trim(); research.Super2 = DropDownList_secondSupervisor.Text.Trim().Replace("Select", "NA").Trim(); research.Super3 = DropDownList_thirdSupervisor.Text.Trim().Replace("Select", "NA").Trim(); research.Super4 = DropDownList_FourthSupervisor.Text.Trim().Replace("Select", "NA").Trim(); research.Super5 = DropDownList_FifthSupervisor.Text.Trim().Replace("Select", "NA").Trim(); research.Research_Title = textbox_Title.Text.Trim(); research.State = DropDown_State.Text.Trim().Replace("Select", "NA").Trim(); try { db.Researches.Add(research); db.SaveChanges(); } catch (Exception ex) { throw; } }
protected void Unnamed1_Click(object sender, EventArgs e) { Entity.unit5Entities db = new Entity.unit5Entities(); Entity.CasulityProfile casulity = new Entity.CasulityProfile(); ///insert ( mapping ) /// // casulity.patientName = textbox_PatientName.Text.Trim(); casulity.patientAge = DropDown_PatientAge.Text.Trim(); casulity.ticketId = textbox_TicketNumber.Text.Trim(); casulity.AdmissionDate = DateTime.Parse(Date_AdmissionDate.Value); casulity.ParityValue = textbox_Parity.Text.Trim(); casulity.AddedValue = textboxPlus.Text.Trim(); casulity.Dynamics = ""; casulity.Dynamics += "Parity 1:" + dropdown_parity1.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 2:" + dropdown_parity2.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 3:" + dropdown_parity3.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 4:" + dropdown_parity4.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 5:" + dropdown_parity5.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 6:" + dropdown_parity6.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 7:" + dropdown_parity7.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 8:" + dropdown_parity8.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 9:" + dropdown_parity9.Value.Replace("Select", "NA").Trim(); casulity.Dynamics += ",Parity 10:" + dropdown_parity10.Value.Replace("Select", "NA").Trim(); casulity.Weeks = DropDown_Diagnosis_Weeks.Text.Trim(); casulity.Days = DropDown_Diagnosis_Days.Text.Trim(); casulity.By = DropDown_Diagnosis_By.Text.Trim().Replace("Select", "NA").Trim(); casulity.Obstetric = DropDown_Diagnosis_Obstetric.Text.Trim().Replace("Select", "NA").Trim(); casulity.Disorder = DropDown_Diagnosis_Disorder.Text.Trim().Replace("Select", "NA").Trim(); casulity.Presentation = DropDown_Diagnosis_Presentation.Text.Trim().Replace("Select", "NA").Trim(); casulity.ChildState = DropDown_Diagnosis_State.Text.Trim().Replace("Select", "NA").Trim(); casulity.NumberOfLivingMale = textbox_LivingMale.Text.Trim(); casulity.NumberOfLivingFemale = textbox_LivingFemale.Text.Trim(); casulity.InterventionDate = DateTime.Parse(Date_InterventionDate.Value); casulity.Intervention = DropDown_Intervention_InterventionSelection.Text.Trim().Replace("Select", "NA").Trim(); casulity.Complications = DropDown_Intervention_Complications.Text.Trim().Replace("Select", "NA").Trim(); casulity.AdditionalComplications = DropDown_Intervention_ExtraComplications.Text.Trim().Replace("Select", "NA").Trim(); casulity.ICU = checkbox_ICU.Text.Trim(); casulity.Outcome = DropDown_Intervention_Outcome.Text.Trim().Replace("Select", "NA").Trim(); casulity.Sex = DropDown_Intervention_Sex.Text.Trim().Replace("Select", "NA").Trim(); casulity.NeonatalCondition = DropDown_Intervention_NeonatalCondition.Text.Trim().Replace("Select", "NA").Trim(); // casulity.OtherIntervention = DropDown_Other_Interventions.Text.Trim().Replace("Select", "NA").Trim(); casulity.OtherIntervention = "test"; casulity.Indications = DropDown_cs_Indications.Text.Trim().Replace("Select", "NA").Trim(); casulity.Surgeons = DropDown_Staff_Surgeon.Text.Trim().Replace("Select", "NA").Trim(); casulity.Assistants = DropDown_Staff_Assistant.Text.Trim().Replace("Select", "NA").Trim(); casulity.Supervisors = DropDown_Staff_Supervisor.Text.Trim().Replace("Select", "NA").Trim(); casulity.AdditionalNotes = TextArea_Others_Notes.InnerText.Trim(); try { db.CasulityProfiles.Add(casulity); db.SaveChanges(); } catch (Exception ex) { throw; } }