//как искать?
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);
}
