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