//как искать? 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 static 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 TestEventsInfo(EventsInfo r) { info = r ?? new EventsInfo(); cancellation = new TestCancellation(info.Cancellation); source = new TestEventSource(info.Source); target = new TestEventTarget(info.Target); }
public override bool Equals(Object obj) { TestCancellation p = obj as TestCancellation; if ((object)p == null) { return(false); } if (this.cancellation == p.cancellation) { return(true); } if ((this.cancellation == null) || (p.cancellation == null)) { return(false); } if ((this.cancellation.Date == p.cancellation.Date) && (this.cancellation.ReasonComment == p.cancellation.ReasonComment) && (Global.Equals(this.reason, p.reason)) && (Global.Equals(this.source, p.source))) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestCacellation"); return(false); } }
internal void UpdateTestEventsInfo(EventsInfo eventsInfo) { if (eventsInfo.Cancellation != null) cancellation = new TestCancellation(eventsInfo.Cancellation); if (eventsInfo.Source != null) source.UpdateTestEventSource(eventsInfo.Source); if (eventsInfo.Target != null) target.UpdateTestEventTarget(eventsInfo.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 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 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); }
internal void UpdateTestEventsInfo(EventsInfo eventsInfo) { if (eventsInfo.Cancellation != null) { cancellation = new TestCancellation(eventsInfo.Cancellation); } if (eventsInfo.Source != null) { source.UpdateTestEventSource(eventsInfo.Source); } if (eventsInfo.Target != null) { target.UpdateTestEventTarget(eventsInfo.Target); } }
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); } }
private void FindMismatch(TestCancellation r) { if (this.cancellation.Date != r.cancellation.Date) { Global.errors3.Add("Несовпадение Date TestCacellation"); } if (this.cancellation.ReasonComment != r.cancellation.ReasonComment) { Global.errors3.Add("Несовпадение Date TestCacellation"); } if (Global.GetLength(this.reason) != Global.GetLength(r.reason)) { Global.errors3.Add("Несовпадение длинны reason TestCacellation"); } if (Global.GetLength(this.source) != Global.GetLength(r.source)) { Global.errors3.Add("Несовпадение длинны source TestCacellation"); } }
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 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); } }
private void FindMismatch(TestCancellation r) { if (this.cancellation.Date != r.cancellation.Date) Global.errors3.Add("Несовпадение Date TestCacellation"); if (this.cancellation.ReasonComment != r.cancellation.ReasonComment) Global.errors3.Add("Несовпадение Date TestCacellation"); if (Global.GetLength(this.reason) != Global.GetLength(r.reason)) Global.errors3.Add("Несовпадение длинны reason TestCacellation"); if (Global.GetLength(this.source) != Global.GetLength(r.source)) Global.errors3.Add("Несовпадение длинны source TestCacellation"); }
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); }