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);
        }
Example #5
0
        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));


            }

            
            
        }
Example #6
0
        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));
 }
Example #8
0
        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");
        }
Example #9
0
        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));
        }
Example #10
0
        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");
        }
Example #11
0
 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");
 }
Example #12
0
 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");
 }
Example #13
0
        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));
            }
        }
Example #16
0
        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");
        }
Example #19
0
        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));
        }
Example #20
0
        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));
        }
Example #22
0
        // 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));
 }
Example #24
0
 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));
 }
Example #26
0
 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\"");
 }
Example #27
0
        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));
        }
Example #28
0
		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));
 }
Example #30
0
 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));
 }
Example #31
0
 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()));
     }
 }
Example #32
0
        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());
            }
        }
Example #34
0
        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));
        }
Example #35
0
        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));
        }
Example #36
0
        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)));
        }
Example #37
0
        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());
        }
Example #39
0
        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)));
        }
Example #41
0
        // 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)));
        }
Example #42
0
        // 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)));
        }
Example #43
0
        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)));
        }
Example #44
0
        // 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());
        }
Example #45
0
        // 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;
            }
        }
Example #47
0
        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));
        }
Example #49
0
        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));
        }
Example #50
0
        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)));
        }
Example #51
0
        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)));
        }
Example #52
0
        // 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)));
        }
Example #53
0
        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)));
        }
Example #54
0
        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));
        }
Example #57
0
        // 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));
        }
Example #59
0
        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)));
        }
Example #60
0
        // 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)));
        }