public override bool Equals(Object obj) { TestReferralSource p = obj as TestReferralSource; if ((object)p == null) { return(false); } if (this.sourse == p.sourse) { return(true); } if ((this.sourse == null) || (p.sourse == null)) { return(false); } if ((this.sourse.IdCaseMis == p.sourse.IdCaseMis) && (this.sourse.IdReferralMis == p.sourse.IdReferralMis) && (Global.Equals(this.documents, p.documents)) && (Global.Equals(this.mainDiagnosis, p.mainDiagnosis)) && (Global.Equals(this.lpu, p.lpu))) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestReferralSource"); return(false); } }
static public TestReferralSource BuildSourceFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_source_lpu_case_mis, id_referral_source_mo_mis, id_source_lpu 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()) { ReferralSource p = new ReferralSource(); while (personFromDataBase.Read()) { //referral_creation_date должен быть тут в Date! if (personFromDataBase["id_source_lpu_case_mis"] != DBNull.Value) { p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_lpu_case_mis"]); } if (personFromDataBase["id_referral_source_mo_mis"] != DBNull.Value) { p.IdReferralMis = Convert.ToString(personFromDataBase["id_referral_source_mo_mis"]); } TestReferralSource pers = new TestReferralSource(p); if (personFromDataBase["id_source_lpu"] != DBNull.Value) { pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_source_lpu"])); } return(pers); } } } return(new TestReferralSource(null)); }
static public TestReferral BuildReferralFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findR = "SELECT * FROM public.referral WHERE id_referral = '" + idReferral + "'"; // string findR = "select id_patient_person from public.referral"; NpgsqlCommand Rcommand = new NpgsqlCommand(findR, connection); using (NpgsqlDataReader RReader = Rcommand.ExecuteReader()) { while (RReader.Read()) { TestReferral r = new TestReferral(); r.evInfo = TestEventsInfo.BuildAdditionalFromDataBaseData(idReferral); if (RReader["id_patient_person"] != DBNull.Value) { r.patient = TestPatient.BuildPatientFromDataBaseData(RReader["id_patient_person"].ToString(), RReader["id_patient_source_mo_mis"].ToString()); } r.refInfo = TestReferralInfo.BuildPersonFromDataBaseData(idReferral); r.refSourse = TestReferralSource.BuildSourceFromDataBaseData(idReferral); r.refSurvey = TestReferralSurvey.BuildAdditionalFromDataBaseData(idReferral); r.refTarget = TestReferralTarget.BuildTargetFromDataBaseData(idReferral); return(r); } } } return(null); }
public TestReferral(Referral r, string idLpu = "") { evInfo = new TestEventsInfo(r.EventsInfo); patient = new TestPatient(r.Patient); refInfo = new TestReferralInfo(r.ReferralInfo); refSurvey = new TestReferralSurvey(r.ReferralSurvey); refSourse = new TestReferralSource(r.Source); refTarget = new TestReferralTarget(r.Target); }
private void FindMismatch(TestReferralSource r) { if (this.sourse.IdCaseMis != r.sourse.IdCaseMis) { Global.errors3.Add("Несовпадение IdCaseMis TestReferralSource"); } if (this.sourse.IdReferralMis != r.sourse.IdReferralMis) { Global.errors3.Add("Несовпадение IdReferralMis TestReferralSource"); } if (Global.GetLength(this.documents) != Global.GetLength(r.documents)) { Global.errors3.Add("Несовпадение длинны documents TestReferralSource"); } if (Global.GetLength(this.mainDiagnosis) != Global.GetLength(r.mainDiagnosis)) { Global.errors3.Add("Несовпадение длинны mainDiagnosis TestReferralSource"); } if (Global.GetLength(this.lpu) != Global.GetLength(r.lpu)) { Global.errors3.Add("Несовпадение длинны lpu TestReferralSource"); } }
public static TestReferralSource BuildSourceFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_source_lpu_case_mis, id_referral_source_mo_mis, id_source_lpu 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()) { ReferralSource p = new ReferralSource(); while (personFromDataBase.Read()) { if (personFromDataBase["id_source_lpu_case_mis"] != DBNull.Value) p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_lpu_case_mis"]); if (personFromDataBase["id_referral_source_mo_mis"] != DBNull.Value) p.IdReferralMis = Convert.ToString(personFromDataBase["id_referral_source_mo_mis"]); TestReferralSource pers = new TestReferralSource(p); pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_source_lpu"])); pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"])); pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"])); return pers; } } } return new TestReferralSource(null); }
private void FindMismatch(TestReferralSource r) { if (this.sourse.IdCaseMis != r.sourse.IdCaseMis) Global.errors3.Add("Несовпадение IdCaseMis TestReferralSource"); if (this.sourse.IdReferralMis != r.sourse.IdReferralMis) Global.errors3.Add("Несовпадение IdReferralMis TestReferralSource"); if (Global.GetLength(this.doctors) != Global.GetLength(r.doctors)) Global.errors3.Add("Несовпадение длинны doctors TestReferralSource"); if (Global.GetLength(this.mainDiagnosis) != Global.GetLength(r.mainDiagnosis)) Global.errors3.Add("Несовпадение длинны mainDiagnosis TestReferralSource"); if (Global.GetLength(this.lpu) != Global.GetLength(r.lpu)) Global.errors3.Add("Несовпадение длинны lpu TestReferralSource"); }