PagingResult <CMSPageViewModel> ICMSManager.GetCMSPageList(Models.PagingModel model)
{
var result = new PagingResult <CMSPageViewModel>();
var query = Context.CMSPages.OrderBy(model.SortBy + " " + model.SortOrder);
if (!string.IsNullOrEmpty(model.Search))
{
query = query.Where(z => z.PageName.Contains(model.Search) || z.PageTitle.Contains(model.Search));
}
var list = query
.Skip(model.PageNo - 1).Take(model.RecordsPerPage)
.ToList().Select(x => new CMSPageViewModel(x)).ToList();
result.List = list;
result.Status = ActionStatus.Successfull;
result.Message = "Page List";
result.TotalCount = query.Count();
return(result);
}
public PageOf <SkuInfo> GetProductInventoryList(InventoryListViewModel queryModel, LanguageEnum languageEnum, Models.PagingModel page)
{
var ds = productDAL.GetProductInventoryList(queryModel, languageEnum, page);
return(new PageOf <SkuInfo>()
{
PageIndex = page.PageIndex,
PageSize = page.PageSize,
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
RowCount = Convert.ToInt32(ds.Tables[1].Rows[0][1]),
Items = DataMapHelper.DataSetToList <SkuInfo>(ds)
});
}
public PageOf <ProductAuditingListModel> GetProductList(ProductAuditingQuyModel queryInfo, LanguageEnum languageEnum, Models.PagingModel page)
{
return(productDAL.GetProductList(queryInfo, languageEnum, page));
}
private void RenderPaging(Models.RenderingModel model, StringBuilder sbHtml)
{
if (model.PagingModel == null)
{
return;
}
Models.PagingModel pagingModel = model.PagingModel;
sbHtml.Append("<div class=\"row\">");
sbHtml.Append("<div class=\"col-xs-6\">");
sbHtml.AppendFormat(model.SummaryMessage,
pagingModel.FirstRecord, pagingModel.LastRecord, pagingModel.TotalRecords
);
sbHtml.Append("</div>");
sbHtml.Append("<div class=\"col-xs-6\">");
int pageToStart;
int pageToEnd;
pagingModel.CalculatePageStartAndEnd(5, out pageToStart, out pageToEnd);
sbHtml.Append("<ul class='pagination pull-right' style='margin-top: 0;'>");
sbHtml.Append("<li");
if (pageToStart == pagingModel.CurrentPage)
{
sbHtml.Append(" class='disabled'");
}
sbHtml.Append(">");
sbHtml.AppendFormat("<a href='#' aria-label='{0}' ", model.PreviousButtonCaption);
if (pageToStart < pagingModel.CurrentPage && pagingModel.PageLinks.Count > (pagingModel.CurrentPage - 1))
{
sbHtml.AppendFormat("onclick='{0}'", pagingModel.PageLinks[pagingModel.CurrentPage - 1]);
}
else
{
sbHtml.AppendFormat("onclick='{0}'", "return false;");
}
sbHtml.Append(">");
sbHtml.AppendFormat("<span aria-hidden='true'>« {0}</span></a></li>", model.PreviousButtonCaption);
for (int i = pageToStart; i <= pageToEnd; i++)
{
sbHtml.Append("<li");
if (i == pagingModel.CurrentPage)
{
sbHtml.Append(" class='active'");
}
sbHtml.Append(">");
sbHtml.AppendFormat("<a href='#' onclick='{0}'>{1}</a></li>", pagingModel.PageLinks[i], i);
}
sbHtml.Append("<li");
if (pageToEnd == pagingModel.CurrentPage)
{
sbHtml.Append(" class='disabled'");
}
sbHtml.Append(">");
sbHtml.AppendFormat("<a href='#' aria-label='{0}' ", model.NextButtonCaption);
if (pageToEnd > pagingModel.CurrentPage)
{
sbHtml.AppendFormat("onclick='{0}'", pagingModel.PageLinks[pagingModel.CurrentPage + 1]);
}
else
{
sbHtml.AppendFormat("onclick='{0}'", "return false;");
}
sbHtml.Append(">");
sbHtml.AppendFormat("<span aria-hidden='true'>{0} »</span></a></li>", model.NextButtonCaption);
sbHtml.Append("</ul>");
sbHtml.Append("</div>");
sbHtml.Append("</div>");
}
