public async Task <List <ProductFullDTO> > GetProductByGroupIdAsync(int groupId, int take = -1)
{
var result = TableNoTracking.ProjectTo <ProductFullDTO>().Where(x =>
x.IsActive == true &&
x.ProductGroupId == groupId);
if (take != -1)
{
result = result.Skip(1).Take(take);
}
return(await result.ToListAsync());
}
/// <summary>
/// گرفتن تمام وضعیت های مربوط به یک شماره فاکتور
/// </summary>
/// <param name="shopOrderId"></param>
/// <returns></returns>
public async Task <List <ShopOrderStatusDTO> > GetItemsByOrderId(int shopOrderId)
{
return(await TableNoTracking.ProjectTo <ShopOrderStatusDTO>().Where(x => x.ShopOrderId == shopOrderId).ToListAsync());
}
/// <summary>
/// Gets all cached localized properties
/// </summary>
/// <returns>Cached localized properties</returns>
public virtual Task <List <LocalizedPropertyCached> > GetAllCachedAsync(CancellationToken cancellationToken = default)
{
return(_cacheManager.GetAsync(LocalizationCacheKeys.LocalizedPropertyAllCacheKey, LocalizationCacheKeys.LocalizedPropertyCacheRegion,
() => TableNoTracking.ProjectTo <LocalizedPropertyCached>(_configurationProvider).ToListAsync(cancellationToken)));
}
/// <summary>
/// Gets all cached localized properties
/// </summary>
/// <returns>Cached localized properties</returns>
public virtual List <LocalizedPropertyCached> GetAllCached()
{
return(_cacheManager.Get(LocalizationCacheKeys.LocalizedPropertyAllCacheKey, LocalizationCacheKeys.LocalizedPropertyCacheRegion,
() => TableNoTracking.ProjectTo <LocalizedPropertyCached>(_configurationProvider).ToList()));
}
