private LabConnSampleInfo ConvertToLabConnSampleInfo(SqlDataReader reader)
{
LabConnSampleInfo info = new LabConnSampleInfo()
{
SID = reader["SID"] == DBNull.Value ? null : (string)reader["SID"],
Patientname = reader["PatientName"] == DBNull.Value ? null : (string)reader["PatientName"],
LocationId = reader["LocationID"] == DBNull.Value ? null : (string)reader["LocationID"],
Age = reader["Age"] == DBNull.Value ? 0 : (int)reader["Age"],
};
var sexStr = reader["Sex"] == DBNull.Value ? null : (string)reader["Sex"];
if (string.IsNullOrEmpty(sexStr))
{
info.Sex = SampleSex.NotSpecifiy;
}
else if ((char)SampleSex.Female == sexStr[0])
{
info.Sex = SampleSex.Female;
}
else if ((char)SampleSex.Male == sexStr[0])
{
info.Sex = SampleSex.Male;
}
else
{
info.Sex = SampleSex.NotSpecifiy;
}
info.DateInput = (DateTime)reader["DateIN"];
return(info);
}
public List <LabConnSampleInfo> GetListPatientId(ListPatientCriteria criteria)
{
List <LabConnSampleInfo> result = new List <LabConnSampleInfo>();
try
{
using (SqlConnection connection = CommonUtils.GetBusinessObject <ConnectionService>().getLabconnectSqlConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(QueryPatient, connection))
{
ApplyQueryCriteria(command, criteria);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
LabConnSampleInfo info = ConvertToLabConnSampleInfo(reader);
result.Add(info);
}
reader.Close();
}
}
}
}
catch (BusinessException)
{
throw;
}
catch (Exception exception)
{
_logger.Error(string.Format("Iternal error {0}", exception));
throw new BusinessException(ErrorCode.InternalErrorException, exception);
}
return(result);
}
