static public TestEventsInfo BuildAdditionalFromDataBaseData(string idReferral) { TestEventsInfo p = new TestEventsInfo(); p.cancellation = TestCancellation.BuildCancellationFromDataBaseData(idReferral); p.source = TestEventSource.BuildSourceFromDataBaseData(idReferral); p.target = TestEventTarget.BuildTargetFromDataBaseData(idReferral); return(p); }
static public TestReferralInfo BuildPersonFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT comment, priority_comment, referral_paper_date, id_referral_type, id_profile_med_service, referral_reason FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY public.referral.id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { ReferralInfo p = new ReferralInfo(); while (personFromDataBase.Read()) { p.IdMq = idReferral; //что делать с mqReferralStatus? if (personFromDataBase["comment"] != DBNull.Value) { p.Comment = Convert.ToString(personFromDataBase["comment"]); } if (personFromDataBase["referral_paper_date"] != DBNull.Value) { p.Date = Convert.ToDateTime(personFromDataBase["referral_paper_date"]); } if (personFromDataBase["priority_comment"] != DBNull.Value) { p.Priority = Convert.ToString(personFromDataBase["priority_comment"]); } if (personFromDataBase["referral_reason"] != DBNull.Value) { p.Reason = Convert.ToString(personFromDataBase["referral_reason"]); } TestReferralInfo pers = new TestReferralInfo(p); pers.cancellation = TestCancellation.BuildCancellationFromDataBaseData(idReferral); if (personFromDataBase["id_referral_type"] != DBNull.Value) { pers.referralType = TestCoding.BuildCodingFromDataBaseData( Convert.ToString(personFromDataBase["id_referral_type"])); } if (personFromDataBase["id_profile_med_service"] != DBNull.Value) { pers.profileMedService = TestCoding.BuildCodingFromDataBaseData( Convert.ToString(personFromDataBase["id_profile_med_service"])); } using (NpgsqlConnection connection2 = Global.GetSqlConnection()) { string findIdMq = "SELECT id_mq_referral_status FROM public.referral, public.referral_status WHERE public.referral.id_referral = '" + idReferral + "' AND public.referral.id_referral = public.referral_status.id_referral ORDER BY public.referral_status.id_referral_status DESC LIMIT 1"; NpgsqlCommand com = new NpgsqlCommand(findIdMq, connection2); using (NpgsqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { if (reader["id_mq_referral_status"] != DBNull.Value) { pers.mqReferralStatus = TestCoding.BuildCodingFromDataBaseData( Convert.ToString(reader["id_mq_referral_status"])); } } } } return(pers); } } } return(null); }