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);
}
