public int GetCountPatientId(ListPatientCriteria criteria)
{
int result = 0;
try
{
using (SqlConnection connection = CommonUtils.GetBusinessObject <ConnectionService>().getLabconnectSqlConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(QueryPatientCount, connection))
{
ApplyQueryCriteria(command, criteria);
result = (int)command.ExecuteScalar();
}
}
}
catch (BusinessException)
{
throw;
}
catch (Exception exception)
{
_logger.Error(string.Format("Iternal error {0}", exception));
throw new BusinessException(ErrorCode.InternalErrorException, exception);
}
return(result);
}
private void ApplyQueryCriteria(SqlCommand command, ListPatientCriteria criteria)
{
SqlParameter parameter = null;
if (criteria.DateSearch != null)
{
const string startDateParamName = "startDate";
const string endDateParamName = "endDate";
command.CommandText += QueryPatient_DateInSelect;
parameter = command.Parameters.Add(new SqlParameter(startDateParamName, SqlDbType.DateTime));
parameter.Value = criteria.DateSearch;
parameter = command.Parameters.Add(new SqlParameter(endDateParamName, SqlDbType.DateTime));
parameter.Value = criteria.DateSearch;
}
if (!string.IsNullOrEmpty(criteria.SID))
{
const string sidParamName = "sid";
command.CommandText += QueryPatient_SIDSelect;
parameter = command.Parameters.Add(new SqlParameter(sidParamName, SqlDbType.NVarChar));
parameter.Value = string.Format("%{0}%", criteria.SID);
}
if (!string.IsNullOrEmpty(criteria.PatientName))
{
const string patientNameParamName = "patientName";
command.CommandText += QueryPatient_PatientName;
parameter = command.Parameters.Add(new SqlParameter(patientNameParamName, SqlDbType.NVarChar));
parameter.Value = string.Format("%{0}%", criteria.PatientName);
}
if (!string.IsNullOrEmpty(criteria.Sequence))
{
const string sequenceParamName = "seq";
command.CommandText += QueryPatient_Seq;
parameter = command.Parameters.Add(new SqlParameter(sequenceParamName, SqlDbType.NVarChar));
parameter.Value = string.Format("{0}%", criteria.Sequence);
}
}
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);
}
