public override bool Equals(Object obj)
{
TestReferralSource p = obj as TestReferralSource;
if ((object)p == null)
{
return(false);
}
if (this.sourse == p.sourse)
{
return(true);
}
if ((this.sourse == null) || (p.sourse == null))
{
return(false);
}
if ((this.sourse.IdCaseMis == p.sourse.IdCaseMis) &&
(this.sourse.IdReferralMis == p.sourse.IdReferralMis) &&
(Global.Equals(this.documents, p.documents)) &&
(Global.Equals(this.mainDiagnosis, p.mainDiagnosis)) &&
(Global.Equals(this.lpu, p.lpu)))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestReferralSource");
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));
}
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(TestReferralSource r)
{
if (this.sourse.IdCaseMis != r.sourse.IdCaseMis)
{
Global.errors3.Add("Несовпадение IdCaseMis TestReferralSource");
}
if (this.sourse.IdReferralMis != r.sourse.IdReferralMis)
{
Global.errors3.Add("Несовпадение IdReferralMis TestReferralSource");
}
if (Global.GetLength(this.documents) != Global.GetLength(r.documents))
{
Global.errors3.Add("Несовпадение длинны documents TestReferralSource");
}
if (Global.GetLength(this.mainDiagnosis) != Global.GetLength(r.mainDiagnosis))
{
Global.errors3.Add("Несовпадение длинны mainDiagnosis TestReferralSource");
}
if (Global.GetLength(this.lpu) != Global.GetLength(r.lpu))
{
Global.errors3.Add("Несовпадение длинны lpu TestReferralSource");
}
}
public static 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())
{
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);
pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_source_lpu"]));
pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"]));
pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"]));
return pers;
}
}
}
return new TestReferralSource(null);
}
private void FindMismatch(TestReferralSource r)
{
if (this.sourse.IdCaseMis != r.sourse.IdCaseMis)
Global.errors3.Add("Несовпадение IdCaseMis TestReferralSource");
if (this.sourse.IdReferralMis != r.sourse.IdReferralMis)
Global.errors3.Add("Несовпадение IdReferralMis TestReferralSource");
if (Global.GetLength(this.doctors) != Global.GetLength(r.doctors))
Global.errors3.Add("Несовпадение длинны doctors TestReferralSource");
if (Global.GetLength(this.mainDiagnosis) != Global.GetLength(r.mainDiagnosis))
Global.errors3.Add("Несовпадение длинны mainDiagnosis TestReferralSource");
if (Global.GetLength(this.lpu) != Global.GetLength(r.lpu))
Global.errors3.Add("Несовпадение длинны lpu TestReferralSource");
}
