/// <summary>
/// Gets the event page.
/// </summary>
/// <param name="applicationId">The application id.</param>
/// <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="eventTypeFilter">The event type filter.</param>
/// <param name="userId">The user id.</param>
/// <param name="startDate">The start date.</param>
/// <param name="endDate">The end date.</param>
/// <returns></returns>
public static LogDatasets.EventLogDataTable GetEventPage(int applicationId, int pageSize, int pageIndex, out int?rowCount, int appLocationFilter, int eventTypeFilter
, int userId, DateTime startDate, DateTime endDate)
{
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("@EventTypeFilter", eventTypeFilter);
dam.AddInputParameter("@AuthenticatedUserIdFilter", userId.ToString());
dam.AddInputParameter("@StartDate", startDate);
dam.AddInputParameter("@EndDate", endDate);
dam.AddOutPutParameter("@RowCount", SqlDbType.Int);
Dictionary <string, object> outputParameters = new Dictionary <string, object>();
LogDatasets.EventLogDataTable dt = dam.ExecuteTableQuery <LogDatasets.EventLogDataTable>(GetFormattedStoredProcedureName(SP_EVENTLOG_GETPAGE_WITHFILTERS), out outputParameters);
rowCount = (int)outputParameters["@RowCount"];
return(dt);
}
/// <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);
}