public void Execute(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, ReportProgressMethod reportProgress)
{
ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.CreateNoWindow = true;
startInfo.FileName = "cmd.exe";
startInfo.Arguments = "/C " + this.Configuration.CmdValue;
startInfo.UseShellExecute = false;
startInfo.RedirectStandardOutput = true;
startInfo.RedirectStandardError = true;
using (Process process = new Process())
{
process.StartInfo = startInfo;
process.Start();
process.WaitForExit();
string output = process.StandardOutput.ReadToEnd();
string error = process.StandardError.ReadToEnd();
if (!String.IsNullOrEmpty(error))
{
throw new Exception("An error occured on execution of " + this.Configuration.CmdValue + ":\n\n" + error);
}
}
}
public void Execute(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, ReportProgressMethod reportProgress)
{
string[] eventLogConnection = connection.GetConnection() as string[];
EventLog eventLog = new EventLog();
eventLog.Source = eventLogConnection[0];
eventLog.Log = eventLogConnection[1];
EventLogEntryType level = (EventLogEntryType)Enum.Parse(typeof(EventLogEntryType), this.Configuration.Level.ToString());
eventLog.WriteEntry(this.Configuration.Message, level);
}
public void Execute(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, ReportProgressMethod reportProgress)
{
using (OdbcConnection sqlConnection = connection.GetConnection() as OdbcConnection)
{
if (sqlConnection.State != System.Data.ConnectionState.Open)
{
sqlConnection.Open();
}
using (OdbcCommand odbcCommand = new OdbcCommand(Configuration.SqlValue, sqlConnection))
{
odbcCommand.ExecuteNonQuery();
}
}
}
public void TransformData(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, SDK.Database.IDatastore dataObject, ReportProgressMethod reportProgress)
{
foreach (var transformation in this.Configuration.DefaultValues)
{
reportProgress(new SimpleProgressReport("Start add default value column " + transformation.ColumnName + ". Value: " + transformation.Value));
dataObject.AddColumn(new ColumnMetadata(transformation.ColumnName));
for (int i = 0; i < dataObject.Count; i++)
{
dataObject.SetValue(i, dataObject.Metadata.Columns[transformation.ColumnName].ColumnIndex, transformation.Value);
}
reportProgress(new SimpleProgressReport("Finished add default value column " + transformation.ColumnName + ". Value: " + transformation.Value));
}
}
public void Execute(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, ReportProgressMethod reportProgress)
{
SmtpClient smtpClient = connection.GetConnection() as SmtpClient;
MailMessage mailMessage = new MailMessage(
this.Configuration.From,
this.Configuration.To,
this.Configuration.Subject,
this.Configuration.Body);
mailMessage.IsBodyHtml = this.Configuration.IsBodyHtml;
if (String.IsNullOrEmpty(this.Configuration.Cc) == false)
{
mailMessage.CC.Add(new MailAddress(this.Configuration.Cc));
}
smtpClient.Send(mailMessage);
}
public void WriteData(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, SDK.Database.IDatastore dataObject, ReportProgressMethod reportProgress)
{
ExcelConnectionObject excelConnection = (ExcelConnectionObject)connection.GetConnection();
ExcelWorksheet worksheet = excelConnection.Worksheet;
// Write columnheaders into the worksheet
foreach (var column in dataObject.Metadata.Columns)
{
worksheet.SetValue(1, column.Value.ColumnIndex + 1, column.Value.ColumnName);
}
// Write data into the worksheet
for (int row = 0; row < dataObject.Count; row++)
{
object[] data = dataObject[row];
for (int column = 0; column < data.Length; column++)
{
worksheet.SetValue(row + 2, column + 1, data[column]);
}
}
excelConnection.Package.Save();
}
public void Execute(IConnection connection, SDK.Database.IDatabaseInterface databaseInterface, ReportProgressMethod reportProgress)
{
System.Threading.Thread.Sleep(this.Configuration.DelayInMilliseconds);
throw new Exception("Error");
}
