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