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