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