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