// Convert Patient Object into list public List <String> ObjectToList(Patient_info Patient) { ////////////////// List <String> row = new List <String>(); row.Add("Click Me"); row.Add(Patient.Patient_ID.ToString()); row.Add(Patient.Age.ToString()); row.Add(Patient.Patient_name); row.Add(Patient.Home_number); row.Add(Patient.Phone_number); row.Add(Patient.Address); row.Add(Patient.Cheif_complaint); row.Add(Patient.Medical_alert); row.Add(Patient.Visit_date.ToShortDateString()); row.Add(Patient.Birth_date.ToShortDateString()); row.Add(Patient.Sex); row.Add(Patient.Relative_marriage); row.Add(Patient.DMF.ToString()); row.Add(Patient.C_dmf.ToString()); row.Add(Patient.DEF.ToString()); row.Add(Patient.Comments); return(row); }
public Edit_Patient(int Patient_ID, int Age, String Patient_Name, String Home_no, String Mobile_no, String Address, String Cheif_comp, String Medical_Alr, String Comments, String Sex, String RelativeMarriage, DateTime VisitDate, DateTime BirthDate, byte[] PatientPhoto, List<Bitmap> xray_images, List<String> xrayimagesNames, Double D, Double M, Double F, Double d, Double m, Double f, Double _D, Double E, Double _F, List<List<String>> DiagnosisAndTPs_table, List<List<String>> DatesAndProc_table) { InitializeComponent(); EPatient_ID = Patient_ID; EAge = Age; EPatient_Name = Patient_Name; EHome_no = Home_no; EMobile_no = Mobile_no; EAddress = Address; ECheif_comp = Cheif_comp; EMedical_Alr = Medical_Alr; EComments = Comments; ESex = Sex; ERelativeMarriage = RelativeMarriage; EVisitDate = VisitDate; EBirthDate = BirthDate; EPatientPhoto = PatientPhoto; Xray_images = xray_images; XrayimagesNames = xrayimagesNames; ED = D; EM = M; EF = F; Ed = d; Em = m; Ef = f; E_D = _D; EE = E; E_F = _F; ID = EPatient_ID; this.Name = "Edit " + EPatient_Name + " Profile"; EDiagnosisAndTPs_table = DiagnosisAndTPs_table; EDatesAndProc_table = DatesAndProc_table; Patient_Xray_images = new List<Bitmap>(); XrayImagesNames = new List<String>(); con = new DataSourceConnection(); BS = new BindingSource(); ValidateData = new Data_Validator(); Error = new ErrorProvider(); DataUpdater = new DCEntities(); Patient = new Patient_info(); Updated_DiagnosisAndTPs_table = new List<List<String>>(); Updated_DatesAndProc_table = new List<List<String>>(); DiagnosisAndTPsIsChanged = false; DatesAndProceduresIsChanged = false; DiagnosisAndTPsIsPressed = false; DatesAndProceduresIsPressed = false; AddnewXrayImagesIsPressed = false; AddnewPatient_saveAndConfirm_button.Visible = false; AddNewPatientSaveAndConfirmIsPressed = false; XrayViewerImageIndex = 0; IntializeComboBoxes(); FillFormData(); }
public Patient_Profile_Viewer(int id) { InitializeComponent(); Patient_ID = id; RetrievedContext = new DCEntities(); ValidateData = new Data_Validator(); Patient = new Patient_info(); Xray_images = new List<Bitmap>(); XrayimagesNames = new List<String>(); Diagnosis = new List<String>(); TreatmentPlans = new List<String>(); DiagnosisAndTPs_table = new List<List<String>>(); DatesAndProc_table = new List<List<String>>(); ViewPatientProfile(); XrayViewerImageIndex = 0; }
public Search() { InitializeComponent(); SearchContext = new DCEntities(); Patient = new Patient_info(); Diagnose = new Diagnosis(); Date = new Date(); con = new DataSourceConnection(); BS = new BindingSource(); ValidateData = new Data_Validator(); Error = new ErrorProvider(); TableNames = new Dictionary<String, String>(); SearchOptions = new List<String>(); IntializeLists(); }
public Search() { InitializeComponent(); SearchContext = new DCEntities(); Patient = new Patient_info(); Diagnose = new Diagnosis(); Date = new Date(); con = new DataSourceConnection(); BS = new BindingSource(); ValidateData = new Data_Validator(); Error = new ErrorProvider(); TableNames = new Dictionary <String, String>(); SearchOptions = new List <String>(); IntializeLists(); }
public Patient_Profile_Viewer(int id) { InitializeComponent(); Patient_ID = id; RetrievedContext = new DCEntities(); ValidateData = new Data_Validator(); Patient = new Patient_info(); Xray_images = new List <Bitmap>(); XrayimagesNames = new List <String>(); Diagnosis = new List <String>(); TreatmentPlans = new List <String>(); DiagnosisAndTPs_table = new List <List <String> >(); DatesAndProc_table = new List <List <String> >(); ViewPatientProfile(); XrayViewerImageIndex = 0; }
// Get the ID of the choise private int GetID(String Option, String Choise) { int ID = 0; if (Option == "Home Number") { Patient = SearchContext.Patient_info.Where(i => i.Home_number == Choise).First(); ID = Patient.Patient_ID; } else if (Option == "Mobile Number") { Patient = SearchContext.Patient_info.Where(i => i.Phone_number == Choise).FirstOrDefault(); ID = Patient.Patient_ID; } return(ID); }
// Main Function private void AddnewPatient_saveAndConfirm_button_Click(object sender, EventArgs e) { int ID = 0, Age; String Name, Home_no = "", Mobile_no, Address, Cheif_comp, Medical_Alr, Comments, Sex, RelativeMarriage; DateTime VisitDate, BirthDate; byte[] PatientPhoto; var newPatient = new Patient_info(); // Re-validate if (!DataValidation()) { return; } try { ID = Int32.Parse(Patient_ID_textBox.Text); Age = Int32.Parse(Age_textBox.Text); Name = Patient_name_textBox.Text; Home_no = Homenum_textBox.Text; Mobile_no = Mobile_textBox.Text; Address = Address_textBox.Text; Cheif_comp = Chief_Complaint_textBox.Text; Medical_Alr = Medical_alert_textBox.Text; VisitDate = Convert.ToDateTime(Visit_date_textBox.Text); BirthDate = Convert.ToDateTime(DateOfBirth_textBox.Text); PatientPhoto = imageToByteArray(Patient_Picture); Comments = Comments_textbox.Text; Sex = Sex_Combobox.Text; RelativeMarriage = Realative_Marriage_comboBox.Text; // Main Panel /////////////////////////////// newPatient.Patient_ID = ID; newPatient.Patient_name = Name; newPatient.Visit_date = VisitDate; newPatient.Age = Age; newPatient.Home_number = Home_no; newPatient.Phone_number = Mobile_no; newPatient.Birth_date = BirthDate; newPatient.Patient_image = PatientPhoto; newPatient.Sex = Sex; newPatient.Relative_marriage = RelativeMarriage; newPatient.Address = Address; newPatient.Cheif_complaint = Cheif_comp; newPatient.Medical_alert = Medical_Alr; newPatient.D_DMF = D; newPatient.M_DMF = M; newPatient.F_DMF = F; newPatient.DMF = DMF; newPatient.dd_dmf = d; newPatient.mm_dmf = m; newPatient.ff_dmf = f; newPatient.C_dmf = _dmf; newPatient.D_DEF = _D; newPatient.E_DEF = E; newPatient.F_DEF = _F; newPatient.DEF = DEF; if (Comments.Length != 0) { newPatient.Comments = Comments; } /////////////////////////////////////////// // Diagnosis and Treatment Plans panel ////////////////////////////////////////// var Dcount = (from o in DataEntiry.Diagnoses select o).Count(); int Dtemp = Dcount + 1; foreach (List <String> row in DiagnosisAndTPs_table) { var DiagnosisObject = new Diagnosis(); DiagnosisObject.Diagnose_ID = Dtemp; DiagnosisObject.Diagnose = row[0]; DiagnosisObject.Treatment_Plan = row[1]; newPatient.Diagnoses.Add(DiagnosisObject); Dtemp++; } ///////////////////////////////////////// // Patinet's X-ray images //////////////////////////////////////// // Byte[] XrayImage; MemoryStream ms; int index = 0; var Xcount = (from o in DataEntiry.X_ray_images select o).Count(); int Xtemp = Xcount + 1; foreach (Bitmap img in Patient_Xray_images) { var XrayimageObject = new X_ray_images(); ms = new MemoryStream(); img.Save(ms, img.RawFormat); XrayimageObject.Xray_image = ms.ToArray(); XrayimageObject.Image_name = XrayImagesNames[index]; XrayimageObject.Xray_images_ID = Xtemp; newPatient.X_ray_images.Add(XrayimageObject); index++; Xtemp++; } ///////////////////////////////////////// // Dates And Procedures Panel //////////////////////////////////////// var DAcount = (from o in DataEntiry.Dates select o).Count(); int DAtemp = DAcount + 1; foreach (List <String> row in DatesAndProc_table) { var DatesObject = new Date(); DatesObject.Dates_ID = DAtemp; DatesObject.Date1 = Convert.ToDateTime(row[0]); DatesObject.Doctor_name = row[1]; DatesObject.Procedures = row[2]; DatesObject.Procedure_Comment = row[3]; if (row[4].Length != 0) { DatesObject.Medication = row[4]; } DatesObject.Supervisor_signature = row[5]; newPatient.Dates.Add(DatesObject); DAtemp++; } } catch (Exception) { MessageBox.Show("Please press Check Data Button before Saving"); return; } DataEntiry.Patient_info.Add(newPatient); try { DataEntiry.SaveChanges(); } catch (Exception ex) { Exception exeption = ex; MessageBox.Show("Something wrong with saving the changes in the DBcontext"); return; } // Check if exist string SqlCommand = "SELECT * FROM Patient_info WHERE Patient_ID = " + ID.ToString() + " AND Home_number = " + Home_no.ToString() + " "; BSS.DataSource = Con.GetData(SqlCommand); Check = (DataTable)BSS.DataSource; if (Check.Rows.Count != 0) { MessageBox.Show("The patient was added successfully"); NewPatientWasAdded = true; Add_new_Patient Reset = new Add_new_Patient(); this.Close(); this.Dispose(); Reset.Show(); } else { MessageBox.Show("Failed to add the patient file"); } }
// Get patient data public void GetPatientData() { Patient = RetrievedContext.Patient_info.Where(ID => ID.Patient_ID == Patient_ID).FirstOrDefault(); }
// Convert Patient Object into list public List<String> ObjectToList(Patient_info Patient) { ////////////////// List<String> row = new List<String>(); row.Add("Click Me"); row.Add(Patient.Patient_ID.ToString()); row.Add(Patient.Age.ToString()); row.Add(Patient.Patient_name); row.Add( Patient.Home_number); row.Add( Patient.Phone_number); row.Add( Patient.Address); row.Add( Patient.Cheif_complaint); row.Add( Patient.Medical_alert); row.Add( Patient.Visit_date.ToShortDateString()); row.Add( Patient.Birth_date.ToShortDateString()); row.Add(Patient.Sex); row.Add(Patient.Relative_marriage); row.Add(Patient.DMF.ToString()); row.Add(Patient.C_dmf.ToString()); row.Add(Patient.DEF.ToString()); row.Add(Patient.Comments); return row; }
// Get the ID of the choise private int GetID(String Option, String Choise) { int ID = 0; if (Option == "Home Number") { Patient = SearchContext.Patient_info.Where(i => i.Home_number == Choise).First(); ID = Patient.Patient_ID; } else if (Option == "Mobile Number") { Patient = SearchContext.Patient_info.Where(i => i.Phone_number == Choise).FirstOrDefault(); ID = Patient.Patient_ID; } return ID; }
// Main Function private void AddnewPatient_saveAndConfirm_button_Click(object sender, EventArgs e) { // re-validate if (!DataValidation()) return; List<Control> ChangedControls = _dirtyTracker.GetListOfDirtyControls(); Patient = DataUpdater.Patient_info.Where(i => i.Patient_ID == EPatient_ID).FirstOrDefault(); #region Basic info if (ChangedControls.Contains(Patient_ID_textBox)) { ID = Int32.Parse(Patient_ID_textBox.Text); Patient.Patient_ID = ID; } if (ChangedControls.Contains(Age_textBox)) { int Age; Age = Int32.Parse(Age_textBox.Text); Patient.Age = Age; } if (ChangedControls.Contains(Sex_Combobox)) { Patient.Sex = Sex_Combobox.Text; } if (ChangedControls.Contains(DateOfBirth_textBox)) { DateTime BD = DateTime.Parse(DateOfBirth_textBox.Text); Patient.Birth_date = BD; } if (ChangedControls.Contains(Visit_date_textBox)) { DateTime VD = DateTime.Parse(Visit_date_textBox.Text); Patient.Visit_date = VD; } if (ChangedControls.Contains(Patient_name_textBox)) { Patient.Patient_name = Patient_name_textBox.Text; } if (ChangedControls.Contains(Homenum_textBox)) { Patient.Home_number = Homenum_textBox.Text; } if (ChangedControls.Contains(Mobile_textBox)) { Patient.Phone_number = Mobile_textBox.Text; } if (ChangedControls.Contains(Realative_Marriage_comboBox)) { Patient.Relative_marriage = Realative_Marriage_comboBox.Text; } if (ChangedControls.Contains(Address_textBox)) { Patient.Address = Address_textBox.Text; } if (ChangedControls.Contains(Chief_Complaint_textBox)) { Patient.Cheif_complaint = Chief_Complaint_textBox.Text; } if (ChangedControls.Contains(Medical_alert_textBox)) { Patient.Medical_alert = Medical_alert_textBox.Text; } if (Profile_Picture != null) { Patient.Patient_image = imageToByteArray(Profile_Picture) ; } if (AddnewXrayImagesIsPressed) { // Patinet's X-ray images //////////////////////////////////////// // Byte[] XrayImage; MemoryStream ms; int ix = 0; var Xcount = (from o in DataUpdater.X_ray_images select o).Count(); int Xtemp = Xcount + 1; foreach (Bitmap img in Patient_Xray_images) { var XrayimageObject = new X_ray_images(); ms = new MemoryStream(); img.Save(ms, img.RawFormat); XrayimageObject.Patient_ID = ID; XrayimageObject.Xray_image = ms.ToArray(); XrayimageObject.Image_name = XrayImagesNames[ix]; XrayimageObject.Xray_images_ID = Xtemp; DataUpdater.X_ray_images.Add(XrayimageObject); ix++; Xtemp++; } } if (ChangedControls.Contains(DMF_D_textBox)) { Patient.D_DMF = D; } if (ChangedControls.Contains(DMF_M_textbox)) { Patient.M_DMF = M; } if (ChangedControls.Contains(DMF_F_textBox)) { Patient.F_DMF = F; } if (ChangedControls.Contains(DMF_D_textBox) || ChangedControls.Contains(DMF_M_textbox) || ChangedControls.Contains(DMF_F_textBox)) { Patient.DMF = DMF; } if (ChangedControls.Contains(_dmf_d_textBox)) { Patient.dd_dmf = d; } if (ChangedControls.Contains(_dmf_m_textBox)) { Patient.mm_dmf = m; } if (ChangedControls.Contains(_dmf_f_textBox)) { Patient.ff_dmf = f; } if (ChangedControls.Contains(_dmf_d_textBox) || ChangedControls.Contains(_dmf_m_textBox) || ChangedControls.Contains(_dmf_f_textBox)) { Patient.C_dmf = _dmf; } if (ChangedControls.Contains(DEF_D_textBox)) { Patient.D_DEF = _D; } if (ChangedControls.Contains(DEF_E_textBox)) { Patient.E_DEF = E; } if (ChangedControls.Contains(DEF_F_textbox)) { Patient.F_DEF = _F; } if (ChangedControls.Contains(DEF_D_textBox) || ChangedControls.Contains(DEF_E_textBox) || ChangedControls.Contains(DEF_F_textbox)) { Patient.DEF = DEF; } #endregion //////////////////////////////////////////////////////////////// #region Diagnosis And Treatment Plans if (DiagnosisAndTPsIsChanged && DiagnosisAndTPsIsPressed) { int index = 0; var Query = from P in DataUpdater.Diagnoses.Where(P => P.Patient_ID == ID) select P; if (Updated_DiagnosisAndTPs_table.Count == EDiagnosisAndTPs_table.Count) { // Update foreach (var item in Query) { List<String> row = Updated_DiagnosisAndTPs_table[index]; item.Diagnose = row[0]; item.Treatment_Plan = row[1]; index++; } } // increase if (Updated_DiagnosisAndTPs_table.Count > EDiagnosisAndTPs_table.Count) { //update foreach (var item in Query) { List<String> row = Updated_DiagnosisAndTPs_table[index]; item.Diagnose = row[0]; item.Treatment_Plan = row[1]; index++; } // create var Dcount = (from o in DataUpdater.Diagnoses select o).Count(); int Dtemp = Dcount + 1; for (int i = index; i < Updated_DiagnosisAndTPs_table.Count; i++) { List<String> row = Updated_DiagnosisAndTPs_table[i]; var DiagnosisObject = new Diagnosis(); DiagnosisObject.Patient_ID = ID; DiagnosisObject.Diagnose_ID = Dtemp; DiagnosisObject.Diagnose = row[0]; DiagnosisObject.Treatment_Plan = row[1]; DataUpdater.Diagnoses.Add(DiagnosisObject); Dtemp++; } } // decrease if (Updated_DiagnosisAndTPs_table.Count < EDiagnosisAndTPs_table.Count) { // update foreach (var item in Query) { if (index < Updated_DiagnosisAndTPs_table.Count) { var checkItem = DataUpdater.Diagnoses.Create(); List<String> row = Updated_DiagnosisAndTPs_table[index]; checkItem.Diagnose = row[0]; checkItem.Treatment_Plan = row[2]; if (item.Diagnose == checkItem.Diagnose && item.Treatment_Plan == checkItem.Treatment_Plan) { index++; continue; } else { item.Diagnose = row[0]; item.Treatment_Plan = row[1]; } } else { // delete DataUpdater.Diagnoses.Remove(item); } index++; } } } #endregion //////////////////////////////////////////////////////////////// #region Dates And Procedures if (DatesAndProceduresIsChanged && DatesAndProceduresIsPressed) { int index = 0; var Query = from P in DataUpdater.Dates.Where(P => P.Patient_ID == ID) select P; if (Updated_DatesAndProc_table.Count == EDatesAndProc_table.Count) { foreach (var item in Query) { List<String> row = Updated_DatesAndProc_table[index]; item.Date1 = DateTime.Parse(row[0]); item.Doctor_name = row[1]; item.Procedures = row[2]; item.Procedure_Comment = row[3]; if (row[4].Length != 0) item.Medication = row[4]; item.Supervisor_signature = row[5]; index++; } } if (Updated_DatesAndProc_table.Count > EDatesAndProc_table.Count) { foreach (var item in Query) { List<String> row = Updated_DatesAndProc_table[index]; item.Date1 = DateTime.Parse(row[0]); item.Doctor_name = row[1]; item.Procedures = row[2]; item.Procedure_Comment = row[3]; if (row[4].Length != 0) item.Medication = row[4]; item.Supervisor_signature = row[5]; index++; } var Dcount = (from o in DataUpdater.Dates select o).Count(); int Dtemp = Dcount + 1; for (int i = index; i < Updated_DatesAndProc_table.Count; i++) { List<String> row = Updated_DatesAndProc_table[i]; var DatesObject = new Date(); DatesObject.Patient_ID = ID; DatesObject.Dates_ID = Dtemp; DatesObject.Date1 = Convert.ToDateTime(row[0]); DatesObject.Doctor_name = row[1]; DatesObject.Procedures = row[2]; DatesObject.Procedure_Comment = row[3]; if (row[4].Length != 0) DatesObject.Medication = row[4]; DatesObject.Supervisor_signature = row[5]; DataUpdater.Dates.Add(DatesObject); Dtemp++; } } if (Updated_DatesAndProc_table.Count < EDatesAndProc_table.Count) { // update foreach (var item in Query) { if (index < Updated_DatesAndProc_table.Count) { var checkItem = DataUpdater.Dates.Create(); List<String> row = Updated_DatesAndProc_table[index]; checkItem.Date1 = DateTime.Parse(row[0]); checkItem.Doctor_name = row[1]; checkItem.Procedures = row[2]; checkItem.Procedure_Comment = row[3]; if (row[4].Length != 0) checkItem.Medication = row[4]; checkItem.Supervisor_signature = row[5]; if (item.Date1 == checkItem.Date1 && item.Doctor_name == checkItem.Doctor_name && item.Procedures == checkItem.Procedures && item.Procedure_Comment == checkItem.Procedure_Comment && item.Medication == checkItem.Medication && item.Supervisor_signature == checkItem.Supervisor_signature) { index++; continue; } else { item.Date1 = DateTime.Parse(row[0]); item.Doctor_name = row[1]; item.Procedures = row[2]; item.Procedure_Comment = row[3]; if (row[4].Length != 0) item.Medication = row[4]; item.Supervisor_signature = row[5]; } } else { // delete DataUpdater.Dates.Remove(item); } index++; } } } #endregion try { DataUpdater.SaveChanges(); } catch (Exception ex) { Exception see = ex; MessageBox.Show("There was a problem while saving in the DBcontext\n" + ex.Message); return; } AddNewPatientSaveAndConfirmIsPressed = true; MessageBox.Show("The Patient was edited successfully"); EditedPatient = new Patient_Profile_Viewer(Int32.Parse(Patient_ID_textBox.Text)); this.Close(); EditedPatient.Show(); }
// Main Function private void AddnewPatient_saveAndConfirm_button_Click(object sender, EventArgs e) { int ID = 0, Age; String Name, Home_no = "", Mobile_no, Address, Cheif_comp, Medical_Alr, Comments, Sex, RelativeMarriage; DateTime VisitDate, BirthDate; byte[] PatientPhoto; var newPatient = new Patient_info(); // Re-validate if (!DataValidation()) return; try { ID = Int32.Parse(Patient_ID_textBox.Text); Age = Int32.Parse(Age_textBox.Text); Name = Patient_name_textBox.Text; Home_no = Homenum_textBox.Text; Mobile_no = Mobile_textBox.Text; Address = Address_textBox.Text; Cheif_comp = Chief_Complaint_textBox.Text; Medical_Alr = Medical_alert_textBox.Text; VisitDate = Convert.ToDateTime(Visit_date_textBox.Text); BirthDate = Convert.ToDateTime(DateOfBirth_textBox.Text); PatientPhoto = imageToByteArray(Patient_Picture); Comments = Comments_textbox.Text; Sex = Sex_Combobox.Text; RelativeMarriage = Realative_Marriage_comboBox.Text; // Main Panel /////////////////////////////// newPatient.Patient_ID = ID; newPatient.Patient_name = Name; newPatient.Visit_date = VisitDate; newPatient.Age = Age; newPatient.Home_number = Home_no; newPatient.Phone_number = Mobile_no; newPatient.Birth_date = BirthDate; newPatient.Patient_image = PatientPhoto; newPatient.Sex = Sex; newPatient.Relative_marriage = RelativeMarriage; newPatient.Address = Address; newPatient.Cheif_complaint = Cheif_comp; newPatient.Medical_alert = Medical_Alr; newPatient.D_DMF = D; newPatient.M_DMF = M; newPatient.F_DMF = F; newPatient.DMF = DMF; newPatient.dd_dmf = d; newPatient.mm_dmf = m; newPatient.ff_dmf = f; newPatient.C_dmf = _dmf; newPatient.D_DEF = _D; newPatient.E_DEF = E; newPatient.F_DEF = _F; newPatient.DEF = DEF; if (Comments.Length != 0) newPatient.Comments = Comments; /////////////////////////////////////////// // Diagnosis and Treatment Plans panel ////////////////////////////////////////// var Dcount = (from o in DataEntiry.Diagnoses select o).Count(); int Dtemp = Dcount + 1; foreach (List<String> row in DiagnosisAndTPs_table) { var DiagnosisObject = new Diagnosis(); DiagnosisObject.Diagnose_ID = Dtemp; DiagnosisObject.Diagnose = row[0]; DiagnosisObject.Treatment_Plan = row[1]; newPatient.Diagnoses.Add(DiagnosisObject); Dtemp++; } ///////////////////////////////////////// // Patinet's X-ray images //////////////////////////////////////// // Byte[] XrayImage; MemoryStream ms; int index = 0; var Xcount = (from o in DataEntiry.X_ray_images select o).Count(); int Xtemp = Xcount + 1; foreach (Bitmap img in Patient_Xray_images) { var XrayimageObject = new X_ray_images(); ms = new MemoryStream(); img.Save(ms, img.RawFormat); XrayimageObject.Xray_image = ms.ToArray(); XrayimageObject.Image_name = XrayImagesNames[index]; XrayimageObject.Xray_images_ID = Xtemp; newPatient.X_ray_images.Add(XrayimageObject); index++; Xtemp++; } ///////////////////////////////////////// // Dates And Procedures Panel //////////////////////////////////////// var DAcount = (from o in DataEntiry.Dates select o).Count(); int DAtemp = DAcount + 1; foreach (List<String> row in DatesAndProc_table) { var DatesObject = new Date(); DatesObject.Dates_ID = DAtemp; DatesObject.Date1 = Convert.ToDateTime(row[0]); DatesObject.Doctor_name = row[1]; DatesObject.Procedures = row[2]; DatesObject.Procedure_Comment = row[3]; if (row[4].Length != 0) DatesObject.Medication = row[4]; DatesObject.Supervisor_signature = row[5]; newPatient.Dates.Add(DatesObject); DAtemp++; } } catch (Exception) { MessageBox.Show("Please press Check Data Button before Saving"); return; } DataEntiry.Patient_info.Add(newPatient); try { DataEntiry.SaveChanges(); } catch (Exception ex) { Exception exeption = ex; MessageBox.Show("Something wrong with saving the changes in the DBcontext"); return; } // Check if exist string SqlCommand = "SELECT * FROM Patient_info WHERE Patient_ID = "+ID.ToString()+" AND Home_number = "+ Home_no.ToString()+" "; BSS.DataSource = Con.GetData(SqlCommand); Check = (DataTable)BSS.DataSource; if (Check.Rows.Count != 0 ) { MessageBox.Show("The patient was added successfully"); NewPatientWasAdded = true; Add_new_Patient Reset = new Add_new_Patient(); this.Close(); this.Dispose(); Reset.Show(); } else MessageBox.Show("Failed to add the patient file"); }
// Get patient data public void GetPatientData() { Patient = RetrievedContext.Patient_info.Where(ID => ID.Patient_ID == Patient_ID).FirstOrDefault(); }