public JsonResult Get(int page = 1) { var products = db.Products //.Select(n => new { // n.ProductID, // n.ProductName, // n.Dated //}) .OrderBy(n=> n.ProductID); if (page <= 0) { page = 1; } var pageInfo = new PaginationInfo() { PageNumber = page, PagesExists = null, ItemsInPage = 30 }; var paged = products.GetPageData(pageInfo, "Products.Get.Count"); var newPaged = products.ToList().Select(n => new { n.ProductID, n.ProductName, Dated = n.Dated.ToString("dd-MMM-yyyy") }); return Json(newPaged, JsonRequestBehavior.AllowGet); }
public static Response Execute(RelativeUri url) { var thisUrl = url.PathAndQuery.Split('?')[0]; var qs = url.ParseQueryString(); var pageSize = GetPageSize(qs); var pagination = new PaginationInfo( firstItemIndex: GetStartIndex(qs), pageSize: pageSize, totalItemCount: logsQ.Count(), pageUrl: "log.ashx?start=!0&max=" + pageSize); var logs = logsQ.Skip(pagination.FirstItemIndex).Take(pagination.PageSize).ToList(); var v = GetView(qs.AllKeys); var view = v.Value(logs, pagination, thisUrl); return new Response.XDocumentResponse(view, v.Key); }
public static void Execute(HttpContextBase context) { var qs = context.Request.QueryString; var thisUrl = context.Request.Url.ToString().Split('?')[0]; var pageSize = GetPageSize(qs); var pagination = new PaginationInfo( firstItemIndex: GetStartIndex(qs), pageSize: pageSize, totalItemCount: logsQ.Count(), pageUrl: "log.ashx?start=!0&max=" + pageSize); var logs = logsQ.Skip(pagination.FirstItemIndex).Take(pagination.PageSize).ToList(); var v = GetView(qs.AllKeys); var view = v.Value(logs, pagination, thisUrl); context.Response.XDocument(view, contentType: v.Key); }
public override IResult Execute(HttpContextBase context) { var qs = context.Request.QueryString; var thisUrl = context.Request.Url.ToString().Split('?')[0]; var pageSize = GetPageSize(qs); var pagination = new PaginationInfo { FirstItemIndex = GetStartIndex(qs), PageSize = pageSize, TotalItemCount = logsQ.Count(), PageUrl = "log.ashx?start=!0&max=" + pageSize, }; var logs = logsQ.Skip(pagination.FirstItemIndex).Take(pagination.PageSize).ToList(); var v = GetView(qs.AllKeys); var view = v.Value(logs, pagination, thisUrl); return new XDocResult(view) { ContentType = v.Key, }; }
public void tt() { var p = new PaginationInfo( firstItemIndex: 350, pageSize: 25, pageSlide: 2, totalItemCount: 398, pageUrl: ""); Assert.AreEqual(16, p.LastPage); Assert.AreEqual(15, p.CurrentPage); Assert.IsTrue(p.HasNextPage); var pages = p.Pages.ToArray(); Assert.AreEqual(5, pages.Length); Assert.AreEqual(12, pages[0]); Assert.AreEqual(13, pages[1]); Assert.AreEqual(14, pages[2]); Assert.AreEqual(15, pages[3]); Assert.AreEqual(16, pages[4]); }
public void tt() { var p = new PaginationInfo { FirstItemIndex = 350, PageSize = 25, PageSlide = 2, TotalItemCount = 398, }; Assert.AreEqual(16, p.LastPage); Assert.AreEqual(15, p.CurrentPage); Assert.IsTrue(p.HasNextPage); var pages = p.Pages.ToArray(); Assert.AreEqual(5, pages.Length); Assert.AreEqual(12, pages[0]); Assert.AreEqual(13, pages[1]); Assert.AreEqual(14, pages[2]); Assert.AreEqual(15, pages[3]); Assert.AreEqual(16, pages[4]); }
public List <MaterialInfo> Get_Materials_By_Vendor_Id(int vendor_Id, ref PaginationInfo pager) { return(_materialRepo.Get_Materials_By_Vendor_Id(vendor_Id, ref pager)); }
public List <MaterialCategoryInfo> Get_Material_Categories(ref PaginationInfo pager) { return(_materialRepo.Get_Material_Categories(ref pager)); }
public List <MaterialSubCategoryInfo> Get_Material_SubCategories(int Material_Category_Id, ref PaginationInfo pager) { return(_materialRepo.Get_Material_SubCategories(Material_Category_Id, ref pager)); }
public PaginationInfo GetPageInfo(int perCyclePerson, int pageNumber) { var pageInfo = new PaginationInfo { ItemsInPage = perCyclePerson, PageNumber = pageNumber, }; return pageInfo; }
public static Object ConvertToSDKResponse(Object toReturn, RESTResponse response, ref PaginationInfo paginationInfo) { if (response != null && response.Result != null) { paginationInfo = response.Page; return(ConvertToSDKResponse(toReturn, response)); } return(null); }
public async Task <IActionResult> Get(PaginationInfo paginationInfo) { var result = await _contact.GetAll(paginationInfo); return(await GetResult(result)); }
public async Task <IActionResult> Filter([FromBody] List <ColumnFilterInfo> columnFilterInfos, PaginationInfo paginationInfo) { return(await GetResult(await _contact.Filter(columnFilterInfos, paginationInfo))); }
public List <CustomerQualityInfo> Get_Customer_Qualities_By_Customer_Id_By_Quality_Id(int customer_Id, int quality_Id, ref PaginationInfo pager) { return(_customerqualityRepo.Get_Customer_Qualities_By_Customer_Id_By_Quality_Id(customer_Id, quality_Id, ref pager)); }
public List <CustomerQualityInfo> Get_Customer_Qualities(ref PaginationInfo pager) { return(_customerqualityRepo.Get_Customer_Qualities(ref pager)); }
/// <summary> /// The actual Work to be done. /// </summary> protected override void Execute() { List <TranscriptionModel> newlist = new List <TranscriptionModel>(); Expression <Func <transcription, bool> > predicate = PredicateBuilder.True <transcription>(); predicate = predicate.And(p => p.TranscriptStatus == false); if (Request.FilterKeyWords != null && Request.FilterKeyWords.Count > 0) { foreach (string keyword in Request.FilterKeyWords) { WellKnownTranscriptionQueueOption option = (WellKnownTranscriptionQueueOption)Enum.Parse( typeof(WellKnownTranscriptionQueueOption), keyword, true); switch (option) { case WellKnownTranscriptionQueueOption.All: break; case WellKnownTranscriptionQueueOption.Priority: predicate = predicate.And(p => p.IsPriority == true); break; case WellKnownTranscriptionQueueOption.Transcribed: predicate = predicate.And(p => !string.IsNullOrEmpty(p.TranscriberAssigned)); break; case WellKnownTranscriptionQueueOption.AuditCheck: predicate = predicate.And(p => !string.IsNullOrEmpty(p.AuditCheckCompleted)); break; case WellKnownTranscriptionQueueOption.FirstEdit: predicate = predicate.And(p => !string.IsNullOrEmpty(p.FirstEditCompleted)); break; case WellKnownTranscriptionQueueOption.SecondEdit: predicate = predicate.And(p => !string.IsNullOrEmpty(p.SecondEditCompleted)); break; case WellKnownTranscriptionQueueOption.DraftSent: predicate = predicate.And(p => !string.IsNullOrEmpty(p.DraftSentDate.ToString())); break; case WellKnownTranscriptionQueueOption.Corrections: predicate = predicate.And(p => !string.IsNullOrEmpty(p.EditWithCorrectionCompleted)); break; case WellKnownTranscriptionQueueOption.FinalEdit: predicate = predicate.And(p => !string.IsNullOrEmpty(p.FinalEditCompleted)); break; case WellKnownTranscriptionQueueOption.SentOut: predicate = predicate.And(p => !string.IsNullOrEmpty(p.FinalSentDate.ToString())); break; default: break; } } } if (!string.IsNullOrEmpty(Request.SearchWord)) { predicate = predicate.And(p => p.Interviewer.Contains(Request.SearchWord) || p.AuditCheckCompleted.Contains(Request.SearchWord) || p.AccessFileLocation.Contains(Request.SearchWord) || p.CoverageSpatial.Contains(Request.SearchWord) || p.CoverageTemporal.Contains(Request.SearchWord) || p.Description.Contains(Request.SearchWord) || p.EditWithCorrectionCompleted.Contains(Request.SearchWord) || p.AudioEquipmentUsed.Contains(Request.SearchWord) || p.VideoEquipmentUsed.Contains(Request.SearchWord) || p.FileName.Contains(Request.SearchWord) || p.FinalEditCompleted.Contains(Request.SearchWord) || p.FirstEditCompleted.Contains(Request.SearchWord) || p.Format.Contains(Request.SearchWord) || p.Identifier.Contains(Request.SearchWord) || p.InitialNote.Contains(Request.SearchWord) || p.Interviewee.Contains(Request.SearchWord) || p.InterviewerNote.Contains(Request.SearchWord) || p.Keywords.Contains(Request.SearchWord) || p.RestrictionNote.Contains(Request.SearchWord) || p.Place.Contains(Request.SearchWord) || p.ProjectCode.Contains(Request.SearchWord) || p.Publisher.Contains(Request.SearchWord) || p.ReasonForPriority.Contains(Request.SearchWord) || p.RelationIsPartOf.Contains(Request.SearchWord) || p.Rights.Contains(Request.SearchWord) || p.ScopeAndContents.Contains(Request.SearchWord) || p.SecondEditCompleted.Contains(Request.SearchWord) || p.Rights.Contains(Request.SearchWord) || p.Title.Contains(Request.SearchWord) || p.Subject.Contains(Request.SearchWord) || p.TranscriberAssigned.Contains(Request.SearchWord) || p.TranscriptLocation.Contains(Request.SearchWord) || p.Transcript.Contains(Request.SearchWord) || p.TranscriptNote.Contains(Request.SearchWord) || p.Type.Contains(Request.SearchWord) ); } IPagedList <transcription> pagedTransactionList = TranscriptionRepository.FindBy(predicate). OrderBy(t => t.Title).ToPagedList(Request.SearchRequest.CurrentPage, Request.SearchRequest.ListLength); PaginationInfo page = page = new PaginationInfo() { CurrentPage = pagedTransactionList.PageNumber, TotalListLength = pagedTransactionList.TotalItemCount, TotalPages = pagedTransactionList.PageCount, ListLength = pagedTransactionList.PageSize }; foreach (transcription item in pagedTransactionList.ToList()) { newlist.Add(Util.ConvertToTranscriptionModel(item)); } Response = new ResponseModel() { PaginationInfo = page, Transcriptions = newlist, IsOperationSuccess = true }; }
public DataTable GetRoles(string roleName, ref PaginationInfo pager) { return(_roleRepo.GetRoles(roleName, ref pager)); }
public SightSeeingTariffViewModel() { //For Sight Seeing Tariff SightSeeingTariff = new SightSeeingTariffInfo(); SightSeeingTariffs = new List <SightSeeingTariffInfo>(); Filter = new SightSeeingTariffFilter(); Vendors = new List <VendorInfo>(); SightSeeings = new List <SightSeeingInfo>(); Meals = new List <MealInfo>(); Occupancies = new List <OccupancyInfo>(); Pager = new PaginationInfo(); FriendlyMessage = new List <FriendlyMessage>(); //for date details SightSeeingTariffDate = new SightSeeingTariffDateInfo(); SightSeeingTariffDates = new List <SightSeeingTariffDateInfo>(); //For Duration Durations = new List <DurationInfo>(); Duration = new DurationInfo(); DurationFilter = new DurationFilter(); //for sight seeing duration SightSeeingTariffDuration = new SightSeeingTariffDurationInfo(); SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>(); SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter(); //For Sight Seeing Tariff Occupancy SightSeeingTariffOccupancy = new SightSeeingTariffOccupancyInfo(); SightSeeingTariffOccupancies = new List <SightSeeingTariffOccupancyInfo>(); SightSeeingTariffOccupancyFilter = new SightSeeingTariffOccupancyFilter(); //For tax formula LstStandardCharges = new List <ChargesInfo>(); LstTaxFormula = new List <TaxFormulaInfo>(); LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>(); //For Sight Seeing Details SightSeeingDetails = new List <SightSeeingDetailInfo>(); SightSeeingDetail = new SightSeeingDetailInfo(); SightSeeingDetailFilter = new SightSeeingDetailFilter(); //For Sight Seeing Tariff Price SightSeeingTariffPrice = new SightSeeingTariffPriceInfo(); SightSeeingTariffPrices = new List <SightSeeingTariffPriceInfo>(); SightSeeingTariffPriceFilter = new SightSeeingTariffPriceFilter(); //For Sight Seeing Tariff Duration SightSeeingTariffDuration = new SightSeeingTariffDurationInfo(); SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>(); SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter(); //for Customer Category SightSeeingTariffCustomerCategory = new SightSeeingTariffCustomerCategoryInfo(); SightSeeingTariffCustomerCategories = new List <SightSeeingTariffCustomerCategoryInfo>(); CustomerCategory = new CustomerCategoryInfo(); CustomerCategories = new List <CustomerCategoryInfo>(); SightSeeingTariffCustomerCategoryFilter = new SightSeeingTariffCustomerCategoryFilter(); }
// 病案检索 public PagingRtnData <QaPatListDTO> getMrRetrievalPatList(QryRootNodeDTO qryRootNodeDTO, PaginationInfo paginationInfo) { List <object> param = new List <object>(); param.Add(qryRootNodeDTO); param.Add(paginationInfo); si.url = url; PagingRtnData <QaPatListDTO> rtn = si.invokePaging <QaPatListDTO>("getMrRetrievalPatList", param.ToArray()); return(rtn); }
public DataTable GetStates(int countryId, string stateCode, string stateName, ref PaginationInfo pager) { List <SqlParameter> sqlParam = new List <SqlParameter>(); sqlParam.Add(new SqlParameter("@CountryId", countryId)); sqlParam.Add(new SqlParameter("@StateCode", stateCode)); sqlParam.Add(new SqlParameter("@StateName", stateName)); DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, StoredProcedureEnum.sp_Get_States.ToString(), CommandType.StoredProcedure); return(CommonMethods.GetPaginatedTable(dt, ref pager)); }
public List <MaterialInfo> Get_Materials(ref PaginationInfo pager) { return(_materialRepo.Get_Materials(ref pager)); }
/// <summary> /// Lists organizations for a user. /// </summary> /// <param name="userId">The ID of the user for which you want to retrieve the organizations.</param> /// <param name="pagination">Specifies pagination info to use when requesting paged results.</param> /// <returns>An <see cref="IPagedList{Organization}"/> containing the list of organizations.</returns> public Task <IPagedList <Organization> > GetAllOrganizationsAsync(string userId, PaginationInfo pagination) { if (pagination == null) { throw new ArgumentNullException(nameof(pagination)); } return(Connection.GetAsync <IPagedList <Organization> >(BuildUri($"users/{EncodePath(userId)}/organizations", new Dictionary <string, string> { { "page", pagination.PageNo.ToString() }, { "per_page", pagination.PerPage.ToString() }, { "include_totals", pagination.IncludeTotals.ToString().ToLower() }, }), DefaultHeaders, organizationsConverters)); }