public PatientInfo GetPatientInfo(string primId)
{
var condition =
new ParadoxCondition.Compare(ParadoxCompareOperator.Equal, primId, 0, 0);
var sr = _Connection.ExecuteQuery("Patients", condition, false);
if (sr.Read())
{
PatientInfo result = new PatientInfo();
result.PrimID = (string)sr[0];
result.Name = sr[1] == DBNull.Value ? "" : (string)sr[1];
result.Birthdate = sr[2] == DBNull.Value ? "" : (string)sr[2];
result.Sex = sr[3] == DBNull.Value ? "" : (string)sr[3];
result.Physician = sr[4] == DBNull.Value ? "" : (string)sr[4];
result.Diagnosis = sr[5] == DBNull.Value ? "" : (string)sr[5];
return result;
}
return new PatientInfo { PrimID = primId };
}
