public async Task <object> ListOperacion(OperacionRequest request)
{
Response response = new Response();
try
{
List <OperacionResponse> list = await _unitOfWork.Murat.ListOperacion(request);
if (list != null)
{
response.Status = Constant.Status;
response.Message = Constant.Ok;
response.Data = list;
}
else
{
response.Status = Constant.Error400;
response.Message = Constant.Consult;
}
}
catch (Exception e)
{
response.Status = Constant.Error500;
response.Message = e.Message;
}
return(response);
}
public async Task <List <OperacionResponse> > ListOperacion(OperacionRequest request)
{
var parameters = new DynamicParameters();
parameters.Add("@DFECHA_INI", request.DFecha_Ini);
parameters.Add("@DFECHA_FIN", request.DFecha_Fin);
parameters.Add("@IDOPERACION", request.IdOperacion);
parameters.Add("@IDUSUARIO", request.IdUsuario);
parameters.Add("@SCLIENTE", request.SCliente);
parameters.Add("@NESTADO", request.Estado);
using (var connection = new SqlConnection(_connectionString))
{
return((await connection.QueryAsync <OperacionResponse>("[dbo].[SPE_LIST_OPERACION]", parameters, commandType: CommandType.StoredProcedure)).ToList());
}
}
public async Task <ActionResult <Response> > ListOperacion(OperacionRequest request)
{
object rpta = new object();
try
{
request = (OperacionRequest)BusinessLogic.Utilities.AuxiliarMethods.ValidateParameters(request, request.GetType());
rpta = await _muratserviceslogic.ListOperacion(request);
if (rpta == null)
{
return(NotFound());
}
}
catch (Exception e)
{
Response response = new Response();
response.Status = Constant.Error500;
response.Message = e.Message;
return(Ok(response));
}
return(Ok(rpta));
}
