예제 #1
0
        public ActionResult AjaxHandler(tblUserParamModel param)
        {
            var allResult = db.getUsers(string.IsNullOrEmpty(param.Donvi) ? "" : param.Donvi).ToList();

            IEnumerable <getUsers_Result> filteredResult;

            //Check whether the companies should be filtered by keyword
            if (!string.IsNullOrEmpty(param.sSearch))
            {
                //Optionally check whether the columns are searchable at all
                var Searchable_0 = Convert.ToBoolean(Request["bSearchable_0"]);
                var Searchable_2 = Convert.ToBoolean(Request["bSearchable_2"]);
                var Searchable_3 = Convert.ToBoolean(Request["bSearchable_3"]);
                var Searchable_4 = Convert.ToBoolean(Request["bSearchable_4"]);
                var Searchable_6 = Convert.ToBoolean(Request["bSearchable_6"]);
                int tmp          = int.TryParse(param.sSearch, out tmp) ? tmp : 0;

                filteredResult = allResult
                                 .Where(c => Searchable_2 && c.HoTen.ToLower().Contains(param.sSearch.ToLower()) ||
                                        Searchable_3 && c.TenDangNhap.ToLower().Contains(param.sSearch.ToLower()) ||
                                        Searchable_4 && c.Email.ToLower().Contains(param.sSearch.ToLower()) ||
                                        Searchable_6 && c.DonVi.ToLower().Contains(param.sSearch.ToLower()) ||
                                        Searchable_0 && c.STT.Equals(tmp)
                                        );
            }
            else
            {
                filteredResult = allResult;
            }

            var Sortable_0      = Convert.ToBoolean(Request["bSortable_0"]);
            var Sortable_2      = Convert.ToBoolean(Request["bSortable_2"]);
            var Sortable_3      = Convert.ToBoolean(Request["bSortable_3"]);
            var Sortable_4      = Convert.ToBoolean(Request["bSortable_4"]);
            var Sortable_6      = Convert.ToBoolean(Request["bSortable_6"]);
            var sortColumnIndex = Convert.ToInt64(Request["iSortCol_0"]);
            Func <getUsers_Result, string> orderingFunction  = (c => sortColumnIndex == 2 && Sortable_2 ? c.HoTen : sortColumnIndex == 3 && Sortable_3 ? c.TenDangNhap : sortColumnIndex == 4 && Sortable_4 ? c.Email : sortColumnIndex == 6 && Sortable_6 ? c.DonVi : "");
            Func <getUsers_Result, Int64>  orderingFunction2 = (c => sortColumnIndex == 0 && Sortable_0 ? c.STT : 0);

            var sortDirection = Request["sSortDir_0"]; // asc or desc

            if (sortDirection == "asc")
            {
                filteredResult = filteredResult.OrderBy(orderingFunction).ThenBy(orderingFunction2);
            }
            else
            {
                filteredResult = filteredResult.OrderByDescending(orderingFunction).ThenByDescending(orderingFunction2);
            }

            var displayed = filteredResult.Skip(param.iDisplayStart).Take(param.iDisplayLength);
            var result    = displayed.Select(c => new
            {
                col0 = c.STT,
                col1 = c.ID,
                col2 = c.HoTen,
                col3 = c.TenDangNhap,
                col4 = c.Email,
                col5 = ListToString(UserManager.GetRoles(c.ID).ToList()),
                col6 = c.DonVi
            });

            return(Json(new
            {
                sEcho = param.sEcho,
                iTotalRecords = allResult.Count(),
                iTotalDisplayRecords = filteredResult.Count(),
                aaData = result
            }, JsonRequestBehavior.AllowGet));
        }