private void HDFSDestinationUI_Load(object sender, EventArgs e)
{
var connections = connectionService.GetConnections();
var connectionManagerId = string.Empty;
if (metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY] != null ||
!string.IsNullOrWhiteSpace(metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY].Value))
{
txtDestinationPath.Text = metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY].Value;
}
IDTSVirtualInput100 vInput = metaData.InputCollection[0].GetVirtualInput();
Dictionary <string, int> columnLineage = new Dictionary <string, int>(vInput.VirtualInputColumnCollection.Count);
int itemIndex = 0;
foreach (IDTSVirtualInputColumn100 item in vInput.VirtualInputColumnCollection)
{
cbSourceColumns.Items.Add(new SourceColumnItem()
{
Name = item.Name.Trim(), Index = itemIndex++, ColumnInfo = item
});
columnLineage.Add(item.Name, item.LineageID);
}
var currentConnectionManager = this.metaData.RuntimeConnectionCollection[0];
if (currentConnectionManager != null)
{
connectionManagerId = currentConnectionManager.ConnectionManagerID;
}
int diff = 0;
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as HDFSConnectionManager.HDFSConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i - diff;
}
}
else
{
diff++;
}
}
}
/// <summary>
/// Add a connection to Project
/// </summary>
/// <param name="connection"></param>
/// <returns></returns>
public ConnectionManager AddConnectionManager(ConnectionManager connection)
{
Debug.Assert(null != connection, @"The connection should not be nullable.");
string connectionStreamName = connection.Name + ".conmgr";
ConnectionManagerItem cmi = Project.ConnectionManagerItems.Add(connection.CreationName, connectionStreamName);
return(cmi.ConnectionManager);
}
/// <summary>
/// Add an EzConnectionManager to Project
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="connection"></param>
/// <returns></returns>
public ConnectionManager AddConnectionManager <T>(T connection) where T : EzConnectionManager
{
Debug.Assert(null != connection, @"The package should not be nullable.");
string connectionStreamName = connection.Name + ".conmgr";
ConnectionManagerItem cmi = Project.ConnectionManagerItems.Add(connection.GetConnMgrID(), connectionStreamName);
return(cmi.ConnectionManager);
}
/// <summary>
/// Add a connection to project with a specified stream name
/// </summary>
/// <param name="connection"></param>
/// <param name="streamname"></param>
/// <returns>connection stream name</returns>
public ConnectionManager AddConnectionManager(ConnectionManager connection, string streamname)
{
Debug.Assert(null != connection, @"The connection should not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(streamname), @"The stream name should not be nullable.");
ConnectionManagerItem cmi = Project.ConnectionManagerItems.Add(connection.CreationName, streamname);
return(cmi.ConnectionManager);
}
public void AddConManagers(List <ConManConfigRow> cons)
{
if (prj == null)
{
return;
}
foreach (ConManConfigRow cmc in cons)
{
ConnectionManagerItem cm = prj.ConnectionManagerItems.Add(cmc.CMType, cmc.Name + ".conmgr");
cm.ConnectionManager.Name = cmc.Name;
cm.ConnectionManager.ConnectionString = cmc.ConnectionString;
}
}
private void btnNewConnectionManager_Click(object sender, EventArgs e)
{
System.Collections.ArrayList created = connectionService.CreateConnection("RABBITMQ");
foreach (ConnectionManager cm in created)
{
var item = new ConnectionManagerItem()
{
Name = cm.Name,
ConnManager = cm.InnerObject as RabbitMQConnectionManager.RabbitMQConnectionManager,
ID = cm.ID
};
cbConnectionList.Items.Insert(0, item);
}
}
private void btnNewConnectionManager_Click(object sender, EventArgs e)
{
System.Collections.ArrayList created = connectionService.CreateConnection("RABBITMQ");
foreach (ConnectionManager cm in created)
{
var item = new ConnectionManagerItem()
{
Name = cm.Name,
ConnManager = cm.InnerObject as RabbitMQConnectionManager.RabbitMQConnectionManager,
ID = cm.ID
};
cbConnectionList.Items.Insert(0, item);
}
}
private void btnNewConnectionManager_Click(object sender, EventArgs e)
{
System.Collections.ArrayList created = connectionService.CreateConnection(Constants.HDFS_CONNECTION_MANAGER);
foreach (ConnectionManager cm in created)
{
var item = new ConnectionManagerItem()
{
Name = cm.Name,
ConnManager = cm.InnerObject as HDFSConnectionManager.HDFSConnectionManager,
ID = cm.ID
};
cbConnectionList.Items.Insert(0, item);
}
}
private void btnNewConnectionManager_Click(object sender, EventArgs e)
{
System.Collections.ArrayList created = connectionService.CreateConnection(Constants.HDFS_CONNECTION_MANAGER);
foreach (ConnectionManager cm in created)
{
var item = new ConnectionManagerItem()
{
Name = cm.Name,
ConnManager = cm.InnerObject as HDFSConnectionManager.HDFSConnectionManager,
ID = cm.ID
};
cbConnectionList.Items.Insert(0, item);
}
}
private void CRMSourceAdapterUIForm_Load(object sender, EventArgs e)
{
var connections = connectionService.GetConnections();
var FetchXML = metaData.CustomPropertyCollection[0];
oldFetchXML = (string)FetchXML.Value;
txtFetchXML.Text = (string)FetchXML.Value;
string connectionManagerId = string.Empty;
var currentConnectionManager = this.metaData.RuntimeConnectionCollection[0];
if (currentConnectionManager != null)
{
connectionManagerId = currentConnectionManager.ConnectionManagerID;
}
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject;
if (conn != null)
{
if (conn.GetType().ToString() == "CRMSSIS.CRMConnectionManager.CRMConnectionManager")
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i;
}
}
}
}
}
private void HDFSTaskUIForm_Load(object sender, EventArgs e)
{
var connectionManagerId = string.Empty;
var hdfsTaskHost = this.taskHost.InnerObject as HDFSTask;
if (hdfsTaskHost != null)
{
connectionManagerId = hdfsTaskHost.ConnectionManagerId;
txtRemoteDirectory.Text = hdfsTaskHost.RemoteDirectory;
txtSourceDirectory.Text = hdfsTaskHost.SourceDirectory;
txtFileTypeFilter.Text = hdfsTaskHost.FileTypeFilter;
}
int diff = 0;
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as HDFSConnectionManager.HDFSConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i - diff;
}
}
else
{
diff++;
}
}
}
private void RabbitMQSourceUIForm_Load(object sender, EventArgs e)
{
var connections = connectionService.GetConnections();
var queueName = metaData.CustomPropertyCollection[0];
txtQueueName.Text = queueName.Value;
string connectionManagerId = string.Empty;
var currentConnectionManager = this.metaData.RuntimeConnectionCollection[0];
if (currentConnectionManager != null)
{
connectionManagerId = currentConnectionManager.ConnectionManagerID;
}
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as RabbitMQConnectionManager.RabbitMQConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i;
}
}
}
}
private void RabbitMQSourceUIForm_Load(object sender, EventArgs e)
{
var connections = connectionService.GetConnections();
var queueName = metaData.CustomPropertyCollection[0];
txtQueueName.Text = queueName.Value;
string connectionManagerId = string.Empty;
var currentConnectionManager = this.metaData.RuntimeConnectionCollection[0];
if (currentConnectionManager != null)
{
connectionManagerId = currentConnectionManager.ConnectionManagerID;
}
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as RabbitMQConnectionManager.RabbitMQConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i;
}
}
}
}
private void HDFSDestinationUI_Load(object sender, EventArgs e)
{
var connections = connectionService.GetConnections();
var connectionManagerId = string.Empty;
if (metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY] != null ||
!string.IsNullOrWhiteSpace(metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY].Value))
{
txtDestinationPath.Text = metaData.CustomPropertyCollection[Constants.HDFS_PATH_PROPERTY].Value;
}
IDTSVirtualInput100 vInput = metaData.InputCollection[0].GetVirtualInput();
Dictionary<string, int> columnLineage = new Dictionary<string, int>(vInput.VirtualInputColumnCollection.Count);
int itemIndex = 0;
foreach (IDTSVirtualInputColumn100 item in vInput.VirtualInputColumnCollection)
{
cbSourceColumns.Items.Add(new SourceColumnItem() { Name = item.Name.Trim(), Index = itemIndex++, ColumnInfo = item });
columnLineage.Add(item.Name, item.LineageID);
}
var currentConnectionManager = this.metaData.RuntimeConnectionCollection[0];
if (currentConnectionManager != null)
{
connectionManagerId = currentConnectionManager.ConnectionManagerID;
}
int diff = 0;
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as HDFSConnectionManager.HDFSConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i - diff;
}
}
else
{
diff++;
}
}
}
private void HDFSTaskUIForm_Load(object sender, EventArgs e)
{
var connectionManagerId = string.Empty;
var hdfsTaskHost = this.taskHost.InnerObject as HDFSTask;
if (hdfsTaskHost != null)
{
connectionManagerId = hdfsTaskHost.ConnectionManagerId;
txtRemoteDirectory.Text = hdfsTaskHost.RemoteDirectory;
txtSourceDirectory.Text = hdfsTaskHost.SourceDirectory;
txtFileTypeFilter.Text = hdfsTaskHost.FileTypeFilter;
}
int diff = 0;
for (int i = 0; i < connections.Count; i++)
{
var conn = connections[i].InnerObject as HDFSConnectionManager.HDFSConnectionManager;
if (conn != null)
{
var item = new ConnectionManagerItem()
{
Name = connections[i].Name,
ConnManager = conn,
ID = connections[i].ID
};
cbConnectionList.Items.Add(item);
if (connections[i].ID.Equals(connectionManagerId))
{
cbConnectionList.SelectedIndex = i - diff;
}
}
else
{
diff++;
}
}
}
