public static TestReferralSurvey BuildAdditionalFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT id_survey_organ, survey_comment, 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);
pers.additional = TestAdditional.BuildAdditionalFromDataBaseData(idReferral);
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 override bool Equals(Object obj)
{
TestReferralSurvey p = obj as TestReferralSurvey;
if ((object)p == null)
{
return(false);
}
if (this.survey == p.survey)
{
return(true);
}
if ((this.survey == null) || (p.survey == null))
{
return(false);
}
if ((this.survey.Comment == p.survey.Comment) &&
(Global.IsEqual(this.additional, p.additional)) &&
(Global.IsEqual(this.surveyOrgan, p.surveyOrgan)) &&
(Global.IsEqual(this.surveyType, p.surveyType)))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestReferralSurvey");
return(false);
}
}
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);
}
static public TestReferral BuildReferralFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM public.referral WHERE id_referral = '" + idReferral + "'";
// string findR = "select id_patient_person from public.referral";
NpgsqlCommand Rcommand = new NpgsqlCommand(findR, connection);
using (NpgsqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
TestReferral r = new TestReferral();
r.evInfo = TestEventsInfo.BuildAdditionalFromDataBaseData(idReferral);
if (RReader["id_patient_person"] != DBNull.Value)
{
r.patient = TestPatient.BuildPatientFromDataBaseData(RReader["id_patient_person"].ToString(), RReader["id_patient_source_mo_mis"].ToString());
}
r.refInfo = TestReferralInfo.BuildPersonFromDataBaseData(idReferral);
r.refSourse = TestReferralSource.BuildSourceFromDataBaseData(idReferral);
r.refSurvey = TestReferralSurvey.BuildAdditionalFromDataBaseData(idReferral);
r.refTarget = TestReferralTarget.BuildTargetFromDataBaseData(idReferral);
return(r);
}
}
}
return(null);
}
public TestReferral(Referral r, string idLpu = "")
{
evInfo = new TestEventsInfo(r.EventsInfo);
patient = new TestPatient(r.Patient);
refInfo = new TestReferralInfo(r.ReferralInfo);
refSurvey = new TestReferralSurvey(r.ReferralSurvey);
refSourse = new TestReferralSource(r.Source);
refTarget = new TestReferralTarget(r.Target);
}
public TestReferral(Referral r, string idLpu = "")
{
evInfo = new TestEventsInfo(r.EventsInfo);
patient = new TestPatient(r.Patient);
refInfo = new TestReferralInfo(r.ReferralInfo);
refSurvey = new TestReferralSurvey(r.ReferralSurvey);
refSourse = new TestReferralSource(r.Source);
refTarget = new TestReferralTarget(r.Target);
}
private void FindMismatch(TestReferralSurvey r)
{
if (this.survey.Comment != r.survey.Comment)
{
Global.errors3.Add("Несовпадение Comment TestReferralSurvey");
}
if (Global.GetLength(this.additional) != Global.GetLength(r.additional))
{
Global.errors3.Add("Несовпадение длинны additional TestReferralSurvey");
}
if (Global.GetLength(this.surveyOrgan) != Global.GetLength(r.surveyOrgan))
{
Global.errors3.Add("Несовпадение длинны surveyOrgan TestReferralSurvey");
}
if (Global.GetLength(this.surveyType) != Global.GetLength(r.surveyType))
{
Global.errors3.Add("Несовпадение длинны surveyType TestReferralSurvey");
}
}
private void FindMismatch(TestReferralSurvey r)
{
if (this.survey.Comment != r.survey.Comment)
Global.errors3.Add("Несовпадение Comment TestReferralSurvey");
if (Global.GetLength(this.additional) != Global.GetLength(r.additional))
Global.errors3.Add("Несовпадение длинны additional TestReferralSurvey");
if (Global.GetLength(this.surveyOrgan) != Global.GetLength(r.surveyOrgan))
Global.errors3.Add("Несовпадение длинны surveyOrgan TestReferralSurvey");
if (Global.GetLength(this.surveyType) != Global.GetLength(r.surveyType))
Global.errors3.Add("Несовпадение длинны surveyType TestReferralSurvey");
}