/// <summary> /// Fetches employees page vise on the basis of page number and page size provided. /// </summary> /// <param name="paging"></param> /// <returns></returns> public IEnumerable <EmployeeModel> GetEmployeePageVise([FromUri] PagingModal paging) { //OrganisationContext oc = new OrganisationContext(); var employee = oc.Employees.Select(emp => new EmployeeModel() { Id = emp.Id, EmpName = emp.EmpName, Email = emp.Email, Salary = emp.Salary, DeptId = emp.DeptId, }).OrderBy(e => e.Id); int count = employee.Count(); int CurrentPage = paging.PageNumber; int PageSize = paging.PageSize; int TotalCount = count; int TotalPages = (int)Math.Ceiling(count / (double)PageSize); var employeeList = employee.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList(); return(employeeList); }
public IEnumerable <EmployeeModel> Get([FromUri] PagingModal paging) { DBOperations dbo = new DBOperations(); return(dbo.GetEmployeePageVise(paging)); }