internal void UpdateTestPerson(Person p)
{
if (p.BirthDate != null)
{
this.person.BirthDate = p.BirthDate;
}
if (p.IdPatientMis != null)
{
this.person.IdPatientMis = p.IdPatientMis;
}
if (p.HumanName != null)
{
if (p.HumanName.FamilyName != null)
{
this.person.HumanName.FamilyName = p.HumanName.FamilyName;
}
if (p.HumanName.GivenName != null)
{
this.person.HumanName.GivenName = p.HumanName.GivenName;
}
if (p.HumanName.MiddleName != null)
{
this.person.HumanName.MiddleName = p.HumanName.MiddleName;
}
}
if (p.Sex != null)
{
this.sex = new TestCoding(p.Sex);
}
}
static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
//опять DiagnosedDateSpecified, что с этим делать?
//ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType?
string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')";
NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
{
while (diagnosisReader.Read())
{
DiagnosisInfo diag = new DiagnosisInfo();
if (diagnosisReader["comment"] != DBNull.Value)
{
diag.Comment = Convert.ToString(diagnosisReader["comment"]);
}
if (diagnosisReader["diagnosis_date"] != DBNull.Value)
{
diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
}
TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
if (diagnosisReader["id_mkb_code"] != DBNull.Value)
{
tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"]));
}
return(tDiag);
}
}
}
return(null);
}
static public List <TestPrivilege> BuildPrivilegeFromDataBaseData(string idPerson)
{
List <TestPrivilege> priveleges = new List <TestPrivilege>();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPriviledge = "SELECT * FROM public.priviledge WHERE id_person = '" + idPerson + "'";
NpgsqlCommand person = new NpgsqlCommand(findPriviledge, connection);
using (NpgsqlDataReader contactReader = person.ExecuteReader())
{
while (contactReader.Read())
{
//что делать с DateSpecified?
Privilege priv = new Privilege();
if (contactReader["date_start"] != DBNull.Value)
{
priv.StartDate = Convert.ToDateTime(contactReader["date_start"]);
}
if (contactReader["date_end"] != DBNull.Value)
{
priv.EndDate = Convert.ToDateTime(contactReader["date_end"]);
}
TestPrivilege privilege = new TestPrivilege(priv);
if (contactReader["id_priviledge_code"] != DBNull.Value)
{
privilege.privilegeType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(contactReader["id_priviledge_code"]));
}
priveleges.Add(privilege);
}
}
}
return((priveleges.Count != 0) ? priveleges : null);
}
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);
}
}
public TestReferralSurvey(Survey r)
{
survey = r ?? new Survey();
additional = new TestAdditional(survey.Additional);
surveyOrgan = new TestCoding(survey.SurveyOrgan);
surveyType = new TestCoding(survey.SurveyType);
}
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);
}
}
public TestEventTarget(EventTarget r)
{
if (r != null)
{
target = r;
}
else
{
target = new EventTarget();
}
if (target.CaseAidForm != null)
{
caseAidForm = new TestCoding(target.CaseAidForm);
}
if (target.CaseAidPlace != null)
{
caseAidPlace = new TestCoding(target.CaseAidPlace);
}
if (target.CaseAidType != null)
{
caseAidType = new TestCoding(target.CaseAidType);
}
if (target.Lpu != null)
{
lpu = new TestCoding(target.Lpu);
}
}
public TestDocument(DocumentDto d)
{
document = d;
documentType = new TestCoding(document.DocumentType);
provider = new TestCoding(document.Provider);
regionCode = new TestCoding(document.RegionCode);
}
static public List <TestContact> BuildContactsFromDataBaseData(string idPerson)
{
List <TestContact> contacts = new List <TestContact>();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT * FROM public.Contact WHERE id_person = '" + idPerson + "'";
NpgsqlCommand person = new NpgsqlCommand(findPatient, connection);
using (NpgsqlDataReader contactReader = person.ExecuteReader())
{
while (contactReader.Read())
{
ContactDto cont = new ContactDto();
if (contactReader["contact_value"] != DBNull.Value)
{
cont.ContactValue = Convert.ToString(contactReader["contact_value"]);
}
TestContact contact = new TestContact(cont);
if (contactReader["id_contact_type"] != DBNull.Value)
{
contact.contactType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(contactReader["id_contact_type"]));
}
contacts.Add(contact);
}
}
}
return((contacts.Count != 0) ? contacts : null);
}
public TestDocument(DocumentDto d)
{
document = d;
documentType = new TestCoding(document.DocumentType);
provider = new TestCoding(document.Provider);
regionCode = new TestCoding(document.RegionCode);
}
static public TestReferralSurvey BuildAdditionalFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT id_survey_organ, survey_comment, id_referral, id_survey_type 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())
{
Survey p = new Survey();
while (personFromDataBase.Read())
{
//что делать с DateSpecified и Мисами?
if (personFromDataBase["survey_comment"] != DBNull.Value)
{
p.Comment = Convert.ToString(personFromDataBase["survey_comment"]);
}
TestReferralSurvey pers = new TestReferralSurvey(p);
if (personFromDataBase["id_referral"] != DBNull.Value)
{
pers.additional = TestAdditional.BuildAdditionalFromDataBaseData(Convert.ToString(personFromDataBase["id_referral"]));
}
if (personFromDataBase["id_survey_organ"] != DBNull.Value)
{
pers.surveyOrgan = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_organ"]));
}
if (personFromDataBase["id_survey_type"] != DBNull.Value)
{
pers.surveyType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_type"]));
}
return(pers);
}
}
}
return(null);
}
public TestDoctor(Doctor r)
{
doctor = r;
if ((doctor.ContactDtos != null) && (doctor.ContactDtos.Length != 0))
{
cnts = new List <TestContact>();
foreach (ContactDto i in doctor.ContactDtos)
{
cnts.Add(new TestContact(i));
}
}
if (doctor.Lpu != null)
{
lpu = new TestCoding(doctor.Lpu);
}
if (doctor.Person != null)
{
person = new TestPerson(doctor.Person);
}
if (doctor.Position != null)
{
position = new TestCoding(doctor.Position);
}
if (doctor.Role != null)
{
role = new TestCoding(doctor.Role);
}
if (doctor.Speciality != null)
{
speciality = new TestCoding(doctor.Speciality);
}
}
static public List <TestAddress> BuildAdressesFromDataBaseData(string idPerson)
{
List <TestAddress> addresses = new List <TestAddress>();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findIdAdresses = "SELECT * FROM public.address WHERE id_person = '" + idPerson + "'";
NpgsqlCommand IdAddresses = new NpgsqlCommand(findIdAdresses, connection);
using (NpgsqlDataReader addressesReader = IdAddresses.ExecuteReader())
{
while (addressesReader.Read())
{
AddressDto address = new AddressDto();
if (addressesReader["address"] != DBNull.Value)
{
address.StringAddress = Convert.ToString(addressesReader["address"]);
}
TestAddress a = new TestAddress(address);
if (addressesReader["id_address_type"] != DBNull.Value)
{
a.addressType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(addressesReader["id_address_type"]));
}
addresses.Add(a);
}
}
}
return((addresses.Count != 0) ? addresses : null);
}
//как искать?
static public TestCancellation BuildCancellationFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT cancellation_date, cancellation_reason_comment, id_cancellation_code, id_cancellation_reason 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())
{
CancellationData p = new CancellationData();
while (personFromDataBase.Read())
{
if (personFromDataBase["cancellation_date"] != DBNull.Value)
{
p.Date = Convert.ToDateTime(personFromDataBase["cancellation_date"]);
}
if (personFromDataBase["cancellation_reason_comment"] != DBNull.Value)
{
p.ReasonComment = Convert.ToString(personFromDataBase["cancellation_reason_comment"]);
}
TestCancellation pers = new TestCancellation(p);
if (personFromDataBase["id_cancellation_code"] != DBNull.Value)
{
pers.source = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_cancellation_code"]));
}
if (personFromDataBase["id_cancellation_reason"] != DBNull.Value)
{
pers.source = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_cancellation_reason"]));
}
return(pers);
}
}
}
return(null);
}
public override bool Equals(Object obj)
{
TestCoding p = obj as TestCoding;
if ((object)p == null)
{
return(false);
}
if (this.coding == p.coding)
{
return(true);
}
if ((this.coding == null) || (p.coding == null))
{
return(false);
}
if ((this.coding.Code == p.coding.Code) &&
(this.coding.System == p.coding.System) &&
(this.coding.Version == p.coding.Version))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestCoding");
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));
}
public TestReferralSource(ReferralSource r)
{
if (r != null)
{
sourse = r;
}
else
{
sourse = new ReferralSource();
}
if ((sourse.Doctors != null) && (sourse.Doctors.Length != 0))
{
docs = new List <TestDoctor>();
foreach (Doctor i in sourse.Doctors)
{
docs.Add(new TestDoctor(i));
}
}
if ((sourse.MainDiagnosis != null) && (sourse.MainDiagnosis.Length != 0))
{
diag = new List <TestMainDiagnosis>();
foreach (MainDiagnosis i in sourse.MainDiagnosis)
{
diag.Add(new TestMainDiagnosis(i));
}
}
if (sourse.Lpu != null)
{
lpu = new TestCoding(sourse.Lpu);
}
}
public TestPrivilege(Privilege p)
{
privilege = p;
if (privilege.PrivilegeType != null)
{
privilegeType = new TestCoding(privilege.PrivilegeType);
}
}
public TestContact(ContactDto c)
{
contact = c;
if (contact.ContactType != null)
{
contactType = new TestCoding(contact.ContactType);
}
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
if (diagnosisInfo.DiagnosisType != null)
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
if (diagnosisInfo.MkbCode != null)
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
public TestEventTarget(EventTarget r)
{
target = r ?? new EventTarget();
caseAidForm = new TestCoding(target.CaseAidForm);
caseAidPlace = new TestCoding(target.CaseAidPlace);
caseAidType = new TestCoding(target.CaseAidType);
lpu = new TestCoding(target.Lpu);
}
public TestPerson(Person p)
{
person = p;
if (person.Sex != null)
{
sex = new TestCoding(person.Sex);
}
}
public TestEventTarget(EventTarget r)
{
target = r ?? new EventTarget();
caseAidForm = new TestCoding(target.CaseAidForm);
caseAidPlace = new TestCoding(target.CaseAidPlace);
caseAidType = new TestCoding(target.CaseAidType);
lpu = new TestCoding(target.Lpu);
}
public TestAddress(AddressDto a)
{
if (a == null)
{
return;
}
address = a;
addressType = new TestCoding(address.AddressType);
}
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);
}
public TestDocument(DocumentDto d)
{
document = d;
if (document.DocumentType != null)
documentType = new TestCoding(document.DocumentType);
if (document.Provider != null)
provider = new TestCoding(document.Provider);
if (document.RegionCode != null)
regionCode = new TestCoding(document.RegionCode);
}
public TestReferralSource(ReferralSource r)
{
sourse = r ?? new ReferralSource();
if (sourse.Doctors != null)
foreach (Doctor i in sourse.Doctors)
docs.Add(new TestDoctor(i));
if (sourse.MainDiagnosis != null)
foreach (MainDiagnosis i in sourse.MainDiagnosis)
diag.Add(new TestMainDiagnosis(i));
lpu = new TestCoding(sourse.Lpu);
}
public TestCancellation(CancellationData r)
{
if (r != null)
cancellation = r;
else
cancellation = new CancellationData();
if (cancellation.CancellationSource != null)
source = new TestCoding(cancellation.CancellationSource);
if (cancellation.CancellationReason != null)
reason = new TestCoding(cancellation.CancellationReason);
}
public TestReferralInfo(ReferralInfo r)
{
info = r ?? new ReferralInfo();
cancellation = new TestCancellation(info.Cancellation);
if (info.MqReferralStatus != null)
mqReferralStatus = new TestCoding(info.MqReferralStatus);
if (info.ProfileMedService != null)
profileMedService = new TestCoding(info.ProfileMedService);
if (info.ReferralType != null)
referralType = new TestCoding(info.ReferralType);
}
public TestReferralSurvey(Survey r)
{
if (r != null)
survey = r;
else
survey = new Survey();
additional = new TestAdditional(survey.Additional);
if (survey.SurveyOrgan != null)
surveyOrgan = new TestCoding(survey.SurveyOrgan);
if (survey.SurveyType != null)
surveyType = new TestCoding(survey.SurveyType);
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
if (diagnosisInfo.DiagnosisType != null)
{
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
}
if (diagnosisInfo.MkbCode != null)
{
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
}
public TestDoctor(Doctor r)
{
doctor = r;
if (doctor.ContactDtos != null)
foreach (ContactDto i in doctor.ContactDtos)
cnts.Add(new TestContact(i));
lpu = new TestCoding(doctor.Lpu);
person = new TestPerson(doctor.Person);
position = new TestCoding(doctor.Position);
role = new TestCoding(doctor.Role);
speciality = new TestCoding(doctor.Speciality);
}
static public List <TestDocument> BuildDocumentsFromDataBaseData(string idPerson)
{
List <TestDocument> documents = new List <TestDocument>();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findDocument = "SELECT * FROM public.documents WHERE id_person = '" + idPerson + "'";
NpgsqlCommand person = new NpgsqlCommand(findDocument, connection);
using (NpgsqlDataReader documentReader = person.ExecuteReader())
{
while (documentReader.Read())
{
//Что делать с DateSpecified?
DocumentDto doc = new DocumentDto();
if (documentReader["docn"] != DBNull.Value)
{
doc.DocN = Convert.ToString(documentReader["docn"]);
}
if (documentReader["docs"] != DBNull.Value)
{
doc.DocS = Convert.ToString(documentReader["docs"]);
}
if (documentReader["expired_date"] != DBNull.Value)
{
doc.ExpiredDate = Convert.ToDateTime(documentReader["expired_date"]);
}
if (documentReader["issued_date"] != DBNull.Value)
{
doc.IssuedDate = Convert.ToDateTime(documentReader["issued_date"]);
}
if (documentReader["provider_name"] != DBNull.Value)
{
doc.ProviderName = Convert.ToString(documentReader["provider_name"]);
}
TestDocument document = new TestDocument(doc);
if (documentReader["id_document_type"] != DBNull.Value)
{
document.documentType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(documentReader["id_document_type"]));
}
if (documentReader["id_provider"] != DBNull.Value)
{
document.provider = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(documentReader["id_provider"]));
}
if (documentReader["id_region_code"] != DBNull.Value)
{
document.regionCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(documentReader["id_region_code"]));
}
documents.Add(document);
}
}
}
return((documents.Count != 0) ? documents : null);
}
public void UpdateTestEventTarget(EventTarget e)
{
if (e.CaseCloseDate != null)
{
this.target.CaseCloseDate = e.CaseCloseDate;
}
if (e.CaseOpenDate != null)
{
this.target.CaseOpenDate = e.CaseOpenDate;
}
if (e.IsReferralReviwed != null)
{
this.target.IsReferralReviwed = e.IsReferralReviwed;
}
if (e.ReceptionAppointComment != null)
{
this.target.ReceptionAppointComment = e.ReceptionAppointComment;
}
if (e.ReceptionAppointDate != null)
{
this.target.ReceptionAppointDate = e.ReceptionAppointDate;
}
if (e.ReceptionAppointTime != null)
{
this.target.ReceptionAppointTime = e.ReceptionAppointTime;
}
if (e.ReferralReviewDate != null)
{
this.target.ReferralReviewDate = e.ReferralReviewDate;
}
if (e.RefferalCreatedDate != null)
{
this.target.RefferalCreatedDate = e.RefferalCreatedDate;
}
if (e.CaseAidForm != null)
{
this.caseAidForm = new TestCoding(e.CaseAidForm);
}
if (e.CaseAidPlace != null)
{
this.caseAidPlace = new TestCoding(e.CaseAidPlace);
}
if (e.CaseAidType != null)
{
this.caseAidType = new TestCoding(e.CaseAidType);
}
if (e.Lpu != null)
{
this.lpu = new TestCoding(e.Lpu);
}
}
public TestEventTarget(EventTarget r)
{
if (r != null)
target = r;
else
target = new EventTarget();
if (target.CaseAidForm != null)
caseAidForm = new TestCoding(target.CaseAidForm);
if (target.CaseAidPlace != null)
caseAidPlace = new TestCoding(target.CaseAidPlace);
if (target.CaseAidType != null)
caseAidType = new TestCoding(target.CaseAidType);
if (target.Lpu != null)
lpu = new TestCoding(target.Lpu);
}
private void FindMismatch(TestCoding r)
{
if (this.Code != r.Code)
{
Global.errors3.Add("Несовпадение Code TestCoding");
}
if (this.System != r.System)
{
Global.errors3.Add("Несовпадение System TestCoding");
}
if (this.Version != r.Version)
{
Global.errors3.Add("Несовпадение Version TestCoding");
}
}
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 TestDoctor(Doctor r)
{
doctor = r;
if (doctor.ContactDtos != null)
{
foreach (ContactDto i in doctor.ContactDtos)
{
cnts.Add(new TestContact(i));
}
}
lpu = new TestCoding(doctor.Lpu);
person = new TestPerson(doctor.Person);
position = new TestCoding(doctor.Position);
role = new TestCoding(doctor.Role);
speciality = new TestCoding(doctor.Speciality);
}
public TestDocument(DocumentDto d)
{
document = d;
if (document.DocumentType != null)
{
documentType = new TestCoding(document.DocumentType);
}
if (document.Provider != null)
{
provider = new TestCoding(document.Provider);
}
if (document.RegionCode != null)
{
regionCode = new TestCoding(document.RegionCode);
}
}
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 TestDoctor(Doctor r)
{
doctor = r;
if ((doctor.ContactDtos != null) && (doctor.ContactDtos.Length != 0))
{
cnts = new List<TestContact>();
foreach (ContactDto i in doctor.ContactDtos)
cnts.Add(new TestContact(i));
}
if (doctor.Lpu != null)
lpu = new TestCoding(doctor.Lpu);
if (doctor.Person != null)
person = new TestPerson(doctor.Person);
if (doctor.Position != null)
position = new TestCoding(doctor.Position);
if (doctor.Role != null)
role = new TestCoding(doctor.Role);
if (doctor.Speciality != null)
speciality = new TestCoding(doctor.Speciality);
}
public TestReferralSource(ReferralSource r)
{
if (r != null)
sourse = r;
else
sourse = new ReferralSource();
if ((sourse.Doctors != null) && (sourse.Doctors.Length != 0))
{
docs = new List<TestDoctor>();
foreach (Doctor i in sourse.Doctors)
docs.Add(new TestDoctor(i));
}
if ((sourse.MainDiagnosis != null) && (sourse.MainDiagnosis.Length != 0))
{
diag = new List<TestMainDiagnosis>();
foreach (MainDiagnosis i in sourse.MainDiagnosis)
diag.Add(new TestMainDiagnosis(i));
}
if (sourse.Lpu != null)
lpu = new TestCoding(sourse.Lpu);
}
public TestPrivilege(Privilege p)
{
privilege = p;
privilegeType = new TestCoding(privilege.PrivilegeType);
}
internal void UpdateTestReferralSurvey(Survey r)
{
if (r.Comment != null)
this.survey.Comment = r.Comment;
if (r.Additional != null)
this.additional.UpdateTestAdditional(r.Additional);
if (r.SurveyOrgan != null)
this.surveyOrgan = new TestCoding(r.SurveyOrgan);
if (r.SurveyType != null)
this.surveyType = new TestCoding(r.SurveyType);
}
public TestPerson(Person p)
{
person = p;
if (person.Sex != null)
sex = new TestCoding(person.Sex);
}
public void UpdateTestReferralInfo(ReferralInfo r)
{
if (r != null)
{
if (r.Comment != null)
this.info.Comment = r.Comment;
if (r.Date != null)
this.info.Date = r.Date;
if (r.IdMq != null)
this.info.IdMq = r.IdMq;
if (r.Priority != null)
this.info.Priority = r.Priority;
if (r.Reason != null)
this.info.Reason = r.Reason;
if (r.Cancellation != null)
this.cancellation = new TestCancellation(r.Cancellation);
if (r.MqReferralStatus != null)
this.mqReferralStatus = new TestCoding(r.MqReferralStatus);
if (r.ProfileMedService != null)
this.mqReferralStatus = new TestCoding(r.ProfileMedService);
if (r.ReferralType != null)
this.referralType = new TestCoding(r.ReferralType);
}
}
public TestCancellation(CancellationData r)
{
cancellation = r ?? new CancellationData();
source = new TestCoding(cancellation.CancellationSource);
reason = new TestCoding(cancellation.CancellationReason);
}
public void UpdateTestEventTarget(EventTarget e)
{
if (e.CaseCloseDate != null)
this.target.CaseCloseDate = e.CaseCloseDate;
if (e.CaseOpenDate != null)
this.target.CaseOpenDate = e.CaseOpenDate;
if (e.IsReferralReviwed != null)
this.target.IsReferralReviwed = e.IsReferralReviwed;
if (e.ReceptionAppointComment != null)
this.target.ReceptionAppointComment = e.ReceptionAppointComment;
if (e.ReceptionAppointDate != null)
this.target.ReceptionAppointDate = e.ReceptionAppointDate;
if (e.ReceptionAppointTime != null)
this.target.ReceptionAppointTime = e.ReceptionAppointTime;
if (e.ReferralReviewDate != null)
this.target.ReferralReviewDate = e.ReferralReviewDate;
if (e.RefferalCreatedDate != null)
this.target.RefferalCreatedDate = e.RefferalCreatedDate;
if (e.CaseAidForm != null)
this.caseAidForm = new TestCoding(e.CaseAidForm);
if (e.CaseAidPlace != null)
this.caseAidPlace = new TestCoding(e.CaseAidPlace);
if (e.CaseAidType != null)
this.caseAidType = new TestCoding(e.CaseAidType);
if (e.Lpu != null)
this.lpu = new TestCoding(e.Lpu);
}
public TestAddress(AddressDto a)
{
if (a == null) return;
address = a;
addressType = new TestCoding(address.AddressType);
}
internal void UpdateTestPerson(Person p)
{
if (p.BirthDate != null)
this.person.BirthDate = p.BirthDate;
if (p.IdPatientMis != null)
this.person.IdPatientMis = p.IdPatientMis;
if (p.HumanName != null)
{
if (p.HumanName.FamilyName != null)
this.person.HumanName.FamilyName = p.HumanName.FamilyName;
if (p.HumanName.GivenName != null)
this.person.HumanName.GivenName = p.HumanName.GivenName;
if (p.HumanName.MiddleName != null)
this.person.HumanName.MiddleName = p.HumanName.MiddleName;
}
if (p.Sex != null)
this.sex = new TestCoding(p.Sex);
}
internal void UpdateTestReferralSource(ReferralSource s)
{
if ((s.Doctors != null) && (s.Doctors.Length != 0))
{
if (this.doctors == null)
docs = new List<TestDoctor>();
foreach (Doctor i in s.Doctors)
docs.Add(new TestDoctor(i));
}
if ((s.MainDiagnosis != null) && (s.MainDiagnosis.Length != 0))
{
if (this.mainDiagnosis == null)
diag = new List<TestMainDiagnosis>();
foreach (MainDiagnosis i in s.MainDiagnosis)
diag.Add(new TestMainDiagnosis(i));
}
if (s.Lpu != null)
lpu = new TestCoding(s.Lpu);
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
public TestContact(ContactDto c)
{
contact = c;
contactType = new TestCoding(contact.ContactType);
}
public TestContact(ContactDto c)
{
contact = c;
if (contact.ContactType != null)
contactType = new TestCoding(contact.ContactType);
}
private void FindMismatch(TestCoding r)
{
if (this.coding.Code != r.coding.Code)
Global.errors3.Add("Несовпадение Code TestCoding");
if (this.coding.System!= r.coding.System)
Global.errors3.Add("Несовпадение System TestCoding");
if (this.coding.Version!= r.coding.Version)
Global.errors3.Add("Несовпадение Version TestCoding");
}