public ActionResult Suppliers(PagedData<Supplier> model) {
model.ToggleSort();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm<Supplier>(db.Suppliers, srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = db.Suppliers.Count();
ModelState.Clear();
return View(model);
}
public ActionResult Suppliers(PagedData <Supplier> model)
{
model.ToggleSort();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm <Supplier>(db.Suppliers, srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = db.Suppliers.Count();
ModelState.Clear();
return(View(model));
}
public ActionResult Index(PagedData<tblGalleryImage> model) {
model.ToggleSort();
var srt = model.ParseSort();
using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) {
IQueryable<tblGalleryImage> query = (from c in db.tblGalleryImages select c);
query = query.SortByParm<tblGalleryImage>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = (from c in db.tblGalleryImages select c).Count();
}
ModelState.Clear();
return View(model);
}
public ActionResult Index(PagedData <tblGalleryImage> model)
{
model.ToggleSort();
var srt = model.ParseSort();
using (PhotoGalleryDataContext db = PhotoGalleryDataContext.GetDataContext()) {
IQueryable <tblGalleryImage> query = (from c in db.tblGalleryImages select c);
query = query.SortByParm <tblGalleryImage>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = (from c in db.tblGalleryImages select c).Count();
}
ModelState.Clear();
return(View(model));
}
public ActionResult Index(PagedData<GalleryGroup> model) {
GalleryHelper gh = new GalleryHelper(this.SiteID);
model.ToggleSort();
var srt = model.ParseSort();
List<GalleryGroup> lst = gh.GalleryGroupListGetBySiteID();
IQueryable<GalleryGroup> query = lst.AsQueryable();
query = query.SortByParm<GalleryGroup>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * model.PageNumberZeroIndex).Take(model.PageSize).ToList();
model.TotalRecords = lst.Count();
ModelState.Clear();
return View(model);
}
public ActionResult Index(PagedData <GalleryGroup> model)
{
GalleryHelper gh = new GalleryHelper(this.SiteID);
model.ToggleSort();
var srt = model.ParseSort();
List <GalleryGroup> lst = gh.GalleryGroupListGetBySiteID();
IQueryable <GalleryGroup> query = lst.AsQueryable();
query = query.SortByParm <GalleryGroup>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * model.PageNumberZeroIndex).Take(model.PageSize).ToList();
model.TotalRecords = lst.Count();
ModelState.Clear();
return(View(model));
}
public ActionResult Index(PagedData <carrot_FaqCategory> model)
{
model.ToggleSort();
var srt = model.ParseSort();
List <carrot_FaqCategory> lst = null;
using (FaqHelper fh = new FaqHelper(this.SiteID)) {
lst = fh.CategoryListGetBySiteID();
}
IQueryable <carrot_FaqCategory> query = lst.AsQueryable();
query = query.SortByParm <carrot_FaqCategory>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * model.PageNumberZeroIndex).Take(model.PageSize).ToList();
model.TotalRecords = lst.Count();
ModelState.Clear();
return(View(model));
}
private PagedData <Employee> GetEmpData(PagedData <Employee> model)
{
List <Employee> lst = new List <Employee>();
model.PageSize = 5;
model.ToggleSort();
var srt = model.ParseSort();
model.DataSource = new List <Employee>();
IQueryable <Employee> query = (from c in db.Employees select c);
query = query.SortByParm <Employee>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = (from c in db.Employees select c).Count();
ViewBag.TerritoryList = db.Territories.ToList();
model.SortByNew = String.Empty;
return(model);
}
public ActionResult ContentSnippetIndex(PagedData<ContentSnippet> model) {
model.ToggleSort();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm<ContentSnippet>(SiteData.CurrentSite.GetContentSnippetList(), srt.SortField, srt.SortDirection);
model.TotalRecords = -1;
model.DataSource = query.ToList();
ModelState.Clear();
return View(model);
}
public ActionResult RoleIndex(PagedData<UserRole> model) {
model.ToggleSort();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm<UserRole>(SecurityData.GetRoleList(), srt.SortField, srt.SortDirection);
model.TotalRecords = -1;
model.DataSource = query.ToList();
ModelState.Clear();
return View(model);
}
public ActionResult UserIndex(PagedData<ExtendedUserData> model) {
model.ToggleSort();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm<ExtendedUserData>(ExtendedUserData.GetUserList(), srt.SortField, srt.SortDirection);
model.TotalRecords = -1;
model.DataSource = query.ToList();
ModelState.Clear();
return View(model);
}
public ActionResult SiteSkinIndex(PagedData<CMSTemplate> model) {
model.ToggleSort();
var templates = cmsHelper.Templates.Where(x => x.TemplatePath.ToLowerInvariant() != SiteData.DefaultTemplateFilename.ToLowerInvariant()).ToList();
var srt = model.ParseSort();
var query = ReflectionUtilities.SortByParm<CMSTemplate>(templates, srt.SortField, srt.SortDirection);
model.TotalRecords = -1;
model.DataSource = query.ToList();
ModelState.Clear();
return View(model);
}
private PagedData<Employee> GetEmpData(PagedData<Employee> model) {
List<Employee> lst = new List<Employee>();
model.PageSize = 5;
model.ToggleSort();
var srt = model.ParseSort();
model.DataSource = new List<Employee>();
IQueryable<Employee> query = (from c in db.Employees select c);
query = query.SortByParm<Employee>(srt.SortField, srt.SortDirection);
model.DataSource = query.Skip(model.PageSize * (model.PageNumber - 1)).Take(model.PageSize).ToList();
model.TotalRecords = (from c in db.Employees select c).Count();
ViewBag.TerritoryList = db.Territories.ToList();
model.SortByNew = String.Empty;
return model;
}
