public LoggingUsageDataSet RetrieveUsagesForUsersCount(DateTimeCompare timeEntity)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_COUNT_BY_TIME", timeEntity.StartTime, timeEntity.EndTime);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForUsersCountByModule(DateTimeCompare timeEntity, string moduleId)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_COUNT_BY_MODULE", timeEntity.StartTime, timeEntity.EndTime, moduleId);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForRole(DateTimeCompare timeEntity, string roleId)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_ROLE", timeEntity.StartTime, timeEntity.EndTime, roleId);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForUser(DateTimeCompare timeEntity, string userName)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_USER", timeEntity.StartTime, timeEntity.EndTime, userName);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForOrganization(DateTimeCompare timeEntity, string organization)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_ORGANIZATION", timeEntity.StartTime, timeEntity.EndTime, organization);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForOffice(DateTimeCompare timeEntity, string office)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_OFFICE", timeEntity.StartTime, timeEntity.EndTime, office);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForGraphicArea(DateTimeCompare timeEntity, string geographicArea)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_AREA", timeEntity.StartTime, timeEntity.EndTime, geographicArea);
return usageDs;
}
public LoggingUsageDataSet RetrieveUsagesForFunction(DateTimeCompare timeEntity, string functionId)
{
LoggingUsageDataSet usageDs = new LoggingUsageDataSet();
Helper.Fill(usageDs.T_IC_LOGGING_USAGE, "dbo.P_IC_LOGGING_USAGE_BY_FUNCTION", timeEntity.StartTime, timeEntity.EndTime, functionId);
return usageDs;
}
//Revised for defect #1359
private void SetChartStype(UltraChart chart, string columnName, LoggingUsageDataSet dataset)
{
List<int> countsList = new List<int>();
foreach (DataRow row in dataset.T_IC_LOGGING_USAGE.Rows)
{
countsList.Add(Convert.ToInt32(row[columnName]));
}
int maxValue = countsList.Max();
chart.Axis.X.TickmarkStyle = AxisTickStyle.Smart;
if (maxValue < 6)
{
chart.Axis.X.TickmarkStyle = AxisTickStyle.DataInterval;
chart.Axis.X.TickmarkInterval = 1;
}
}
