public ActionResult Results(int? page, string keywords = "") { string _keywords = keywords != null ? keywords.ToString().ToLower() : ""; List<Work> works = new List<Work>(); int pageSize = 20; int pageNumber = (page ?? 1); if(!string.IsNullOrEmpty(_keywords) && !string.IsNullOrWhiteSpace(_keywords)) { works = (from wk in WorkBl.GetList() where (wk.Description.ToLower().Contains(_keywords) || wk.Title.ToLower().Contains(_keywords) || wk.User.Name.ToLower().Contains(_keywords) || wk.User.Username.ToLower().Contains(_keywords)) orderby wk.Id descending select wk).ToList(); ViewBag.Keywords = _keywords; //paging return View(works.ToPagedList(pageNumber, pageSize)); } return View(works.ToPagedList(pageNumber, pageSize)); }
// GET: Student public async Task<ActionResult> Index(string sort = "id", int? page = 1, string fields = "id,name,address") { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:53506/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = await client.GetAsync("api/student?sort=" + sort + "&page=" + page + "&fields=" + fields); if (response.IsSuccessStatusCode) { List<Student> students = await response.Content.ReadAsAsync<List<Student>>(); List<StudentViewModel> model = new List<StudentViewModel>(); StudentDTO dto = new StudentDTO(); model = dto.ConvertToStudentViewModel(students); int pageSize = 3; int pageNumber = (page ?? 1); return View(model.ToPagedList(pageNumber, pageSize)); } var re = response.Content.ReadAsStringAsync().Result; } return View("Error"); }
public ActionResult CommentsOfTopReview(int? page, String IDPhim, String IDReview = "-1") { List<CommentViewModels> result = new List<CommentViewModels>(); ReviewFilmService reviewS = new ReviewFilmService(); TopReviewModels top = null; ViewBag.IDPhim = IDPhim; ViewBag.IDReview = IDReview; if(IDReview.Equals("-1")) // Bài Review nổi bật nhất { top = reviewS.getTopReview(IDPhim); } else { top = reviewS.getReview(IDReview); } if(top != null) { result = reviewS.getComment(top.MS_ReView.ToString()); TempData["IDPost"] = top.MS_ReView; } int pageNumber = page ?? 1; int pageSize = 10; return PartialView(result.ToPagedList(pageNumber, pageSize)); }
public JsonResult SomeRows(int? page, int? size) { List<DataRow> customers = new List<DataRow>(); for (int i = 0; i < 23; i++) { customers.Add(new DataRow { Name = "Customer " + i.ToString(), DOB = (new DateTime().AddDays(i)) }); } int pageNumber = page ?? 1; int pageSize = size ?? 5; var pageOfCustomers = customers.ToPagedList(pageNumber, pageSize); //double pageCount = System.Math.Round(totalPages,0,); var results = new ResultSet { Pages = pageOfCustomers.PageCount, Current = pageOfCustomers.PageNumber, IsFirst = pageOfCustomers.IsFirstPage, IsLast = pageOfCustomers.IsLastPage, HasPrevious = pageOfCustomers.HasPreviousPage, HasNext = pageOfCustomers.HasNextPage, Results = pageOfCustomers.ToList() }; return Json(results); }
public ActionResult Index(int? page, int? PageSize, string sortBy) { var customers = new List<DSC_CUSTOMER>(); var viewCustomers = new List<CustViewModel>(); ViewBag.CurrentItemsPerPage = PageSize ?? 10; ViewBag.SortNameParameter = String.IsNullOrEmpty(sortBy) ? "Name desc" : "Name"; ViewBag.SortParentParameter = sortBy == "Parent" ? "Parent desc" : "Parent"; using (DSC_OBS_DB_ENTITY db = new DSC_OBS_DB_ENTITY()) { customers = db.DSC_CUSTOMER.Where(cust_id => cust_id.dsc_cust_id > 0).ToList(); } //DateTime active_date; foreach (DSC_CUSTOMER customer in customers) { string activeAction = ""; try { if (customer.dsc_cust_eff_end_date == null) { activeAction = "YES"; }//end of if else { if (customer.dsc_cust_eff_end_date <= DateTime.Today) { activeAction = "NO"; } else { activeAction = "YES"; } }//end of else }//end of try catch { activeAction = "NO"; }//end of catch viewCustomers.Add(new CustViewModel(customer.dsc_cust_id, customer.dsc_cust_name, customer.dsc_cust_parent_name, activeAction, activeAction == "YES" ? "Deactivate" : "Activate")); }// end of foreach switch (sortBy) { case "Name desc": return View(viewCustomers.OrderByDescending(x=>x.dsc_cust_name).ToPagedList(page ?? 1, PageSize ?? 10)); case "Parent desc": return View(viewCustomers.OrderByDescending(x => x.dsc_cust_parent_name).ToPagedList(page ?? 1, PageSize ?? 10)); case"Name": return View(viewCustomers.OrderBy(x => x.dsc_cust_name).ToPagedList(page ?? 1, PageSize ?? 10)); case "Parent": return View(viewCustomers.OrderBy(x => x.dsc_cust_parent_name).ToPagedList(page ?? 1, PageSize ?? 10)); default: return View(viewCustomers.ToPagedList(page ?? 1, PageSize ?? 10)); } }
public async Task<ActionResult> Index(int page = 1) { var entities = await hotelRep.Get().ToListAsync(); var models = new List<HotelViewModel>(); HotelViewModel model; foreach (var h in entities) { model = new HotelViewModel(); model.Id = h.Id; model.Name = h.Name; model.RegionId = h.RegionId; model.RegionName = RegionToName(h.RegionId, ""); model.Phone = h.Phone; model.Created = h.Created; model.Modified = h.Modified; model.Status = (HotelStatus)h.Status; var hotelImg = imgRep.FindById(h.Id, 0); if (hotelImg != null) { model.ImgUrl = hotelImg.Url; } models.Add(model); } return View(models.ToPagedList(page, 10)); }
// // GET: /PhotoBook/UserAlbums public ActionResult UserAlbum(int page = 1) { var albumList = new List<AlbumViewModel>(); var users = unitOfWork.UserRepository.Get(); FillAlbumModel(users, albumList); return View(albumList.ToPagedList(page, Settings.Default.PhotosPerPage)); }
public ActionResult Index(int? page) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _ListArea = _AreaService.GetAllAreaWithProject(); var proObj = new List<AreaViewModel>(); if (_ListArea != null) { foreach (var item in _ListArea) { proObj.Add( new AreaViewModel() { AreaId = item.AreaId, AreaName = item.AreaName, Keyword = item.Keyword, MetaDescription = item.MetaDescription, NumOfProject = item.Projects.Count(t => t.IsDelete == false) }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._ListArea = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public async Task<ActionResult> Index(int page = 1) { var orders = await orderRep.Get().OrderByDescending(o => o.OrderDate).ToListAsync(); var models = new List<OrderViewModel>(); OrderViewModel model; foreach (var o in orders) { model = new OrderViewModel(); model.OrderId = o.OrderId; model.UserId = o.UserId; model.UserName = o.FullName; model.PhoneNumber = o.PhoneNumber; model.Email = o.Email; model.Remark = o.Remark; model.OrderDate = o.OrderDate; model.Amount = o.Amount; model.ShippingTo = o.ShippingTo; model.OrderStatus = o.OrderStatus; model.ShippingAddress = o.ShippingAddress; model.ShippingStatus = o.ShippingStatus; models.Add(model); } return View(models.ToPagedList(page, 10)); }
public ActionResult Index(int? page) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _ListNew = _NewsService.GetAllNew(); var proObj = new List<NewViewModel>(); if (_ListNew != null) { foreach (var item in _ListNew) { proObj.Add( new NewViewModel() { NewId = item.NewId, Content = item.Content, CreateDate = item.CreateDate.ToShortDateString(), Image = item.Image, ShortDes = item.ShortDes, MetaDescription = item.MetaDescription, Keyword = item.Keyword, Title = item.Title }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._ListNew = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public ActionResult Index(int ? page) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _ListPrice = _PriceService.GetAllPrice(); var proObj = new List<PriceViewModel>(); if (_ListPrice != null) { foreach (var item in _ListPrice) { proObj.Add( new PriceViewModel() { PriceId = item.PriceId, PriceValue = item.PriceValue, NumOfProjects = item.Projects.Count(t => t.IsDelete == false) }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._ListPrice = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public ActionResult Index(int? page) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _listContractor = _contractorServices.GetAllContractor(); var proObj = new List<ContractorViewModel>(); if (_listContractor != null) { foreach (var item in _listContractor) { proObj.Add( new ContractorViewModel() { ContractorId = item.ContractorId, Image = item.Image, Name = item.Name, LinkContent = item.LinkContent }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._listContractor = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public ActionResult Index(int page=1) { var locations = new List<Location>(); using (var client = new HttpClient()) { var task = client.GetAsync(url) .ContinueWith(request => { request.Result.EnsureSuccessStatusCode(); var readTask=request.Result.Content.ReadAsAsync<List<Location>>() .ContinueWith(read => { locations = read.Result; }); readTask.Wait(); }).ContinueWith(error => { if (error.Exception != null) ViewBag.Error = error.Exception.StackTrace; }); task.Wait(); } SetExtraData(); return View(locations.ToPagedList(page, 6)); }
public ActionResult Index(int ? Id,int ? page) { int pageSize = 5; int pageNum = (page ?? 1); ViewBag.Sektori = ctx.Sektoris.Where(x => x.IsActive == true).ToList(); if(Id!=null) { int id = Id ?? default(int); Sektori s = ctx.Sektoris.Where(x => x.SektorID == id).SingleOrDefault(); if (s != null) { ViewData["Sektor"] = s; List<ObavijestiSektori> sek = ctx.ObavijestiSektoris.Where(x => x.SektorID == s.SektorID && x.IsActive == true).OrderByDescending(x=>x.ObavijestSektorID).ToList(); List<Obavijesti> obavijesti = new List<Obavijesti>(); foreach (ObavijestiSektori item in sek) { Obavijesti o = ctx.Obavijestis.Where(x => x.ObavijestID == item.ObavijestID && x.IsActive == true).SingleOrDefault(); if (o != null) obavijesti.Add(o); } return View(obavijesti.ToPagedList(pageNum, pageSize)); } } return RedirectToAction("Index", "Index"); }
public ViewResult Index(string sortOrder, string currentFilterMMP, string currentFilterMDP, string minMonthlyPurchases, string minDollarPurchases, int? page) { int cr=0; int pageSize = 10; if (Request.HttpMethod == "GET") { minMonthlyPurchases = currentFilterMMP; minDollarPurchases = currentFilterMDP; } else { page = 1; } ViewBag.CurrentFilterMMP = minMonthlyPurchases; ViewBag.CurrentFilterMDP = minDollarPurchases; int pageNumber = (page ?? 1); if (minMonthlyPurchases != null && minDollarPurchases != null) { var Rewards = from s in serviceProxy.GetRewardsReport(sbyte.Parse(minMonthlyPurchases), decimal.Parse(minDollarPurchases), cr) select s; return View(Rewards.ToPagedList(pageNumber, pageSize)); } else { List<SCustomer> sc = new List<SCustomer>(); return View(sc.ToPagedList(1, 1)); } }
public async Task<ActionResult> Details(int id, int page = 1, int pageSize = 20) { if (id == default(int)) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var role = await RoleManager.FindByIdAsync(id); if (role == null) { return HttpNotFound(); } var users = new List<UserViewModel>(); foreach (var user in UserManager.Users.ToList()) { if (await UserManager.IsInRoleAsync(user.Id, role.Name)) { users.Add(new UserViewModel { UserName = user.UserName, Email = user.Email, PhoneNumber = user.PhoneNumber, Created = user.Created }); } } ViewBag.RoleId = role.Id; ViewBag.RoleName = role.Name; ViewBag.RoleDescription = role.Description; return View(users.ToPagedList(page, 20)); }
public ActionResult Search(string search, string searchBy, string sortBy, int? page) { ViewBag.SortNameParameter = string.IsNullOrEmpty(sortBy) ? "Name desc" : ""; List<Message> SearchResults = new List<Message>(); if (!string.IsNullOrWhiteSpace(search)) { foreach (var message in fe.Messages) { SearchResults.Add(message); } if (string.IsNullOrWhiteSpace(search) != true) SearchResults = SearchResults.Where(m => m.Content.Contains(search)).ToList(); switch (sortBy) { case "Name desc": SearchResults = SearchResults.OrderByDescending(a => a.MessageId).ToList(); break; default: SearchResults = SearchResults.OrderBy(a => a.MessageId).ToList(); break; } } return View(SearchResults.ToPagedList(page ?? 1, 3)); }
public ActionResult Index(int ? page ) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _listProjectType = _projectType.GetListProjectType(); var proObj = new List<ProjectTypeViewModel>(); if (_listProjectType != null) { foreach (var item in _listProjectType) { proObj.Add( new ProjectTypeViewModel() { Name = item.NameType, Image = item.Image, ProjectTypeId = item.ProjectTypeId, Description = item.Description, Keyword = item.Keyword, MetaDescription = item.MetaDescription, NumOfProject = item.Projects.Count(t=>t.IsDelete==false) }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._listProjectType = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public async Task<ActionResult> Index(int hotelid = 0, int page = 1) { ViewBag.HotelId = 0; ViewBag.HotelName = ""; List<Room> rooms; if (hotelid == default(int)) { rooms = await roomRep.Get().ToListAsync(); } else { rooms = await roomRep.Get(r => r.HotelId == hotelid).ToListAsync(); ViewBag.HotelId = hotelid; ViewBag.HotelName = hotelRep.FindById(hotelid).Name; } var roomsView = new List<RoomViewModel>(); foreach (var r in rooms) { roomsView.Add(new RoomViewModel { Id = r.Id, HotelId = r.HotelId, HotelName = hotelRep.FindById(r.HotelId).Name, Name = r.Name, StandartPrice = r.StandartPrice, Price = r.Price, Quantity = r.Quantity, Status = (RoomStatus)r.Status }); } return View(roomsView.ToPagedList(page, 10)); }
public ActionResult GameDev(int? page) { var userList = from user in jobRepo.GetUsers() select user; var users = new List<MyApplication.Job>(); if (userList.Any()) { foreach (var user in userList) { if (user.Category.Equals("Game Developer ") && user.Status.Equals(true)) { var Name = accountRepo.GetUsers().FirstOrDefault(u => u.UserId.Equals(user.UserId)); ViewBag.Name = Name.Username; ViewBag.Head = "Game Developer"; users.Add(new MyApplication.Job() { Title = user.Title, InitialBudget = user.InitialBudget, finalBudget = user.finalBudget, Category = user.Category, JobId = user.JobId, Date = user.Date }); } } } int pageSize = 20; int pageNumber = (page ?? 1); return View("CategoryJob", users.ToPagedList(pageNumber, pageSize)); }
public ActionResult Index(string roleId, int index = 1) { //取role列表 var roles = _roleManager.Roles.ToList(); //roleId是否为空 if (string.IsNullOrWhiteSpace(roleId)) { //取第一个role的id roleId = roles.FirstOrDefault().Id; } //放入viewbag,设置默认值 ViewBag.RoleID = new SelectList(roles, "ID", "Name", roleId); //取角色权限列表 var permissions = _roleManager.GetRolePermissions(roleId); //创建ViewModel var permissionViews = new List<PermissionViewModel>(); //var map = Mapper.CreateMap<ApplicationPermission, PermissionViewModel>(); permissions.Each(t => { var view = Mapper.Map<PermissionViewModel>(t); view.RoleId = roleId; permissionViews.Add(view); }); //排序 permissionViews.Sort(new PermissionViewModelComparer()); return View(permissionViews.ToPagedList(index, 10)); }
// GET: /Ads/ public ActionResult Index(int? page) { if (Authentication.Checklogin()) { int pageSize = 8; int pageNum = (page ?? 1); var _ListAds = _adsService.GetAllAds(); var proObj = new List<AdsViewModel>(); if (_ListAds != null) { foreach (var item in _ListAds) { proObj.Add( new AdsViewModel() { AdsId = item.AdsId, Name = item.Name, Image = item.Image, URL = item.URL, IsShow = item.IsShow == true ? "Có" : "Không" }); } } ViewBag.Count = proObj.Count; var result = proObj.ToPagedList(pageNum, pageSize); ViewBag._ListAds = result; return View(result); } else return RedirectToAction("Index", "Login"); }
public ActionResult Information(int iduser, int? page) { int pageSize = 10; int pageNumber = (page ?? 1); List<TweetsModel> currentTweetsList = new List<TweetsModel>(); currentTweetsList = curentTweetService.GetAllTweets(iduser).OrderByDescending(xTweet => xTweet.id_tweet).ToList(); return View("Information", currentTweetsList.ToPagedList(pageNumber, pageSize)); }
public SPlistViewModel(List<SPViewModel> picks, int? page) { if (page.HasValue) { _Page = page.Value; } _Picks = picks; _PickPages = _Picks.ToPagedList(_Page, 10); }
public ActionResult VeHuu(int? page) { //List<NhanVien> list = bizNV.BIZ_LayDuLieuNV(); list = bizNV.BIZ_LayDuLieuNV(); TempData["list"] = list; int pageSize = 10; int pageNumber = (page ?? 1); return View(list.ToPagedList(pageNumber, pageSize)); }
public ActionResult Information(int? page) { int pageSize = 10; int pageNumber = (page ?? 1); List<UsersModel> currentUserList = new List<UsersModel>(); currentUserList = currentUserService.GetAll().OrderByDescending(xUser => xUser.id_user).ToList(); return View("Information", currentUserList.ToPagedList(pageNumber, pageSize)); logger.Debug("You called the method \"GetAll\""); }
public ActionResult BookSearch(string q, string currentFilter, int? page, int? formCountry, int? formProvince, int? formCity) { if (Request.HttpMethod == "GET") { q = currentFilter; } else { page = 1; } ViewBag.CurrentFilter = q; var books = new List<Book>(); if (!String.IsNullOrWhiteSpace(q)) { books = db.Books .Where(a => a.Title.Contains(q)).OrderBy(a => a.Title) .ToList(); if (books.Count == 0) { Information(EMPTY); } } else { books = db.Books.OrderBy(a => a.Title).ToList(); } if (formCountry != null && formCountry != 0) { books = books.Where(b => b.User.Address.CountryId == formCountry).ToList(); ViewBag.CurrentCountryId = formCountry; ViewBag.CurrentCountryName = db.Countries.Find(formCountry).Name; } if (formProvince != null && formProvince != 0) { books = books.Where(b => b.User.Address.ProvinceId == formProvince).ToList(); ViewBag.CurrentProvinceId = formProvince; ViewBag.CurrentProvinceName = db.Provinces.Find(formProvince).Name; } if (formCity != null && formCity != 0) { books = books.Where(b => b.User.Address.CityId == formCity).ToList(); ViewBag.CurrentCityId = formCity; ViewBag.CurrentCityName = db.Cities.Find(formCity).Name; } int pageSize = 10; int pageNumber = (page ?? 1); return View(books.ToPagedList(pageNumber, pageSize)); }
public void Zero_Item_Data_Set_Returns_Zero_Pages() { //arrange var data = new List<object>(); //act var pagedList = data.ToPagedList(1, 10); //assert Assert.Equal(0, pagedList.PageCount); }
public async Task<ActionResult> Index(int index = 1) { var users = await _userManager.Users.ToListAsync(); var views = new List<EditUserRoleViewModel>(); foreach (var user in users) { var view = Mapper.Map<EditUserRoleViewModel>(user); views.Add(view); } return View(views.ToPagedList(index, 10)); }
public ActionResult Index(int? page) { int itemsPerPage = 25; int pageNumber = page ?? 1; List<Lucky> luckyGuids = new List<Lucky>(); for (int i = 0; i < 100; i++) { luckyGuids.Add(new Lucky() { Guid = Guid.NewGuid().ToString() }); } return View(luckyGuids.ToPagedList(pageNumber, itemsPerPage)); }
static void LoadUsersThread() { //Thread y = new Thread(LoadCertificateAgents); //y.Start(); using (AgentDataAccess dbRep = new AgentDataAccess()) { globalListAgents = dbRep.LoadAllAgents(); UC_Certification.staticDataSource = UC_Certification.GetDataSourceStatic(globalListAgents.ToPagedList(1, globalListAgents.Count())); } }
public virtual PartialViewResult _PartialUserSearchFiles(string SearchTerm, string SearchField, string RecordCount, int?Page, string SortOrder, string[] Tags) { System.Web.HttpContext currentContext = System.Web.HttpContext.Current; if (SearchField == "DisplayDirectory" && SearchTerm != "") { SearchTerm = SearchTerm.Replace("\\", "\\" + "\\"); } string userid = currentContext.User.Identity.GetUserId().ToString(); if (SearchTerm != "") { SearchTerm = "(" + SearchTerm + ")" + "AND userid:" + userid; } string searchTags = null; if (Tags != null) { foreach (var item in Tags) { searchTags = searchTags + "Tag:" + item + " OR "; } searchTags = searchTags.Substring(0, searchTags.Length - 4); if (SearchTerm != "") { SearchTerm = "(" + "(" + SearchTerm + ")" + "AND userid:" + userid + ")" + " AND " + searchTags; } } //// create default Lucene search index directory //if (!Directory.Exists(DMSIndex.DMSIndex._luceneDir)) Directory.CreateDirectory(DMSIndex.DMSIndex._luceneDir); // perform Lucene search int RecordCount1 = 1; int FileCount = IndexCRUD.GetAllUserIndexRecords(userid).Count(); if (RecordCount != null && RecordCount != "All") { RecordCount1 = Int32.Parse(RecordCount); } else { RecordCount1 = FileCount; } int PageSize = (RecordCount1); // sayfadaki veri sayısı int PageNumber = (Page ?? 1); // sayfa seçilmediyse page değişkenine 1 ata IEnumerable <IndexModel> _searchResults = IndexCRUD.SearchDefault(SearchTerm, SearchField); if (SearchField == "") { _searchResults = IndexCRUD.SearchDefault(SearchTerm); } else { IndexCRUD.SearchDefault(SearchTerm, SearchField); } if (string.IsNullOrEmpty(SearchTerm) && searchTags == null) { _searchResults = IndexCRUD.GetAllUserIndexRecords(userid); } else if (string.IsNullOrEmpty(SearchTerm) && searchTags != null) { _searchResults = IndexCRUD.GetAllUserIndexRecordsCategorised(userid, searchTags); } var x = _searchResults; var files = from s in _searchResults select s; switch (SortOrder) { case "ZA": files = files.OrderByDescending(s => s.name); break; case "AZ": files = files.OrderBy(s => s.name); break; case "S-": files = files.OrderByDescending(s => s.size); break; case "S+": files = files.OrderBy(s => s.size); break; case "CT-": files = files.OrderByDescending(s => s.create_time); break; case "CT+": files = files.OrderBy(s => s.create_time); break; case "MT-": files = files.OrderByDescending(s => s.lmodified_time); break; case "MT+": files = files.OrderBy(s => s.lmodified_time); break; default: files = files.OrderBy(s => s.name); break; } var viewmodel = new List <IndexRecordViewModel>(); foreach (var item in files) { var temp = new IndexRecordViewModel(); temp.fullpath = item.fullpath; temp.name = item.name; temp.display_directory = item.display_directory; temp.laccess_time = item.laccess_time; temp.lmodified_time = item.lmodified_time; temp.create_time = item.create_time; temp.size = FormatByteSize(item.size); viewmodel.Add(temp); } IPagedList Pagedfiles = viewmodel.ToPagedList(PageNumber, PageSize); return(PartialView("_PartialUserSearchFiles", Pagedfiles)); }
// GET: Information public ActionResult BackListPaging(int pageNum = 1, string p_priority = "ALL", string p_read_yn = "N", string p_query_type = "999", string p_data = "N") { try { int pageSize = 5; int currentPage = pageNum < 1 ? 1 : pageNum; ViewBag.Read_YN = p_read_yn; //將partialview資料傳給 主要view ViewBag.Priority = p_priority; ViewBag.Query_Type = p_query_type; ViewBag.Query_Data = p_data; //int memberID = 1; //CMember member = Session[CDictionary.welcome] as CMember; //int memberID = member.fMemberId; //(int)Session["MemberID"]; Func <Information, bool> myWhere = null; SingleApartmentEntities db = new SingleApartmentEntities(); IEnumerable <Information> table = null; //myWhere = p => p.Status != "User_Deleted"; //todo:ok Linq多重where //if (string.IsNullOrEmpty(read_yn)) //modify by Jony 1091205 後台程式, 移除 p.MemberID == memberID 這個 where 條件 //p_priority == "ALL" 顯示全部資料 if (p_query_type == "999" && p_priority == "ALL") { myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted"; } else if (p_query_type == "999" && p_priority == "Null") { //p_priority == "Null" 顯示已讀或未讀資料 //移除 p.Priority == p_priority myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.Read_YN == p_read_yn; } else if (p_query_type == "999" && p_read_yn == "Null") { //p_read_yn == "Null" 顯示優先等級資料 //移除 p.Read_YN == p_read_yn myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.Priority == p_priority; } //<option value="999">請選擇查詢項目</option> // <option value="100">系統分類</option> // <option value="200">個人分類</option> // <option value="300">關鍵字</option> else if (p_query_type == "100") {//100 = 系統分類 myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.InformationCategoryID == Convert.ToInt32(p_data); } else if (p_query_type == "200") {//200 = 使用者帳號 myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.MemberID == Convert.ToInt32(p_data); } else if (p_query_type == "300") {//300 = 關鍵字 myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.InformationContent.Contains(p_data); } else if (p_query_type == "400") {//全部資料 myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted"; } else { //no use //myWhere = p => p.Status != "User_Deleted" && p.Status != "Admin_Deleted" && p.Read_YN == p_read_yn && p.Priority == p_priority; } table = db.Information.Where(myWhere); List <CInformation> list = new List <CInformation>(); foreach (Information item in table) { list.Add(new CInformation() { information_entity = item, InformationCategoryName = item.InformationCategory.InformationCategoryName, //三元運算子 UserCategoryName = item.MemberCategoryID == null ? "未分類" : item.MemberInformationCategory.MemberCategoryName, //UserCategoryName = item.MemberInformationCategory.MemberCategoryName == null ? "未分類": item.MemberInformationCategory.MemberCategoryName }); //CInformation x = new CInformation(); //x.information_entity = item; //x.InformationCategoryName = item.InformationCategory.InformationCategoryName; //if (x.MemberCategoryID != null) //{ // MemberInformationCategory c = db.MemberInformationCategory.Where(p => p.MemberCategoryID == item.MemberCategoryID).FirstOrDefault(); // //沒設關聯, 為了取得 UserCategoryName = MemberInformationCategory.MemberCategoryName // if (c != null) // x.UserCategoryName = c.MemberCategoryName; //} //list.Add(x); } //return View(list); var pagedlist = list.ToPagedList(currentPage, pageSize); //return View(pagedlist); //Page_原始ok 此cshtml使用 return(PartialView(pagedlist));//使用部分顯示 } catch { return(View()); } }
public ActionResult Search(string blogSearchString, int?page) { List <IPublishedContent> contents = new List <IPublishedContent>(); List <BlogPreview> results = new List <BlogPreview>(); var pageNumber = page ?? 1; var searcher = "BlogSearcher"; //Fetching our SearchProvider by giving it the name of our searchprovider var Searcher = Examine.ExamineManager.Instance.SearchProviderCollection[searcher]; foreach (var item in umbracoHelper.TypedSearch(blogSearchString, false, "BlogSearcher")) { var post = umbracoHelper.TypedContent(item.Id); int imageId = post.GetPropertyValue <int>("summaryImage"); var mediaItem = umbracoHelper.Media(imageId); results.Add(new BlogPreview(post.Name, post.GetPropertyValue <string>("summaryText"), mediaItem.Url, post.Url, post.CreateDate, post.CreatorName, 0)); } var urlSegment = string.Format("/blog/search/{0}", blogSearchString); var pageInfo = new HtmlMeta("SITE NAME", "Search results for " + blogSearchString, "", "http://www.example.com", "@OGSiteName", "@TwitterName"); BlogSearchResults searchResults = new BlogSearchResults(blogSearchString, "Search", urlSegment, results.ToPagedList(pageNumber, PAGESIZE)); var viewModel = new SearchResultsViewModel { PageInfo = pageInfo, Results = searchResults }; return(View(viewModel)); }
public ActionResult Tags(string tag, int?page) { List <BlogPreview> blogResults = new List <BlogPreview>(); var pageNumber = page ?? 1; if (!string.IsNullOrEmpty(tag)) { //model = getExamineSearchResultsByField("tagsIndexed", tag); blogResults = blogResultsHelper.getResultsByTag(tag); } var urlSegment = string.Format("/blog/tags/{0}", tag); var pageInfo = new HtmlMeta("SITE NAME", tag, "", "http://www.example.com", "@OGSiteName", "@TwitterName"); BlogSearchResults searchResults = new BlogSearchResults(tag, "Tagged with", urlSegment, blogResults.ToPagedList(pageNumber, PAGESIZE)); var viewModel = new SearchResultsViewModel { PageInfo = pageInfo, Results = searchResults }; return(View(viewModel)); }
public ActionResult NetbuyAsynByCodeOrName(string date, int col, int odcol, NetbuyMode mode, int index, bool isPage, string daytype, bool isOns = false) { Expression <Func <t_foam, bool> > expression = d => true; bool isYestoday = false; switch (mode) { case NetbuyMode.只看上涨: expression = expression.And(d => d.Change >= 0m); break; case NetbuyMode.只看下跌: expression = expression.And(d => d.Change < 0m); break; case NetbuyMode.只看净买: expression = expression.And(d => d.Netbuy >= 0m); break; case NetbuyMode.只看净卖: expression = expression.And(d => d.Netbuy < 0m); break; case NetbuyMode.主力洗筹初期: expression = expression.And(d => d.State == ForceState.XI); break; case NetbuyMode.主力大互盘: expression = expression.And(d => d.State == ForceState.HU); break; case NetbuyMode.主力洗筹末期: expression = expression.And(d => d.State == ForceState.xi); break; case NetbuyMode.主力小互盘: expression = expression.And(d => d.State == ForceState.hu); break; case NetbuyMode.主力大砸盘: expression = expression.And(d => d.State == ForceState.ZA); break; case NetbuyMode.主力拉伸末期: expression = expression.And(d => d.State == ForceState.LA); break; case NetbuyMode.主力小砸盘: expression = expression.And(d => d.State == ForceState.za); break; case NetbuyMode.主力拉伸初期: expression = expression.And(d => d.State == ForceState.la); break; case NetbuyMode.昨日上涨: expression = expression.And(d => d.Change >= 0m); isYestoday = true; break; case NetbuyMode.昨日下跌: expression = expression.And(d => d.Change < 0m); isYestoday = true; break; case NetbuyMode.昨日净买: expression = expression.And(d => d.Netbuy >= 0m); isYestoday = true; break; case NetbuyMode.昨日净卖: expression = expression.And(d => d.Netbuy < 0m); isYestoday = true; break; case NetbuyMode.昨日主力洗筹初期: expression = expression.And(d => d.State == ForceState.XI); isYestoday = true; break; case NetbuyMode.昨日主力大互盘: expression = expression.And(d => d.State == ForceState.HU); isYestoday = true; break; case NetbuyMode.昨日主力洗筹末期: expression = expression.And(d => d.State == ForceState.xi); isYestoday = true; break; case NetbuyMode.昨日主力小互盘: expression = expression.And(d => d.State == ForceState.hu); isYestoday = true; break; case NetbuyMode.昨日主力大砸盘: expression = expression.And(d => d.State == ForceState.ZA); isYestoday = true; break; case NetbuyMode.昨日主力拉伸末期: expression = expression.And(d => d.State == ForceState.LA); isYestoday = true; break; case NetbuyMode.昨日主力小砸盘: expression = expression.And(d => d.State == ForceState.za); isYestoday = true; break; case NetbuyMode.昨日主力拉伸初期: expression = expression.And(d => d.State == ForceState.la); isYestoday = true; break; default: break; } var samples = SetSamplesByDateByCodeOrName(date); //var pd = db.FoamList.Where(expression).ConvertAll(d => samples.ContainsKey(d.Date) ? d.SetNum(samples[d.Date]) : d).OrderBy(d => d.Code).ThenByDescending(d => d.Date).ToPagedList(index, pageSize); var groups = db.FoamList.Where(d => date.Contains(d.Code) || date.Contains(d.Name)).GroupBy(d => d.Date) .Select(g => new { date = g.Key, queue = g }); IEnumerable <t_foam> pd = new List <t_foam>(); if (groups.Any()) { if (groups.SelectMany(d => d.queue).GroupBy(d => d.Code).Count() == 1) { pd = groups.SelectMany(d => d.queue) .ConvertAll(d => samples.ContainsKey(d.Code + d.Date) ? d.SetNum(samples[d.Code + d.Date]) : d); } else if (isYestoday) { if (groups.Count() > 1) { var codes = groups.OrderByDescending(d => d.date).Skip(1).FirstOrDefault()?.queue.AsQueryable() .Where(expression).Select(d => d.Code); pd = groups.OrderByDescending(d => d.date).FirstOrDefault()?.queue.AsQueryable().Where(d => codes.Contains(d.Code)) .ConvertAll(d => samples.ContainsKey(d.Code + d.Date) ? d.SetNum(samples[d.Code + d.Date]) : d); } } else { pd = groups.OrderByDescending(d => d.date).FirstOrDefault()?.queue.AsQueryable().Where(expression) .ConvertAll(d => samples.ContainsKey(d.Code + d.Date) ? d.SetNum(samples[d.Code + d.Date]) : d); } Expression <Func <t_foam, decimal?> > odby = d => d.State == ForceState.XI ? 1 : 0; switch (col) { case 1: odby = d => d.Netbuy; break; case 2: odby = d => d.Change; break; case 3: odby = d => d.Ltotal; break; //case 4: // odby = d => d.Foam; // break; case 5: odby = d => d.Num; break; default: break; } if (isPage || index > 1) { ViewData["odcol"] = odcol; if (col == odcol) { pd = pd.AsQueryable().OrderBy(d => d.Date).ThenBy(odby); } else { pd = pd.AsQueryable().OrderByDescending(d => d.Date).ThenBy(odby); } } else { if (col == odcol) { ViewData["odcol"] = 0; pd = pd.AsQueryable().OrderByDescending(d => d.Date).ThenBy(odby); } else { ViewData["odcol"] = col; pd = pd.AsQueryable().OrderBy(d => d.Date).ThenBy(odby); } } } return(View(isOns ? "NetbuyOns" : "Netbuy", pd.ToPagedList(index, pageSize))); }
public ActionResult Index(string searchString, string currentFilter, string sortOrder, int?page) { int _pageSize = 10; var storyList = new List <Story>(); var storiesCache = (List <Story>)MemoryCache.Default["StoriesCache"]; ViewBag.AuthorSortParam = String.IsNullOrEmpty(sortOrder) ? "Author_desc" : ""; ViewBag.TitleSortParam = sortOrder == "Title" ? "Title_desc" : "Title"; if (!String.IsNullOrEmpty(searchString)) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; if (storiesCache == null) { storyList = _repository .Get(searchString, currentFilter, sortOrder, page) .ToList(); MemoryCache.Default["StoriesCache"] = storyList; } else { storyList = storiesCache; } if (!String.IsNullOrEmpty(searchString)) { searchString = searchString.ToUpper(); storyList = storyList.Where(s => s.Author.ToUpper().Contains(searchString) || s.Title.ToUpper().Contains(searchString)) .ToList(); } switch (sortOrder) { case "Author_desc": storyList = storyList.OrderByDescending(s => s.Author).ToList(); break; case "Title": storyList = storyList.OrderBy(s => s.Title).ToList(); break; case "Title_desc": storyList = storyList.OrderByDescending(s => s.Title).ToList(); break; default: storyList = storyList.OrderBy(s => s.Author).ToList(); break; } storyList = Numbering.Get(storyList); var pageNumber = (page ?? 1); return(View(storyList.ToPagedList(pageNumber, _pageSize))); }
public ActionResult ManageProduct_IC(int?page, string sortOrder) { ViewBag.pcodeSortParm = String.IsNullOrEmpty(sortOrder) ? "pcode" : ""; ViewBag.pname1SortParm = String.IsNullOrEmpty(sortOrder) ? "pname1" : ""; ViewBag.pname11SortParm = String.IsNullOrEmpty(sortOrder) ? "pname11" : ""; ViewBag.ptypeSortParm = String.IsNullOrEmpty(sortOrder) ? "ptype" : ""; ViewBag.pstatusSortParm = String.IsNullOrEmpty(sortOrder) ? "pstatus" : ""; ViewBag.prod_idSortParm = String.IsNullOrEmpty(sortOrder) ? "prod_id" : ""; int pageSize = 5; int pageNumber = (page ?? 1); List <Products> product = _db.Products.ToList(); //ViewBag.getptype = product; List <Typeproduct> ptype = _db.Typeproduct.ToList(); ViewBag.getptype = ptype; List <Warehouse> wcode = _db.Warehouse.ToList(); ViewBag.getwcode = wcode; List <Groupproduct> pgroup = _db.Groupproduct.ToList(); ViewBag.getpgroup = pgroup; List <Unit> unit = _db.Unit.ToList(); ViewBag.getunit = unit; switch (sortOrder) { case "pcode": product = _db.Products.OrderBy(s => s.pcode).ToList(); break; case "pname1": product = _db.Products.OrderBy(s => s.pname1).ToList(); break; case "pname11": product = _db.Products.OrderBy(s => s.pname11).ToList(); break; case "ptype": product = _db.Products.OrderBy(s => s.ptype).ToList(); break; case "pstatus": product = _db.Products.OrderBy(s => s.pstatus).ToList(); break; case "prod_id": product = _db.Products.OrderBy(s => s.prod_id).ToList(); break; default: product = product.OrderByDescending(s => s.prod_id).ToList(); break; } ViewBag.MyData = product.ToPagedList(pageNumber, pageSize); ViewBag.sortOrder = sortOrder; return(View()); }
public ActionResult Index(string searchStringUserNameOrEmail, string currentFilter, int?page) { try { int intPage = 1; int intPageSize = 5; int intTotalPageCount = 0; if (searchStringUserNameOrEmail != null) { intPage = 1; } else { if (currentFilter != null) { searchStringUserNameOrEmail = currentFilter; intPage = page ?? 1; } else { searchStringUserNameOrEmail = ""; intPage = page ?? 1; } } ViewBag.CurrentFilter = searchStringUserNameOrEmail; List <ExpandedUserDTO> col_UserDTO = new List <ExpandedUserDTO>(); int intSkip = (intPage - 1) * intPageSize; intTotalPageCount = UserManager.Users .Where(x => x.UserName.Contains(searchStringUserNameOrEmail)) .Count(); var result = UserManager.Users .Where(x => x.UserName.Contains(searchStringUserNameOrEmail)) .OrderBy(x => x.UserName) .Skip(intSkip) .Take(intPageSize) .ToList(); foreach (var item in result) { ExpandedUserDTO objUserDTO = new ExpandedUserDTO(); objUserDTO.UserName = item.UserName; objUserDTO.Email = item.Email; objUserDTO.LockoutEndDateUtc = item.LockoutEndDateUtc; col_UserDTO.Add(objUserDTO); } // Set the number of pages var _UserDTOAsIPagedList = new StaticPagedList <ExpandedUserDTO> ( col_UserDTO, intPage, intPageSize, intTotalPageCount ); return(View(_UserDTOAsIPagedList)); } catch (Exception ex) { ModelState.AddModelError(string.Empty, "Error: " + ex); List <ExpandedUserDTO> col_UserDTO = new List <ExpandedUserDTO>(); return(View(col_UserDTO.ToPagedList(1, 25))); } }
public PartialViewResult CommentForm(int?id, int?page) { List <Comment> comment = db.Comments.Where(n => n.IDProduct == id).ToList(); ViewBag.Comment = comment; //rating double ratingTotal = 0; int count = 0; int r1 = 0, r2 = 0, r3 = 0, r4 = 0, r5 = 0; double ratioR1 = 0, ratioR2 = 0, ratioR3 = 0, ratioR4 = 0, ratioR5 = 0; foreach (var i in comment) { if (i.Rate == 1) { r1++; } if (i.Rate == 2) { r2++; } if (i.Rate == 3) { r3++; } if (i.Rate == 4) { r4++; } if (i.Rate == 5) { r5++; } count++; } if ((r1 + r2 + r3 + r4 + r5) != 0) { ratingTotal = (5 * r5 + 4 * r4 + 3 * r3 + 2 * r2 + 1 * r1) / (r1 + r2 + r3 + r4 + r5); } else { ratingTotal = 0; } ratioR1 = (double)((double)r1 / count) * 100; ratioR2 = (double)((double)r2 / count) * 100; ratioR3 = (double)((double)r3 / count) * 100; ratioR4 = (double)((double)r4 / count) * 100; ratioR5 = (double)((double)r5 / count) * 100; // ViewBag.R1 = r1; ViewBag.R2 = r2; ViewBag.R3 = r3; ViewBag.R4 = r4; ViewBag.R5 = r5; // ViewBag.RatioR1 = ratioR1; ViewBag.RatioR2 = ratioR2; ViewBag.RatioR3 = ratioR3; ViewBag.RatioR4 = ratioR4; ViewBag.RatioR5 = ratioR5; if (ratingTotal != null) { ViewBag.RateTotal = ratingTotal; } else { ViewBag.RateTotal = 0; } //end rating //paging int pageSize = 9; int pageCurrent = (page ?? 1); return(PartialView(comment.ToPagedList(pageCurrent, pageSize))); }
// GET: /<controller>/ public IActionResult Index(string currentSort, string sortOrder, string currentFilter, string searchString, int?page) { List <Employee> employeeList = _employeeService.Get(); ViewBag.NameSortParam = sortOrder == "Name" ? "name_desc" : "Name"; ViewBag.LastnameSortParam = sortOrder == "Lastname" ? "lastname_desc" : "Lastname"; ViewBag.EmailSortParam = sortOrder == "Email" ? "email_desc" : "Email"; ViewBag.PhoneSortParam = sortOrder == "Phone" ? "phone_desc" : "Phone"; ViewBag.HireDateParam = sortOrder == "HireDate" ? "hire_date" : "HireDate"; if (!String.IsNullOrEmpty(searchString)) { employeeList = employeeList.Where(s => s.Email.Contains(searchString) || s.Name.ToString().Contains(searchString) || s.Lastname.Contains(searchString) || s.Phone.Contains(searchString)).ToList(); ViewBag.CurrentFilter = searchString; } else { if (!String.IsNullOrEmpty(currentFilter)) { ViewBag.CurrentFilter = currentFilter; employeeList = employeeList.Where(s => s.Email.Contains(currentFilter) || s.Name.Contains(currentFilter) || s.Lastname.ToString().Contains(currentFilter) || s.Phone.Contains(currentFilter)).ToList(); } } if (String.IsNullOrEmpty(sortOrder)) { sortOrder = currentSort; } switch (sortOrder) { case "Name": employeeList = employeeList.OrderBy(s => s.Name).ToList(); ViewBag.CurrentSort = sortOrder; break; case "name_desc": employeeList = employeeList.OrderByDescending(s => s.Name).ToList(); ViewBag.CurrentSort = sortOrder; break; case "Lastname": employeeList = employeeList.OrderBy(s => s.Lastname).ToList(); ViewBag.CurrentSort = sortOrder; break; case "lastname_desc": employeeList = employeeList.OrderByDescending(s => s.Lastname).ToList(); ViewBag.CurrentSort = sortOrder; break; case "Email": employeeList = employeeList.OrderBy(s => s.Email).ToList(); ViewBag.CurrentSort = sortOrder; break; case "email_desc": employeeList = employeeList.OrderByDescending(s => s.Email).ToList(); ViewBag.CurrentSort = sortOrder; break; case "Phone": employeeList = employeeList.OrderBy(s => s.Phone).ToList(); ViewBag.CurrentSort = sortOrder; break; case "phone_desc": employeeList = employeeList.OrderByDescending(s => s.Phone).ToList(); ViewBag.CurrentSort = sortOrder; break; case "HireDate": employeeList = employeeList.OrderBy(s => s.HireDate).ToList(); ViewBag.CurrentSort = sortOrder; break; case "hire_date": employeeList = employeeList.OrderByDescending(s => s.HireDate).ToList(); ViewBag.CurrentSort = sortOrder; break; } int pageSize = 10; var pageNumber = page ?? 1; return(View(employeeList.ToPagedList(pageNumber, pageSize))); }
// GET: demo public ActionResult Index(int?i, DateTime?start, DateTime?end, string sortOrder, DateTime?currentFilter, DateTime?currentFilter2) { Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("uk"); Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("uk"); ViewBag.CurrentSort = sortOrder; string mainconn = ConfigurationManager.ConnectionStrings["Myconnection"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); string sqlquery; if (start == null) { start = Estado.fecha_i; end = Estado.fecha_f; sqlquery = "set dateformat dmy select top 200 * from [erpadmin].[P_APP_HACIENDA_DE] where FECHA between '" + start + "'and'" + end + "'"; } else { sqlquery = "set dateformat dmy select * from [erpadmin].[P_APP_HACIENDA_DE] where FECHA between '" + start + "'and'" + end + "'"; ViewBag.CurrentFilter = start; ViewBag.CurrentFilter2 = end; Estado.fecha_i = Convert.ToDateTime(start); Estado.fecha_f = Convert.ToDateTime(end); } SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn); sqlconn.Open(); SqlDataAdapter sda = new SqlDataAdapter(sqlcomm); DataSet ds = new DataSet(); sda.Fill(ds); List <MVClass> lc = new List <MVClass>(); foreach (DataRow dr in ds.Tables[0].Rows) { var con_err = Convert.ToString(dr["CONTIENE_ERRORES"]); var con_errws = Convert.ToString(dr["ERROR_WS"]); var con_soft = Convert.ToString(dr["ERROR_SOFTLAND"]); var acept = Convert.ToString(dr["ACEPTADO"]); var envia = Convert.ToString(dr["ENVIADO"]); var error = true; var error2 = true; var error3 = true; var var_env = false; var var_acep = false; if (con_err == "N") { error = false; } if (con_errws == "N") { error2 = false; } if (con_soft == "N") { error3 = false; } if (envia == "S") { var_env = true; } if (acept == "A") { var_acep = true; } lc.Add(new MVClass { DOCUMENTO = Convert.ToString(dr["DOCUMENTO"]), CLIENTE = Convert.ToString(dr["CLIENTE"]), FECHA = Convert.ToDateTime(dr["FECHA"]), NOMBRE = Convert.ToString(dr["NOMBRE"]), NIT_RECEPTOR = Convert.ToString(dr["NIT_RECEPTOR"]), CODIGO_MONEDA = Convert.ToString(dr["CODIGO_MONEDA"]), CLAVE = Convert.ToString(dr["CLAVE"]), TOTALGRAVADO = Convert.ToDecimal(dr["TOTALGRAVADO"]), TOTALEXENTO = Convert.ToDecimal(dr["TOTALEXENTO"]), TOTALDESCUENTOS = Convert.ToDecimal(dr["TOTALDESCUENTOS"]), TOTALIMPUESTO = Convert.ToDecimal(dr["TOTALIMPUESTO"]), TOTALCOMPROBANTE = Convert.ToDecimal(dr["TOTALCOMPROBANTE"]), CONTIENE_ERRORES = error, ERROR_WS = error2, ERROR_SOFTLAND = error3, ENVIADO = var_env, ACEPTADO = var_acep, RESPUESTA_XML = Convert.ToString(dr["RESPUESTA_XML"]).Remove(0, 19), PDF = Convert.ToString(dr["PDF"]).Remove(0, 19), XML = Convert.ToString(dr["XML"]).Remove(0, 19), CIA = Convert.ToString(dr["CIA"]) }); } int pagesize = 25; int pagenumber = (i ?? 1); sqlconn.Close(); ModelState.Clear(); return(View(lc.ToPagedList(pagenumber, pagesize))); }
public ViewResult SearchLink(string recordnumber, string invoicedate, string toinvoicedate, string invoicenumber, string vendornumber, string vendorname, string ponumber, string invoicetypecd, string sortOrder, int?page) { ViewBag.Currentrecordnumber = recordnumber; ViewBag.Currentinvoicedate = invoicedate; ViewBag.Currenttoinvoicedate = toinvoicedate; ViewBag.Currentinvoicenumber = invoicenumber; ViewBag.Currentvendornumber = vendornumber; ViewBag.Currentvendorname = vendorname; ViewBag.Currentponumber = ponumber; ViewBag.Currentinvoicetypecd = invoicetypecd; ViewBag.CurrentSort = sortOrder; ViewBag.DateSortParm = String.IsNullOrEmpty(sortOrder) ? "date" : ""; ViewBag.VendorNameSortParm = sortOrder == "vendor" ? "vendor_desc" : "vendor"; ViewBag.InvoiceTypeSortParm = sortOrder == "invoicetype" ? "invoicetype_desc" : "invoicetype"; DateTime?toinvoicedateparse = null; DateTime?invoicedateparse = null; if (!String.IsNullOrEmpty(toinvoicedate)) { toinvoicedateparse = Convert.ToDateTime(toinvoicedate); } if (!String.IsNullOrEmpty(invoicedate)) { invoicedateparse = Convert.ToDateTime(invoicedate); } // page = 1; var apcainvoices = new List <APCAInvoice>(); if (NoParams(recordnumber, invoicedate, toinvoicedate, invoicenumber, vendornumber, vendorname, ponumber, invoicetypecd)) { apcainvoices = db.APCAInvoices.OrderByDescending(a => a.Invoice_Date).Take(100).ToList(); } else { SqlConnection oSQLConn = new SqlConnection(); oSQLConn.ConnectionString = ConfigurationManager.ConnectionStrings["APCAAppDBContext"].ConnectionString; try { oSQLConn.Open(); SqlCommand cmd = new SqlCommand("GetAPCAInvoices", oSQLConn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter fromInvoiceDateparam = new SqlParameter("@FromInvoiceDate", System.Data.SqlDbType.DateTime); fromInvoiceDateparam.Value = invoicedateparse; SqlParameter toInvoiceDateparam = new SqlParameter("@ToInvoiceDate", System.Data.SqlDbType.DateTime); toInvoiceDateparam.Value = toinvoicedateparse; cmd.Parameters.AddWithValue("@RecordNumber", recordnumber); cmd.Parameters.Add(fromInvoiceDateparam); cmd.Parameters.Add(toInvoiceDateparam); cmd.Parameters.AddWithValue("@InvoiceNumber", invoicenumber); cmd.Parameters.AddWithValue("@VendorNumber", vendornumber); cmd.Parameters.AddWithValue("@VendorName", vendorname); cmd.Parameters.AddWithValue("@PONumber", ponumber); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { apcainvoices.Add(new APCAInvoice { //APCAInvoiceID = reader["APCAInvoiceID"].ToString(), Record_Number = reader["Record_Number"].ToString(), Invoice_Date = Convert.ToDateTime(reader["Invoice_Date"].ToString()), Invoice_Number = reader["Invoice_Number"].ToString(), Vendor_Number = reader["Vendor_Number"].ToString(), Vendor_Name = reader["Vendor_Name"].ToString(), PO_Number = reader["PO_Number"].ToString(), Invoice_Type_cd = (reader["Invoice_Type_cd"] != null) ? reader["Invoice_Type_cd"].ToString() : null //etc }); } } } catch (Exception ex) { } if (apcainvoices.Count() > 100) { ViewBag.TotalAPRecords = "Search Criteria returned " + apcainvoices.Count() + " records. Only the first 100 records are displayed. Please narrow your search criteria."; if (Response.IsClientConnected) { apcainvoices = apcainvoices.OrderByDescending(a => a.Invoice_Date).Take(100).ToList(); } else { apcainvoices = apcainvoices.OrderByDescending(a => a.Invoice_Date).Take(100).ToList(); } } else { ViewBag.TotalAPRecords = "Your search criteria returned " + apcainvoices.Count() + " record(s)."; } } switch (sortOrder) { case "vendor_desc": apcainvoices = apcainvoices.OrderByDescending(s => s.Vendor_Name).ToList(); break; case "vendor": apcainvoices = apcainvoices.OrderBy(s => s.Vendor_Name).ToList(); break; case "invoicetype_desc": apcainvoices = apcainvoices.OrderByDescending(s => s.Invoice_Type_cd).ToList(); break; case "invoicetype": apcainvoices = apcainvoices.OrderBy(s => s.Invoice_Type_cd).ToList(); break; case "date": apcainvoices = apcainvoices.OrderBy(s => s.Invoice_Date).ToList(); break; default: apcainvoices = apcainvoices.OrderByDescending(a => a.Invoice_Date).ToList(); break; } int pageSize = 30; int pageNumber = (page ?? 1); //return PartialView("_AP", await apcainvoices.ToListAsync()); return(View(apcainvoices.ToPagedList(pageNumber, pageSize))); }
// GET: /Emp/ public ActionResult Index(string sortOrder, string searchString, string currentFilter, int?page) { ViewBag.CurrentSort = sortOrder; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DesigSortParm = sortOrder == "designation" ? "designation_desc" : "designation"; ViewBag.LocSortParm = sortOrder == "location" ? "location_desc" : "location"; ViewBag.SectionSortParm = sortOrder == "section" ? "section_desc" : "section"; ViewBag.DepartmentSortParm = sortOrder == "wing" ? "wing_desc" : "wing"; ViewBag.ShiftSortParm = sortOrder == "shift" ? "shift_desc" : "shift"; ViewBag.TypeSortParm = sortOrder == "type" ? "type_desc" : "type"; //List<EmpView> emps = new List<EmpView>(); if (searchString != null) { page = 1; } else { searchString = currentFilter; } User LoggedInUser = Session["LoggedUser"] as User; QueryBuilder qb = new QueryBuilder(); string query = qb.MakeCustomizeQuery(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from EmpView" + query); List <EmpView> emps = dt.ToList <EmpView>(); ViewBag.CurrentFilter = searchString; if (!String.IsNullOrEmpty(searchString)) { if (searchString == "Active" || searchString == "active") { emps = emps.Where(aa => aa.Status == true).ToList(); } else if (searchString == "Inactive" || searchString == "inactive") { emps = emps.Where(aa => aa.Status == false).ToList(); } else { try { emps = emps.Where(s => s.EmpName.ToUpper().Contains(searchString.ToUpper()) || s.EmpNo.Contains(searchString.ToUpper()) || s.SectionName.ToUpper().Contains(searchString.ToUpper()) || s.ShiftName.ToUpper().Contains(searchString.ToUpper()) || s.DesignationName.ToUpper().Contains(searchString.ToUpper())).ToList(); } catch (Exception ex) { } } } switch (sortOrder) { case "name_desc": emps = emps.OrderByDescending(s => s.EmpName).ToList(); break; case "designation_desc": emps = emps.OrderByDescending(s => s.DesignationName).ToList(); break; case "designation": emps = emps.OrderBy(s => s.DesignationName).ToList(); break; case "location_desc": emps = emps.OrderByDescending(s => s.LocName).ToList(); break; case "location": emps = emps.OrderBy(s => s.LocName).ToList(); break; case "section_desc": emps = emps.OrderByDescending(s => s.SectionName).ToList(); break; case "section": emps = emps.OrderBy(s => s.SectionName).ToList(); break; case "wing_desc": emps = emps.OrderByDescending(s => s.DeptName).ToList(); break; case "wing": emps = emps.OrderBy(s => s.DeptName).ToList(); break; case "shift_desc": emps = emps.OrderByDescending(s => s.ShiftName).ToList(); break; case "shift": emps = emps.OrderBy(s => s.ShiftName).ToList(); break; case "type_desc": emps = emps.OrderByDescending(s => s.TypeName).ToList(); break; case "type": emps = emps.OrderBy(s => s.TypeName).ToList(); break; default: emps = emps.OrderBy(s => s.EmpName).ToList(); break; } int pageSize = 10; int pageNumber = (page ?? 1); return(View(emps.ToPagedList(pageNumber, pageSize))); //var emps = db.Emps.Include(e => e.Company).Include(e => e.Crew).Include(e => e.Designation).Include(e => e.Grade).Include(e => e.JobTitle).Include(e => e.Location).Include(e => e.Section).Include(e => e.Shift).Include(e => e.EmpType).Include(e => e.EmpFace).Include(e => e.EmpFp).Include(e => e.LvQuota); //return View(emps.ToList()); }
// GET: Comics public ActionResult Index(string searchBd, string sortOrder, string currentFilter, int?page) { ViewBag.CurrentSort = sortOrder; if (searchBd != null) { page = 1; } else { searchBd = currentFilter; } ViewBag.CurrentFilter = searchBd; ApplicationDbContext context = new ApplicationDbContext(); string userid = User.Identity.GetUserId(); IEnumerable <Comic> comics = new List <Comic>(); ViewBag.DateSortParm = String.IsNullOrEmpty(sortOrder) ? "date_asc" : ""; ViewBag.SerieSortParm = sortOrder == "Serie" ? "serie_desc" : "Serie"; ViewBag.TitleSortParm = sortOrder == "Title" ? "title_desc" : "Title"; ViewBag.VolumeSortParm = sortOrder == "Volume" ? "volume_desc" : "Volume"; ViewBag.ScenaristSortParm = sortOrder == "Scenarist" ? "scenarist_desc" : "Scenarist"; ViewBag.CartoonistSortParm = sortOrder == "Cartoonist" ? "cartoonist_desc" : "Cartoonist"; ViewBag.RatingSortParm = sortOrder == "Rating" ? "rating_asc" : "Rating"; if (!string.IsNullOrEmpty(userid)) { comics = context.Comics.Where(x => x.UserId == userid); if (!String.IsNullOrEmpty(searchBd)) { string searchBdLower = searchBd.ToLower(); comics = comics.Where(s => s.Serie.ToLower().Contains(searchBdLower) || s.Title.ToLower().Contains(searchBdLower) || (!string.IsNullOrEmpty(s.Scenarist) && s.Scenarist.ToLower().Contains(searchBdLower)) || (!string.IsNullOrEmpty(s.Cartoonist) && s.Cartoonist.ToLower().Contains(searchBdLower))); } switch (sortOrder) { case "serie_desc": comics = comics.OrderByDescending(s => s.Serie); break; case "Serie": comics = comics.OrderBy(s => s.Serie); break; case "title_desc": comics = comics.OrderByDescending(s => s.Title); break; case "Title": comics = comics.OrderBy(s => s.Title); break; case "volume_desc": comics = comics.OrderByDescending(s => s.Volume); break; case "Volume": comics = comics.OrderBy(s => s.Volume); break; case "scenarist_desc": comics = comics.OrderByDescending(s => s.Scenarist); break; case "Scenarist": comics = comics.OrderBy(s => s.Scenarist); break; case "cartoonist_desc": comics = comics.OrderByDescending(s => s.Cartoonist); break; case "Cartoonist": comics = comics.OrderBy(s => s.Cartoonist); break; case "date_asc": comics = comics.OrderBy(s => s.Date); break; case "rating_asc": comics = comics.OrderBy(s => s.Rating); break; case "Rating": comics = comics.OrderByDescending(s => s.Rating); break; default: comics = comics.OrderByDescending(s => s.Date); break; } int pageSize = 15; int pageNumber = (page ?? 1); return(View(comics.ToPagedList(pageNumber, pageSize))); } else { return(View("Error")); } }
// GET: Books public ActionResult Index(string searchString, string sortOption, int page = 1) { try { int pageSize = 3; var books = db.Books.ToList(); if (!String.IsNullOrEmpty(searchString)) { books = (db.Books.Include(b => b.Author).Include(b => b.Country).Where(n => n.Title.Contains(searchString) || n.Author.FullName.Contains(searchString))).ToList(); if (!books.Any()) { return(PartialView("NotFound", searchString)); } } List <BookModel> bm = GetBooksList.GetResult(books); switch (sortOption) { case "title_acs": bm = bm.OrderBy(p => p.Title).ToList(); break; case "title_desc": bm = bm.OrderByDescending(p => p.Title).ToList(); break; case "author_acs": bm = bm.OrderBy(p => p.AuthorID).ToList(); break; case "author_desc": bm = bm.OrderByDescending(p => p.AuthorID).ToList(); break; case "country_acs": bm = bm.OrderBy(p => p.CountryID).ToList(); break; case "country_desc": bm = bm.OrderByDescending(p => p.CountryID).ToList(); break; case "pages_acs": bm = bm.OrderBy(p => p.PagesCount).ToList(); break; case "pages_desc": bm = bm.OrderByDescending(p => p.PagesCount).ToList(); break; case "price_acs": bm = bm.OrderBy(p => p.TotalPrice).ToList(); break; case "price_desc": bm = bm.OrderByDescending(p => p.TotalPrice).ToList(); break; default: bm = bm.OrderBy(p => p.BookID).ToList(); break; } if (page > bm.ToPagedList(page, pageSize).PageCount) { return(RedirectToAction("Index")); } return(Request.IsAjaxRequest() ? (ActionResult)PartialView("GridBooks", bm.ToPagedList(page, pageSize)) : View(bm.ToPagedList(page, pageSize))); } catch (Exception ex) { throw ex; } }
public ActionResult ArchiveByYearMonth(int year, int month, int?page) { IPublishedContent homePage = umbracoHelper.TypedContentAtRoot().FirstOrDefault(x => x.ContentType.Alias.Equals("home")); IPublishedContent blogPage = homePage.Children.Where(x => x.DocumentTypeAlias == "blogHome").FirstOrDefault(); var pageNumber = page ?? 1; List <BlogPost> blogResults = blogPage.Descendants <BlogPost>().ToList(); List <BlogPreview> blogPreviews = new List <BlogPreview>(); foreach (BlogPost post in blogResults.Where(r => r.CreateDate.Year == year && r.CreateDate.Month == month).OrderByDescending(x => x.CreateDate)) { int imageId = post.GetPropertyValue <int>("summaryImage"); var mediaItem = umbracoHelper.Media(imageId); blogPreviews.Add(new BlogPreview(post.Name, post.SummaryText, mediaItem.Url, post.Url, post.CreateDate, post.CreatorName)); } var date = new DateTime(year, month, 1); var urlSegment = string.Format("/blog/{0}/{1}", date.ToString("yyyy"), date.ToString("MM")); var infoTitle = date.ToString("MM yyyy") + " Archives"; var pageInfo = new HtmlMeta("SITE NAME", infoTitle, "", "http://www.example.com", "@OGSiteName", "@TwitterName"); BlogSearchResults searchResults = new BlogSearchResults(date.ToString("MMMM yyyy"), "Archives", urlSegment, blogPreviews.ToPagedList(pageNumber, PAGESIZE)); var viewModel = new SearchResultsViewModel { PageInfo = pageInfo, Results = searchResults }; return(View(viewModel)); }
public async Task Get_Paginated_Role_List_With_PageSize_Test(int pageSize) { // Arrange var pagedQuery = new PagedQuery { PageSize = pageSize }; _mockRolerService.Setup(s => s.GetPaginatedList(It.IsAny <PagedQuery>())).ReturnsAsync(() => _roles.ToPagedList(_roles.Count)); // Assert var pagedList = await _mockRolerService.Object.GetPaginatedList(pagedQuery); Assert.NotNull(pagedList); Assert.NotNull(pagedList.Items); Assert.True(pagedList.Items.IsNotEmpty()); Assert.True(pagedList.Items.ToList().Count <= pagedQuery.PageSize); Assert.Equal(pagedList.Count, _roles.Count); // Act _mockRolerService.Verify((s) => s.GetPaginatedList(pagedQuery)); }
public ActionResult Category(string category, int?page) { List <BlogPreview> blogResults = new List <BlogPreview>(); var pageNumber = page ?? 1; if (!string.IsNullOrEmpty(category)) { blogResults = blogResultsHelper.getResultsByCategory(category); } var urlSegment = string.Format("/blog/category/{0}", category); var pageInfo = new HtmlMeta("SITE NAME", category, "", "http://www.example.com", "@OGSiteName", "@TwitterName"); BlogSearchResults searchResults = new BlogSearchResults(category, "Categorised as", urlSegment, blogResults.ToPagedList(pageNumber, PAGESIZE)); var viewModel = new SearchResultsViewModel { PageInfo = pageInfo, Results = searchResults }; return(View(viewModel)); }
public ActionResult Index(int?page, int?pageItems) { int idClub; try { Organization myClub = Session["MyClub"] as Organization; idClub = myClub.Id; } catch (Exception e) { idClub = 2; } var userProcessor = new UserProcessor(); var players = new List <PlayerListViewModel>(); try { var myPlayers = userProcessor.GetClubPlayers(idClub); foreach (var item in myPlayers) { PlayerListViewModel player = new PlayerListViewModel(); player.setId(item.Id); player.setFirstName(item.FirstName); player.setLastName(item.LastName); players.Add(player); } } catch (Exception e) { //players = null; } //<Broj stavki po stranici> List <SelectListItem> items = new List <SelectListItem> { new SelectListItem { Text = "10", Value = "10" }, new SelectListItem { Text = "15", Value = "15" }, new SelectListItem { Text = "20", Value = "20" } }; ViewData["ItemsPerPage"] = new SelectList(items, "Value", "Text", pageItems); ViewBag.CurrentPageSize = pageItems ?? 10; //</Broj stavki po stranici> //<Paginacija> int pageSize = (pageItems ?? 10); int pageNumber = (page ?? 1); //</Paginacija> return(View(players.ToPagedList(pageNumber, pageSize))); }
public ActionResult ManageTypes(string search, int?page, string sortby) { var emailid = User.Identity.Name.ToString(); Users admin = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault(); ViewBag.SortDate = string.IsNullOrEmpty(sortby) ? "Date Desc" : ""; ViewBag.SortType = sortby == "Type" ? "Type Desc" : "Type"; ViewBag.SortDescription = sortby == "Description" ? "Description Desc" : "Description"; ViewBag.SortAddedBy = sortby == "AddedBy" ? "AddedBy Desc" : "AddedBy"; System.Linq.IQueryable <NotesMarketplace.NoteTypes> filtered; if (String.IsNullOrEmpty(search)) // All Type { // All Type filtered = dbobj.NoteTypes.Where(x => x.IsActive == true || x.IsActive == false).ToList().AsQueryable(); } else { filtered = dbobj.NoteTypes.Where(x => (x.Name.Contains(search) || x.Description.Contains(search) || (x.CreatedDate.Value.Day + "-" + x.CreatedDate.Value.Month + "-" + x.CreatedDate.Value.Year).Contains(search) )).ToList().AsQueryable(); } switch (sortby) { case "Date Desc": filtered = filtered.OrderByDescending(x => x.CreatedDate); break; case "Type": filtered = filtered.OrderBy(x => x.Name); break; case "Type Desc": filtered = filtered.OrderByDescending(x => x.Name); break; case "Description": filtered = filtered.OrderBy(x => x.Description); break; case "Description Desc": filtered = filtered.OrderByDescending(x => x.Description); break; default: filtered = filtered.OrderBy(x => x.CreatedDate); break; } //Converting filtered entry into Manage Type Model var mtobj = new List <ManageType>(); foreach (var item in filtered) { mtobj.Add(new ManageType() { TypeID = item.ID, TypeName = item.Name, Description = item.Description, CreatedDate = item.CreatedDate, AddedBy = "", IsActive = item.IsActive }); } ViewBag.ProfilePicture = dbobj.Admin.Where(x => x.UserID == admin.ID).Select(x => x.ProfilePicture).FirstOrDefault(); return(View(mtobj.ToPagedList(page ?? 1, 5))); }
// GET: Aluno / Lista //https://docs.microsoft.com/pt-br/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application //https://stackoverflow.com/questions/2728340/how-can-i-do-an-orderby-with-a-dynamic-string-parameter //http://jasonwatmore.com/post/2014/07/16/dynamic-linq-using-strings-to-sort-by-properties-and-child-object-properties //http://www.macoratti.net/12/01/aspn_mvc32.htm public async Task <ActionResult> Lista(string sortOrder = "id", string strCriterio = "", int?page = 1) { if (Session["usuarioId"] == null) { return(RedirectToAction("Login", "Home")); } if (ViewBag.Orders == null) { //Se tivesse mais tempo faria isto dinamicamente ViewBag.Orders = new List <string> { "id", "Nome", "CPF", "data_nascimento", "sexo", "telefonemov", "data_cadastro", "cidade" }; } if (!string.IsNullOrEmpty(strCriterio)) { string[] valores = strCriterio.Split('|'); if (valores.Count() == 3) { page = 1; } } List <ListAlunos> listAlunoViewModel = new List <ListAlunos>(); await Task.Factory.StartNew(() => { using (Repositorio <Aluno> ralu = new Repositorio <Aluno>()) { Expression <Func <Aluno, bool> > expressao = null; IQueryable <Aluno> registros; if (!string.IsNullOrEmpty(strCriterio)) { var filter = new Filter <Aluno>(); string tipoCampo, nomeCampo, valorCampo; tipoCampo = nomeCampo = valorCampo = string.Empty; string[] valores = strCriterio.Split('|'); tipoCampo = valores[0]; nomeCampo = valores[1]; valorCampo = valores[2]; ViewBag.CurrentFilter = valorCampo; if (tipoCampo == "text") { filter.By(nomeCampo.Replace(" desc", ""), Operation.StartsWith, valorCampo); expressao = filter.GetExpression(filter); } else if (tipoCampo == "number") { int valorInt = Convert.ToInt32(valorCampo); filter.By(nomeCampo.Replace(" desc", ""), Operation.EqualTo, valorInt); expressao = filter.GetExpression(filter); } else if (tipoCampo == "date") { DateTime data = Convert.ToDateTime(valorCampo); filter.By(nomeCampo.Replace(" desc", ""), Operation.EqualTo, data); expressao = filter.GetExpression(filter); } if (expressao != null) { registros = ralu.OrderBy(ralu.Get(expressao), sortOrder.Replace(" desc", ""), !sortOrder.EndsWith(" desc")); } else { registros = ralu.OrderBy(ralu.Get(), sortOrder.Replace(" desc", ""), !sortOrder.EndsWith(" desc")); } } else { //sortOrder.Replace("id", "cMun") - Força o mapeamento virtual registros = ralu.OrderBy(ralu.Get(), sortOrder.Replace(" desc", ""), !sortOrder.EndsWith(" desc")); } var registrosEnum = registros.GetEnumerator(); //Se mais tempo seria AutoMapper while (registrosEnum.MoveNext()) { listAlunoViewModel.Add(new ListAlunos { id = registrosEnum.Current.id, Nome = registrosEnum.Current.nome, CPF = registrosEnum.Current.cpf, data_nascimento = registrosEnum.Current.data_nascimento, sexo = registrosEnum.Current.sexo, telefonemov = registrosEnum.Current.telefonemov, cidade = registrosEnum.Current.cidade, data_cadastro = registrosEnum.Current.data_cadastro }); } } }); var listaOrder = (List <string>)ViewBag.Orders; for (int i = 0; i < listaOrder.Count; i++) { if (listaOrder[i] == sortOrder) { if (listaOrder[i].EndsWith(" desc")) { listaOrder[i] = listaOrder[i].Replace(" desc", ""); } else { listaOrder[i] = listaOrder[i] + " desc"; } } } ViewBag.Orders = listaOrder; int pageSize = 10; int pageNumber = (page ?? 1); return(View(listAlunoViewModel.ToPagedList(pageNumber, pageSize))); }
public ActionResult Index(int?page, string idea_title, string name, string categoryID, string departmentID, string ideaStatus, string time_order, string pubFrom, string pubTo) { //check logged in? if (Session["loggedIn"] == null) { return(Redirect("~/Home/LoginPage")); } if (Session["deptCbb"] == null) { List <department> departments = dbData.departments.ToList(); SelectList listItems = new SelectList(departments, "department_id", "department_name"); Session["deptCbb"] = listItems; } if (Session["cateCbb"] == null) { List <category> categories = dbData.categories.ToList(); SelectList listItems = new SelectList(categories, "category_id", "category_name"); Session["cateCbb"] = listItems; } //store page to return to proper page when visited Details page Session["previousPage"] = Url.Action("Index", "Idea"); current_year = dbData.academic_years.Where(item => item.started_at <= DateTime.Now).Where(item => item.ended_at >= DateTime.Now).Single(); List <display_idea> display_Ideas = getAllDisplayIdeas().Where(item => item.idea.isEnabled == 1).ToList(); //--------filtering------- //filter with title display_Ideas = TitleFilter(display_Ideas, idea_title); // filter with published user name display_Ideas = UsernameFilter(display_Ideas, name); //filter with category display_Ideas = CategoryFilter(display_Ideas, categoryID); //filter with department display_Ideas = DepartmentFilter(display_Ideas, departmentID); // filter for status display_Ideas = StatusFilter(display_Ideas, ideaStatus); // filter publish from to display_Ideas = PublishFromFilter(display_Ideas, pubFrom, pubTo); // filter for order display_Ideas = OrderFilter(display_Ideas, time_order); //--------End filtering------- user loggedIn = ((user)Session["loggedIn"]); ViewBag.currentUser = loggedIn; int pageSize = 5; int pageNumber = (page ?? 1); return(View(display_Ideas.ToPagedList(pageNumber, pageSize))); }
public IPagedList <RequerimentoGridDC> ListGrid(FormatGridUtils <Requerimento> request, bool filtrarPorAtendente, bool filtrarPorRequerente) { using (var contexto = new ScirContext()) { //var innerJoin = from a in contexto.FluxoStatus // join b in contexto.StatusRequerimento on a.StatusAtualId equals b.Id // join c in contexto.StatusRequerimento on a.StatusProximoId equals c.Id // join d in contexto.TipoRequerimento on a.TipoRequerimentoId equals d.Id // where (!string.IsNullOrWhiteSpace(request.SearchPhrase)? EF.Functions.Like(b.Nome, "%"+request.SearchPhrase+"%") || EF.Functions.Like(d.Nome, "%" + request.SearchPhrase + "%") : a.StatusAtualId == a.StatusAtualId) // select new // { // a.StatusAtualId, // StatusAtualNome = b.Nome, // a.StatusProximoId, // StatusProximoNome = c.Nome, // a.TipoRequerimentoId, // TipoRequerimentoNome = d.Nome // }; var innerJoin = from a in contexto.Requerimento join b in contexto.Usuario on a.UsuarioAtendenteId equals b.Id join c in contexto.Usuario on a.UsuarioRequerenteId equals c.Id join d in contexto.StatusRequerimento on a.StatusRequerimentoId equals d.Id join e in contexto.TipoRequerimento on a.TipoRequerimentoId equals e.Id where (!string.IsNullOrWhiteSpace(request.SearchPhrase) ? (EF.Functions.Like(d.Nome, "%" + request.SearchPhrase + "%") || EF.Functions.Like(e.Nome, "%" + request.SearchPhrase + "%") || EF.Functions.Like(a.Protocolo, "%" + request.SearchPhrase + "%") || EF.Functions.Like(b.Nome, "%" + request.SearchPhrase + "%") || EF.Functions.Like(c.Nome, "%" + request.SearchPhrase + "%")) && ((filtrarPorAtendente || filtrarPorRequerente) ? (filtrarPorAtendente? a.UsuarioAtendenteId == request.Entidade.UsuarioAtendenteId : 1 == 2) || (filtrarPorRequerente? a.UsuarioRequerenteId == request.Entidade.UsuarioRequerenteId : 1 == 2): 1 == 1) : (filtrarPorAtendente || filtrarPorRequerente)? ((filtrarPorAtendente ? a.UsuarioAtendenteId == request.Entidade.UsuarioAtendenteId : 1 == 2) || (filtrarPorRequerente ? a.UsuarioRequerenteId == request.Entidade.UsuarioRequerenteId : 1 == 2)) : 1 == 1) select new { a.Id, a.Protocolo, a.Abertura, a.TipoRequerimentoId, TipoRequerimento = e.Nome, a.StatusRequerimentoId, StatusRequerimento = d.Nome, Requerente = c.Nome, Atendente = b.Nome }; if (string.IsNullOrWhiteSpace(request.CampoOrdenacao)) { request.CampoOrdenacao = "Id asc"; } var listFluxoStatus = innerJoin.OrderBy(request.CampoOrdenacao).ToPagedList(request.Current, request.RowCount); var lista = new List <RequerimentoGridDC>(); foreach (var item in listFluxoStatus) { lista.Add(new RequerimentoGridDC { Id = item.Id, Abertura = item.Abertura, AberturaToString = item.Abertura.ToString("dd/MM/yyyy HH:mm"), TipoRequerimentoNome = item.TipoRequerimento, TipoRequerimentoId = item.TipoRequerimentoId, StatusRequerimentoNome = item.StatusRequerimento, StatusRequerimentoId = item.StatusRequerimentoId, Protocolo = item.Protocolo, TotalItensGrid = listFluxoStatus.TotalItemCount, AtendenteNome = item.Atendente, RequerenteNome = item.Requerente }); } var retorno = lista.ToPagedList(1, request.RowCount); return(retorno); } }
public ActionResult Index(int?user_id, string name, int?cancled_status, int?page = 1) { if (!Utils.Utils.GetPermission("CANCELLATIONS_SHOW")) { return(new RedirectResult("/Main")); } DateTime dateFrom = Utils.Utils.GetRequestDate(Request["dt_from"], true); DateTime dateTo = Utils.Utils.GetRequestDate(Request["dt_to"], false); using (DataContext _db = new DataContext()) { using (var daper_db = new SqlConnection(ConfigurationManager.ConnectionStrings["DataConnect"].ToString())) { string str = " SELECT c.[id],cu.[code] FROM [DigitalTVBilling].[book].[Cards] as c inner join [DigitalTVBilling].[book].[Customers] as cu on c.customer_id=cu.id"; //using (var multi = daper_db.QueryMultiple(str)) //{ ViewBag.cards = daper_db.Query <CardCustumerID>(str); ViewBag.Returned = daper_db.Query <ReturnedCard>("SELECT * FROM [DigitalTVBilling].[dbo].[ReturnedCards] "); //} ViewBag.Cancel = "active"; ViewBag.UserGroups = Newtonsoft.Json.JsonConvert.SerializeObject(_db.Users.Where(c => c.UserType.Name == "მემონტაჟეები").Select(c => new IdName { Id = c.Id, Name = c.Name }).ToList()); ViewBag.ExecutorUsers = _db.Users.Where(u => u.Type == 4 || u.Type == 44).ToList(); ViewBag.selectedStatus = cancled_status == null ? -1 : cancled_status; //ViewBag.Returned = _db.ReturnedCards.ToList(); List <Cancellation> cancel = new List <Cancellation>(); if (name != null && name != "") { //var fullname = name.Split('/')[0]; cancel = _db.Cancellations.Where(c => c.Name.Substring(0, name.Length) == name || c.Code == name).OrderByDescending(c => c.Id).ToList();//.ToPagedListAsync(page, 20); return(View(cancel.ToPagedList(page ?? 1, 20))); } if (user_id != null && user_id != 0) { ViewBag.selectedUserFilter = user_id; //orders = orders.Where(o => o.ExecutorID == user_id).ToList(); if (cancled_status != null && cancled_status != -1) { cancel = _db.Cancellations.Where(c => c.Tdate >= dateFrom && c.Tdate <= dateTo && c.ExecutorID == user_id && c.Status == (CancleStatus)cancled_status /*((user_id != null || user_id != 0? user_id: c.ExecutorID))*/).OrderByDescending(c => c.Id).ToList(); } else { cancel = _db.Cancellations.Where(c => c.Tdate >= dateFrom && c.Tdate <= dateTo && c.ExecutorID == user_id /*((user_id != null || user_id != 0? user_id: c.ExecutorID))*/).OrderByDescending(c => c.Id).ToList(); } } else { if (cancled_status != null && cancled_status != -1) { cancel = _db.Cancellations.Where(c => c.Tdate >= dateFrom && c.Tdate <= dateTo && c.ExecutorID == c.ExecutorID && c.Status == (CancleStatus)cancled_status /*((user_id != null || user_id != 0? user_id: c.ExecutorID))*/).OrderByDescending(c => c.Id).ToList(); } else { cancel = _db.Cancellations.Where(c => c.Tdate >= dateFrom && c.Tdate <= dateTo && c.ExecutorID == c.ExecutorID /*((user_id != null || user_id != 0? user_id: c.ExecutorID))*/).OrderByDescending(c => c.Id).ToList(); } } //cancel = _db.Cancellations.ToList(); return(View(cancel.ToPagedList(page ?? 1, 20))); } } }
public ActionResult AllQuestion(string sort, string search, int?page) { int DiscussionCategoryId = 0; string s = sort; int result; if (int.TryParse(s, out result)) { DiscussionCategoryId = Convert.ToInt32(sort); } else { } ViewBag.NewestSort = sort == "newestsearch" ? "newest_desc" : "newest_search"; ViewBag.OldestSort = sort == "oldestsearch" ? "oldest_asec" : "oldest_search"; ViewBag.DiscussionCategory = sort == "discussioncategory" ? "discuss_cat" : "discussion_category"; ViewBag.CurrentSort = sort; ViewBag.CurrentSearch = search; AllQuestionListViewModel mainModel = new AllQuestionListViewModel(); var listModel = new List <QuestionListWithOwnerAndLastParticipantViewModel>(); var reportList = new List <TopTenReport>(); var topQList = new List <TopSevenQuestions>(); var likeList = new List <MostLikeQuestion>(); if (!String.IsNullOrEmpty(search)) { var questions = _applicationDbContext.Questions.Include(dc => dc.DiscussionCategory).Where(d => d.Title.ToLower().Contains(search) || d.QuestionText.ToLower().Contains(search) || d.Tag.ToLower().Contains(search)).ToList(); foreach (var q in questions) { var answers = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == q.QuestionId).ToList(); QuestionListWithOwnerAndLastParticipantViewModel model = new QuestionListWithOwnerAndLastParticipantViewModel(); model.QuestionId = q.QuestionId; model.Title = q.Title; model.DiscussionCategory = q.DiscussionCategory.Name; model.DateAsked = q.DateAsked.ToString("d,MMMM yy"); DateTime commentDate = DateTime.UtcNow.Date; DateTime answerDate = DateTime.UtcNow.Date; var userName = _applicationDbContext.Users.Find(q.UserId); var getQuestionComment = _applicationDbContext.QuestionComments.Where(id => id.QuestionId == q.QuestionId).OrderByDescending(p => p.QuestionCommentId).FirstOrDefault(); var getAnswerComment = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == q.QuestionId).OrderByDescending(p => p.AnswerToQuestionId).FirstOrDefault(); model.QuestionOwner = userName.NameExtension; if (answers != null) { model.AnswerCount = answers.Count; } else { model.AnswerCount = 0; } if (getQuestionComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = q.DateAsked.ToString("d,MMMM yy"); commentDate = q.DateAsked; } else { commentDate = getQuestionComment.DateCommented; } if (getAnswerComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = q.DateAsked.ToString("d,MMM yy"); answerDate = q.DateAsked; } else { answerDate = getAnswerComment.DateAnswered; } if (getQuestionComment != null) { if (commentDate >= answerDate) { var commentOwner = _applicationDbContext.Users.Find(getQuestionComment.UserId); model.LastParticipantOwner = commentOwner.NameExtension; model.LastParticipantDate = getQuestionComment.DateCommented.ToString("d,MMMM yy"); } } if (getAnswerComment != null) { if (commentDate <= answerDate) { var questionOwner = _applicationDbContext.Users.Find(getAnswerComment.UserId); model.LastParticipantOwner = questionOwner.NameExtension; model.LastParticipantDate = getAnswerComment.DateAnswered.ToString("d,MMMM yy"); } } listModel.Add(model); } } else { var questions = _applicationDbContext.Questions.Include(dc => dc.DiscussionCategory).OrderByDescending(d => d.DateAsked).ToList(); foreach (var q in questions) { var answers = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == q.QuestionId).ToList(); QuestionListWithOwnerAndLastParticipantViewModel model = new QuestionListWithOwnerAndLastParticipantViewModel(); model.QuestionId = q.QuestionId; model.Title = q.Title; model.DiscussionCategory = q.DiscussionCategory.Name; model.DateAsked = q.DateAsked.ToString("d,MMMM yy"); DateTime commentDate = DateTime.UtcNow.Date; DateTime answerDate = DateTime.UtcNow.Date; var userName = _applicationDbContext.Users.Find(q.UserId); var getQuestionComment = _applicationDbContext.QuestionComments.Where(id => id.QuestionId == q.QuestionId).OrderByDescending(p => p.QuestionCommentId).FirstOrDefault(); var getAnswerComment = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == q.QuestionId).OrderByDescending(p => p.AnswerToQuestionId).FirstOrDefault(); model.QuestionOwner = userName.NameExtension; if (answers != null) { model.AnswerCount = answers.Count; } else { model.AnswerCount = 0; } if (getQuestionComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = q.DateAsked.ToString("d,MMMM yy"); commentDate = q.DateAsked; } else { commentDate = getQuestionComment.DateCommented; } if (getAnswerComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = q.DateAsked.ToString("d,MMM yy"); answerDate = q.DateAsked; } else { answerDate = getAnswerComment.DateAnswered; } if (getQuestionComment != null) { if (commentDate >= answerDate) { var commentOwner = _applicationDbContext.Users.Find(getQuestionComment.UserId); model.LastParticipantOwner = commentOwner.NameExtension; model.LastParticipantDate = getQuestionComment.DateCommented.ToString("d,MMMM yy"); } } if (getAnswerComment != null) { if (commentDate <= answerDate) { var questionOwner = _applicationDbContext.Users.Find(getAnswerComment.UserId); model.LastParticipantOwner = questionOwner.NameExtension; model.LastParticipantDate = getAnswerComment.DateAnswered.ToString("d,MMMM yy"); } } listModel.Add(model); } } HtmlToText convert = new HtmlToText(); var topReport = _applicationDbContext.Reports .OrderByDescending(dt => dt.DateCreated) .Take(7); foreach (var top in topReport) { TopTenReport rmodel = new TopTenReport(); rmodel.ReportText = convert.Convert(top.ReportText); rmodel.ReportId = top.ReportId; rmodel.Title = top.Title; rmodel.ReportDate = top.DateCreated; reportList.Add(rmodel); } var mostLikedQuestion = _applicationDbContext.QuestionLikes.ToList(); var itemsWithTotals = mostLikedQuestion .GroupBy(item => item.QuestionId) .Select(groupByQId => new { QuestionId = groupByQId.Key, Total = groupByQId.Count() }) .OrderByDescending(t => t.Total) .Take(7); foreach (var item in itemsWithTotals) { var getQuestion = this._applicationDbContext.Questions.SingleOrDefault(id => id.QuestionId == item.QuestionId); MostLikeQuestion mModel = new MostLikeQuestion(); mModel.QuestionId = item.QuestionId; mModel.QuestionLikeCount = item.Total; mModel.QuestionTitle = getQuestion.Title; mModel.QuestionText = getQuestion.QuestionText; mModel.DateAsked = getQuestion.DateAsked; likeList.Add(mModel); } var topSevenQuestion = _applicationDbContext.Questions .OrderByDescending(dt => dt.DateAsked) .Take(7); foreach (var qs in topSevenQuestion) { TopSevenQuestions qmodel = new TopSevenQuestions(); qmodel.QuestionId = qs.QuestionId; qmodel.QuestionTitle = qs.Title; qmodel.QuestionText = convert.Convert(qs.QuestionText); qmodel.DateAsked = qs.DateAsked; topQList.Add(qmodel); } int pageSize = 50; int pageNumber = page ?? 1; ViewBag.DiscussionCategory = new SelectList(_applicationDbContext.DiscussionCategories, "DiscussionCategoryId", "Name"); mainModel.TopTenReports = reportList; mainModel.TopSevenQuestions = topQList; mainModel.MostLikeQuestions = likeList; mainModel.QuestionListWithOwnerAndLastParticipantViewModels = listModel.ToPagedList <QuestionListWithOwnerAndLastParticipantViewModel>(pageNumber, pageSize); return(View(mainModel)); }
// GET: Aula public ActionResult Index(int?page, string sortOrder = "", string currentFilter = "", string searchString = "") { List <Aula> a = _repository.All(); return(View(a.ToPagedList((page ?? 1), 5))); }
public ActionResult QuestionList(int q, string sort, string search, int?page) { QuestionAndReportViewModel mainModel = new QuestionAndReportViewModel(); HtmlToText convert = new HtmlToText(); ViewBag.NewestSort = sort == "newestsearch" ? "newest_desc" : "newest_search"; ViewBag.OldestSort = sort == "oldestsearch" ? "oldest_asec" : "oldest_search"; ViewBag.CurrentSort = sort; ViewBag.CurrentSearch = search; var questModel = _applicationDbContext.Questions.Where(catId => catId.DiscussionCategoryId == q).Include(d => d.DiscussionCategory) .OrderByDescending(dt => dt.DateAsked).ToList(); var questList = new List <QuestionListViewModel>(); var reportList = new List <TopTenReport>(); var topQList = new List <TopSevenQuestions>(); var likeList = new List <MostLikeQuestion>(); foreach (var quest in questModel) { if (!String.IsNullOrEmpty(search)) { if (quest.Title.ToLower().Contains(search) || quest.Title.ToLower().Contains(search) || quest.Tag.ToLower().Contains(search)) { QuestionListViewModel model = new QuestionListViewModel(); var answers = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == quest.QuestionId).ToList(); model.QuestionId = quest.QuestionId; model.Title = quest.Title; model.DiscussionCategory = quest.DiscussionCategory.Name; model.DateAsked = quest.DateAsked.ToString("d,MMMM yy"); DateTime commentDate = DateTime.UtcNow.Date; DateTime answerDate = DateTime.UtcNow.Date; var userName = _applicationDbContext.Users.Find(quest.UserId); var getQuestionComment = _applicationDbContext.QuestionComments.Where(id => id.QuestionId == quest.QuestionId).OrderByDescending(p => p.QuestionCommentId).FirstOrDefault(); var getAnswerComment = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == quest.QuestionId).OrderByDescending(p => p.AnswerToQuestionId).FirstOrDefault(); model.QuestionOwner = userName.NameExtension; if (answers != null) { model.AnswerCount = answers.Count; } else { model.AnswerCount = 0; } if (getQuestionComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = quest.DateAsked.ToString("d,MMMM yy"); commentDate = quest.DateAsked; } else { commentDate = getQuestionComment.DateCommented; } if (getAnswerComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = quest.DateAsked.ToString("d,MMM yy"); answerDate = quest.DateAsked; } else { answerDate = getAnswerComment.DateAnswered; } if (getQuestionComment != null) { if (commentDate >= answerDate) { var commentOwner = _applicationDbContext.Users.Find(getQuestionComment.UserId); model.LastParticipantOwner = commentOwner.NameExtension; model.LastParticipantDate = getQuestionComment.DateCommented.ToString("d,MMMM yy"); } } if (getAnswerComment != null) { if (commentDate <= answerDate) { var questionOwner = _applicationDbContext.Users.Find(getAnswerComment.UserId); model.LastParticipantOwner = questionOwner.NameExtension; model.LastParticipantDate = getAnswerComment.DateAnswered.ToString("d,MMMM yy"); } } questList.Add(model); string title = quest.DiscussionCategory.Description; string PageTitle = Regex.Replace(title, "[^A-Za-z0-9]", "-"); ViewBag.PageTitle = PageTitle; } else { } } else { QuestionListViewModel model = new QuestionListViewModel(); var answers = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == quest.QuestionId).ToList(); model.QuestionId = quest.QuestionId; model.Title = quest.Title; model.DiscussionCategory = quest.DiscussionCategory.Name; model.DateAsked = quest.DateAsked.ToString("d,MMMM yy"); DateTime commentDate = DateTime.UtcNow.Date; DateTime answerDate = DateTime.UtcNow.Date; var userName = _applicationDbContext.Users.Find(quest.UserId); var getQuestionComment = _applicationDbContext.QuestionComments.Where(id => id.QuestionId == quest.QuestionId).OrderByDescending(p => p.QuestionCommentId).FirstOrDefault(); var getAnswerComment = _applicationDbContext.AnswerToQuestions.Where(id => id.QuestionId == quest.QuestionId).OrderByDescending(p => p.AnswerToQuestionId).FirstOrDefault(); model.QuestionOwner = userName.NameExtension; if (answers != null) { model.AnswerCount = answers.Count; } else { model.AnswerCount = 0; } if (getQuestionComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = quest.DateAsked.ToString("d,MMMM yy"); commentDate = quest.DateAsked; } else { commentDate = getQuestionComment.DateCommented; } if (getAnswerComment == null) { model.LastParticipantOwner = userName.NameExtension; model.LastParticipantDate = quest.DateAsked.ToString("d,MMM yy"); answerDate = quest.DateAsked; } else { answerDate = getAnswerComment.DateAnswered; } if (getQuestionComment != null) { if (commentDate >= answerDate) { var commentOwner = _applicationDbContext.Users.Find(getQuestionComment.UserId); model.LastParticipantOwner = commentOwner.NameExtension; model.LastParticipantDate = getQuestionComment.DateCommented.ToString("d,MMMM yy"); } } if (getAnswerComment != null) { if (commentDate <= answerDate) { var questionOwner = _applicationDbContext.Users.Find(getAnswerComment.UserId); model.LastParticipantOwner = questionOwner.NameExtension; model.LastParticipantDate = getAnswerComment.DateAnswered.ToString("d,MMMM yy"); } } questList.Add(model); string title = quest.DiscussionCategory.Description; string PageTitle = Regex.Replace(title, "[^A-Za-z0-9]", "-"); ViewBag.PageTitle = PageTitle; } } if (questList.Count == 0) { mainModel.QuestionCount = 0; } if (questList.Count > 0) { mainModel.QuestionCount = 1; } var CategoryName = _applicationDbContext.DiscussionCategories.SingleOrDefault(d => d.DiscussionCategoryId == q); var topReport = _applicationDbContext.Reports .OrderByDescending(dt => dt.DateCreated) .Take(7); foreach (var top in topReport) { TopTenReport rmodel = new TopTenReport(); rmodel.ReportText = convert.Convert(top.ReportText); rmodel.ReportId = top.ReportId; rmodel.Title = top.Title; rmodel.ReportDate = top.DateCreated; reportList.Add(rmodel); } var mostLikedQuestion = _applicationDbContext.QuestionLikes.ToList(); var itemsWithTotals = mostLikedQuestion .GroupBy(item => item.QuestionId) .Select(groupByQId => new { QuestionId = groupByQId.Key, Total = groupByQId.Count() }) .OrderByDescending(t => t.Total) .Take(7); foreach (var item in itemsWithTotals) { var getQuestion = this._applicationDbContext.Questions.SingleOrDefault(id => id.QuestionId == item.QuestionId); MostLikeQuestion mModel = new MostLikeQuestion(); mModel.QuestionId = item.QuestionId; mModel.QuestionLikeCount = item.Total; mModel.QuestionTitle = getQuestion.Title; mModel.QuestionText = getQuestion.QuestionText; mModel.DateAsked = getQuestion.DateAsked; likeList.Add(mModel); } var topSevenQuestion = _applicationDbContext.Questions .OrderByDescending(dt => dt.DateAsked) .Take(7); foreach (var qs in topSevenQuestion) { TopSevenQuestions qmodel = new TopSevenQuestions(); qmodel.QuestionId = qs.QuestionId; qmodel.QuestionTitle = qs.Title; qmodel.QuestionText = convert.Convert(qs.QuestionText); topQList.Add(qmodel); } int pageSize = 50; int pageNumber = page ?? 1; ViewBag.Category = CategoryName.Name; ViewBag.q = q; mainModel.TopTenReports = reportList; mainModel.TopSevenQuestions = topQList; mainModel.MostLikeQuestions = likeList; mainModel.QuestionListViewModels = questList.ToPagedList <QuestionListViewModel>(pageNumber, pageSize); return(View(mainModel)); }
public ActionResult List(string filter, string provider, int page = 1) { var videos = new List <Videos>(); try { //Create a list of select list items - this will be returned as your select list var i = 0; //videos = db.Videos.ToList(); // var categorias = videos.Select(m => m.Category).Distinct(); //procedure to check titles with a category name and then insert that "name" as a category /*foreach (var item in categorias) * { * * var anyvideos = new List<Videos>(); * if (item != null) * { * //var countVideos = 1; * //anyvideos = db.Videos.Where(m => m.Title.Contains(item) && !m.Category.Contains(item)).ToList(); * //if (anyvideos != null && anyvideos.Count() > 0) * //{ * // foreach (var elem in anyvideos) * // { * // elem.Category = elem.Category + "," + item; * // db.Videos.Attach(elem); * // db.Entry(elem).State = EntityState.Modified; * // db.SaveChanges(); * // Logs.logger.Info("Added video "+countVideos+" to cat="+item); * // countVideos++; * // } * // Logs.logger.Info("Added " + countVideos + " VIDEOS"); * * //} * SelectListItem selListItem = new SelectListItem() { Value = i.ToString(), Text = item }; * * newList.Add(selListItem); * } * }*/ if (provider != null && provider != "null") { provider = provider.ToLower(); videos = db.Videos.Where(m => m.Url.Contains(provider)).Take(500).ToList(); } else if (filter != null && filter != "null") { var estado = filter.Contains("PornMaleon Videos"); filter = estado == true ? null : filter; //get just videos by cat ViewBag.filter = filter; if (filter == null) { videos = db.Videos.Where(m => m.Category == null).Take(500).ToList(); } else { videos = db.Videos.Where(m => m.Category.Contains(filter)).Take(500).ToList(); } } else { //show random videos without categories //videos = db.Videos.Where(m => m.Category == null).Take(300).OrderBy(a => Guid.NewGuid()).ToList(); // videos = db.Videos.Where(m => m.Category == null).OrderBy(a => Guid.NewGuid()).Take(300).ToList(); videos = db.Videos.Where(m => m.Category == null).Take(500).OrderBy(a => Guid.NewGuid()).ToList(); //videos = db.Videos.Where(m => m.Url.Contains("x3xtube")).ToList(); } ViewBag.categorias = new SelectList(Categorias, "Value", "Text", null); ViewBag.providers = new SelectList(Providers, "Value", "Text", null); //check for duplicates values videos = videos.Distinct(new VideosComparer()).ToList(); } catch (Exception ex) { Logs.logger.Error(Logs.ToMessageAndCompleteStacktrace(ex)); Response.StatusCode = 400; } return(PartialView("_List", videos.ToPagedList(page, 18))); }
// GET: StudentKhs public ActionResult Index(string currentFilter, string searchString, short?Term_Year_Id, short?Department_Id, short?Class_Prog_Id, int?page, int?rowPerPage) { if (searchString != null) { page = 1; } else { searchString = currentFilter; } Session["rowPerPage"] = (Session["rowPerPage"] == null) ? 10 : ((rowPerPage == null || rowPerPage < 1) ? Session["rowPerPage"] : rowPerPage); int pageSize = Convert.ToInt32(Session["rowPerPage"]); ViewBag.rowPerPage = pageSize; int pageNumber = (page == null || page < 1) ? 1 : Convert.ToInt32(page); //for url ViewBag.searchString = searchString; ViewBag.Department = Department_Id; ViewBag.Term_Year = Term_Year_Id; ViewBag.Class_Prog = Class_Prog_Id; //dropdown ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year.OrderByDescending(ty => ty.Term_Year_Id), "Term_Year_Id", "Term_Year_Name", Term_Year_Id).ToList(); ViewBag.Department_Id = new SelectList(db.Mstr_Department.OrderBy(d => d.Department_Code), "Department_Id", "Department_Name", Department_Id).ToList(); ViewBag.Class_Prog_Id = new SelectList(db.Mstr_Class_Program, "Class_Prog_Id", "Class_Program_Name", Class_Prog_Id).ToList(); List <Vm_Student_Khs> list_vm_Student_Khs = new List <Vm_Student_Khs>(); if (Term_Year_Id != null && Department_Id != null && Class_Prog_Id != null) { //var khs_sudah_dinilai = db.Acd_Student_Khs // .Where(x => x.Acd_Student_Krs.Term_Year_Id == Term_Year_Id // && x.Acd_Student.Department_Id == Department_Id // && x.Acd_Student.Class_Prog_Id == Class_Prog_Id // && x.Grade_Letter_Id != null // ) // .Select(x => x.Krs_Id); var acd_Student_Khs = db.Acd_Student_Krs.Where(x => x.Term_Year_Id == Term_Year_Id && x.Acd_Course.Department_Id == Department_Id && x.Acd_Student.Class_Prog_Id == Class_Prog_Id ) .GroupBy(y => new { y.Acd_Course.Course_Code, y.Acd_Course.Course_Name, y.Mstr_Class.Class_Name }) .OrderBy(y => y.FirstOrDefault().Acd_Course.Course_Code).ThenBy(y => y.FirstOrDefault().Class_Id) .Select(y => new Vm_Student_Khs { Course_Id = y.FirstOrDefault().Course_Id, Class_Id = y.FirstOrDefault().Class_Id, Course_Code = y.FirstOrDefault().Acd_Course.Course_Code, Course_Name = y.FirstOrDefault().Acd_Course.Course_Name, Class_Name = y.FirstOrDefault().Mstr_Class.Class_Name, Jml_Peserta = y.Count(), //Sudah_Dinilai = db.Acd_Student_Khs.Where(z => z.Acd_Student_Krs.Term_Year_Id == Term_Year_Id // && z.Acd_Student.Department_Id == Department_Id // && z.Acd_Student.Class_Prog_Id == Class_Prog_Id // && z.Acd_Student_Krs.Course_Id == y.FirstOrDefault().Course_Id // && z.Acd_Student_Krs.Class_Id == y.FirstOrDefault().Class_Id) // .Count() //Jml_Peserta = db.Acd_Student_Krs.Where(a => a.Course_Id == x.FirstOrDefault().Course_Id // && a.Term_Year_Id == Term_Year_Id // && a.Acd_Course.Department_Id == Department_Id // && a.Acd_Student.Class_Prog_Id == Class_Prog_Id).Count(), //Sudah_Dinilai = db.Acd_Student_Krs.Where(b => b.Course_Id == y.FirstOrDefault().Course_Id // && b.Class_Id == y.FirstOrDefault().Class_Id // && b.Term_Year_Id == Term_Year_Id // && b.Acd_Course.Department_Id == Department_Id // && b.Acd_Student.Class_Prog_Id == Class_Prog_Id // && khs_sudah_dinilai.Contains(b.Krs_Id) // ).Count() //Sudah_Dinilai = db.Acd_Student_Khs.Where(a => khs_sudah_dinilai.Contains(a.Krs_Id) // && a.Acd_Student_Krs.Class_Id == y.FirstOrDefault().Class_Id // && a.Acd_Student_Krs.Course_Id == y.FirstOrDefault().Course_Id // ).Count() }); if (!String.IsNullOrEmpty(searchString)) { acd_Student_Khs = acd_Student_Khs.Where(x => x.Course_Code.Contains(searchString) || x.Course_Name.Contains(searchString)); } //acd_Student_Khs = acd_Student_Khs.OrderBy(x => x.Course_Code); //foreach (var item in acd_Student_Khs) //{ // Vm_Student_Khs vm_Student_Khs = new Vm_Student_Khs(); // vm_Student_Khs.Course_Code = item.Course_Code; // vm_Student_Khs.Course_Name = item.Course_Name; // vm_Student_Khs.Class_Name = item.Class_Name; // vm_Student_Khs.Jml_Peserta = item.Jml_Peserta; // vm_Student_Khs.Sudah_Dinilai = item.Sudah_Dinilai; // list_vm_Student_Khs.Add(vm_Student_Khs); //} return(View(acd_Student_Khs.ToPagedList(pageNumber, pageSize))); } return(View(list_vm_Student_Khs.ToPagedList(pageNumber, pageSize))); }