public async Task <QueryIndividualsResponse> QueryIndividuals(QueryIndividualsRequest request)
{
var queryObject = _mapper.Map <QueryIndividualsRequest, QueryIndividualsQuery>(request);
var queryResponse = await _mediator.Send(queryObject);
if (queryResponse.IsSuccess)
{
}
}
public async Task <QueryIndividualsResponse> QueryIndividuals(QueryIndividualsRequest request)
{
using (var connection = new SqlConnection(_connectionString))
{
var parameters = new DynamicParameters();
InitializeQueryIndividualsParameters(request, parameters);
var response = await connection.QueryAsync <QueryIndividualsItem>("[dbo].[spQueryIndividuals]",
parameters, commandType : CommandType.StoredProcedure) as List <QueryIndividualsItem>;
return(new QueryIndividualsResponse
{
List = response.Any() ? response : new List <QueryIndividualsItem>()
});
}
}
private static void InitializeQueryIndividualsParameters(QueryIndividualsRequest request, DynamicParameters parameters)
{
if (!string.IsNullOrEmpty(request.QueryString))
{
parameters.Add("@QueryString", request.QueryString);
}
else
{
parameters.Add("@QueryString", (string)null);
}
if (!string.IsNullOrEmpty(request.Name))
{
parameters.Add("@Name", request.Name);
}
else
{
parameters.Add("@Name", (string)null);
}
if (!string.IsNullOrEmpty(request.LastName))
{
parameters.Add("@LastName", request.LastName);
}
else
{
parameters.Add("@LastName", (string)null);
}
if (!string.IsNullOrEmpty(request.PersonalId))
{
parameters.Add("@PersonalId", request.PersonalId);
}
else
{
parameters.Add("@PersonalId", (string)null);
}
if (!string.IsNullOrEmpty(request.City))
{
parameters.Add("@City", request.City);
}
else
{
parameters.Add("@City", (string)null);
}
if (request.Gender.HasValue)
{
parameters.Add("@Gender", request.Gender.Value);
}
else
{
parameters.Add("@Gender", (int?)null);
}
if (request.BirthDate.HasValue)
{
parameters.Add("@BirthDate", request.BirthDate.Value);
}
else
{
parameters.Add("@BirthDate", (DateTime?)null);
}
if (!string.IsNullOrEmpty(request.OrderBy))
{
parameters.Add("@OrderBy", request.OrderBy);
}
else
{
parameters.Add("@OrderBy", (string)null);
}
if (request.PageNumber.HasValue)
{
parameters.Add("@PageNumber", request.PageNumber.Value);
}
else
{
parameters.Add("@PageNumber", (int?)null);
}
if (request.PageSize.HasValue)
{
parameters.Add("@PageSize", request.PageSize.Value);
}
else
{
parameters.Add("@PageSize", (int?)null);
}
}
