public SearchResult <EmployeeCost> Search(DateRangeSearchInfo searchInfo) { string url = string.Format("{0}?page={1}&limit={2}&start={3}&end={4}", ResourceUrl, searchInfo.PageIndex, searchInfo.PageSize, searchInfo.Start, searchInfo.End); return(CreateGetRequest <SearchResult <EmployeeCost> >(Guid.Empty, url)); }
public SearchResult <EmployeeCost> GetByCriteria(int page, int limit, DateTime?start = null, DateTime?end = null) { var searchInfo = new DateRangeSearchInfo { Start = start, End = end, PageIndex = page, PageSize = limit }; return(service.Search(searchInfo)); }
void OnRefresh(object param) { var searchInfo = new DateRangeSearchInfo { Start = startDate, End = endDate, PageIndex = pageIndex, PageSize = pageSize }; var result = costService.Search(searchInfo); CostList = new ObservableCollection <Models.EmployeeCost>(result.Items); TotalRecords = result.Total; DeleteCommand.EntityId = Guid.Empty; }
public SearchResult <HenDepreciation> Search(DateRangeSearchInfo searchInfo) { int start = (searchInfo.PageIndex - 1) * searchInfo.PageSize; var result = new SearchResult <HenDepreciation>(); using (var conn = factory.OpenDbConnection()) { var ev = OrmLiteConfig.DialectProvider.ExpressionVisitor <Models.Data.HenDepreciation>(); if (searchInfo.Start.HasValue && searchInfo.End.HasValue) { ev = ev.Where(e => e.Date >= searchInfo.Start.Value.Date && e.Date <= searchInfo.End.Value.Date); } ev.OrderByDescending(e => e.Date).Limit(start, searchInfo.PageSize); var depreciationList = conn.Select(ev); foreach (var depreciationData in depreciationList) { var list = conn.Where <Models.Data.HenDepreciationDetail>(new { DepreciationId = depreciationData.Id }); var depreciation = MapDataToModel(depreciationData, list); result.Items.Add(depreciation); } if (searchInfo.Start.HasValue && searchInfo.End.HasValue) { result.Total = (int)conn.Count <Models.Data.HenDepreciation>( e => e.Date >= searchInfo.Start.Value.Date && e.Date <= searchInfo.End.Value.Date); } else { result.Total = (int)conn.Count <Models.Data.HenDepreciation>(); } } return(result); }