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