public JsonResult GetEmployee(DTParameters param) { EmployeeViewStore employee = new EmployeeViewStore(); employee.PageIndex = param.Start / param.Length + 1; employee.PageSize = param.Length; if (param.Search.Value == null) { employee.Search = "%%"; } else { employee.Search = "%" + param.Search.Value + "%"; } employee.Order = param.SortOrder; EmployeeViewStore categories = new EmployeeModels().GetEmployeeByPage(employee.Search, employee.Order, employee.PageIndex, employee.PageSize); DTResult <EmployeeDTO> final = new DTResult <EmployeeDTO>() { draw = param.Draw, data = categories.Employee.ToList(), recordsFiltered = categories.RecordCount, recordsTotal = categories.Employee.Count }; return(Json(final)); }
public EmployeeViewStore GetEmployeeByPage(string search, string order, int pageIndex, int pageSize) { EmployeeViewStore employee = new EmployeeViewStore(); employee.PageIndex = pageIndex; employee.PageSize = pageSize; employee.Search = search; employee.Order = order; SqlParameter paramPageSearch = new SqlParameter("@PageSearch", search); SqlParameter paramOrderColumn = new SqlParameter("@SortOrder", order); SqlParameter paramPageIndex = new SqlParameter("@PageIndex", pageIndex); SqlParameter paramPageSize = new SqlParameter("@PageSize", pageSize); SqlParameter paramRecordCount = new SqlParameter("@RecordCount", employee.RecordCount); paramRecordCount.Direction = ParameterDirection.Output; var listResult = db.Database.SqlQuery <Employee>("EXEC [dbo].[usp_MaintainEmployeePage] @PageSearch, @SortOrder, @PageIndex, @PageSize, @RecordCount = @RecordCount OUTPUT", paramPageSearch, paramOrderColumn, paramPageIndex, paramPageSize, paramRecordCount).ToList(); employee.RecordCount = (int)paramRecordCount.Value; employee.Employee = listResult.Select(e => new EmployeeDTO() { FirstName = e.FirstName, LastName = e.LastName, EmployeeID = e.EmployeeID, PhotoPath = e.PhotoPath, Title = e.Title, TitleOfCourtesy = e.TitleOfCourtesy, HomePhone = e.HomePhone, Address = e.Address, BirthDate = e.BirthDate, City = e.City, Country = e.Country, Extension = e.Extension, HireDate = e.HireDate, Notes = e.Notes, Photo = e.Photo, PostalCode = e.PostalCode, Region = e.Region, ReportsTo = e.ReportsTo }).ToList(); return(employee); }