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