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); }