public ConsultaAdelantoPorIdBE ConsultarAdelantoPorId(ConsultaAdelantoPorIdRequestDTO request)
{
ConsultaAdelantoPorIdBE consultaAdelantoPorIdBE = _IAdelantoRepository.ConsultarAdelantoPorId(request.AdelantoId);
return(consultaAdelantoPorIdBE);
}
public ConsultaAdelantoPorIdBE ConsultarAdelantoPorId(int adelantoId)
{
ConsultaAdelantoPorIdBE itemBE = null;
var parameters = new DynamicParameters();
parameters.Add("@AdelantoId", adelantoId);
using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB))
{
var list = db.Query <ConsultaAdelantoPorIdBE>("uspAdelantoConsultaPorId", parameters, commandType: CommandType.StoredProcedure);
if (list.Any())
{
itemBE = list.First();
}
}
return(itemBE);
}
