public ActionResult PositionListDataTable(DataTableAjaxPostModel model) { var expression = _datatableSearch.CreateSearchExpression(model); var positionList = _positionService.GetAllPositions( expression, _datatableOrder.CreateOrderExpression(model), model.start, model.length + model.start); var result = from a in positionList select new[] { a.Id.ToString(), a.Id.ToString(), a.Name, a.Description, a.DepartmentName }; return(Json(new { Draw = model.draw, recordsTotal = _positionService.GetPositionViewCount(), recordsFiltered = _positionService.GetPositionViewCount(expression), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult DepartmentListDataTable(DataTableAjaxPostModel model) { var expression = _datatableSearch.CreateSearchExpression(model); var departmentlist = _departmentService.GetAllDepartments( expression, _datatableOrder.CreateOrderExpression(model), model.start, model.length + model.start); var result = from a in departmentlist select new[] { a.Id.ToString(), a.Id.ToString(), a.Name, a.Description, a.CreateDate != null?Convert.ToDateTime(a.CreateDate).ToString("dd.MM.yyyy") : "" }; return(Json(new { Draw = model.draw, recordsTotal = _departmentService.GetDepartmentCount(), recordsFiltered = _departmentService.GetDepartmentCount(expression), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult UserListDataTable(DataTableAjaxPostModel model) { var expression = _datatableSearch.CreateSearchExpression(model); var userList = _userService.GetAllUsers( expression, _datatableOrder.CreateOrderExpression(model), model.start, model.length + model.start); var result = from a in userList select new[] { a.Id.ToString(), a.Id.ToString(), a.Name + " " + a.Surname, a.Title, a.EmailAddress, a.IsAdminUser == true ? "Admin" : "Normal" }; return(Json(new { Draw = model.draw, recordsTotal = _userService.UserCount(), recordsFiltered = _userService.UserCount(expression), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult CustomerListDataTable(DataTableAjaxPostModel model) { var expression = _datatableSearch.CreateSearchExpression(model); var customerList = _customerService.GetAllCustomers( expression, _datatableOrder.CreateOrderExpression(model), model.start, model.length + model.start); var result = from a in customerList select new[] { a.Id.ToString(), a.Id.ToString(), a.DisplayName, a.CommercialTitle, a.TaxOffice, a.TaxNumber, a.Identifier, a.TelephoneNumber, a.EmailAddress, a.WebAddress }; return(Json(new { Draw = model.draw, recordsTotal = _customerService.GetCustomerCount(), recordsFiltered = _customerService.GetCustomerCount(expression), data = result }, JsonRequestBehavior.AllowGet)); }