public TestReferralTarget(ReferralTarget r) { if (r != null) { target = r; } else { target = new ReferralTarget(); } if ((target.Doctors != null) && (target.Doctors.Length != 0)) { docs = new List <TestDoctor>(); foreach (Doctor i in target.Doctors) { docs.Add(new TestDoctor(i)); } } if ((target.MainDiagnosis != null) && (target.MainDiagnosis.Length != 0)) { diag = new List <TestMainDiagnosis>(); foreach (MainDiagnosis i in target.MainDiagnosis) { diag.Add(new TestMainDiagnosis(i)); } } if (target.Lpu != null) { lpu = new TestCoding(target.Lpu); } }
internal void UpdateTestReferralTarget(ReferralTarget t) { if ((t.Doctors != null) && (t.Doctors.Length != 0)) { if (this.doctors == null) { docs = new List <TestDoctor>(); } foreach (Doctor i in t.Doctors) { docs.Add(new TestDoctor(i)); } } if ((t.MainDiagnosis != null) && (t.MainDiagnosis.Length != 0)) { if (this.mainDiagnosis == null) { diag = new List <TestMainDiagnosis>(); } foreach (MainDiagnosis i in t.MainDiagnosis) { diag.Add(new TestMainDiagnosis(i)); } } if (t.Lpu != null) { lpu = new TestCoding(t.Lpu); } }
static public TestReferralTarget BuildTargetFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_target_lpu, is_referral_review_target_mo, referral_review_date_target_mo, reception_appoint_date, reception_appoint_time_comment, reception_appoint_additional_comment, id_target_lpu_case_mis FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY record_created DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { ReferralTarget p = new ReferralTarget(); while (personFromDataBase.Read()) { //зачем тут диагнозы и доктора и ReferralReviewDate и IsReferralReviewed? if (personFromDataBase["id_target_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_target_lpu_case_mis"]); } if (personFromDataBase["is_referral_review_target_mo"] != DBNull.Value) { p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_target_mo"]); } if (personFromDataBase["reception_appoint_additional_comment"] != DBNull.Value) { p.ReceptionAppointComment = Convert.ToString(personFromDataBase["reception_appoint_additional_comment"]); } if (personFromDataBase["reception_appoint_time_comment"] != DBNull.Value) { p.ReceptionAppointTime = Convert.ToString(personFromDataBase["reception_appoint_time_comment"]); } if (personFromDataBase["reception_appoint_date"] != DBNull.Value) { p.ReceptionAppointDate = Convert.ToDateTime(personFromDataBase["reception_appoint_date"]); } if (personFromDataBase["referral_review_date_target_mo"] != DBNull.Value) { p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_target_mo"]); } TestReferralTarget pers = new TestReferralTarget(p); pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_target_lpu"])); pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_target_lpu"])); pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_target_lpu"])); return(pers); } } } return(null); }
static public TestReferralTarget BuildTargetFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_target_lpu_case_mis, is_referral_review_target_mo, reception_appoint_additional_comment, reception_appoint_time_comment, referral_review_date_target_mo, id_target_lpu, reception_appoint_date FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { ReferralTarget p = new ReferralTarget(); while (personFromDataBase.Read()) { //что делать с DateSpecified и Мисами? if (personFromDataBase["id_target_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_lpu_case_mis"]); } if (personFromDataBase["is_referral_review_target_mo"] != DBNull.Value) { p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_target_mo"]); } if (personFromDataBase["reception_appoint_additional_comment"] != DBNull.Value) { p.ReceptionAppointComment = Convert.ToString(personFromDataBase["reception_appoint_additional_comment"]); } if (personFromDataBase["reception_appoint_time_comment"] != DBNull.Value) { p.ReceptionAppointTime = Convert.ToString(personFromDataBase["reception_appoint_time_comment"]); } if (personFromDataBase["reception_appoint_date"] != DBNull.Value) { p.ReceptionAppointDate = Convert.ToDateTime(personFromDataBase["reception_appoint_date"]); } if (personFromDataBase["referral_review_date_target_mo"] != DBNull.Value) { p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_target_mo"]); } TestReferralTarget pers = new TestReferralTarget(p); if (personFromDataBase["id_target_lpu"] != DBNull.Value) { pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_target_lpu"])); } return(pers); } } } return(null); }
public TestReferralTarget(ReferralTarget r) { target = r ?? new ReferralTarget(); if (r?.Doctors != null) { foreach (Doctor i in r.Doctors) { docs.Add(new TestDoctor(i)); } } if (r?.MainDiagnosis != null) { foreach (MainDiagnosis i in r.MainDiagnosis) { diag.Add(new TestMainDiagnosis(i)); } } lpu = new TestCoding(r?.Lpu); }