private PagedList<TreatmentCustomer> PerformTreatmentSearch(SearchParameters searchParameters, int page, int pageSize)
{
var treatments = _treatmentService.GetTreatmentsBySearchCriteria(searchParameters);
return new PagedList<TreatmentCustomer>(treatments, page, pageSize);
}
public List<TreatmentCustomer> GetTreatmentsBySearchCriteria(SearchParameters searchParameters)
{
_logger.DebugFormat("Recieved GetTreatmentsBySearchCriteria with searchCritera: {0}", searchParameters);
var fromDate = DateTimeParser.ParseDateTimeFromDateToString(searchParameters.TreatmentFromDate);
var toDate = DateTimeParser.ParseDateTimeToDateToString(searchParameters.TreatmentToDate);
try
{
var result = _treatmentRepository.GetTreatmentsBySearchCriteria(searchParameters, fromDate, toDate);
return _mappingEngine.Map<List<TreatmentCustomer>>(result);
}
catch (Exception ex)
{
_logger.ErrorFormat("Exception when calling GetTreatmentsBySearchCriteria: {0}", ex);
}
return null;
}
private PagedList<Customer> PerformCustomerSearch(SearchParameters searchParameters, int page, int pageSize)
{
var customers = _customerService.GetCustomersBySearchCriteria(searchParameters);
return new PagedList<Customer>(customers, page, pageSize);
}
public List<CustomerEntity> GetCustomerBySearchParameters(SearchParameters searchParameters)
{
DynamicParameters parameters = null;
var isWhereClauseAppended = false;
var needForAndClause = false;
if (!string.IsNullOrWhiteSpace(searchParameters.CustomerName))
{
isWhereClauseAppended = true;
needForAndClause = true;
if (parameters == null)
{
parameters = new DynamicParameters();
}
SearchCustomer_Query += "WHERE ";
SearchCustomer_Query += Query_CustomerName;
parameters.Add("CustomerName", "%" + searchParameters.CustomerName + "%");
}
if (!string.IsNullOrWhiteSpace(searchParameters.PhoneNumber))
{
if (parameters == null)
{
parameters = new DynamicParameters();
}
if (!isWhereClauseAppended)
{
SearchCustomer_Query += "WHERE ";
isWhereClauseAppended = true;
}
if (needForAndClause)
{
SearchCustomer_Query += "AND ";
needForAndClause = true;
}
SearchCustomer_Query += Query_MobilePhone;
parameters.Add("MobilePhoneNumber", searchParameters.PhoneNumber);
}
if (!string.IsNullOrWhiteSpace(searchParameters.Profession))
{
if (parameters == null)
{
parameters = new DynamicParameters();
}
if (!isWhereClauseAppended)
{
SearchCustomer_Query += "WHERE ";
isWhereClauseAppended = true;
}
if (needForAndClause)
{
SearchCustomer_Query += "AND ";
needForAndClause = true;
}
SearchCustomer_Query += Query_Profession;
parameters.Add("Profession", searchParameters.Profession);
}
_logger.DebugFormat("GetCustomerBySearchParameters");
var result = DapperConnectionSingleton.DapperConnection.Query<CustomerEntity>(SearchCustomer_Query, parameters);
return result.ToList();
}
