public override bool Equals(Object obj)
{
TestReferralInfo p = obj as TestReferralInfo;
if ((object)p == null)
{
return(false);
}
if ((this.info.Comment == p.info.Comment) &&
(this.info.Date == p.info.Date) &&
(this.info.IdMq == p.info.IdMq) &&
(this.info.Priority == p.info.Priority) &&
(this.info.Reason == p.info.Reason) &&
(Global.IsEqual(this.cancellation, p.cancellation)) &&
(Global.IsEqual(this.mqReferralStatus, p.mqReferralStatus)) &&
(Global.IsEqual(this.profileMedService, p.profileMedService)) &&
(Global.IsEqual(this.referralType, p.referralType)))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestReferralInfo");
return(false);
}
}
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);
}
public static 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;
}
private void FindMismatch(TestReferralInfo r)
{
if (this.info.Comment != r.info.Comment)
{
Global.errors3.Add("Несовпадение Comment TestReferralInfo");
}
if (this.info.Date != r.info.Date)
{
Global.errors3.Add("Несовпадение DateSpecified TestReferralInfo");
}
if (this.info.IdMq != r.info.IdMq)
{
Global.errors3.Add("Несовпадение IdMq TestReferralInfo");
}
if (this.info.Priority != r.info.Priority)
{
Global.errors3.Add("Несовпадение Priority TestReferralInfo");
}
if (this.info.Reason != r.info.Reason)
{
Global.errors3.Add("Несовпадение Reason TestReferralInfo");
}
if (Global.GetLength(this.cancellation) != Global.GetLength(r.cancellation))
{
Global.errors3.Add("Несовпадение длины cancellation TestReferralInfo");
}
if (Global.GetLength(this.mqReferralStatus) != Global.GetLength(r.mqReferralStatus))
{
Global.errors3.Add("Несовпадение длины mqReferralStatus TestReferralInfo");
}
if (Global.GetLength(this.profileMedService) != Global.GetLength(r.profileMedService))
{
Global.errors3.Add("Несовпадение длины profileMedService TestReferralInfo");
}
if (Global.GetLength(this.referralType) != Global.GetLength(r.referralType))
{
Global.errors3.Add("Несовпадение длины referralType TestReferralInfo");
}
}
private void FindMismatch(TestReferralInfo r)
{
if (this.info.Comment != r.info.Comment)
Global.errors3.Add("Несовпадение Comment TestReferralInfo");
if (this.info.Date != r.info.Date)
Global.errors3.Add("Несовпадение DateSpecified TestReferralInfo");
if (this.info.IdMq != r.info.IdMq)
Global.errors3.Add("Несовпадение IdMq TestReferralInfo");
if (this.info.Priority != r.info.Priority)
Global.errors3.Add("Несовпадение Priority TestReferralInfo");
if (this.info.Reason != r.info.Reason)
Global.errors3.Add("Несовпадение Reason TestReferralInfo");
if (Global.GetLength(this.cancellation) != Global.GetLength(r.cancellation))
Global.errors3.Add("Несовпадение длины cancellation TestReferralInfo");
if (Global.GetLength(this.mqReferralStatus) != Global.GetLength(r.mqReferralStatus))
Global.errors3.Add("Несовпадение длины mqReferralStatus TestReferralInfo");
if (Global.GetLength(this.profileMedService) != Global.GetLength(r.profileMedService))
Global.errors3.Add("Несовпадение длины profileMedService TestReferralInfo");
if (Global.GetLength(this.referralType) != Global.GetLength(r.referralType))
Global.errors3.Add("Несовпадение длины referralType TestReferralInfo");
}
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);
}