//public void GetInitialFilters(int academicYear)
public async Task EmployeeSearch(string name)
{
// Arrange
#region UserProfile (not necessary in this test)
//NOTE: This is a mock (use it when needed to insert it to the new controller/engine instance)
//Set UserProfile from Mock User (Set values for scenarios)
var userProfile = this.BuildUserProfile(new List <Claim>()
{
new Claim("centerid", "356")
}, new List <string>()
{
"my.custom.permission"
});
#endregion
//Set in Controller
_Controller = ObjectContainer.GetService <EmployeeApiController>();
// Act
PagedListViewModel <EmployeeViewModel> result = await _Controller.SearchAsync(name);
// Asserts
Assert.IsNotNull(result.Data.Length > 0, "Should return something");
}
public virtual PagedListViewModel <VisitorLog> List(ApiCall call)
{
string weekname = call.GetValue("weekname");
var log = call.WebSite.SiteDb().VisitorLog;
if (!string.IsNullOrEmpty(weekname))
{
log = call.WebSite.SiteDb().LogByWeek <VisitorLog>(weekname);
}
var pager = ApiHelper.GetPager(call, 50);
PagedListViewModel <VisitorLog> result = new PagedListViewModel <VisitorLog>();
var alllog = log.Take(false, 0, Kooboo.Data.AppSettings.MaxVisitorLogRead);
var total = alllog.Count();
result.TotalCount = total;
result.TotalPages = ApiHelper.GetPageCount(total, pager.PageSize);
result.PageNr = pager.PageNr;
List <VisitorLog> logs = alllog.Skip(pager.SkipCount).Take(pager.PageSize).ToList();
result.List = logs;
return(result);
}
public PagedListViewModel <ExternalResourceItemViewModel> External(ApiCall call)
{
var sitedb = call.WebSite.SiteDb();
var pager = ApiHelper.GetPager(call, 50);
PagedListViewModel <ExternalResourceItemViewModel> result = new PagedListViewModel <ExternalResourceItemViewModel>();
var alllinks = sitedb.ExternalResource.All();
var total = alllinks.Count;
result.TotalCount = total;
result.TotalPages = ApiHelper.GetPageCount(total, pager.PageSize);
result.PageNr = pager.PageNr;
List <ExternalResourceItemViewModel> list = new List <ExternalResourceItemViewModel>();
var items = alllinks.OrderBy(o => o.Name).Skip(pager.SkipCount).Take(pager.PageSize);
foreach (var item in items)
{
ExternalResourceItemViewModel model = new ExternalResourceItemViewModel();
model.Id = item.Id;
model.FullUrl = item.FullUrl;
model.ResourceType = ConstObjectType.GetName(item.DestinationObjectType);
model.LastModified = item.LastModified;
model.Relations = Sites.Helper.RelationHelper.Sum(sitedb.ExternalResource.GetUsedBy(item.Id));
list.Add(model);
}
result.List = list;
return(result);
}
public void Can_Paginate()
{
// Arrange
Mock <IProjectRepository> mock = new Mock <IProjectRepository>();
mock.Setup(m => m.Projects).Returns((new Project[] {
new Project {
ProjectID = 1, Name = "P1"
},
new Project {
ProjectID = 2, Name = "P2"
},
new Project {
ProjectID = 3, Name = "P3"
},
new Project {
ProjectID = 4, Name = "P4"
},
new Project {
ProjectID = 5, Name = "P5"
}
}).AsQueryable <Project>());
ProjectsController controller = new ProjectsController(mock.Object);
controller.PageSize = 3;
// Act
PagedListViewModel <Project> result = controller.List(2).ViewData.Model as PagedListViewModel <Project>;
// Assert
Project[] prodArray = result.Entities.ToArray();
Assert.True(prodArray.Length == 2);
Assert.Equal("P4", prodArray[0].Name);
Assert.Equal("P5", prodArray[1].Name);
}
public PagedListViewModel <TextContentViewModel> ByFolder(Guid FolderId, ApiCall call)
{
int pagesize = ApiHelper.GetPageSize(call, 50);
int pagenr = ApiHelper.GetPageNr(call);
string language = Kooboo.Data.Language.LanguageSetting.GetCmsSiteLangCode(call.Context, call.WebSite);
PagedListViewModel <TextContentViewModel> model = new PagedListViewModel <TextContentViewModel>();
model.PageNr = pagenr;
model.PageSize = pagesize;
var textContents = call.WebSite.SiteDb().TextContent.Query.Where(it => it.FolderId == FolderId).SelectAll();
model.TotalCount = textContents.Count();
model.TotalPages = ApiHelper.GetPageCount(model.TotalCount, model.PageSize);
var list = textContents.OrderByDescending(o => o.LastModified).Skip(model.PageNr * model.PageSize - model.PageSize).Take(model.PageSize).ToList();
var contenttype = call.Context.WebSite.SiteDb().ContentTypes.GetByFolder(FolderId);
model.List = new List <TextContentViewModel>();
foreach (var item in list)
{
model.List.Add(Sites.Helper.ContentHelper.ToListDisplayView(item, contenttype, language));
}
return(model);
}
public PagedListViewModel <IDictionary <string, object> > Data(ApiCall call)
{
var db = Kooboo.Data.DB.GetKDatabase(call.Context.WebSite);
var table = db.GetOrCreateTable(call.GetValue("table"));
var total = table.All();
var pager = ApiHelper.GetPager(call, 30);
PagedListViewModel <IDictionary <string, object> > result = new PagedListViewModel <IDictionary <string, object> >();
result.TotalCount = total.Count;
result.TotalPages = ApiHelper.GetPageCount(total.Count, pager.PageSize);
result.PageNr = pager.PageNr;
result.PageSize = pager.PageSize;
int totalskip = 0;
if (pager.PageNr > 1)
{
totalskip = (pager.PageNr - 1) * pager.PageSize;
}
var items = total.Skip(totalskip).Take(pager.PageSize).ToList();
if (items != null && items.Count() > 0)
{
result.List = items;
}
return(result);
}
public override System.Web.Mvc.ActionResult Index(int?currentPageNum, int?pageSize, System.Web.Mvc.FormCollection collection)
{
if (!currentPageNum.HasValue)
{
currentPageNum = 1;
}
if (!pageSize.HasValue)
{
pageSize = PagedListViewModel <Xzqy> .DefaultPageSize;
}
int pageNum = currentPageNum.Value;
string roleId = LRequest.GetString("roleId");
#region MyRegion
ViewData["RoleId"] = roleId;
DataTable dt = DbFactory.DBA.QueryDataTable("SELECT * FROM [Role] WHERE ID='" + roleId + "'");
if (dt.Rows.Count > 0)
{
ViewData["RoleName"] = dt.Rows[0]["Name"].ToString();
}
else
{
ViewData["RoleName"] = "";
}
#endregion
var list = repo.GetRoleAuthority(Guid.Parse(roleId));
var contactLitViewModel = new PagedListViewModel <RoleAuthority>(pageNum, pageSize.Value, list);
return(View(contactLitViewModel));
}
public async Task <PagedListViewModel <ProductViewModel> > FilterProducts(ProductFilter filter)
{
var products = await _shopy.ListProducts(filter);
var items = _mapper.Map <IEnumerable <ProductViewModel> >(products.Result);
var viewModel = new PagedListViewModel <ProductViewModel>(items, products.TotalRecords);
return(viewModel);
}
public PagedListViewModel <SiteLogViewModel> List(ApiCall apiCall)
{
var sitedb = apiCall.WebSite.SiteDb();
var pager = ApiHelper.GetPager(apiCall, 50);
PagedListViewModel <SiteLogViewModel> result = new PagedListViewModel <SiteLogViewModel>();
var total = sitedb.Log.Store.Count();
result.TotalCount = total;
result.TotalPages = ApiHelper.GetPageCount(total, pager.PageSize);
result.PageNr = pager.PageNr;
List <SiteLogViewModel> list = new List <SiteLogViewModel>();
var items = sitedb.Log.Store.Filter.OrderByDescending().Skip(pager.SkipCount).Take(pager.PageSize);
foreach (var item in items)
{
SiteLogViewModel model = new SiteLogViewModel
{
LastModified = item.UpdateTime,
ItemName = Kooboo.Sites.Service.LogService.GetLogDisplayName(sitedb, item),
Id = item.Id
};
if (model.ItemName != null && model.ItemName.Length > 85)
{
model.ItemName = Lib.Helper.StringHelper.SementicSubString(model.ItemName, 0, 70);
var bytes = System.Text.Encoding.UTF8.GetBytes(model.ItemName);
if (bytes.Length > 160)
{
model.ItemName = Lib.Helper.StringHelper.SementicSubString(model.ItemName, 0, 40);
}
model.ItemName += "...";
}
model.StoreName = item.StoreName;
model.KeyHash = item.KeyHash;
model.StoreNameHash = item.StoreNameHash;
model.ActionType = item.EditType.ToString();
model.UserName = Data.GlobalDb.Users.GetUserName(item.UserId);
if (model.KeyHash != default(Guid))
{
list.Add(model);
}
}
result.List = list;
return(result);
}
private PagedListViewModel <MediaFileViewModel> GetPagedFilesBy(SiteDb siteDb, string by, int PageSize, int PageNumber)
{
string baseurl = siteDb.WebSite.BaseUrl();
// by = View, Page, Layout, TextContent, Style.
byte consttype = ConstObjectType.GetByte(by);
var images = siteDb.Images.ListUsedBy(consttype);
int totalskip = 0;
if (PageNumber > 1)
{
totalskip = (PageNumber - 1) * PageSize;
}
PagedListViewModel <MediaFileViewModel> Result = new PagedListViewModel <MediaFileViewModel>();
Result.TotalCount = images.Count();
Result.TotalPages = ApiHelper.GetPageCount(Result.TotalCount, PageSize);
Result.PageSize = PageSize;
Result.PageNr = PageNumber;
List <MediaFileViewModel> list = new List <MediaFileViewModel>();
foreach (var item in images.Skip(totalskip).Take(PageSize))
{
MediaFileViewModel model = new MediaFileViewModel();
model.Id = item.Id;
model.Height = item.Height;
model.Width = item.Width;
model.Size = item.Size;
model.Name = item.Name;
model.LastModified = item.LastModified;
model.Thumbnail = ThumbnailService.GenerateThumbnailUrl(item.Id, 90, 0, siteDb.Id);
model.Url = ObjectService.GetObjectRelativeUrl(siteDb, item);
model.IsImage = true;
model.PreviewUrl = Lib.Helper.UrlHelper.Combine(baseurl, model.Url);
var usedby = siteDb.Images.GetUsedBy(item.Id);
if (usedby != null)
{
model.References = usedby.GroupBy(it => it.ConstType).ToDictionary(
key =>
{
return(ConstTypeService.GetModelType(key.Key).Name);
}, value => value.Count());
}
list.Add(model);
}
Result.List = list;
return(Result);
}
/// <summary>
/// A method to be called for dynamical creation generic type of PagedListViewModel.
/// </summary>
private static object PagedListCreationMethod <T>()
{
var objectGenerator = new ObjectGenerator();
var obj = (IQueryable <T>)objectGenerator.GenerateObject(typeof(IQueryable <T>));
var retVal = new PagedListViewModel <T>(obj.ToPagedList(new Pagination()))
{
Data = obj
};
return(retVal);
}
public PagedListViewModel <FormValue> FormValues(ApiCall call)
{
PagedListViewModel <FormValue> result = new PagedListViewModel <Sites.Models.FormValue>();
var pager = ApiHelper.GetPager(call, 50);
var total = call.WebSite.SiteDb().FormValues.Query.Where(o => o.FormId == call.ObjectId).Count();
result.TotalCount = total;
result.TotalPages = ApiHelper.GetPageCount(total, pager.PageSize);
result.PageNr = pager.PageNr;
result.List = call.WebSite.SiteDb().FormValues.Query.Where(o => o.FormId == call.ObjectId).OrderByDescending(o => o.CreationDate).Skip(pager.SkipCount).Take(pager.PageSize);
return(result);
}
public async Task <PagedListViewModel <PagedListPostViewModel> > GetPagedList(int categoryId, int pageNumber, int pageSize)
{
var resultsToSkip = pageNumber * pageSize;
var pagedList = new PagedListViewModel <PagedListPostViewModel>
{
List = await _posts.Where(post => post.CategoryId == categoryId).OrderByDescending(post => post.PostedDate)
.ProjectTo <PagedListPostViewModel>(null, _mappingEngine)
.Skip(() => resultsToSkip)
.Take(() => pageSize)
.ToListAsync(),
TotalCount = await _posts.CountAsync()
};
return(pagedList);
}
public async Task <IViewComponentResult> InvokeAsync(IEnumerable <PostBase> list, int pageCount, int pageIndex, string filter, bool isPage, bool?isTable)
{
var posts = list.InPagesOf(pageCount).GetPage(pageIndex);
string actionName = ViewContext.ActionDescriptor.RouteValues["action"];
string controller = ViewContext.ActionDescriptor.RouteValues["controller"];
string actionParameter = actionName == "Index"
? String.Empty
: actionName == "ViewCategory"
? "category"
: "tag";
string actionValue = actionName == "Index"
? String.Empty
: ViewContext.RouteData.Values[actionParameter] as string;
PagedListViewModel viewModel = null;
await Task.Run(() =>
{
viewModel = new PagedListViewModel
{
IsPage = isPage,
Pager = new Pager
{
Action = actionName,
Controller = controller,
CssClass = "pagination",
Filter = filter,
HasNextPage = posts.HasNextPage,
HasPreviousPage = posts.HasPreviousPage,
NextCssClass = "right",
NextText = "Next",
PageCount = posts.PageCount,
PageIndex = posts.PageIndex,
PreviousCssClass = "left",
PreviousText = "Previous",
RouteValues = new Dictionary <string, object> {
[actionParameter] = actionValue
}
},
Posts = posts
};
});
// ReSharper disable once Mvc.ViewComponentViewNotResolved
return(isTable.HasValue && isTable.Value ? View("Table", viewModel) : View(viewModel));
}
public override System.Web.Mvc.ActionResult Index(int?currentPageNum, int?pageSize, System.Web.Mvc.FormCollection collection)
{
if (!currentPageNum.HasValue)
{
currentPageNum = 1;
}
if (!pageSize.HasValue)
{
pageSize = PagedListViewModel <SchoolInfoPageListViewModel> .DefaultPageSize;
}
string schoolId = LRequest.GetString("schoolId");
var list = RF.Concrete <ISchoolInfoRepository>().GetSchoolTeacherList(Guid.Parse(schoolId));
var contactLitViewModel = new PagedListViewModel <SchoolTeacherViewModel>(currentPageNum.Value, pageSize.Value, list);
return(View(contactLitViewModel));
}
public override System.Web.Mvc.ActionResult Index(int?currentPageNum, int?pageSize, System.Web.Mvc.FormCollection collection)
{
if (!currentPageNum.HasValue)
{
currentPageNum = 1;
}
if (!pageSize.HasValue)
{
pageSize = PagedListViewModel <TLog> .DefaultPageSize;
}
int pageNum = currentPageNum.Value;
var list = repo.FindAll(p => p.UpdateDate, LCL.SortOrder.Descending);
var contactLitViewModel = new PagedListViewModel <TLog>(pageNum, pageSize.Value, list.ToList());
return(View(contactLitViewModel));
}
public ActionResult Posts(int page = 1)
{
ViewBag.Title = "Latest Posts";
PagingInfo pagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = PAGECOUNT,
TotalItems = _blogRepository.TotalPosts()
};
PagedListViewModel pagedList = new PagedListViewModel
{
PagingInfo = pagingInfo,
ViewModel = new ListViewModel(_blogRepository, page, PAGECOUNT)
};
return(View("List", pagedList));
}
public ActionResult CallList_DataNajnowsze(int?page)
{
if (Request.IsAuthenticated)
{
int pagenumber = (page ?? 1);
int pageNumber = (page ?? 1);
string ID = User.Identity.GetUserId();
var calls = db.Calls.Where(a => a.adresseID == ID || a.UserID == ID).OrderByDescending(x => x.date).ToList();
var vm = new PagedListViewModel()
{
ListaPolaczen = calls.ToPagedList(page ?? 1, 3)
};
return(View(vm));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult CallList_StatusNIE(int?page)
{
if (Request.IsAuthenticated)
{
int pagenumber = (page ?? 1);
int pageNumber = (page ?? 1);
string ID = User.Identity.GetUserId();
var calls = db.Calls.Where(a => a.adresseID == ID && !a.status).ToList();
var vm = new PagedListViewModel()
{
ListaPolaczen = calls.ToPagedList(page ?? 1, 3)
};
return(View(vm));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public IHtmlString Pager <TItem>(PagedListViewModel <TItem> model, int noOfPageToShow) where TItem : class
{
IDictionary <string, object> values = new Dictionary <string, object>();
foreach (var key in htmlHelper.ViewContext.HttpContext.Request.QueryString.AllKeys)
{
if (!values.Keys.Contains(key))
{
values.Add(key, htmlHelper.ViewContext.HttpContext.Request.QueryString[key]);
}
}
foreach (KeyValuePair <string, object> pair in htmlHelper.ViewContext.RouteData.Values)
{
if (!values.Keys.Contains(pair.Key))
{
values.Add(pair.Key, pair.Value);
}
}
return(Pager(null, null, null, values, "page", model.PageCount, noOfPageToShow, 1, model.CurrentPage));
}
public PagedListViewModel <TextContentViewModel> Search(Guid FolderId, string Keyword, ApiCall call)
{
var sitedb = call.WebSite.SiteDb();
if (string.IsNullOrWhiteSpace(Keyword) || FolderId == default(Guid))
{
return(new PagedListViewModel <TextContentViewModel>());
}
int pagesize = ApiHelper.GetPageSize(call, 50);
int pagenr = ApiHelper.GetPageNr(call);
string language = string.IsNullOrEmpty(call.Context.Culture) ? call.WebSite.DefaultCulture : call.Context.Culture;
PagedListViewModel <TextContentViewModel> model = new PagedListViewModel <TextContentViewModel>();
model.PageNr = pagenr;
model.PageSize = pagesize;
var all = sitedb.TextContent.Query.Where(o => o.FolderId == FolderId).SelectAll();
var textContents = all.Where(o => o.Body.IndexOf(Keyword, StringComparison.OrdinalIgnoreCase) > -1).OrderByDescending(o => o.LastModified);
model.TotalCount = textContents.Count();
model.TotalPages = ApiHelper.GetPageCount(model.TotalCount, model.PageSize);
var list = textContents.OrderByDescending(o => o.LastModified).Skip(model.PageNr * model.PageSize - model.PageSize).Take(model.PageSize).ToList();
var contenttype = call.Context.WebSite.SiteDb().ContentTypes.GetByFolder(FolderId);
model.List = new List <TextContentViewModel>();
foreach (var item in list)
{
model.List.Add(Sites.Helper.ContentHelper.ToListDisplayView(item, contenttype, language));
}
return(model);
}
public PagedListViewModel <RouteItemViewModel> Internal(ApiCall apiCall)
{
var sitedb = apiCall.WebSite.SiteDb();
var pager = ApiHelper.GetPager(apiCall, 30);
PagedListViewModel <RouteItemViewModel> result = new PagedListViewModel <RouteItemViewModel>();
var allroutes = sitedb.Routes.All();
var total = allroutes.Count;
result.TotalCount = total;
result.TotalPages = ApiHelper.GetPageCount(total, pager.PageSize);
result.PageNr = pager.PageNr;
List <RouteItemViewModel> list = new List <RouteItemViewModel>();
string baseurl = sitedb.WebSite.BaseUrl();
var items = allroutes.OrderBy(o => o.Name).Skip(pager.SkipCount).Take(pager.PageSize);
foreach (var item in items)
{
RouteItemViewModel model = new RouteItemViewModel();
model.Id = item.Id;
model.Name = item.Name;
model.ResourceType = ConstObjectType.GetName(item.DestinationConstType);
model.ObjectId = item.objectId;
model.LastModified = item.LastModified;
model.Relations = Sites.Helper.RelationHelper.Sum(sitedb.Routes.GetUsedBy(item.Id));
model.PreviewUrl = Kooboo.Lib.Helper.UrlHelper.Combine(baseurl, model.Name);
list.Add(model);
}
result.List = list;
return(result);
}
// TODO: get the posts for the tag and return the view.
public ActionResult Tag(string tag, int page = 1)
{
var tagViewModel = new ListViewModel(_blogRepository, Criterion.Tag, tag, page, PAGECOUNT);
if (tagViewModel.Tag == null)
{
return(HttpNotFound("Записи с данным тегом не найдены"));
}
ViewBag.Title = $"Последние посты с тегом {tagViewModel.Tag.Name}";
PagingInfo pagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = PAGECOUNT,
TotalItems = _blogRepository.Tags().Count()
};
PagedListViewModel pagedList = new PagedListViewModel
{
PagingInfo = pagingInfo,
ViewModel = tagViewModel
};
return(View("List", pagedList));
}
// TODO: get the posts for the category and return the view.
public ActionResult Category(string category, int page = 1)
{
var viewModel = new ListViewModel(_blogRepository, Criterion.Category, category, page, PAGECOUNT);
if (viewModel.Category == null)
{
return(HttpNotFound("Категория не найдена"));
}
ViewBag.Title = $"Последние посты с категорией '{viewModel.Category.Name}'";
PagingInfo pagingInfo = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = PAGECOUNT,
TotalItems = _blogRepository.Categories().Count()
};
PagedListViewModel pagedList = new PagedListViewModel
{
PagingInfo = pagingInfo,
ViewModel = viewModel
};
return(View("List", pagedList));
}
// GET: Call
public ActionResult CallList(int?page)
{
if (Request.IsAuthenticated)
{
int pagenumber = (page ?? 1);
var calls = db.Calls.ToList();
//int pageSize = 5;
int pageNumber = (page ?? 1);
var vm = new PagedListViewModel()
{
ListaPolaczen = calls.ToPagedList(page ?? 1, 3)
};
var ListaPolaczen = calls.ToPagedList(page ?? 1, 3);
return(View(vm));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
// Index (List)
public ActionResult Index(int? page)
{
var meetings = new PagedListViewModel<Meeting>(_meetingRepository.All(), 5, page ?? 0);
return View(meetings);
}
public ActionResult Index(int? currentPageNum, int? pageSize)
{
if (!currentPageNum.HasValue)
{
currentPageNum = 1;
}
if (!pageSize.HasValue)
{
pageSize = PagedListViewModel<ScheduledEvents>.DefaultPageSize;
}
var list = FindAll();
var contactLitViewModel = new PagedListViewModel<ScheduledEvents>(currentPageNum.Value, pageSize.Value, list.ToList());
return View(contactLitViewModel);
}
// Index (List)
public ActionResult Index(int? page)
{
var venues = new PagedListViewModel<Venue>(_repository.All(), 5, page ?? 0);
return View(venues);
}
