public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int SessionStaffID = 0, string filter = "") { var db = new EmployeeRelationshipsDAL(); int?total = 0; var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = pageSize, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; int staffID = 0; int.TryParse(Session["StaffID"].ToString(), out staffID); var result = db.GetEmployeeRelationships(baseListParam, out total, SessionStaffID); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal }))); }
public ActionResult TableServerSideGetData2(int pageIndex, int pageSize, string filter = "") { var db = new EmployeeRelationshipsDAL(); int?total = 0; var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = Global.CurrentUser.LoginUserId, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = pageSize, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; int staffID = 0; var result = db.GetEmployeeRelationships(baseListParam, out total, staffID); return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total }))); }