/// <summary>
/// Gets the exception page.
/// </summary>
/// <param name="applicationId">The application id.</param>
/// <param name="pageSize">The amount of record rows to retrieve.</param>
/// <param name="pageIndex">The index of the page to retrieve.</param>
/// <param name="rowCount">The total amount of rows of the exception table.</param>
/// <param name="appLocationFilter">The ApplicationLocation to filter. Set this value to -1 if you don't want to filter by application locations.</param>
/// <param name="handlingStatus">The handling status of this exception. Set this value to -1 if you don't want to filter by handling status.</param>
/// <param name="orderBy">The order by.</param>
/// <returns></returns>
public static LogDatasets.ExceptionLogDataTable GetExceptionPage(int applicationId, int pageSize, int pageIndex, out int?rowCount, int appLocationFilter, int handlingStatus
, ExceptionsOrderBy orderBy)
{
rowCount = 0;
DataAccessManager dam = new DataAccessManager(ConnectionString);
dam.AddInputParameter("@ApplicationId", applicationId);
dam.AddInputParameter("@PageIndex", pageIndex);
dam.AddInputParameter("@PageSize", pageSize);
dam.AddInputParameter("@AppLocationFilter", appLocationFilter);
dam.AddInputParameter("@HandlingStatus", handlingStatus);
dam.AddOutPutParameter("@RowCount", SqlDbType.Int);
dam.AddInputParameter("@OrderBy", (int)orderBy);
Dictionary <string, object> outputParameters = new Dictionary <string, object>();
LogDatasets.ExceptionLogDataTable dt = dam.ExecuteTableQuery <LogDatasets.ExceptionLogDataTable>(GetFormattedStoredProcedureName(SP_EXCEPTIONS_GETPAGE), out outputParameters);
rowCount = (int)outputParameters["@RowCount"];
return(dt);
}
/// <summary>
/// Gets the exception page.
/// </summary>
/// <param name="pageSize">Size of the page.</param>
/// <param name="pageIndex">Index of the page.</param>
/// <param name="rowCount">The row count.</param>
/// <param name="appLocationFilter">The app location filter.</param>
/// <param name="handlingStatus">The handling status.</param>
/// <param name="orderBy">The order by.</param>
/// <returns></returns>
public static LogDatasets.ExceptionLogDataTable GetExceptionPage(int pageSize, int pageIndex, out int?rowCount, int appLocationFilter, int handlingStatus
, ExceptionsOrderBy orderBy)
{
return(GetExceptionPage(LogController.ApplicationId, pageSize, pageIndex, out rowCount, appLocationFilter, handlingStatus, ExceptionsOrderBy.DateLastOccurredDesc));
}
