public LoggingServer(IConfig config)
{
_config = config;
if (_config.LoggingEnabled)
{
if (_config.LoggingTracePath != "")
{
tr = new TextWriterTraceListener(_config.LoggingTracePath);
ts.Listeners.Add(tr);
}
if (_config.LoggingConnectionString != "")
{
try
{
SQLDataExecutor.ExecuteStatement(_config.LoggingConnectionString, "select count(*) from sys.databases", 5);
_validTargerServer = true;
}
catch (Exception ex)
{
_validTargerServer = false;
throw;
}
}
}
}
public void OnNext(List <Log> value)
{
if (_config.LoggingEnabled)
{
foreach (Log log in value)
{
if (tr != null)
{
tr.WriteLine(log.GetBaseMessage());
ts.Flush();
}
if (_validTargerServer)
{
SQLDataExecutor.ExecuteStatement(_config.LoggingConnectionString, "dbo.Insert_Log ", log.GetSQLParameters());
}
}
}
}
public void Load(ref Log returnLog)
{
Data = new DataSet();
try
{
returnLog.StartTime = DateTime.Now;
Data = SQLDataExecutor.FillDataSet(this.ConnectionString, this.FillQuery);
returnLog.Message = "Load Completed successfully. Record count:" + Data.Tables[0].Rows.Count;
returnLog.EndTime = DateTime.Now;
}
catch (Exception ex)
{
returnLog.EndTime = DateTime.Now;
returnLog.Successful = false;
returnLog.Message = ex.Message;
}
}
public void Refresh(ref Log returnLog)
{
DataSet updatedDataSet = new DataSet();
try
{
returnLog.StartTime = DateTime.Now;
updatedDataSet = SQLDataExecutor.FillDataSet(this.ConnectionString, this.FillQuery);
returnLog.Message = "Refresh Completed successfully. Previous count:" + Data.Tables[0].Rows.Count + ". New count:" + updatedDataSet.Tables[0].Rows.Count;
Data = updatedDataSet.Copy();
returnLog.EndTime = DateTime.Now;
}
catch (Exception ex)
{
returnLog.EndTime = DateTime.Now;
returnLog.Successful = false;
returnLog.Message = "Error in refresh:" + ex.Message;
}
}
public List <Log> Execute(DataManager dm, Dictionary <string, ITaskVariable> taskVariables, Log returnLog)
{
var tempQueryList = QueryList.Copy();
List <Log> returnLogs = new List <Log>();
foreach (ReplacementValue strv in Replacements)
{
var temp = dm.GetValueFromMacro(strv.Value, taskVariables);
for (int i = 0; i < tempQueryList.Count; i++)
{
tempQueryList[i].Statement = dm.GetValueFromMacro(tempQueryList[i].Statement, taskVariables);
if (strv.Global)
{
tempQueryList[i].Statement = Regex.Replace(tempQueryList[i].Statement, strv.Pattern, temp);
}
else
{
tempQueryList[i].Statement = dm.GetValueFromMacro(tempQueryList[i].Statement, strv, taskVariables);
}
}
}
for (int i = 0; i < tempQueryList.Count; i++)
{
Log sqlLog = new Log()
{
Type = returnLog.Type, Source = returnLog.Source
};
try
{
sqlLog.StartTime = DateTime.Now;
sqlLog.Source += "-" + i;
sqlLog.Statement = dm.GetValueFromMacro(tempQueryList[i].Statement, taskVariables);
if (tempQueryList[i].OutputType == SqlStatementOutputType.None)
{
SQLDataExecutor.ExecuteStatement(tempQueryList[i].ConnectionString, sqlLog.Statement);
}
else
{
object output = null;
if (tempQueryList[i].OutputType == SqlStatementOutputType.Scalar)
{
output = SQLDataExecutor.ExecuteScalar(tempQueryList[i].ConnectionString, sqlLog.Statement);
}
if (tempQueryList[i].OutputList.Count > 0 && output != null)
{
dm.SetOutputValues(output, tempQueryList[i].OutputList, ref taskVariables);
}
}
sqlLog.Message = "Completed successfully";
sqlLog.EndTime = DateTime.Now;
}
catch (Exception ex)
{
sqlLog.EndTime = DateTime.Now;
sqlLog.Successful = false;
sqlLog.Message = ex.Message;
}
returnLogs.Add(sqlLog);
}
return(returnLogs);
}
public void Load(DataManager dm)
{
OriginalValue = Value;
Value = Convert.ToString(SQLDataExecutor.ExecuteScalar(ConnectionString, Statement));
}
