public TestEventsInfo(EventsInfo r)
{
info = r ?? new EventsInfo();
cancellation = new TestCancellation(info.Cancellation);
source = new TestEventSource(info.Source);
target = new TestEventTarget(info.Target);
}
public static TestEventSource BuildSourceFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT is_referral_review_source_mo, referral_creation_date, planned_date, referral_out_date, referral_review_date_source_mo 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())
{
EventSource p = new EventSource();
while (personFromDataBase.Read())
{
if (personFromDataBase["is_referral_review_source_mo"] != DBNull.Value)
p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_source_mo"]);
if (personFromDataBase["referral_creation_date"] != DBNull.Value)
p.ReferralCreateDate = Convert.ToDateTime(personFromDataBase["referral_creation_date"]);
if (personFromDataBase["planned_date"] != DBNull.Value)
p.PlannedDate = Convert.ToDateTime(personFromDataBase["planned_date"]);
if (personFromDataBase["referral_out_date"] != DBNull.Value)
p.ReferralOutDate = Convert.ToDateTime(personFromDataBase["referral_out_date"]);
if (personFromDataBase["referral_review_date_source_mo"] != DBNull.Value)
p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_source_mo"]);
TestEventSource pers = new TestEventSource(p);
return pers;
}
}
}
return null;
}
public override bool Equals(Object obj)
{
TestEventSource p = obj as TestEventSource;
if ((object)p == null)
{
return(false);
}
if (this.source == p.source)
{
return(true);
}
if ((this.source == null) || (p.source == null))
{
return(false);
}
if ((this.source.IsReferralReviewed == p.source.IsReferralReviewed) &&
(this.source.PlannedDate == p.source.PlannedDate) &&
(this.source.ReferralCreateDate == p.source.ReferralCreateDate) &&
(this.source.ReferralOutDate == p.source.ReferralOutDate) &&
(this.source.ReferralReviewDate == p.source.ReferralReviewDate))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestEventSource");
return(false);
}
}
public TestEventsInfo(EventsInfo r)
{
info = r ?? new EventsInfo();
cancellation = new TestCancellation(info.Cancellation);
source = new TestEventSource(info.Source);
target = new TestEventTarget(info.Target);
}
static public TestEventsInfo BuildAdditionalFromDataBaseData(string idReferral)
{
TestEventsInfo p = new TestEventsInfo();
p.cancellation = TestCancellation.BuildCancellationFromDataBaseData(idReferral);
p.source = TestEventSource.BuildSourceFromDataBaseData(idReferral);
p.target = TestEventTarget.BuildTargetFromDataBaseData(idReferral);
return(p);
}
public TestEventsInfo(EventsInfo r)
{
if (r != null)
info = r;
else
info = new EventsInfo();
cancellation = new TestCancellation(info.Cancellation);
source = new TestEventSource(info.Source);
target = new TestEventTarget(info.Target);
}
public TestEventsInfo(EventsInfo r)
{
if (r != null)
{
info = r;
}
else
{
info = new EventsInfo();
}
cancellation = new TestCancellation(info.Cancellation);
source = new TestEventSource(info.Source);
target = new TestEventTarget(info.Target);
}
static public TestEventSource BuildSourceFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
//ReferralCreateDate что с этим делать???
string findPatient = "SELECT is_referral_review_source_mo, referral_creation_date, planned_date, referral_out_date, referral_review_date_source_mo 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())
{
EventSource p = new EventSource();
while (personFromDataBase.Read())
{
if (personFromDataBase["is_referral_review_source_mo"] != DBNull.Value)
{
p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_source_mo"]);
}
if (personFromDataBase["referral_creation_date"] != DBNull.Value)
{
p.ReferralCreateDate = Convert.ToDateTime(personFromDataBase["referral_creation_date"]);
}
if (personFromDataBase["planned_date"] != DBNull.Value)
{
p.PlannedDate = Convert.ToDateTime(personFromDataBase["planned_date"]);
}
if (personFromDataBase["referral_out_date"] != DBNull.Value)
{
p.ReferralOutDate = Convert.ToDateTime(personFromDataBase["referral_out_date"]);
}
if (personFromDataBase["referral_review_date_source_mo"] != DBNull.Value)
{
p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_source_mo"]);
}
TestEventSource pers = new TestEventSource(p);
return(pers);
}
}
}
return(null);
}
private void FindMismatch(TestEventSource r)
{
if (this.source.IsReferralReviewed != r.source.IsReferralReviewed)
{
Global.errors3.Add("Несовпадение IsReferralReviewed TestEventSource");
}
if (this.source.PlannedDate != r.source.PlannedDate)
{
Global.errors3.Add("Несовпадение PlannedDate TestEventSource");
}
if (this.source.ReferralCreateDate != r.source.ReferralCreateDate)
{
Global.errors3.Add("Несовпадение ReferralCreateDate TestEventSource");
}
if (this.source.ReferralOutDate != r.source.ReferralOutDate)
{
Global.errors3.Add("Несовпадение ReferralOutDate TestEventSource");
}
if (this.source.ReferralReviewDate != r.source.ReferralReviewDate)
{
Global.errors3.Add("Несовпадение ReferralReviewDate TestEventSource");
}
}
private void FindMismatch(TestEventSource r)
{
if (this.source.IsReferralReviewed != r.source.IsReferralReviewed)
Global.errors3.Add("Несовпадение IsReferralReviewed TestEventSource");
if (this.source.PlannedDate != r.source.PlannedDate)
Global.errors3.Add("Несовпадение PlannedDate TestEventSource");
if (this.source.ReferralCreateDate != r.source.ReferralCreateDate)
Global.errors3.Add("Несовпадение ReferralCreateDate TestEventSource");
if (this.source.ReferralOutDate != r.source.ReferralOutDate)
Global.errors3.Add("Несовпадение ReferralOutDate TestEventSource");
if (this.source.ReferralReviewDate != r.source.ReferralReviewDate)
Global.errors3.Add("Несовпадение ReferralReviewDate TestEventSource");
}
