public Model.PagedList<Model.Remark> GetRemarks(string employeeId, int pageNumber = 1, int pageSize = 20, string orderBy = "Id", Model.SortingOrder sortingOrder = Model.SortingOrder.DESC) { using (var connection = new SqlConnection(Configurations.EmployeeDbConnectionString)) { var addRemarkCommand = new SqlCommand("spGetRemarksForEmployee", connection); addRemarkCommand.CommandType = System.Data.CommandType.StoredProcedure; addRemarkCommand.Parameters.Add(new SqlParameter("@EmployeeId", long.Parse(employeeId))); addRemarkCommand.Parameters.Add(new SqlParameter("@PageNumber", pageNumber)); addRemarkCommand.Parameters.Add(new SqlParameter("@PageSize", pageSize)); addRemarkCommand.Parameters.Add(new SqlParameter("@OrderBy", orderBy)); addRemarkCommand.Parameters.Add(new SqlParameter("@SortingOrder", sortingOrder.ToString())); var resultReader = addRemarkCommand.ExecuteReader(); int totalRecords = 0; var pagedList = new Model.PagedList<Model.Remark>(); if (resultReader.HasRows) { while (resultReader.Read()) { pagedList.Add(new Model.Remark() { Text = (string)resultReader["RemarkText"], CreateTimeStamp = (DateTime)resultReader["CreateTimestamp"] }); totalRecords = (int)resultReader["TotalResults"]; } } pagedList.PageSize = pageSize; pagedList.PageNumber = pageNumber; pagedList.TotalRecords = totalRecords; return pagedList; } }
public static DataContract.PagedList <DataContract.Employee> ToDataContract(this Model.PagedList <Model.Employee> employeeList) { if (employeeList == null) { return(null); } var pagedList = new DataContract.PagedList <DataContract.Employee>(); pagedList.PageNumber = employeeList.PageNumber; pagedList.PageSize = employeeList.PageSize; pagedList.TotalRecords = employeeList.TotalRecords; pagedList.Results = new List <DataContract.Employee>(); employeeList.ForEach(employee => { pagedList.Results.Add(new DataContract.Employee() { Id = employee.Id, Title = employee.Title, FirstName = employee.FirstName, LastName = employee.LastName, Email = employee.Email, JoiningDate = employee.JoiningDate, Phone = employee.Phone, Roles = employee.Roles }); }); return(pagedList); }
public Model.PagedList<Model.Employee> GetEmployees(int pageNumber = 1, int pageSize = 20, string orderBy = "Id", Model.SortingOrder sortingOrder = Model.SortingOrder.DESC) { using (var connection = new SqlConnection(Configurations.EmployeeDbConnectionString)) { var addRemarkCommand = new SqlCommand("spGetEmployees", connection); addRemarkCommand.CommandType = System.Data.CommandType.StoredProcedure; addRemarkCommand.Parameters.Add(new SqlParameter("@PageNumber", pageNumber)); addRemarkCommand.Parameters.Add(new SqlParameter("@PageSize", pageSize)); addRemarkCommand.Parameters.Add(new SqlParameter("@OrderBy", orderBy)); addRemarkCommand.Parameters.Add(new SqlParameter("@SortingOrder", sortingOrder.ToString())); var resultReader = addRemarkCommand.ExecuteReader(); int totalRecords = 0; var pagedList = new Model.PagedList<Model.Employee>(); if (resultReader.HasRows) { while (resultReader.Read()) { pagedList.Add(ParseEmployee(resultReader)); totalRecords = (int)resultReader["TotalResults"]; } } pagedList.PageSize = pageSize; pagedList.PageNumber = pageNumber; pagedList.TotalRecords = totalRecords; return pagedList; } }
public static DataContract.PagedList <DataContract.Remark> ToDataContract(this Model.PagedList <Model.Remark> remarkList) { if (remarkList == null) { return(null); } var pagedList = new DataContract.PagedList <DataContract.Remark>(); pagedList.PageNumber = remarkList.PageNumber; pagedList.PageSize = remarkList.PageSize; pagedList.TotalRecords = remarkList.TotalRecords; pagedList.Results = new List <DataContract.Remark>(); remarkList.ForEach(remark => { pagedList.Results.Add(new DataContract.Remark() { Text = remark.Text, CreateTimeStamp = remark.CreateTimeStamp }); }); return(pagedList); }