private void ConnectButton_Click(object sender, RoutedEventArgs e)
{
Endpoint lockInfo;
try
{
var paramsList = EndpointURL.Text.Replace("k1://", "").Replace("/", "").Split(':').ToList();
lockInfo = Backend.GetLockInfo(Guid.Parse(paramsList.Last()));
SshWrapper w = new SshWrapper(lockInfo);
this.Hide();
string result = w.Connect();
this.Show();
}
catch (Exception ex)
{
StatusLabel.Content = String.Format("Error: {0}", ex.Message);
}
}
public MainWindow()
{
InitializeComponent();
EndpointURL.IsEnabled = false;
ConnectButton.IsEnabled = false;
StatusLabel.Content = "Hello";
RegistryTool.SetUrlHandler();
if (Environment.GetCommandLineArgs().Count() > 1)
{
var paramsList = Environment.GetCommandLineArgs().Last().Replace("k1://", "").Replace("/", "").Split(':').ToList();
if (paramsList.First() == "lock")
{
Endpoint lockInfo;
try
{
StatusLabel.Content = String.Format("Connecting");
lockInfo = Backend.GetLockInfo(Guid.Parse(paramsList.Last()));
SshWrapper w = new SshWrapper(lockInfo);
string result = w.Connect();
StatusLabel.Content = String.Format("Connected" + Environment.NewLine + result);
} catch (Exception ex)
{
StatusLabel.Content = String.Format("Error: {0}", ex.Message);
}
}
else
{
StatusLabel.Content += "No endpoint id";
}
}
else
{
StatusLabel.Content = "No link" + Environment.NewLine + "Enter link in field below";
EndpointURL.IsEnabled = true;
ConnectButton.IsEnabled = true;
};
}
public bool ExecuteTask(ScheduledTask task)
{
message = "";
var dataSourceOption = task.DataSourceDictionary;
if (dataSourceOption == null || !dataSourceOption.Any())
{
message = string.Format("No data Source Options was configured for Job: {0}", task.JobName);
// log.Info(message);
return(false);
}
foreach (var datasource in dataSourceOption)
{
var TypeOfDataSource = (DataSourceType)Convert.ToInt16(HelperMethods.DictionaryLookUp(datasource, "TypeOfDataSource"));
var securityTypeForDataSource = (AccessSecurityType)Convert.ToInt16(HelperMethods.DictionaryLookUp(datasource, "SecurityTypeForDataSource"));
var relativeOrAbsoluteFilePath = string.IsNullOrEmpty((string)HelperMethods.DictionaryLookUp(datasource, "RelativeOrAbsoluteFilePath")) ? "R" : (string)HelperMethods.DictionaryLookUp(datasource, "RelativeOrAbsoluteFilePath");
if (TypeOfDataSource == DataSourceType.Database)
{
string connectionString = (string)HelperMethods.DictionaryLookUp(datasource, "ValueForDataConnectionType");
string queryFile = null;
if (relativeOrAbsoluteFilePath.ToUpper().Equals("R"))
{
queryFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory,
(string)HelperMethods.DictionaryLookUp(datasource, "ValueForDataRetrievalMethod"));
}
else
{
queryFile = (string)HelperMethods.DictionaryLookUp(datasource, "ValueForDataRetrievalMethod");
}
if (!File.Exists(queryFile))
{
message = string.Format("Unable to load query files: {0} for Job: {1}", queryFile, task.JobName);
return(false);
}
//Get Values for Data Source Property
if (datasource.ContainsKey("RequirePreOrPostProcessExecution") && (datasource["RequirePreOrPostProcessExecution"].Equals("1") || datasource["RequirePreOrPostProcessExecution"].Equals("2") || datasource["RequirePreOrPostProcessExecution"].Equals("3")))
{
if (datasource.ContainsKey("ProcessExecution"))
{
var executionProcess = datasource["ProcessExecution"];
var processes = (List <Dictionary <string, object> >)executionProcess;
if (executionProcess != null)
{
Dictionary <string, object> preProcess =
processes.FirstOrDefault(a => a.ContainsKey("Type") && a.ContainsValue("1"));
if (preProcess.Any())
{
ExternalProcessExecution(preProcess);
}
}
}
}
string query = System.IO.File.ReadAllText(queryFile);
var dbProviderForDatabaseDataSource = (DataSourceDbProvider)Convert.ToInt16(HelperMethods.DictionaryLookUp(datasource, "DbProviderForDatabaseDataSource"));
if (securityTypeForDataSource == AccessSecurityType.Ssl)
{
SshWrapper.Connect(null);
}
log.Info(string.Format("Job Query Retrieved for Job: {0}", task.JobName));
DataTable sourceData = null;
try
{
sourceData = DataDbAccess.GetSourceData(dbProviderForDatabaseDataSource, connectionString, query);
}
catch (Exception exp)
{
log.Error(exp);
}
log.Info(string.Format("Record(s) Retrieved: {0} for Job: {1}", sourceData == null ? 0 : sourceData.Rows.Count, task.JobName));
if (securityTypeForDataSource == AccessSecurityType.Ssl)
{
SshWrapper.Disconnect();
}
if (sourceData == null || sourceData.Rows.Count < 1)
{
message = string.Format("No data was retrieved from Source: {0}", task.JobName);
// return false;
}
if (!datasource.ContainsKey("OutputFileFormat"))
{
message = string.Format("No Output File Format Defined for Job: {0}", task.JobName);
return(false);
}
var fileName = CreateDataFile((Dictionary <string, object>)datasource["OutputFileFormat"], relativeOrAbsoluteFilePath, sourceData);
if (fileName == null)
{
message = string.Format("Unable to Create data File for Job: {0}", task.JobName);
return(false);
}
log.Info(string.Format("Output File created at : {0} for Job: {1} ", fileName, task.JobName));
bool status = DeliveryMethodHelper.ProcessDeliveryMethod(task.DataDeliveryDictionary, fileName);
if (!status)
{
// message = string.Format("Unable to Delivery data using Delivery Option: {0} for Job: {1} ",
// task.DataDeliveryOptions.DeliveryMethod, task.JobName);
//return false;
}
}
else
{
message = string.Format("No Operation has been defined for Type of Data Source: {0} for Job: {1}",
TypeOfDataSource, task.JobName);
// log.Info(message);
}
}
return(true);
}
