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);
 }
Ejemplo n.º 3
0
 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]);
 }
Ejemplo n.º 7
0
 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));
 }
Ejemplo n.º 8
0
 public List <MaterialCategoryInfo> Get_Material_Categories(ref PaginationInfo pager)
 {
     return(_materialRepo.Get_Material_Categories(ref pager));
 }
Ejemplo n.º 9
0
 public List <MaterialSubCategoryInfo> Get_Material_SubCategories(int Material_Category_Id, ref PaginationInfo pager)
 {
     return(_materialRepo.Get_Material_SubCategories(Material_Category_Id, ref pager));
 }
Ejemplo n.º 10
0
        public PaginationInfo GetPageInfo(int perCyclePerson, int pageNumber)
        {
            var pageInfo = new PaginationInfo
            {
                ItemsInPage = perCyclePerson,
                PageNumber = pageNumber,

            };
            return pageInfo;
        }
Ejemplo n.º 11
0
 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);
 }
Ejemplo n.º 12
0
        public async Task <IActionResult> Get(PaginationInfo paginationInfo)
        {
            var result = await _contact.GetAll(paginationInfo);

            return(await GetResult(result));
        }
Ejemplo n.º 13
0
 public async Task <IActionResult> Filter([FromBody] List <ColumnFilterInfo> columnFilterInfos, PaginationInfo paginationInfo)
 {
     return(await GetResult(await _contact.Filter(columnFilterInfos, paginationInfo)));
 }
Ejemplo n.º 14
0
 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));
 }
Ejemplo n.º 15
0
 public List <CustomerQualityInfo> Get_Customer_Qualities(ref PaginationInfo pager)
 {
     return(_customerqualityRepo.Get_Customer_Qualities(ref pager));
 }
Ejemplo n.º 16
0
        /// <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
            };
        }
Ejemplo n.º 17
0
 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();
        }
Ejemplo n.º 19
0
        // 病案检索
        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);
        }
Ejemplo n.º 20
0
        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));
        }
Ejemplo n.º 21
0
 public List <MaterialInfo> Get_Materials(ref PaginationInfo pager)
 {
     return(_materialRepo.Get_Materials(ref pager));
 }
Ejemplo n.º 22
0
        /// <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));
        }