private void Init()
{
var results = PeriodicReportData.Select();
foreach (var result in results)
{
var entry = mEntries.FirstOrDefault(e => e.Data.PeriodicReportID == result.PeriodicReportID);
if (entry == null)
{
if (result.PeriodicReportStatus == 1)
{
Log("Adding PeriodReport ID=" + result.PeriodicReportID + " Recipients=" + result.Recipients);
entry = new PeriodicReportEntry()
{
Data = result,
NextAttempt = CalculateNextTimestamp(result.ScheduleDay, result.ScheduleHour, result.ScheduleMinute),
};
mEntries.Add(entry);
}
}
else
{
if (entry.Data.PeriodicReportStatus != result.PeriodicReportStatus && result.PeriodicReportStatus == 0)
{
Log("Removing PeriodReport ID=" + result.PeriodicReportID);
mEntries.Remove(entry);
}
}
}
}
private bool SendReport(PeriodicReportData data)
{
string outputFilename = "Report.txt";
Log("Sending report: ID=" + data.PeriodicReportID);
try
{
Process process = new Process();
process.StartInfo.FileName = "sqlcmd.exe";
process.StartInfo.Arguments = "-S" + Environment.MachineName + "\\sqlexpress -U testuser -P testapp_987 -d testautomation -i " + data.ScriptPath + " -o " + outputFilename;
process.StartInfo.UseShellExecute = false;
process.Start();
process.WaitForExit();
EmailHelper.SendEmail(data.Recipients, data.EmailHeader, data.EmailBody, outputFilename);
}
catch (Exception ex)
{
Log("SendReport exception: " + ex);
}
return(true);
}