public async Task <ActionResult> GetPropertiesBL(int iPageno, string sSortName, string sLocationKey, int iServiceId, int iLocationID, int iCategoryId, int iTypeId, int idevhold, int iminbed, int imaxbed, int iminPrice, int[] fixtures, int imaxPrice, int[] views) { string sCriteria = ""; int iPageSize = Convert.ToInt32(StringConstants.PAGE_SIZE); PagedPropertyViews pagedView = new PagedPropertyViews(); //IEnumerable<PropertyModelView> PropertyModels; try { if (Request.IsAjaxRequest()) { sCriteria = GetCriteria(iServiceId, iLocationID, iCategoryId, iTypeId, idevhold, iminbed, imaxbed, iminPrice, imaxPrice, fixtures, views); if (sCriteria == null || sCriteria == "") { var query = new Sql().Select("*").From(TABLE_NAME); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count(); //IEnumerable<PropertyModelView> PropertyModels = db.Fetch<PropertyModelView>(new Sql().Select("*").From(TABLE_NAME)).OrderBy(m => m.PropertyId).Skip(pagesize * (pagenumber - 1)).Take(pagesize).ToList(); pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } else { var query = new Sql().Select("*").From(TABLE_NAME).Where(sCriteria); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count(); //IEnumerable<PropertyModelView> PropertyModels = db.Fetch<PropertyModelView>(new Sql().Select("*").From(TABLE_NAME).Where(sCriteria)).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } } else { var query = new Sql().Select("*").From(TABLE_NAME); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count(); pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } pagedView.TotalPages = Convert.ToInt32(Math.Ceiling((double)pagedView.TotalRecords / iPageSize)); pagedView.CurrentPage = iPageno; SetPagingValues(ref pagedView); FillPropertyViewModel(ref pagedView.PropertyModels); return(PartialView(StringConstants.PARTIAL_VIEW_PATH + PARTIAL_VIEW_LIST, await Task.FromResult(pagedView))); } catch (Exception x) { //log the error return(null); } }
public async Task <ActionResult> GetProperties(int iPageno, string sSortName, string sCriteria) { int iPageSize = Convert.ToInt32(StringConstants.PAGE_SIZE); PagedPropertyViews pagedView = new PagedPropertyViews(); //IEnumerable<PropertyModelView> PropertyModels; try { if (Request.IsAjaxRequest()) { if (sCriteria == null || sCriteria == "") { var query = new Sql().Select("*").From(TABLE_NAME); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count; pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } else { //sCriteria = "serviceType='1'"; var query = new Sql().Select("*").From(TABLE_NAME).Where(sCriteria); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count; pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } } else { var query = new Sql().Select("*").From(TABLE_NAME); pagedView.TotalRecords = db.Fetch <PropertyViewModel>(query).Count; pagedView.PropertyModels = db.Fetch <PropertyViewModel>(query).OrderBy(m => m.PropertyId).Skip(iPageSize * (iPageno - 1)).Take(iPageSize).ToList(); } pagedView.CurrentPage = iPageno; FillPropertyViewModel(ref pagedView.PropertyModels); return(PartialView(StringConstants.PARTIAL_VIEW_PATH + PARTIAL_VIEW_LIST, await Task.FromResult(pagedView))); } catch (Exception x) { return(null); } }
private void SetPagingValues(ref PagedPropertyViews pager) { pager.StartPage = pager.CurrentPage - 5; pager.EndPage = pager.CurrentPage + 4; if (pager.StartPage <= 0) { pager.EndPage -= (pager.StartPage - 1); pager.StartPage = 1; } if (pager.EndPage > pager.TotalPages) { pager.EndPage = pager.TotalPages; if (pager.EndPage > 10) { pager.StartPage = pager.EndPage - 9; } } }
public async Task <ActionResult> GetAgents(int iPageno, string sSortName, string sAgentId, string sCategory, string sService, string sCity) { int iPageSize = Convert.ToInt32(StringConstants.PAGE_SIZE); PagedAgentCMSView pagedView = new PagedAgentCMSView(); try { if (Request.IsAjaxRequest()) { //AdvSearchModel srchModel = new AdvSearchModel(); var searcher = Examine.ExamineManager.Instance.SearchProviderCollection[StringConstants.EXMINE_MEM_SEARCHER_NAME]; IEnumerable <SearchResult> pagedResults; IBooleanOperation query = GetCriteria(sAgentId, sCategory, sService, sCity, ref searcher); //Get the search result var results = searcher.Search(query.Compile()); if (results.Count() > 0) { pagedView.TotalRecords = results.Count(); } else { pagedView.TotalRecords = 0; } pagedResults = results.Skip((iPageno - 1) * iPageSize).Take(iPageSize); if (pagedResults.Count() > 0) { //Prepare Property Models to be displayed on the result page List <AgentViewCMSModel> properties = new List <AgentViewCMSModel>(); foreach (var result in pagedResults) { AgentViewCMSModel item = new AgentViewCMSModel(); //IMember member = Services.MemberService.GetById(Convert.ToInt32(result.Fields["id"])); IPublishedContent node = Members.GetById(Convert.ToInt32(result.Fields["id"])); item = MapNodeToModel(node); properties.Add(item); } pagedView.CMSAgents = properties; } } pagedView.TotalPages = Convert.ToInt32(Math.Ceiling((double)pagedView.TotalRecords / iPageSize)); pagedView.CurrentPage = iPageno; SetPagingValues(ref pagedView); PagedPropertyViews pagedresults = new PagedPropertyViews(); //PagedPropertyCMSView pgrslt = new PagedPropertyCMSView(); return(PartialView(StringConstants.PARTIAL_VIEW_PATH + PARTIAL_VIEW_LIST, await System.Threading.Tasks.Task.FromResult(pagedView))); } catch (Exception x) { //log the error return(null); } }
public async Task <ActionResult> GetBlogPostList(int iPageno, string sSortName) { int iPageSize = Convert.ToInt32(StringConstants.BLOG_PAGE_SIZE); PagedBlogPostCMSViewModel pagedView = new PagedBlogPostCMSViewModel(); //IEnumerable<IPublishedContent> pagedResults; try { if (Request.IsAjaxRequest()) { RealHomesDataTypesCMSModel settingsName = new RealHomesDataTypesCMSModel(); //Get the All the posts under blog content node var results = Umbraco.TypedContent(WebConfigurationManager.AppSettings[settingsName.BLOGMAINCT_SETTING_NAME]).Children(); if (results.Count() > 0) { pagedView.TotalRecords = results.Count(); } else { pagedView.TotalRecords = 0; } //filtered results for requested page var pagedResults = results.Skip((iPageno - 1) * iPageSize).Take(iPageSize); if (pagedResults.Count() > 0) { //Prepare Property Models to be displayed on the result page List <BlogPostCMSViewModel> BlogPosts = new List <BlogPostCMSViewModel>(); foreach (var result in pagedResults) { BlogPostCMSViewModel Post = new BlogPostCMSViewModel(); //IPublishedContent node = Umbraco.Content(result.Id); Post = MapNodeToModel(result); BlogPosts.Add(Post); } pagedView.BlogPostModels = BlogPosts; } } pagedView.TotalPages = Convert.ToInt32(Math.Ceiling((double)pagedView.TotalRecords / iPageSize)); pagedView.CurrentPage = iPageno; SetPagingValues(ref pagedView); PagedPropertyViews pagedresults = new PagedPropertyViews(); return(PartialView(StringConstants.PARTIAL_VIEW_PATH + PARTIAL_VIEW_LIST, await System.Threading.Tasks.Task.FromResult(pagedView))); } catch (Exception x) { //log the error return(null); } }