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