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