public LogIDPairEntity GetLogIDRangeByLogTime(DateTimeCompare timeEntity, string userName, string machineName)
{
string temporaryUserNameInput = TranslateWildcardForExceptionLog(userName);
string temporaryMachineameInput = TranslateWildcardForExceptionLog(machineName);
DbCommand command = Helper.BuildDbCommand("P_IC_LOGGING_EXCEPTION_LOG_ID_RANGE");
Helper.AssignParameterValues(
command,
timeEntity.StartTime,
timeEntity.EndTime,
temporaryUserNameInput,
temporaryMachineameInput
);
Helper.ExecuteScalar(command);
long minLogID = (long)(Helper.GetParameterValue(command, "p_min_log_id"));
long maxLogID = (long)(Helper.GetParameterValue(command, "p_max_log_id"));
return new LogIDPairEntity(minLogID, maxLogID);
}
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;
}
private void ButtonSearchForCount_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
DisableValidationProvider();
this.validationProvider7.Enabled = true;
if (this.ValidateChildren())
{
DateTimeCompare timeEntity = new DateTimeCompare(
DateTimeStartDateForCount.DateTime.Date, DateTimeEndDateForCount.DateTime.Date);
using (AsyncWorker<IUsageLogView> worker = new AsyncWorker<IUsageLogView>(_presenter, this.ultraChart7, new Control[] { ButtonSearchForCount }))
{
#region worker defini
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
var tempEntity = eDoWork.Argument as DateTimeCompare;
if (tempEntity == null)
{
return;
}
eDoWork.Result = _presenter.GetAllCountOfUsers(tempEntity);
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LoggingUsageDataSet dataset = eCompleted.Result as LoggingUsageDataSet;
if (dataset != null && dataset.T_IC_LOGGING_USAGE.Rows.Count > 0)
{
int rowCount = dataset.T_IC_LOGGING_USAGE.Rows.Count - 1;
this.ultraChart7.Height = CHART_BASE_HEIGHT + rowCount * INCREMENT_FEED;
this.usageByUserCountExpandableGroupBox.Height = EXPANDABLE_GROUP_BOX_BASE_HEIGHT + rowCount * INCREMENT_FEED;
SetChartStype(this.ultraChart7, "USER_COUNT", dataset);
this.ultraChart7.DataSource = dataset.T_IC_LOGGING_USAGE.Select(
data => new
{
emptyname = String.Empty,
usercount = Convert.ToInt32(data["USER_COUNT"])
}
).ToList();
this.ultraChart7.Visible = true;
}
else
{
this.ultraChart7.Visible = false;
this.usageByUserCountExpandableGroupBox.Height = EXPANDABLE_GROUP_BOX_BASE_HEIGHT - CHART_BASE_HEIGHT;
}
};
#endregion
worker.Run(timeEntity);
}
}
}
catch (Exception ex)
{
if (ExceptionManager.Handle(ex))
{
throw;
}
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void PrepareShowExceptionList(DateTimeCompare timepair, string userName, string machineName)
{
string instanceID = TextBoxInstanceID.Text.Trim();
if (!string.IsNullOrEmpty(instanceID))
{
using (AsyncWorkerByTrunk<IExceptionLogView> worker = new AsyncWorkerByTrunk<IExceptionLogView>(_presenter, this.GridViewExceptionLog, new Control[] { ButtonSearch, ButtonClear }, true))
{
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
eDoWork.Result = _presenter.GetExceptionLog(
new LogIDPairEntity(),
null,
null,
null,
null,
null,
instanceID);
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LoggingViewDataSet loggingViewData = eCompleted.Result as LoggingViewDataSet;
GridViewExceptionLog.DataSource = loggingViewData;
this.totalCount.Text = GridViewExceptionLog.Rows.Count.ToString();
};
worker.Run();
}
}
else
{
using (AsyncWorkerByTrunk<IExceptionLogView> worker = new AsyncWorkerByTrunk<IExceptionLogView>(_presenter, this.GridViewExceptionLog, new Control[] { ButtonSearch, ButtonClear }, true))
{
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
eDoWork.Result = _presenter.GetLogIDRangeByLogTime(timepair, userName, machineName);
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LogIDPairEntity logIDPairEntity = eCompleted.Result as LogIDPairEntity;
GridViewExceptionLog.DataSource = new LoggingViewDataSet();
this.totalCount.Text = GridViewExceptionLog.Rows.Count.ToString();
if (logIDPairEntity != null && logIDPairEntity.MinLogID > 0)
{
// Step 1. Return Min LOG_ID and Max LOG_ID
totalMaxLogID = logIDPairEntity.MaxLogID;
this._ultraProgressBarForSearch.Value = 3; // only prepare for loading data, initial progress is 3%
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnProcess);
ProgressCounter++;
this.ButtonSearch.Text = "&Stop";
IsAsyncWorking = true;
// Step 2. Recursive loading data according to LOG_ID and LOG_ID
ShowExceptionLogList(
new LoggingViewDataSet(),
logIDPairEntity,
timepair,
TextBoxUseName.Text,
ComboxSeverity.Value.ToString(),
TextBoxMachineName.Text,
TextBoxLogContent.Text,
TextBoxInstanceID.Text.Trim());
}
else
{
this._ultraProgressBarForSearch.Visible = false;
}
};
worker.Run();
}
}
}
private LogIDPairEntity GetIDRangeByLogTime(DateTimeCompare timeEntity, string spName)
{
DataTable dt = new DataTable();
DbCommand command = Helper.BuildDbCommand(spName);
Helper.AssignParameterValues(
command,
timeEntity.StartTime,
timeEntity.EndTime
);
Helper.Fill(dt, command);
long minLogID = (long)(Helper.GetParameterValue(command, "p_min_log_id"));
long maxLogID = (long)(Helper.GetParameterValue(command, "p_max_log_id"));
//LogIDPairEntity logIDPair = new LogIDPairEntity();
//long logID;
//if (dt.Rows.Count > 0 && dt.Rows.Count <= 1)
//{
// logID = long.Parse(dt.Rows[0][0].ToString());
// logIDPair = new LogIDPairEntity(logID, logID);
//}
//if (dt.Rows.Count > 1)
//{
// List<long> logIDCollection = new List<long>();
// foreach (DataRow row in dt.Rows)
// {
// logID = long.Parse(row[0].ToString());
// logIDCollection.Add(logID);
// }
// logIDPair = new LogIDPairEntity(logIDCollection.Min<long>(), logIDCollection.Max<long>());
//}
//return logIDPair;
return new LogIDPairEntity(minLogID, maxLogID);
}
public Int64[] GetIndexRange(DateTimeCompare timeEntity)
{
DbCommand cmd = _loggingDBHelper.BuildDbCommand(GetIndexRangeSP);
_loggingDBHelper.AssignParameterValues(cmd,timeEntity.StartTime,timeEntity.EndTime);
_loggingDBHelper.ExecuteNonQuery(cmd);
object temp = _loggingDBHelper.GetParameterValue(cmd, "min");
Int64 min = (temp==DBNull.Value)?0:(Int64)temp;
temp = _loggingDBHelper.GetParameterValue(cmd, "max");
Int64 max = (temp == DBNull.Value) ? 0 : (Int64)temp;
return new [] { min,max};
}
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;
}
private void PrepareShowInstrumentationList(DateTimeCompare timepair)
{
using (AsyncWorkerByTrunk<IInstrumentationView> worker = new AsyncWorkerByTrunk<IInstrumentationView>(_presenter, this.GridViewInstrumentation, new Control[] { ButtonSearch, ButtonClear }, true))
{
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
eDoWork.Result = _presenter.GetLogIDRangeByLogTime(timepair);
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LogIDPairEntity logIDPairEntity = eCompleted.Result as LogIDPairEntity;
GridViewInstrumentation.DataSource = new LoggingViewDataSet();
this.totalCount.Text = GridViewInstrumentation.Rows.Count.ToString();
if (logIDPairEntity != null && logIDPairEntity.MinLogID > 0)
{
// Step 1. Return Min LOG_ID and Max LOG_ID
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnProcess);
ProgressCounter++;
this.ButtonSearch.Text = "&Stop";
IsAsyncWorking = true;
// Step 2. Recursive loading data according to LOG_ID and LOG_ID
InstrumentationSearchCondition condition = new InstrumentationSearchCondition();
condition.UserName = TextBoxUserName.Text;
condition.IpAddress = TextBoxIpAddress.Text;
condition.ModuleId = TextBoxModuleId.Text;
condition.FunctionId = TextBoxFunctionId.Text;
condition.ComponentName = ComboxComponentName.Value.ToString();
condition.PCName = PCName.Text;
ShowInstrumentationLogList(
new LoggingViewDataSet(),
logIDPairEntity,timepair,
condition);
}
};
worker.Run();
}
}
private void ShowInstrumentationLogList(
LoggingViewDataSet loggingViewData,
LogIDPairEntity logIDPair,DateTimeCompare timeEntity,
InstrumentationSearchCondition condition)
{
using (AsyncWorkerByTrunk<IInstrumentationView> worker = new AsyncWorkerByTrunk<IInstrumentationView>(_presenter, this.GridViewInstrumentation, new Control[] { ButtonClear }, true))
{
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
eDoWork.Result = _presenter.GetInstrumentationData(
logIDPair,timeEntity,
condition);
Thread.Sleep(300); // default 300
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
if (WorkItem.SmartParts[ViewId] == null || !IsAsyncWorking)
{
this.ButtonSearch.Text = "&Search";
return;
}
// ExceptionViewData exceptionViewData = eCompleted.Result as ExceptionViewData;
LoggingViewDataSet tempLoggingViewData = eCompleted.Result as LoggingViewDataSet;
if (tempLoggingViewData == null) tempLoggingViewData = new LoggingViewDataSet();
loggingViewData.Merge(tempLoggingViewData);
GridViewInstrumentation.DataSource = loggingViewData;
this.totalCount.Text = GridViewInstrumentation.Rows.Count.ToString();
string[] logIDPairArray = tempLoggingViewData.ExtendedProperties["LogIDPair"].ToString().Split(',');
Int64 minLogID = Convert.ToInt64(logIDPairArray[0]);
Int64 maxLogID = Convert.ToInt64(logIDPairArray[1]);
if (minLogID <= maxLogID)
{
ShowInstrumentationLogList(
loggingViewData,
new LogIDPairEntity(minLogID, maxLogID),timeEntity,
condition);
}
else
{
IsAsyncWorking = false;
this.ButtonSearch.Text = "&Search";
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
ProgressCounter--;
AsyncWaiting(500);
}
};
worker.Run();
}
}
private void ButtonSearch_Click(object sender, EventArgs e)
{
try
{
if (this.ValidateChildren())
{
this.Cursor = Cursors.WaitCursor;
switch (this.ButtonSearch.Text)
{
case "&Search":
// Step 1. Return Min LOG_ID and Max LOG_ID
DateTimeCompare timepair = new DateTimeCompare(DateTimeStartDate.DateTime, DateTimeEndDate.DateTime);
PrepareShowInstrumentationList(timepair);
this.GridViewInstrumentation.Focus();
break;
case "&Stop":
IsAsyncWorking = false;
this.ButtonSearch.Text = "&Search";
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
ProgressCounter--;
break;
}
}
}
catch (Exception ex)
{
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
if (ExceptionManager.Handle(ex)) throw;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void ButtonSearch_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (this.ValidateChildren())
{
// Initialize data grid
LoggingViewData = new LoggingViewDataSet();
GridViewPerformance.DataSource = LoggingViewData.T_IC_PERFORMANCE_LOG;
this.totalCount.Text = GridViewPerformance.Rows.Count.ToString();
this.GridViewPerformance.Focus();
DateTimeCompare timeEntity = new DateTimeCompare(DateTimeStartDate.DateTime,
DateTimeEndDate.DateTime);
var argus = new object[] { timeEntity,
TextBoxFunctionId.Text,
ComboxComponentName.Value.ToString(),
this.TextBoxUserName.Text };
using (AsyncWorkerByTrunk<IPerformanceMonitoringView> worker = new AsyncWorkerByTrunk<IPerformanceMonitoringView>(_presenter, this.GridViewPerformance, new Control[] { ButtonSearch, ButtonClear }))
{
#region worker definition
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
var tempArgus = eDoWork.Argument as object[];
if (tempArgus==null || tempArgus.Length<=3)
{
return;
}
eDoWork.Result = _presenter.GetPerformanceData(
tempArgus[0] as DateTimeCompare,
tempArgus[1] as string,
tempArgus[2] as string, tempArgus[3] as string);
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LoggingViewData = eCompleted.Result as LoggingViewDataSet;
if (null==LoggingViewData)
{
LoggingViewData = new LoggingViewDataSet();
}
GridViewPerformance.DataSource = LoggingViewData.T_IC_PERFORMANCE_LOG;
this.totalCount.Text = GridViewPerformance.Rows.Count.ToString();
};
#endregion
worker.Run(argus);
}
}
}
catch (Exception ex)
{
if (ExceptionManager.Handle(ex)) throw;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void ButtonSearchForUser_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
DisableValidationProvider();
this.validationProvider1.Enabled = true;
if (this.ValidateChildren())
{
DateTimeCompare timeEntity = new DateTimeCompare(DateTimeStartDateForUser.DateTime.Date,
DateTimeEndDateForUser.DateTime.Date);
var argus = new object[] {timeEntity, TextBoxUserName.Text};
using (AsyncWorker<IUsageLogView> worker = new AsyncWorker<IUsageLogView>(_presenter, this.ultraChart1, new Control[] { ButtonSearchForUser }))
{
#region worker definition
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
var tempArgus = eDoWork.Argument as object[];
if (tempArgus==null || tempArgus.Length<=1)
{
return;
}
eDoWork.Result = _presenter.GetUsageForUserData(
tempArgus[0] as DateTimeCompare,tempArgus[1] as string );
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
LoggingUsageDataSet dataset = eCompleted.Result as LoggingUsageDataSet;
if (dataset != null && dataset.T_IC_LOGGING_USAGE.Rows.Count > 0)
{
int rowCount = dataset.T_IC_LOGGING_USAGE.Rows.Count - 1;
this.ultraChart1.Height = CHART_BASE_HEIGHT + rowCount * INCREMENT_FEED;
this.usageByUserExpandableGroupBox.Height = EXPANDABLE_GROUP_BOX_BASE_HEIGHT + rowCount * INCREMENT_FEED;
SetChartStype(this.ultraChart1, "FREQUENCY", dataset);
this.ultraChart1.DataSource = dataset.T_IC_LOGGING_USAGE.Select(
data => new
{
username = data["USER_NAME"].ToString(),
logintimes = Convert.ToInt32(data["FREQUENCY"])
}
).ToList();
this.ultraChart1.Visible = true;
}
else
{
this.ultraChart1.Visible = false;
this.usageByUserExpandableGroupBox.Height = EXPANDABLE_GROUP_BOX_BASE_HEIGHT - CHART_BASE_HEIGHT;
}
};
#endregion
worker.Run(argus);
}
}
}
catch (Exception ex)
{
if (ExceptionManager.Handle(ex)) throw;
}
finally
{
this.Cursor = Cursors.Default;
}
}
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 LoggingViewDataSet RetrieveExceptionLog(LogIDPairEntity logIDPair, DateTimeCompare timeEntity, string userName, string category, string severity, string machineName, string logContent, string instanceID)
{
const int MaxErrorLogNumber = 1000;
if (!string.IsNullOrEmpty(instanceID))
{
LoggingViewDataSet logDs = new LoggingViewDataSet();
DbCommand command;
command = Helper.BuildDbCommand("dbo.P_IC_LOGGING_EXCEPTION_LOG_S_BY_ID");
Helper.AssignParameterValues(command, instanceID);
Helper.Fill(logDs.T_IC_LOGGING_LOG, command);
return logDs;
}
else
{
long minLogID = logIDPair.MinLogID;
long maxLogID = logIDPair.MaxLogID;
long currentMinLogID = maxLogID - MaxErrorLogNumber;
LoggingViewDataSet logDs;
LoggingViewDataSet logDsByFilter = new LoggingViewDataSet();
DbCommand command;
int recordCount = 0;
int computeCount = 0;
string temporaryUserNameInput = TranslateWildcardForExceptionLog(userName);
string temporaryMachineameInput = TranslateWildcardForExceptionLog(machineName);
while (recordCount == 0 && minLogID <= maxLogID && computeCount < MaxNullFounds)
{
command = Helper.BuildDbCommand("dbo.P_IC_LOGGING_EXCEPTION_LOG_S");
command.CommandTimeout = 0;
if (currentMinLogID < minLogID)
{
currentMinLogID = minLogID;
}
logDs = new LoggingViewDataSet();
Helper.AssignParameterValues(command, currentMinLogID, maxLogID, temporaryUserNameInput, temporaryMachineameInput);
Helper.Fill(logDs.T_IC_LOGGING_LOG, command);
var list = (from n in logDs.T_IC_LOGGING_LOG
// ReSharper disable ConditionIsAlwaysTrueOrFalse
where (string.IsNullOrEmpty(severity) || ConvertToString(n.SEVERITY).Equals(severity))
&& (!string.IsNullOrEmpty(userName) ? SearchHelper.IsRegexMatch(ConvertToString(n.USER_NAME), userName, @"[\w|\W]*") : true)
&& (string.IsNullOrEmpty(category) || ConvertToString(n.CATEGORY_NAME).Equals(category))
&& (!string.IsNullOrEmpty(machineName) ? SearchHelper.IsRegexMatch(ConvertToString(n.MACHINE_NAME), machineName, @"[\w|\W]*") : true)
&& (!string.IsNullOrEmpty(logContent) ? SearchHelper.IsRegexMatch(ConvertToString(n.FORMATTED_MESSAGE), logContent, @"[\w|\W]*") : true)
&& (string.IsNullOrEmpty(instanceID) || ConvertToString(n.INSTANCE_ID).Equals(instanceID))
&& (timeEntity == null ? true : n.LOG_TIME <= timeEntity.EndTime)
&& (timeEntity == null ? true : n.LOG_TIME >= timeEntity.StartTime)
// ReSharper restore ConditionIsAlwaysTrueOrFalse
select n);
maxLogID = currentMinLogID - 1;
currentMinLogID = maxLogID - MaxErrorLogNumber;
recordCount += list.Count();
computeCount += 1;
foreach (var row in list)
{
logDsByFilter.T_IC_LOGGING_LOG.ImportRow(row);
}
logDs.Dispose();
}
logDsByFilter.ExtendedProperties.Add("LogIDPair", minLogID.ToString() + "," + maxLogID.ToString());
logDsByFilter.AcceptChanges();
return logDsByFilter;
}
}
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 LoggingViewDataSet RetrieveInstrumentation(LogIDPairEntity logIDPair, DateTimeCompare timeEntity,string userName, string ipAddress, string moduleId, string functionId, string componentName, string category, string pcName)
{
long minLogID = logIDPair.MinLogID;
long maxLogID = logIDPair.MaxLogID;
long currentMinLogID = maxLogID - MaxRecords;
LoggingViewDataSet logDs;
LoggingViewDataSet logDsByFilter = new LoggingViewDataSet();
DbCommand command;
int recordCount = 0;
int computeCount = 0;
while (recordCount == 0 && minLogID <= maxLogID && computeCount < MaxNullFounds)
{
command = Helper.BuildDbCommand("dbo.P_IC_LOGGING_INSTRUMENTATION_S");
command.CommandTimeout = 0;
if (currentMinLogID < minLogID)
{
currentMinLogID = minLogID;
}
logDs = new LoggingViewDataSet();
Helper.AssignParameterValues(command, currentMinLogID, maxLogID);
Helper.Fill(logDs.T_IC_LOGGING_LOG, command);
var list = (from n in logDs.T_IC_LOGGING_LOG
// ReSharper disable ConditionIsAlwaysTrueOrFalse
where (string.IsNullOrEmpty(category) || n.CATEGORY_NAME.Equals(category))
&& (string.IsNullOrEmpty(componentName) || n.COMPONENT.Equals(ConvertToString(componentName)))
&& (!string.IsNullOrEmpty(userName) ? SearchHelper.IsRegexMatch(ConvertToString(n.USER_NAME), userName, @"[\w|\W]*") : true)
&& (!string.IsNullOrEmpty(ipAddress) ? SearchHelper.IsRegexMatch(ConvertToString(n.IP_ADDRESS), ipAddress, @"[\w|\W]*") : true)
&& (!string.IsNullOrEmpty(moduleId) ? SearchHelper.IsRegexMatch(ConvertToString(n.MODULE_ID), moduleId, @"[\w|\W]*") : true)
&& (!string.IsNullOrEmpty(functionId) ? SearchHelper.IsRegexMatch(ConvertToString(n.FUNCTION_ID), functionId, @"[\w|\W]*") : true)
&& (!string.IsNullOrEmpty(pcName) ? SearchHelper.IsRegexMatch(ConvertToString(n.MACHINE_NAME), pcName, @"[\w|\W]*") : true)
// ReSharper restore ConditionIsAlwaysTrueOrFalse
&& (timeEntity == null ? true : n.LOG_TIME <= timeEntity.EndTime)
&& (timeEntity == null ? true : n.LOG_TIME >= timeEntity.StartTime)
select n);
maxLogID = currentMinLogID - 1;
currentMinLogID = maxLogID - MaxRecords;
recordCount += list.Count();
computeCount += 1;
foreach (var row in list)
{
logDsByFilter.T_IC_LOGGING_LOG.ImportRow(row);
}
logDs.Dispose();
}
logDsByFilter.ExtendedProperties.Add("LogIDPair", minLogID.ToString() + "," + maxLogID.ToString());
logDsByFilter.AcceptChanges();
return logDsByFilter;
}
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 LoggingViewDataSet RetrievePerformanceInformation(DateTimeCompare timeEntity, string functionId, string componentName, string userName)
{
LoggingViewDataSet logDs = new LoggingViewDataSet();
Helper.Fill(logDs.T_IC_PERFORMANCE_LOG, "dbo.P_IC_LOGGING_PERFORMANCE_S", timeEntity.StartTime, timeEntity.EndTime, functionId, componentName, userName);
return logDs;
}
public LogIDPairEntity GetInstrumentationLogIDRangeByLogTime(DateTimeCompare timeEntity)
{
return GetIDRangeByLogTime(timeEntity, "P_IC_LOGGING_INSTRUMENTATION_LOG_ID_RANGE");
}
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;
}
private void ButtonSearch_Click(object sender, EventArgs e)
{
try
{
if (this.ValidateChildren())
{
this.Cursor = Cursors.WaitCursor;
switch (this.ButtonSearch.Text)
{
case "&Search":
// Step 1. Return Min LOG_ID and Max LOG_ID
this._ultraProgressBarForSearch.Value = 0;
this._ultraProgressBarForSearch.Visible = false; // Only open here.
DateTimeCompare timepair = new DateTimeCompare(DateTimeStartTime.DateTime, DateTimeEndTime.DateTime);
PrepareShowExceptionList(timepair,
TextBoxUseName.Text,
TextBoxMachineName.Text);
this.GridViewExceptionLog.Focus();
break;
case "&Stop":
IsAsyncWorking = false;
this.ButtonSearch.Text = "&Search";
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
ProgressCounter--;
this._ultraProgressBarForSearch.Visible = false;
break;
}
}
}
catch (Exception ex)
{
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
if (ExceptionManager.Handle(ex)) throw;
}
finally
{
this.Cursor = Cursors.Default;
}
}
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;
}
private void ShowExceptionLogList(
LoggingViewDataSet loggingViewData,
LogIDPairEntity logIDPair,
DateTimeCompare timeEntity,
string userName,
string severity,
string machineName,
string logContent,
string instanceID)
{
using (AsyncWorkerByTrunk<IExceptionLogView> worker = new AsyncWorkerByTrunk<IExceptionLogView>(_presenter, this.GridViewExceptionLog, new Control[] { ButtonClear }, true))
{
worker.DoWork += delegate(object oDoWork, DoWorkEventArgs eDoWork)
{
eDoWork.Result = _presenter.GetExceptionLog(
logIDPair,
timeEntity,
userName,
severity,
machineName,
logContent,
instanceID);
Thread.Sleep(300); // default 300
};
worker.RunWorkerCompleted += delegate(object oCompleted, RunWorkerCompletedEventArgs eCompleted)
{
if (WorkItem.SmartParts[ViewId] == null || !IsAsyncWorking)
{
this.ButtonSearch.Text = "&Search";
return;
}
// ExceptionViewData exceptionViewData = eCompleted.Result as ExceptionViewData;
LoggingViewDataSet LoggingViewData = eCompleted.Result as LoggingViewDataSet;
if (LoggingViewData == null) LoggingViewData = new LoggingViewDataSet();
loggingViewData.Merge(LoggingViewData);
GridViewExceptionLog.DataSource = loggingViewData;
this.totalCount.Text = GridViewExceptionLog.Rows.Count.ToString();
string[] logIDPairArray = LoggingViewData.ExtendedProperties["LogIDPair"].ToString().Split(',');
Int64 minLogID = Convert.ToInt64(logIDPairArray[0]);
Int64 maxLogID = Convert.ToInt64(logIDPairArray[1]);
double remain = maxLogID - minLogID;
double total = totalMaxLogID - minLogID;
double remains = (1 - remain / total) * 97 + 3;
if (remains > 0 && remains <= 100)
{
this._ultraProgressBarForSearch.Value = Convert.ToInt32(remains);
}
if (minLogID <= maxLogID)
{
ShowExceptionLogList(
loggingViewData,
new LogIDPairEntity(minLogID, maxLogID),
timeEntity,
TextBoxUseName.Text,
ComboxSeverity.Value.ToString(),
TextBoxMachineName.Text,
TextBoxLogContent.Text,
TextBoxInstanceID.Text.Trim());
}
else
{
IsAsyncWorking = false;
this.ButtonSearch.Text = "&Search";
_presenter.OnUpdateProgressBar(ProgressBarStatus.OnEnd);
ProgressCounter--;
this._ultraProgressBarForSearch.Value = 100;
AsyncWaiting(500);
}
};
worker.Run();
}
}
public Int64[] GetIndexRange(DateTimeCompare timeEntity)
{
var da = InstanceBuilder.CreateInstance<AuditLogViewDA>();
return da.GetIndexRange(timeEntity);
}
