public JsonResult IndexAjax(DataTableJS data)
        {
            var    itmes  = _service.GetIQueryableItems().ToList();
            String search = null;

            if (data.search != null && data.search["value"] != null)
            {
                search = data.search["value"];
            }
            var    column      = data.order[0]["column"];
            var    dir         = data.order[0]["dir"];
            string columnName  = ((String[])data.columns[int.Parse(column)]["data"])[0];
            var    queryFilter =
                _service.GetIQueryableItems()
                .Where(
                    T => T.Active == 1 &&
                    (search == "" || (search != null &&
                                      (T.KeySearch.ToLower().Contains(search.ToLower())))));

            if (dir == "asc")
            {
                queryFilter = queryFilter.OrderByField(columnName, true);
            }
            else
            {
                queryFilter = queryFilter.OrderByField(columnName, false);
            }
            data.recordsTotal    = _service.GetIQueryableItems().Where(T => T.Active == 1).Count();
            data.recordsFiltered = queryFilter.Count();
            data.data            = queryFilter.Skip(data.start)
                                   .Take(data.length == -1 ? data.recordsTotal : data.length)
                                   .ToList().Select(T => new { ID = T.ID, DisPercent = T.DisPercent, Description = T.Description, FromDateToDate = T.FromDate.Value.ToString(MvcApplication.DateTimeFormat.ShortDatePattern) + " - " + T.ToDate.Value.ToString(MvcApplication.DateTimeFormat.ShortDatePattern), Name = T.Name, TypeApply = T.TypeApply, Active = T.Active });
            return(Json(data, JsonRequestBehavior.AllowGet));
        }
예제 #2
0
        public JsonResult CheckEventAjax(double money)
        {
            double   ME      = 0;
            double   DE      = 0;
            int      P       = 0;
            var      dateNow = DateTime.Now;
            BDSEvent ev      = _serviceEvent.GetIQueryableItems().Where(T => T.FromDate <= dateNow && dateNow <= T.ToDate).OrderBy(T => T.FromDate).FirstOrDefault();

            if (ev != null)
            {
                ME = money * ev.DisPercent / 100;
                DE = ev.DisPercent;
            }

            return(Json(new { M = money, ME = ME, P = P, DE = DE }, JsonRequestBehavior.AllowGet));
        }