private void DatabaseOperation_DataSourceAllPagesReadyEventUnattended(DataSet dataSet)
{
if (_unattended)
{
DataTable statisticsInfoDataTable = dataSet.Tables[1];
string periodBegin = "";
if (statisticsInfoDataTable.Rows[0]["MinStartTime"] != DBNull.Value)
{
DateTime minStartTime = Convert.ToDateTime(statisticsInfoDataTable.Rows[0]["MinStartTime"]);
_minStartTime = minStartTime;
string formattedMinStartTime = GenericHelper.FormatFileNameDate(minStartTime);
periodBegin = formattedMinStartTime;
}
string periodEnd = "";
if (statisticsInfoDataTable.Rows[0]["MaxStartTime"] != DBNull.Value)
{
DateTime maxStartTime = Convert.ToDateTime(statisticsInfoDataTable.Rows[0]["MaxStartTime"]);
_maxStartTime = maxStartTime;
string formattedMaxStartTime = GenericHelper.FormatFileNameDate(maxStartTime);
periodEnd = formattedMaxStartTime;
}
_fileName = string.Format(_fileName, periodBegin, periodEnd, _totalRows);
}
_databaseOperation.DataSourceAllPagesReadyEvent -= DatabaseOperation_DataSourceAllPagesReadyEventUnattended;
ExportToCsv.DoExport(dataSet.Tables[0], _fileName, _dataViewerParameters);
}
public static void InitializeLog()
{
DirectoryInfo di = new DirectoryInfo(GenericHelper.ExecPath);
FileInfo[] logFiles = di.GetFiles(string.Format(@"{0}*.log", GenericHelper.ApplicationName));
GenericHelper.DateCompareFileInfo dateCompareFileInfo = new GenericHelper.DateCompareFileInfo();
Array.Sort(logFiles, dateCompareFileInfo);
for (int i = ConfigHandler.NumberOfServiceContextLogFiles - 1; i < logFiles.Length; i++)
{
try
{
GenericHelper.DeleteFile(logFiles[i].FullName);
}
catch
{
}
}
_fileNameDate = GenericHelper.FormatFileNameDate(DateTime.Now);
_log = new StringBuilder();
}
public bool InititalizeStatisticsGeneration(string statisticsName, string filter1Name, string filter2Name, string tempPath, List <string> sendToWebServiceNames, string tempPathSendToWebService, int nameIterator)
{
bool success = true;
if (!string.IsNullOrEmpty(filter1Name))
{
bool filter1NameExists = filter1UserControl.InitializeSavedSearch(filter1Name);
if (filter1NameExists)
{
filter1UserControl.ApplyFilter();
}
else
{
OutputHandler.WriteToLog(string.Format("The requested Filter1 \"{0}\" for statistic \"{1}\" does not exist", filter1Name, statisticsName));
success = false;
}
}
if (!string.IsNullOrEmpty(filter2Name))
{
bool filter2NameExists = filter2UserControl.InitializeSavedSearch(filter2Name);
if (filter2NameExists)
{
filter2UserControl.ApplyFilter();
}
else
{
OutputHandler.WriteToLog(string.Format("The requested Filter2 \"{0}\" for statistic \"{1}\" does not exist", filter2Name, statisticsName));
success = false;
}
}
bool statisticsNameExists = statisticUserControl1.InitializeSavedSearch(statisticsName);
if (statisticsNameExists)
{
if (!Directory.Exists(tempPath))
{
Directory.CreateDirectory(tempPath);
}
string exportCsvFileName = string.Format(@"{0}\[{1}][{2}][{3}][{4}][{5}][{6}].csv", tempPath, statisticsName, "{0}", "{1}", filter1Name, filter2Name, "{2}");
statisticUserControl1.ExportStatisticsUnattended(exportCsvFileName);
string periodBegin = "";
if (statisticUserControl1.GetMinStartTime() != DateTime.MinValue)
{
periodBegin = GenericHelper.FormatFileNameDate(statisticUserControl1.GetMinStartTime());
}
string periodEnd = "";
if (statisticUserControl1.GetMaxStartTime() != DateTime.MinValue)
{
periodEnd = GenericHelper.FormatFileNameDate(statisticUserControl1.GetMaxStartTime());
}
if (sendToWebServiceNames.Count > 0)
{
if (!Directory.Exists(tempPathSendToWebService))
{
Directory.CreateDirectory(tempPathSendToWebService);
}
for (int i = 0; i < sendToWebServiceNames.Count; i++)
{
if (i == nameIterator && sendToWebServiceNames[i] == statisticsName)
{
File.Copy(string.Format(exportCsvFileName, periodBegin, periodEnd, _totalRows), string.Format(@"{0}\[{1}][{2}][{3}][{4}][{5}][{6}].csv", tempPathSendToWebService, statisticsName, periodBegin, periodEnd, filter1Name, filter2Name, _totalRows));
}
}
}
}
else
{
OutputHandler.WriteToLog(string.Format("The requested statistic \"{0}\" does not exist", statisticsName));
success = false;
}
return(success);
}
