public async Task <CodigoVerificacao> GetById(CodigoVerificacaoFilter model)
{
var _codigoverificacao = await this.SingleOrDefaultAsync(this.GetAll(this.DataAgregation(model))
.Where(_ => _.CodigoVerificacaoId == model.CodigoVerificacaoId));
return(_codigoverificacao);
}
public async Task <dynamic> GetDataCustom(CodigoVerificacaoFilter filters)
{
var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.CodigoVerificacaoId
}));
return(querybase);
}
public async Task <PaginateResult <dynamic> > GetDataListCustomPaging(CodigoVerificacaoFilter filters)
{
var querybase = await this.PagingDataListCustom <dynamic>(filters, this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.CodigoVerificacaoId
}));
return(querybase);
}
public async Task <IEnumerable <dynamic> > GetDataItem(CodigoVerificacaoFilter filters)
{
var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.CodigoVerificacaoId,
Name = _.Codigo
}));
return(querybase);
}
public IQueryable <CodigoVerificacao> GetBySimplefilters(CodigoVerificacaoFilter filters)
{
var querybase = this.GetAll(this.DataAgregation(filters))
.WithBasicFilters(filters)
.WithCustomFilters(filters)
.OrderByDomain(filters)
.OrderByProperty(filters);
return(querybase);
}
public async Task <IActionResult> Get([FromQuery] CodigoVerificacaoFilter filters)
{
var result = new HttpResult <CodigoVerificacaoDto>(this._logger);
try
{
var searchResult = await this._app.GetByFilters(filters);
return(result.ReturnCustomResponse(this._app, searchResult, filters));
}
catch (Exception ex)
{
var responseEx = result.ReturnCustomException(ex, "Seed - CodigoVerificacao", filters, new ErrorMapCustom());
return(responseEx);
}
}
public async Task <IActionResult> Get(int id, [FromQuery] CodigoVerificacaoFilter filters)
{
var result = new HttpResult <CodigoVerificacaoDto>(this._logger);
try
{
if (id.IsSent())
{
filters.CodigoVerificacaoId = id;
}
var returnModel = await this._app.GetOne(filters);
return(result.ReturnCustomResponse(this._app, returnModel));
}
catch (Exception ex)
{
var responseEx = result.ReturnCustomException(ex, "Seed - CodigoVerificacao", id);
return(responseEx);
}
}
public static IQueryable <CodigoVerificacao> WithCustomFilters(this IQueryable <CodigoVerificacao> queryBase, CodigoVerificacaoFilter filters)
{
var queryFilter = queryBase;
return(queryFilter);
}
public virtual Task <PaginateResult <CodigoVerificacao> > GetByFiltersPaging(CodigoVerificacaoFilter filters)
{
var queryBase = this._rep.GetBySimplefilters(filters);
return(this._rep.PagingAndDefineFields(filters, queryBase));
}
public virtual async Task <IEnumerable <CodigoVerificacao> > GetByFilters(CodigoVerificacaoFilter filters)
{
var queryBase = this._rep.GetBySimplefilters(filters);
return(await this._rep.ToListAsync(queryBase));
}
public virtual async Task <CodigoVerificacao> GetOne(CodigoVerificacaoFilter filters)
{
return(await this._rep.GetById(filters));
}
public static IQueryable <CodigoVerificacao> OrderByDomain(this IQueryable <CodigoVerificacao> queryBase, CodigoVerificacaoFilter filters)
{
return(queryBase.OrderBy(_ => _.CodigoVerificacaoId));
}
public static IQueryable <CodigoVerificacao> WithBasicFilters(this IQueryable <CodigoVerificacao> queryBase, CodigoVerificacaoFilter filters)
{
var queryFilter = queryBase;
if (filters.Ids.IsSent())
{
queryFilter = queryFilter.Where(_ => filters.GetIds().Contains(_.CodigoVerificacaoId));
}
if (filters.CodigoVerificacaoId.IsSent())
{
queryFilter = queryFilter.Where(_ => _.CodigoVerificacaoId == filters.CodigoVerificacaoId);
}
if (filters.ParticipanteId.IsSent())
{
queryFilter = queryFilter.Where(_ => _.ParticipanteId == filters.ParticipanteId);
}
if (filters.Codigo.IsSent())
{
queryFilter = queryFilter.Where(_ => _.Codigo == filters.Codigo);
}
if (filters.DataInicio.IsSent())
{
queryFilter = queryFilter.Where(_ => _.DataInicio >= filters.DataInicio.AddHours(-filters.DataInicio.Hour).AddMinutes(-filters.DataInicio.Minute).AddSeconds(-filters.DataInicio.Second) && _.DataInicio <= filters.DataInicio.AddDays(1).AddHours(-filters.DataInicio.Hour).AddMinutes(-filters.DataInicio.Minute).AddSeconds(-filters.DataInicio.Second));
}
if (filters.DataInicioStart.IsSent())
{
queryFilter = queryFilter.Where(_ => _.DataInicio >= filters.DataInicioStart);
}
if (filters.DataInicioEnd.IsSent())
{
filters.DataInicioEnd = filters.DataInicioEnd.AddDays(1).AddMilliseconds(-1);
queryFilter = queryFilter.Where(_ => _.DataInicio <= filters.DataInicioEnd);
}
if (filters.DataFim.IsSent())
{
queryFilter = queryFilter.Where(_ => _.DataFim >= filters.DataFim.AddHours(-filters.DataFim.Hour).AddMinutes(-filters.DataFim.Minute).AddSeconds(-filters.DataFim.Second) && _.DataFim <= filters.DataFim.AddDays(1).AddHours(-filters.DataFim.Hour).AddMinutes(-filters.DataFim.Minute).AddSeconds(-filters.DataFim.Second));
}
if (filters.DataFimStart.IsSent())
{
queryFilter = queryFilter.Where(_ => _.DataFim >= filters.DataFimStart);
}
if (filters.DataFimEnd.IsSent())
{
filters.DataFimEnd = filters.DataFimEnd.AddDays(1).AddMilliseconds(-1);
queryFilter = queryFilter.Where(_ => _.DataFim <= filters.DataFimEnd);
}
if (filters.statusCodigoId.IsSent())
{
queryFilter = queryFilter.Where(_ => _.statusCodigoId == filters.statusCodigoId);
}
return(queryFilter);
}
