//как искать? 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; }
//как искать? 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 TestCancellation(CancellationData r) { if (r != null) cancellation = r; else cancellation = new CancellationData(); if (cancellation.CancellationSource != null) source = new TestCoding(cancellation.CancellationSource); if (cancellation.CancellationReason != null) reason = new TestCoding(cancellation.CancellationReason); }
public TestCancellation(CancellationData r) { if (r != null) { cancellation = r; } else { cancellation = new CancellationData(); } if (cancellation.CancellationSource != null) { source = new TestCoding(cancellation.CancellationSource); } if (cancellation.CancellationReason != null) { reason = new TestCoding(cancellation.CancellationReason); } }
public TestCancellation(CancellationData r) { cancellation = r ?? new CancellationData(); source = new TestCoding(cancellation.CancellationSource); reason = new TestCoding(cancellation.CancellationReason); }
public TestCancellation(CancellationData r) { cancellation = r ?? new CancellationData(); source = new TestCoding(cancellation.CancellationSource); reason = new TestCoding(cancellation.CancellationReason); }