public override bool Equals(Object obj) { TestDoctor p = obj as TestDoctor; if ((object)p == null) { return(false); } if (this.doctor == p.doctor) { return(true); } if ((this.doctor == null) || (p.doctor == null)) { return(false); } if ((Global.IsEqual(this.contacts, this.contacts)) && (Global.IsEqual(this.lpu, this.lpu)) && (Global.IsEqual(this.person, this.person)) && (Global.IsEqual(this.position, this.position)) && (Global.IsEqual(this.role, this.role)) && (Global.IsEqual(this.speciality, this.speciality))) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestDoctor"); return(false); } }
private void FindMismatch(TestDoctor r) { if (Global.GetLength(this.contacts) != Global.GetLength(this.contacts)) { Global.errors3.Add("Несовпадение длины contacts TestDoctor"); } if (Global.GetLength(this.lpu) != Global.GetLength(this.lpu)) { Global.errors3.Add("Несовпадение длины lpu TestDoctor"); } if (Global.GetLength(this.person) != Global.GetLength(this.person)) { Global.errors3.Add("Несовпадение длины person TestDoctor"); } if (Global.GetLength(this.position) != Global.GetLength(this.position)) { Global.errors3.Add("Несовпадение длины position TestDoctor"); } if (Global.GetLength(this.role) != Global.GetLength(this.role)) { Global.errors3.Add("Несовпадение длины role TestDoctor"); } if (Global.GetLength(this.speciality) != Global.GetLength(this.speciality)) { Global.errors3.Add("Несовпадение длины speciality TestDoctor"); } }
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()) { 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)); }
static public List <TestDoctor> BuildDoctorFromDataBaseData(string idReferral) { List <TestDoctor> docs = new List <TestDoctor>(); using (NpgsqlConnection c = Global.GetSqlConnection()) { string findDoctorsIds = "SELECT * FROM public.referral_doctor WHERE id_referral = '" + idReferral + "'"; NpgsqlCommand fd = new NpgsqlCommand(findDoctorsIds, c); using (NpgsqlDataReader idr = fd.ExecuteReader()) { if (idr["id_doctor"] != DBNull.Value) { string idDoctor = idr["id_doctor"].ToString(); using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findDoctor = "SELECT * FROM public.doctor WHERE id_doctor = '" + idDoctor + "' ORDER BY id_doctor DESC LIMIT 1"; NpgsqlCommand doc = new NpgsqlCommand(findDoctor, connection); using (NpgsqlDataReader doctorFromDataBase = doc.ExecuteReader()) { Doctor p = new Doctor(); while (doctorFromDataBase.Read()) { TestDoctor doctor = new TestDoctor(p); if (doctorFromDataBase["id_doctor_role"] != DBNull.Value) { doctor.role = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_role"])); } if (doctorFromDataBase["id_doctor_speciality"] != DBNull.Value) { doctor.speciality = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_speciality"])); } if (doctorFromDataBase["id_lpu"] != DBNull.Value) { doctor.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_lpu"])); } if (doctorFromDataBase["id_position"] != DBNull.Value) { doctor.position = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_position"])); } if (doctorFromDataBase["id_person"] != DBNull.Value) { doctor.person = TestPerson.BuildPersonFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]), Convert.ToString(doctorFromDataBase["id_doctor_mis"])); } if (doctorFromDataBase["id_person"] != DBNull.Value) { doctor.cnts = TestContact.BuildContactsFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"])); } docs.Add(doctor); } } } } } } return((docs.Count != 0) ? docs : null); }
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); }
public static List<TestDoctor> BuildDoctorFromDataBaseData(string idReferral) { List<TestDoctor> docs = new List<TestDoctor>(); using (NpgsqlConnection c = Global.GetSqlConnection()) { string findDoctorsIds = "SELECT * FROM public.referral_doctor WHERE id_referral = '" + idReferral + "'"; NpgsqlCommand fd = new NpgsqlCommand(findDoctorsIds, c); using (NpgsqlDataReader idr = fd.ExecuteReader()) { if (idr["id_doctor"] != DBNull.Value) { string idDoctor = idr["id_doctor"].ToString(); using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findDoctor = "SELECT * FROM public.doctor WHERE id_doctor = '" + idDoctor + "' ORDER BY id_doctor DESC LIMIT 1"; NpgsqlCommand doc = new NpgsqlCommand(findDoctor, connection); using (NpgsqlDataReader doctorFromDataBase = doc.ExecuteReader()) { Doctor p = new Doctor(); while (doctorFromDataBase.Read()) { TestDoctor doctor = new TestDoctor(p); if (doctorFromDataBase["id_doctor_role"] != DBNull.Value) doctor.role = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_role"])); if (doctorFromDataBase["id_doctor_speciality"] != DBNull.Value) doctor.speciality = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_speciality"])); if (doctorFromDataBase["id_lpu"] != DBNull.Value) doctor.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_lpu"])); if (doctorFromDataBase["id_position"] != DBNull.Value) doctor.position = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_position"])); if (doctorFromDataBase["id_person"] != DBNull.Value) doctor.person = TestPerson.BuildPersonFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]), Convert.ToString(doctorFromDataBase["id_doctor_mis"])); if (doctorFromDataBase["id_person"] != DBNull.Value) doctor.cnts = TestContact.BuildContactsFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"])); docs.Add(doctor); } } } } } } return (docs.Count != 0) ? docs : null; }
private void FindMismatch(TestDoctor r) { if (Global.GetLength(this.contacts) != Global.GetLength(this.contacts)) Global.errors3.Add("Несовпадение длины contacts TestDoctor"); if (Global.GetLength(this.lpu) != Global.GetLength(this.lpu)) Global.errors3.Add("Несовпадение длины lpu TestDoctor"); if (Global.GetLength(this.person) != Global.GetLength(this.person)) Global.errors3.Add("Несовпадение длины person TestDoctor"); if (Global.GetLength(this.position) != Global.GetLength(this.position)) Global.errors3.Add("Несовпадение длины position TestDoctor"); if (Global.GetLength(this.role) != Global.GetLength(this.role)) Global.errors3.Add("Несовпадение длины role TestDoctor"); if (Global.GetLength(this.speciality) != Global.GetLength(this.speciality)) Global.errors3.Add("Несовпадение длины speciality TestDoctor"); }