public async Task <Spent> GetById(SpentFilter model)
{
var _spent = await this.SingleOrDefaultAsync(this.GetAll(this.DataAgregation(model))
.Where(_ => _.SpentId == model.SpentId));
return(_spent);
}
public async Task <IActionResult> Get(int id, [FromQuery] SpentFilter filters)
{
if (id.IsSent())
{
filters.SpentId = id;
}
return(await base.GetOne(filters, "Personal.Expenses - Spent"));
}
public async Task <dynamic> GetDataCustom(SpentFilter filters)
{
var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.SpentId
}));
return(querybase);
}
public async Task <PaginateResult <dynamic> > GetDataListCustomPaging(SpentFilter filters)
{
var querybase = await this.PagingDataListCustom <dynamic>(filters, this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.SpentId
}));
return(querybase);
}
public async Task <IEnumerable <dynamic> > GetDataItem(SpentFilter filters)
{
var querybase = await this.ToListAsync(this.GetBySimplefilters(filters).Select(_ => new
{
Id = _.SpentId,
Name = _.Description
}));
return(querybase);
}
public IQueryable <Spent> GetBySimplefilters(SpentFilter filters)
{
var querybase = this.GetAll(this.DataAgregation(filters))
.WithBasicFilters(filters)
.WithCustomFilters(filters)
.OrderByDomain(filters)
.OrderByProperty(filters);
return(querybase);
}
public static IQueryable <Spent> WithBasicFilters(this IQueryable <Spent> queryBase, SpentFilter filters)
{
var queryFilter = queryBase;
if (filters.Ids.IsSent())
{
queryFilter = queryFilter.Where(_ => filters.GetIds().Contains(_.SpentId));
}
if (filters.SpentId.IsSent())
{
queryFilter = queryFilter.Where(_ => _.SpentId == filters.SpentId);
}
if (filters.Description.IsSent())
{
queryFilter = queryFilter.Where(_ => _.Description.Contains(filters.Description));
}
return(queryFilter);
}
public virtual Task <PaginateResult <Spent> > GetByFiltersPaging(SpentFilter filters)
{
var queryBase = this._rep.GetBySimplefilters(filters);
return(this._rep.PagingAndDefineFields(filters, queryBase));
}
public virtual async Task <IEnumerable <Spent> > GetByFilters(SpentFilter filters)
{
var queryBase = this._rep.GetBySimplefilters(filters);
return(await this._rep.ToListAsync(queryBase));
}
public virtual async Task <Spent> GetOne(SpentFilter filters)
{
return(await this._rep.GetById(filters));
}
public static IQueryable <Spent> OrderByDomain(this IQueryable <Spent> queryBase, SpentFilter filters)
{
return(queryBase.OrderBy(_ => _.SpentId));
}
public async Task <IActionResult> Get([FromQuery] SpentFilter filters)
{
return(await base.Get <SpentFilter>(filters, "Personal.Expenses - Spent"));
}
public static IQueryable <Spent> WithCustomFilters(this IQueryable <Spent> queryBase, SpentFilter filters)
{
var queryFilter = queryBase;
return(queryFilter);
}
