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); }