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)); }
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)); }