public IEnumerable <TrackOrderDto> SearchByDailyInfo(PagerDto <DailySearchModel> model) { using (_trackRepository) { return(_trackRepository.SearchByDailyInfo(model)); } }
public IEnumerable <TrackOrderDto> SearchByClient(PagerDto <long> client) { using (_trackRepository) { return(_trackRepository.SearchByClient(client)); } }
public IEnumerable <TrackOrderDto> SearchByPhone(PagerDto <String> phone) { using (_trackRepository) { return(_trackRepository.SearchByPhone(phone)); } }
public IEnumerable <TrackOrderDto> SearchByPhone(PagerDto <String> phone) { var query = DbEntities.OrderToStore.Where(e => e.OrderAtoId != null && e.ClientPhone.Phone.Contains(phone.Data)) .Select(ExpGetTrackOrderDto()); phone.Pager.Total = query.Count(); return(query.OrderByDescending(e => e.OrderToStoreId).Skip(phone.Pager.SkipRow).Take(phone.Pager.Size).ToList()); }
public async Task <IList <ProductEntity> > GetAsync(PagerDto pager, short countryId, bool?isActive) { return(await context .Product .Include(products => products.Country) .Where(w => w.CountryId == countryId && (isActive == null || w.IsActive == (bool)isActive)) .Paged(pager) .ToListAsync()); }
/// <summary> /// page a query /// </summary> public static IQueryable <T> Paged <T>(this IQueryable <T> query, PagerDto pager) where T : class { pager.Total = query.Count(); int skip = pager.PageIndex * pager.PageSize; return(query.Skip(skip) .Take(pager.PageSize)); }
public IEnumerable <TrackOrderDto> SearchByClient(PagerDto <long> client) { var clientId = client.Data; var query = DbEntities.OrderToStore.Where(e => e.OrderAtoId != null && e.Client.ClientId == clientId) .Select(ExpGetTrackOrderDto()); client.Pager.Total = query.Count(); return(query.OrderByDescending(e => e.OrderToStoreId).Skip(client.Pager.SkipRow).Take(client.Pager.Size).ToList()); }
IList <ProductEntity> GetPaged(PagerDto pager) { var lst = new List <ProductEntity>() { new Mock <ProductEntity>().Object, new Mock <ProductEntity>().Object, new Mock <ProductEntity>().Object, new Mock <ProductEntity>().Object, new Mock <ProductEntity>().Object }.AsQueryable(); return(lst.Paged <ProductEntity>(pager).ToList()); }
public void ItMapsToPagedResultLastPage() { var pager = new PagerDto(4, 1); var items = GetPaged(pager); var result = items.MapPaged <ProductDto>(pager); Assert.Equal(result.Pager.PageIndex, (int)4); Assert.Equal(result.Pager.PageSize, (int)1); Assert.Equal(result.Pager.Total, (int)5); Assert.Equal(result.Pager.PageNumber, (int)5); Assert.False(result.Pager.IsFirstPage); Assert.True(result.Pager.IsLastPage); }
private void GetResultByDailySearch() { OnStatusChanged(SettingsData.Constants.TrackConst.SEARCH_ORDERLIST_ON_PROGRESS, "Buscando pedidos..."); var pagerDto = new PagerDto <DailySearchModel> { Data = (DailySearchModel)_pagerCache.SearchObjValue, Pager = Pager.PagerModel, }; _client.ExecutionProxy.ExecuteRequest <PagerDto <DailySearchModel>, PagerDto <DailySearchModel>, ResponseMessageData <TrackOrderDto>, ResponseMessageData <TrackOrderDto> > (pagerDto, TransferDto.SameType, SharedConstants.Server.TRACK_HUB, SharedConstants.Server.SEARCH_BY_DAILY_INFO_TRACK_HUB_METHOD, TransferDto.SameType) .Subscribe(OnResultSearchOk, OnResultSearchError); }
public ResponseMessageData <TrackOrderDto> SearchByDailyInfo(PagerDto <DailySearchModel> model) { try { return(new ResponseMessageData <TrackOrderDto> { IsSuccess = true, LstData = AppInit.Container.Resolve <ITrackService>().SearchByDailyInfo(model), Pager = model.Pager }); } catch (Exception ex) { SharedLogger.LogError(ex); return(ResponseMessageData <TrackOrderDto> .CreateCriticalMessage("No fue posible obtener los pedidos con esos parámetros")); } }
public ResponseMessageData <TrackOrderDto> SearchByClientName(PagerDto <long> client) { try { return(new ResponseMessageData <TrackOrderDto> { IsSuccess = true, LstData = AppInit.Container.Resolve <ITrackService>().SearchByClient(client), Pager = client.Pager }); } catch (Exception ex) { SharedLogger.LogError(ex); return(ResponseMessageData <TrackOrderDto> .CreateCriticalMessage("No fue posible rastrear por nombre del cliente")); } }
public ResponseMessageData <TrackOrderDto> SearchByPhone(PagerDto <String> phone) { try { var lstData = AppInit.Container.Resolve <ITrackService>().SearchByPhone(phone); return(new ResponseMessageData <TrackOrderDto> { IsSuccess = true, LstData = lstData, Pager = phone.Pager }); } catch (Exception ex) { SharedLogger.LogError(ex); return(ResponseMessageData <TrackOrderDto> .CreateCriticalMessage("No fue posible rastrear por número telefónico")); } }
public IEnumerable <TrackOrderDto> SearchByDailyInfo(PagerDto <DailySearchModel> model) { var dailyInfo = model.Data; var query = DbEntities.OrderToStore.Where(e => e.OrderAtoId != null && ( DbFunctions.TruncateTime(e.StartDatetime) == DbFunctions.TruncateTime(dailyInfo.SearchDate) && ( dailyInfo.StoreId == SettingsData.Constants.Entities.NULL_ID_INT || e.FranchiseStoreId == dailyInfo.StoreId ) && ( dailyInfo.AgentId == String.Empty || e.UserInsId == dailyInfo.AgentId ) )) .Select(ExpGetTrackOrderDto()); model.Pager.ExtraData = query.Sum(e => (decimal?)e.OrderTotal) ?? 0; model.Pager.Total = query.Count(); return(query.OrderByDescending(e => e.OrderToStoreId).Skip(model.Pager.SkipRow).Take(model.Pager.Size).ToList()); }
/// <summary> /// Automapper wrapper. Maps a source object to destination based on mapping configurations /// </summary> public static PagedResultDto <TDestination> MapPaged <TDestination>(this IEnumerable <object> source, PagerDto pager) where TDestination : class { var items = source.MapList <TDestination>(); return(new PagedResultDto <TDestination>(items, pager)); }
public async Task <PagedResultDto <ProductDto> > GetAsync(PagerDto pager, short countryId) { var items = await productRepository.GetAsync(pager, countryId, true); return(items.MapPaged <ProductDto>(pager)); }