public EmployeeDetailsList GetRecordPage(int iPageNo, int iPageSize)
{
EmployeeDetailsList objReturn = null;
try
{
if (iPageNo > 0)
{
using (EmployeeDetails_DAL objDAL = new EmployeeDetails_DAL())
{
objReturn = objDAL.GetRecordPage(iPageNo, iPageSize);
}
}
}
catch (Exception ex)
{ log.Error("GetRecordsPage Error: ", ex); }
return(objReturn);
}
public EmployeeDetailsList GetRecordPage(int iPageNo, int iPageSize)
{
EmployeeDetailsList objReturn = new EmployeeDetailsList();
try
{
using (SqlConnection db = new SqlDBConnect().GetConnection())
{
DynamicParameters param = new DynamicParameters();
param.Add("@pageNum", iPageNo);
param.Add("@pageSize", iPageSize);
param.Add("@TotalRecords", dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output);
objReturn.EmployeeDetailss = db.Query <EmployeeDetails>("udp_EmployeeDetails_lstpage", param, commandType: System.Data.CommandType.StoredProcedure).ToList();
objReturn.TotalRecords = param.Get <int>("@TotalRecords");
}
}
catch (Exception ex)
{ log.Error("GetRecordsPage Error: ", ex); }
return(objReturn);
}
