private bool CheckConnection(bool display) { bool result = false; var workflowManagementServer = new WorkflowManagementServer(); try { if (string.IsNullOrEmpty(txtServerName.Text) || string.IsNullOrEmpty(txtServerPort.Text.ToString())) { this.DisplayError("Enter servername and port", "ServerName or Port empty"); return(result); } ConnectionBuilder = new SCConnectionStringBuilder(); ConnectionBuilder.Host = txtServerName.Text; ConnectionBuilder.Port = uint.Parse(txtServerPort.Text); ConnectionBuilder.IsPrimaryLogin = true; ConnectionBuilder.Integrated = chkIntegratedSecurity.Checked; if (!string.IsNullOrEmpty(txtUserName.Text)) { if (string.IsNullOrEmpty(txtServerName.Text) || string.IsNullOrEmpty(txtServerPort.Text.ToString())) { this.DisplayError("Enter servername and port", "ServerName or Port empty"); return(result); } ConnectionBuilder.UserID = txtUserName.Text; ConnectionBuilder.Password = txtUserPassword.Text; ConnectionBuilder.SecurityLabelName = txtLabel.Text; ConnectionBuilder.WindowsDomain = txtDomain.Text; } workflowManagementServer.CreateConnection(); workflowManagementServer.Connection.Open(ConnectionBuilder.ConnectionString); if (display) { this.DisplayInfo("Connection to '" + txtServerName.Text + "' succeeded", "Connection succeeded"); } btnOK.Enabled = true; result = true; } catch (Exception ex) { this.DisplayError("Connection Failed to '" + txtServerName.Text + ":" + txtServerPort.Text + "' Message: " + ex.Message, "Connection Failed"); btnOK.Enabled = false; result = false; } finally { this.Stop(); workflowManagementServer?.Connection?.Dispose(); } return(result); }
public Boolean WorkItemAction(string serialno, string action) { //TODO - Move into K2 Helpers Connection K2Conn = new Connection(); SCConnectionStringBuilder K2ConnString = new SCConnectionStringBuilder(); //Setup Connection String K2ConnString.Host = "Win2012-K2"; K2ConnString.Integrated = false; K2ConnString.UserID = "Sa4Demo\\Tberry"; K2ConnString.Password = "******"; K2ConnString.Port = 5252; K2ConnString.WindowsDomain = "Sa4Demo"; K2ConnString.SecurityLabelName = "K2"; K2ConnString.Authenticate = true; K2ConnString.IsPrimaryLogin = true; K2Conn.Open("Win2012-K2", K2ConnString.ConnectionString); SourceCode.Workflow.Client.WorklistItem worklistItem = K2Conn.OpenWorklistItem(serialno); // action the workflow by executing the action if (worklistItem.Actions.Count > 0) { worklistItem.Actions[action].Execute(); return (true); } else { return (false); } }
public static SCConnectionStringBuilder[] GetAllServerConfiguration() { var servers = new List <SCConnectionStringBuilder>(); using (var userStorage = IsolatedStorageFile.GetUserStoreForAssembly()) { if (userStorage.GetFileNames(_k2ConfigFile).Contains(_k2ConfigFile)) { using (var userStream = new IsolatedStorageFileStream(_k2ConfigFile, FileMode.Open, userStorage)) using (var cryptostreamLoad = new CryptoStream(userStream, Decryptor(), CryptoStreamMode.Read)) { var xpathDoc = new XPathDocument(cryptostreamLoad); var xpathNavigator = xpathDoc.CreateNavigator(); var connections = xpathNavigator.Select("//connectionstring"); foreach (XPathNavigator connection in connections) { var server = new SCConnectionStringBuilder(connection.GetAttribute("connectionstring", string.Empty)); servers.Add(server); } } } } return(servers.ToArray()); }
public List<SA4Launcher.Models.WorklistItem> LoadWorkList() { Connection K2Conn = new Connection(); SCConnectionStringBuilder K2ConnString = new SCConnectionStringBuilder(); List<SA4Launcher.Models.WorklistItem> _currentWorkList = new List<SA4Launcher.Models.WorklistItem>(); //Setup Connection String K2ConnString.Host = "Sa4DemoK2wAD"; K2ConnString.Integrated = false; K2ConnString.UserID = "SA4Demo\\Tberry"; K2ConnString.Password = "******"; K2ConnString.Port = 5252; K2ConnString.WindowsDomain = "Sa4Demo"; K2ConnString.SecurityLabelName = "K2"; K2ConnString.Authenticate = false; K2ConnString.IsPrimaryLogin = true; K2Conn.Open("Sa4DemoK2wAD", K2ConnString.ConnectionString.ToString()); //TODO: Need to add try loop with true false return Worklist K2WorkList = K2Conn.OpenWorklist(); List<SA4Launcher.Models.Action> CurrentActions = new List<SA4Launcher.Models.Action>(); if (K2WorkList != null) { _currentWorkList.Clear(); foreach (SourceCode.Workflow.Client.WorklistItem K2worklistitem in K2WorkList) { //Build Actions First CurrentActions.Clear(); foreach (SourceCode.Workflow.Client.Action K2action in K2worklistitem.Actions) { CurrentActions.Add(new SA4Launcher.Models.Action { Name = K2action.Name, Batchable = K2action.Batchable }); } //Load worklist items into model _currentWorkList.Add(new SA4Launcher.Models.WorklistItem { ID = K2worklistitem.ID, serialno = K2worklistitem.SerialNumber, Name = K2worklistitem.ProcessInstance.Name, UserName = K2worklistitem.AllocatedUser, Folio = K2worklistitem.ProcessInstance.Folio, StartDate = K2worklistitem.ProcessInstance.StartDate, Status = K2worklistitem.Status.ToString(), ViewFlow = K2worklistitem.ProcessInstance.ViewFlow, Data = K2worklistitem.Data, Priority = K2worklistitem.ProcessInstance.Priority, Actions = CurrentActions.ToList() }); } } K2Conn.Close(); return (_currentWorkList); }
private void InitializeConnectionString() { _connectionString = new SCConnectionStringBuilder(); _connectionString.Host = _serverName; _connectionString.Port = _serverPort; _connectionString.IsPrimaryLogin = true; _connectionString.Integrated = true; }
private void cboRecentServers_SelectedIndexChanged(object sender, EventArgs e) { SCConnectionStringBuilder selectedServer = ((sender as ComboBox).SelectedItem as DisplayServer).ServerSetting; ConnectionBuilder = selectedServer; this.UpdateTextBoxes(); btnDelete.Enabled = true; }
public string GetSOConnectionString() { SCConnectionStringBuilder scConStr = new SCConnectionStringBuilder(_sessionConnectionString); SOConnectionStringBuilder soConStr = new SOConnectionStringBuilder() { Server = scConStr.Host, Port = Convert.ToInt32(scConStr.Port) }; return soConStr.ConnectionString; }
private string CreateConnectionString(string host, int port) { SCConnectionStringBuilder connBuilder = new SCConnectionStringBuilder(); connBuilder.Host = host; connBuilder.Port = (uint)port; connBuilder.IsPrimaryLogin = true; connBuilder.Integrated = true; return(connBuilder.ConnectionString); }
public static List<SmartObject> SmartObjectExplorer() { List<SmartObject> list = new List<SmartObject>(); SCConnectionStringBuilder hostServerConnectionString = new SCConnectionStringBuilder(); hostServerConnectionString.Host = "dlx"; hostServerConnectionString.Port = 5555; hostServerConnectionString.IsPrimaryLogin = true; hostServerConnectionString.Integrated = true; SourceCode.SmartObjects.Management.SmartObjectManagementServer smomgt = new SourceCode.SmartObjects.Management.SmartObjectManagementServer(); smomgt.CreateConnection(); try { smomgt.Connection.Open(hostServerConnectionString.ConnectionString.ToString()); SourceCode.SmartObjects.Management.SmartObjectExplorer smartobjects = smomgt.GetSmartObjects(); foreach (SourceCode.SmartObjects.Management.SmartObjectInfo info in smartobjects.SmartObjectList) { list.Add(new SmartObject { Description = info.Metadata.Description.ToString(), Name = info.Name, guid = info.Guid, ArtefactType = "SmartObject", displayname = info.Metadata.DisplayName, Version = info.Version.ToString(), Service = info.ServiceObjectName, ServiceGUID = info.ServiceInstanceGuid }); } } catch (Exception ex) { list.Add(new SmartObject { Description = ex.Message, Name = ex.Source, ArtefactType = "SmartObject Error" }); } finally { smomgt.Connection.Close(); } return list; }
public static string GetDisplayName(this SCConnectionStringBuilder connectionStringBuilder) { var displayName = $"{connectionStringBuilder.Host}:{connectionStringBuilder.Port}"; if (!string.IsNullOrEmpty(connectionStringBuilder.UserID)) { displayName = $"{displayName} - {connectionStringBuilder.UserID}"; } return(displayName.ToUpperInvariant()); }
private void btnDelete_Click(object sender, EventArgs e) { if (cboRecentServers.SelectedItem is DisplayServer) { SCConnectionStringBuilder serverSetting = (cboRecentServers.SelectedItem as DisplayServer).ServerSetting; var config = new ServerConfiguration(); config.Remove(serverSetting); cboRecentServers.Items.Remove(cboRecentServers.SelectedItem); } }
void IPartImportsSatisfiedNotification.OnImportsSatisfied() { // Called when all [Import]s have been resolved. var builder = new SCConnectionStringBuilder(); builder.Host = Dns.GetHostName(); builder.Integrated = true; builder.IsPrimaryLogin = true; builder.Port = _k2ServerPort; _k2ServerConnectionString = builder.ConnectionString; }
private static string GetConnectionString() { SCConnectionStringBuilder connectionStringBuilder = new SCConnectionStringBuilder { Host = ConfigurationManager.AppSettings["Host"], Port = Convert.ToUInt32(ConfigurationManager.AppSettings["Port"]), IsPrimaryLogin = true, Integrated = true }; return(connectionStringBuilder.ConnectionString); }
/* * /// <summary> * /// Method creates a SqlExecute object which only needs a SqlQuery and Parameters to be set. * /// </summary> * /// <returns></returns> * protected SqlExecute CreateDirectSqlExecute() * { * //SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();//BuildConnectionString(); * ServiceBroker.IsSqlExecute = true; * ServiceBroker.SqlQueryExecute = new SqlExecute(); * ServiceBroker.SqlQueryExecute.ServerName = string.Empty; //"DLX"; * ServiceBroker.SqlQueryExecute.Provider = string.Empty; //"SQLOLEDB"; * ServiceBroker.SqlQueryExecute.UserID = string.Empty; * ServiceBroker.SqlQueryExecute.Password = string.Empty; * * if (this.ServiceBroker.Service.ServiceConfiguration.ServiceAuthentication.AuthenticationMode == AuthenticationMode.SSO || * this.ServiceBroker.Service.ServiceConfiguration.ServiceAuthentication.AuthenticationMode == AuthenticationMode.Static) * { * ServiceBroker.SqlQueryExecute.UserID = this.ServiceBroker.Service.ServiceConfiguration.ServiceAuthentication.UserName; * ServiceBroker.SqlQueryExecute.Password = this.ServiceBroker.Service.ServiceConfiguration.ServiceAuthentication.Password; * } * else * { * ServiceBroker.SqlQueryExecute.IntegratedSecurity = true.ToString(); * } * * ServiceBroker.SqlQueryExecute.DifferentSQLServer = false; * * return ServiceBroker.SqlQueryExecute; * } */ #endregion Protected Methods and properties that are useful for the child class #region Private helper methods private string GetBaseConnection(uint port) { if (this.baseConnection == null) { this.baseConnection = new SCConnectionStringBuilder(); this.baseConnection.Authenticate = true; this.baseConnection.Host = "localhost"; //hardcoded, always connect to yourself. Works better on NLB environments. this.baseConnection.Integrated = true; this.baseConnection.IsPrimaryLogin = true; this.baseConnection.Port = port; } return(this.baseConnection.ToString()); }
private static string EnvionmentServerConnection(string environmentServer) { SCConnectionStringBuilder cb = new SCConnectionStringBuilder(); cb.Host = environmentServer; cb.Port = 5555; cb.Integrated = true; cb.IsPrimaryLogin = true; cb.Authenticate = true; cb.EncryptedPassword = false; string envionmentServerConnection = cb.ToString(); return(envionmentServerConnection); }
/// <summary> /// Builds the connection string /// </summary> /// <returns></returns> public static string ConnectToK2() { GetDetails(); SCConnectionStringBuilder connectionstring = new SCConnectionStringBuilder(); connectionstring.Host = _Server; connectionstring.Port = _Port; connectionstring.IsPrimaryLogin = true; connectionstring.Integrated = true; return(connectionstring.ToString()); }
private void recentServer_Click(object sender, EventArgs e) { SCConnectionStringBuilder selectedServer = (SCConnectionStringBuilder)(sender as ToolStripMenuItem).Tag; ServerConfiguration config = new ServerConfiguration(); config.CreateNewServerConfig(selectedServer); this.GetRecentServers(); K2Client.Instance.K2Config.HostServerConnectionString = selectedServer.ConnectionString; this.ChangeServerStatus(); SyncFromServer(); }
public void CreateNewServerConfig(SCConnectionStringBuilder hostServerConfig) { hostServerConfig.ThrowIfNull(nameof(hostServerConfig)); string name = hostServerConfig.GetDisplayName(); string connectionstring = hostServerConfig.ConnectionString; CreateIsolatedStorage(); using (var userStorage = IsolatedStorageFile.GetUserStoreForAssembly()) { XmlDocument k2ConfDoc = null; using (var userStream = new IsolatedStorageFileStream(_k2ConfigFile, FileMode.Open, userStorage)) using (var cryptostreamLoad = new CryptoStream(userStream, Decryptor(), CryptoStreamMode.Read)) { k2ConfDoc = new XmlDocument(); k2ConfDoc.Load(cryptostreamLoad); } using (var userStream = new IsolatedStorageFileStream(_k2ConfigFile, FileMode.Create, userStorage)) using (var cryptostream = new CryptoStream(userStream, Encryptor(), CryptoStreamMode.Write)) { try { var connectionStringsElement = k2ConfDoc.SelectSingleNode("/configuration/connectionstrings"); var currentNode = connectionStringsElement.SelectSingleNode(string.Format("connectionstring[@name='{0}']", name)); if (currentNode != null) { connectionStringsElement.RemoveChild(currentNode); } var connStringNode = k2ConfDoc.CreateElement("connectionstring"); connectionStringsElement.PrependChild(connStringNode); connStringNode.SetAttribute("name", name); connStringNode.SetAttribute("connectionstring", connectionstring); k2ConfDoc.Save(cryptostream); userStream.Flush(); } finally { k2ConfDoc = null; } } } }
/// <summary> /// Get Connection String Connect to K2. /// </summary> /// <returns>The connection string.</returns> private string GetConnectionString() { var hostServerConnectionString = new SCConnectionStringBuilder { Host = ConfigurationManager.AppSettings[ConstantValueService.K2_URL], Port = Convert.ToUInt32(ConfigurationManager.AppSettings[ConstantValueService.K2_MANAGEMENT_PORT]), IsPrimaryLogin = true, Integrated = false, UserID = ConfigurationManager.AppSettings[ConstantValueService.K2_ADMINUSERNAME], Password = ConfigurationManager.AppSettings[ConstantValueService.K2_ADMINPASSWORD], SecurityLabelName = ConfigurationManager.AppSettings[ConstantValueService.K2_SECURITYLABEL] }; return(hostServerConnectionString.ToString()); }
public static List<SmartObjectProperty> SmartObjectMethodsExplorer(Guid SmartObjectGUID) { List<SmartObjectProperty> list = new List<SmartObjectProperty>(); SCConnectionStringBuilder hostServerConnectionString = new SCConnectionStringBuilder(); hostServerConnectionString.Host = "dlx"; hostServerConnectionString.Port = 5555; hostServerConnectionString.IsPrimaryLogin = true; hostServerConnectionString.Integrated = true; SourceCode.SmartObjects.Management.SmartObjectManagementServer smomgt = new SourceCode.SmartObjects.Management.SmartObjectManagementServer(); smomgt.CreateConnection(); try { smomgt.Connection.Open(hostServerConnectionString.ConnectionString.ToString()); foreach (SourceCode.SmartObjects.Management.SmartMethodInfo info in smomgt.GetSmartObjectInfo(smomgt.GetSmartObjectDefinition(SmartObjectGUID).ToString()).Methods) { list.Add(new SmartObjectProperty { Description = info.Metadata.Description.ToString(), Name = info.Name, Type = info.Type.ToString(), Transaction = info.Transaction.ToString(), displayname = info.Metadata.DisplayName }); } } catch (Exception ex) { list.Add(new SmartObjectProperty { Description = ex.Message, Name = ex.Source, displayname = "SmartObject Property Error" }); } finally { smomgt.Connection.Close(); } return list; }
private static string GetServerConnectionSetup() { SCConnectionStringBuilder connectionString = new SCConnectionStringBuilder(); connectionString.Authenticate = true; connectionString.Host = K2ServerName; connectionString.Integrated = true; connectionString.IsPrimaryLogin = true; connectionString.Port = 5555; connectionString.UserID = K2User; connectionString.Password = Password; connectionString.WindowsDomain = K2Domain; connectionString.SecurityLabelName = SecurityLabelName; return(connectionString.ConnectionString); }
public SmartObjectClientServer NewSmartObjectClientServer() { SCConnectionStringBuilder hostServerConnectionString = new SCConnectionStringBuilder(); hostServerConnectionString.Host = this.AppConfig.K2Server; hostServerConnectionString.Port = 5555; hostServerConnectionString.IsPrimaryLogin = true; hostServerConnectionString.Integrated = true; SmartObjectClientServer result = new SmartObjectClientServer(); result.CreateConnection(); //open the connection to the K2 server result.Connection.Open(hostServerConnectionString.ToString()); //return the SOClientServer object return(result); }
public K2ConnectionStringBuilder(string userID) { ConnSetup = new ConnectionSetup(); SCConnectionStringBuilder connectionString = new SCConnectionStringBuilder(); connectionString.Authenticate = true; connectionString.Integrated = false; connectionString.IsPrimaryLogin = true; connectionString.EncryptedPassword = false; connectionString.Host = K2Environments.Host; connectionString.Port = K2Environments.Port; connectionString.SecurityLabelName = K2Environments.SecurityLabelName; connectionString.UserID = userID; connectionString.Password = "******"; ConnSetup.ConnectionString = connectionString.ToString(); }
private static SCConnectionStringBuilder GetSmOConnection() { SCConnectionStringBuilder scbuilder = new SCConnectionStringBuilder(); scbuilder.Authenticate = true; scbuilder.Host = "localhost"; scbuilder.Integrated = true; scbuilder.IsPrimaryLogin = true; scbuilder.Port = 5555; //scbuilder.WindowsDomain = "Denallix"; //scbuilder.UserID = "k2service"; //scbuilder.Password = "******"; //scbuilder.SecurityLabelName = "K2"; return(scbuilder); }
public K2ConnectionStringBuilder(string userID) { ConnSetup = new ConnectionSetup(); SCConnectionStringBuilder connectionString = new SCConnectionStringBuilder(); connectionString.Authenticate = true; connectionString.Integrated = false; connectionString.IsPrimaryLogin = true; connectionString.EncryptedPassword = false; connectionString.Host = K2Environments.Host; connectionString.Port = K2Environments.Port; connectionString.SecurityLabelName = K2Environments.SecurityLabelName; connectionString.UserID = userID; connectionString.Password = "******"; ConnSetup.ConnectionString = connectionString.ToString(); }
/// <summary> /// Aligns your expected user's context to the BaseAPIConnection /// </summary> /// <param name="connection">Your current BaseAPIConnection who's context will be alligned</param> /// <param name="k2Connection">The broker base.</param> internal static void ImpersonateSessionUser(this BaseAPIConnection connection, K2Connection k2Connection) { connection.ThrowIfNull("connection"); k2Connection.ThrowIfNull("k2Connection"); try { // Don't impersonate if the connection does not have a session cookie var sessionCookie = connection.GetPropertyValue("SessionCookie") as string; if (string.IsNullOrEmpty(sessionCookie)) { return; } // Don't impersonate if the session's FQN is the same as the expected user's FQN var activeSession = k2Connection.SessionManager.GetActiveSession(sessionCookie); activeSession.ThrowIfNull("activeSession"); if (string.Equals(k2Connection.UserName, activeSession.Owner.PrimaryCredential.FullyQualifiedName.FQN, StringComparison.OrdinalIgnoreCase)) { return; } // Don't impersonate if not integrated or connection has a password var builder = new SCConnectionStringBuilder(k2Connection.SessionConnectionString); if (!builder.Integrated || !string.IsNullOrEmpty(builder.Password)) { return; } //In A PTA scenario, you would have fallen back to the service account and we would have Authenticated you as the service account. //If we are in a PTA context we should call the ImpersonateSessionUserByName method to align this connetion's user to the expected user K2NEServiceBroker.SecurityManager.ImpersonateSessionUserByName(sessionCookie, k2Connection.UserName, ImpersonationType.PassThrough, true); } catch { if (connection != null) { connection.Dispose(); } throw; } }
public K2NotificationManager() { this.serverName = ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2Server]; var port = ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2Port]; this.connectionString = new SCConnectionStringBuilder { Authenticate = true, Host = ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2Host], Integrated = false, IsPrimaryLogin = true, Port = !string.IsNullOrWhiteSpace(port) ? Convert.ToUInt32(ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2Port]) : 5252, UserID = ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2UserName], //WindowsDomain = this.domain, Password = ConfigurationManager.AppSettings[Constants.ConfigurationConstants.K2Password], //SecurityLabelName = "K2" }; }
/// <summary> /// Connect to and open the SmartObject Client service of the K2 server. /// </summary> /// <returns>The SmartObjectClientServer connection</returns> private SmartObjectClientServer GetSmartObjectConnection() { var client = new SmartObjectClientServer(); client.CreateConnection(); // Connect to the K2 server var scConnectionString = new SCConnectionStringBuilder { Host = _settings.K2Server, Port = _settings.Port, IsPrimaryLogin = true, Integrated = true }; client.Connection.Open(scConnectionString.ConnectionString); return(client); }
public void Remove(SCConnectionStringBuilder hostServerConfig) { hostServerConfig.ThrowIfNull(nameof(hostServerConfig)); string name = hostServerConfig.GetDisplayName(); CreateIsolatedStorage(); using (var userStorage = IsolatedStorageFile.GetUserStoreForAssembly()) { XmlDocument k2ConfDoc = null; using (var userStream = new IsolatedStorageFileStream(_k2ConfigFile, FileMode.Open, userStorage)) using (CryptoStream cryptostreamLoad = new CryptoStream(userStream, Decryptor(), CryptoStreamMode.Read)) { k2ConfDoc = new XmlDocument(); k2ConfDoc.Load(cryptostreamLoad); } var deleteNode = k2ConfDoc.SelectSingleNode(string.Format("//configuration/connectionstrings/connectionstring[@name='{0}']", name)); if (deleteNode != null) { var connectionstringsNode = k2ConfDoc.SelectSingleNode("//configuration/connectionstrings"); connectionstringsNode.RemoveChild(deleteNode); using (var userStream = new IsolatedStorageFileStream(_k2ConfigFile, FileMode.Create, userStorage)) using (var cryptostream = new CryptoStream(userStream, Encryptor(), CryptoStreamMode.Write)) { try { k2ConfDoc.Save(cryptostream); userStream.Flush(); } finally { k2ConfDoc = null; } } } } }
public static DeploymentResults DeployProcess(Process process) { // Create a connection string SCConnectionStringBuilder connBuilder = new SCConnectionStringBuilder(); connBuilder.Host = "localhost"; connBuilder.Port = 5555; connBuilder.IsPrimaryLogin = true; connBuilder.Integrated = true; // Set up the deployment manager DeploymentManager deploymentMng = new DeploymentManager(); // The workflow management connection string points to the workflow server. // The SmartObject connection string points to the SmartObject server and is // required by the deployment because a SmartObject is created from the process. deploymentMng.WorkflowManagementConnectionString = connBuilder.ConnectionString; deploymentMng.SmartObjectConnectionString = connBuilder.ConnectionString; return(deploymentMng.Deploy(process)); }
public K2ConnectionStringBuilder(ServerType type) { switch (type) { case ServerType.UserRoleManager: SCConnectionStringBuilder builder = new SCConnectionStringBuilder() { Host = K2Environments.Host, Port = 5555, Integrated = true, IsPrimaryLogin = true, }; this.ConnectionString = builder.ToString(); break; } }
public static string GetDefaultHostServerConnectionString() { var builder = new SCConnectionStringBuilder(); builder.Host = Environment.MachineName; builder.Port = 5555; builder.IsPrimaryLogin = true; builder.Integrated = true; var connectionString = builder.ConnectionString; try { using (var environmentSettingsManager = new EnvironmentSettingsManager(false)) { environmentSettingsManager.ConnectionString = connectionString; environmentSettingsManager.InitializeSettingsManager(false); if (environmentSettingsManager.EnvironmentTemplates.Count <= 0) { environmentSettingsManager.ConnectToServer(); environmentSettingsManager.InitializeSettingsManager(true); environmentSettingsManager.Disconnect(); } if (environmentSettingsManager.CurrentEnvironment != null) { var smartObjectfield = (SmartObjectField)environmentSettingsManager.CurrentEnvironment.GetDefaultField(typeof(SmartObjectField)); if (smartObjectfield != null) { return(smartObjectfield.ConnectionString); } } } } catch { } return(connectionString); }
public K2ConnectionStringBuilder(ServerType type) { switch (type) { case ServerType.UserRoleManager: SCConnectionStringBuilder builder = new SCConnectionStringBuilder() { Host = K2Environments.Host, Port = 5555, Integrated = true, IsPrimaryLogin = true, }; this.ConnectionString = builder.ToString(); break; } }
private static SmartObjectClientServer GetSOClientConnection() { SmartObjectClientServer soClient = new SmartObjectClientServer(); soClient.Connection = soClient.CreateConnection(); if (!soClient.Connection.IsConnected) { //use connection string builder to create connection string. SCConnectionStringBuilder connectionStr = new SCConnectionStringBuilder(); //set server info connectionStr.Host = _K2ServerName; connectionStr.Integrated = true; connectionStr.IsPrimaryLogin = true; connectionStr.Password = _Password; connectionStr.Port = 5555; connectionStr.UserID = _K2User; connectionStr.WindowsDomain = _K2Domain; connectionStr.SecurityLabelName = _SecurityLabelName; //open connection try { soClient.Connection.Open(connectionStr.ConnectionString); } catch { return(null); } } return(soClient); }
private static SCConnectionStringBuilder GetSmOConnection() { SCConnectionStringBuilder scbuilder = new SCConnectionStringBuilder(); scbuilder.Authenticate = true; scbuilder.Host = "localhost"; scbuilder.Integrated = true; scbuilder.IsPrimaryLogin = true; scbuilder.Port = 5555; //scbuilder.WindowsDomain = "Denallix"; //scbuilder.UserID = "k2service"; //scbuilder.Password = "******"; //scbuilder.SecurityLabelName = "K2"; return scbuilder; }
void IPartImportsSatisfiedNotification.OnImportsSatisfied() { // Called when all [Import]s have been resolved. var builder = new SCConnectionStringBuilder(); builder.Host = Dns.GetHostName(); builder.Integrated = true; builder.IsPrimaryLogin = true; builder.Port = _k2ServerPort; _k2ServerConnectionString = builder.ConnectionString; }
static void Main(string[] args) { SmartObjectClientServer server = new SmartObjectClientServer(); try { SCConnectionStringBuilder cb = new SCConnectionStringBuilder(); cb.Host = "DLX"; cb.Port = 5555; cb.Integrated = true; cb.IsPrimaryLogin = true; //Connect to server server.CreateConnection(); server.Connection.Open(cb.ToString()); //-------------------------- //Get the Employee //Get SmartObject Definition SmartObject employee = server.GetSmartObject("Employee"); //Set properties employee.Properties["ID"].Value = "2"; //Get the record employee.MethodToExecute = "FindEmployee"; server.ExecuteScalar(employee); System.Diagnostics.Trace.WriteLine( employee.Properties["FirstName"].Value); System.Diagnostics.Trace.WriteLine( employee.Properties["LastName"].Value); System.Diagnostics.Trace.WriteLine( employee.Properties["Email"].Value); } catch (Exception ex) { throw new Exception("Error Creating Request >> " + ex.Message); } }
private SourceCode.SmartObjects.Client.SmartObjectClientServer GetSmOServer() { SCConnectionStringBuilder ConnectionString = new SCConnectionStringBuilder(); ConnectionString.Authenticate = true; ConnectionString.IsPrimaryLogin = true; ConnectionString.Integrated = true; ConnectionString.Host = "localhost"; ConnectionString.Port = 5555; SourceCode.SmartObjects.Client.SmartObjectClientServer SmoClient = new SourceCode.SmartObjects.Client.SmartObjectClientServer(); SmoClient.CreateConnection(); SmoClient.Connection.Open(ConnectionString.ConnectionString); return SmoClient; }
private SourceCode.SmartObjects.Management.SmartObjectManagementServer GetSmOMgmServer() { SCConnectionStringBuilder ConnectionString = new SCConnectionStringBuilder(); ConnectionString.Authenticate = true; ConnectionString.IsPrimaryLogin = true; ConnectionString.Integrated = true; ConnectionString.Host = "localhost"; ConnectionString.Port = 5555; SourceCode.SmartObjects.Management.SmartObjectManagementServer SmartObjectManagementSvr = new SourceCode.SmartObjects.Management.SmartObjectManagementServer(); SmartObjectManagementSvr.CreateConnection(); SmartObjectManagementSvr.Connection.Open(ConnectionString.ConnectionString); //ServiceManagementSvr = new ServiceManagementServer(); //ServiceManagementSvr.Connection = SmartObjectManagementSvr.Connection; return SmartObjectManagementSvr; }
private string GetBaseConnection(uint port) { if (this.baseConnection == null) { this.baseConnection = new SCConnectionStringBuilder(); this.baseConnection.Authenticate = true; this.baseConnection.Host = "localhost"; //hardcoded, always connect to yourself. Works better on NLB environments. this.baseConnection.Integrated = true; this.baseConnection.IsPrimaryLogin = true; this.baseConnection.Port = port; } return this.baseConnection.ToString(); }
private void ChangeServerStatus() { var connectionStringBuilder = new SCConnectionStringBuilder(K2Client.Instance.K2Config.HostServerConnectionString); tssServer.Text = connectionStringBuilder.GetDisplayName(); }
static void Main(string[] args) { //Get Form View Relation DataTable dtFormView = new DataTable(); dtFormView.Columns.Add("FormGUID", typeof(Guid)); dtFormView.Columns.Add("ViewGUID", typeof(Guid)); SCConnectionStringBuilder sb = new SCConnectionStringBuilder(); sb.Authenticate = true; sb.IsPrimaryLogin = true; sb.Integrated = true; sb.Host = "localhost"; sb.Port = 5555; SmartObjectClientServer socs = new SmartObjectClientServer(); socs.CreateConnection(); socs.Connection.Open(sb.ToString()); FormsManager fm = new FormsManager(sb.ToString()); FormExplorer fe = fm.GetForms(); foreach (FormInfo fi in fe.Forms) { Guid formGUID = fi.Guid; //Console.WriteLine("Form: " + fi.DisplayName); ViewExplorer ve = fm.GetViewsForForm(fi.Guid); foreach (ViewInfo vi in ve.Views) { DataRow dr = dtFormView.NewRow(); dr["FormGUID"] = formGUID; dr["ViewGUID"] = vi.Guid; dtFormView.Rows.Add(dr); } } //Get Form Process Relation DataTable dtFormProcess = new DataTable(); dtFormProcess.Columns.Add("ProcessName", typeof(string)); dtFormProcess.Columns.Add("FormGUID", typeof(Guid)); fe = fm.GetForms(); foreach (FormInfo fi in fe.Forms) { Guid formGUID = fi.Guid; IEnumerable<string> processes = fm.GetProcessesForForm(fi.Guid); foreach (var process in processes) { DataRow dr = dtFormProcess.NewRow(); dr["FormGUID"] = formGUID; dr["ProcessName"] = process; dtFormProcess.Rows.Add(dr); } } //Get View SMO Relation DataTable dtViewSMO = new DataTable(); dtViewSMO.Columns.Add("ViewGUID", typeof(Guid)); dtViewSMO.Columns.Add("SmartObjectGUID", typeof(Guid)); fe = fm.GetForms(); foreach (FormInfo fi in fe.Forms) { ViewExplorer ve = fm.GetViewsForForm(fi.Guid); foreach (ViewInfo vi in ve.Views) { Guid viewGUID = vi.Guid; foreach (Guid soGuid in fm.GetObjectsForView(vi.Guid)) { DataRow dr = dtViewSMO.NewRow(); dr["ViewGUID"] = viewGUID; dr["SmartObjectGUID"] = soGuid; dtViewSMO.Rows.Add(dr); } } } fm.Connection.Close(); socs.Connection.Close(); //Delete data from table string stmt = "Delete From FormViewDependency"; ExecuteNoneQuery(stmt, CommandType.Text); //Insert Form View Relation to table for(int i = 0; i < dtFormView.Rows.Count; i++) { DataRow dr = dtFormView.Rows[i]; stmt = @"INSERT INTO [dbo].[FormViewDependency] ([FormGUID] ,[ViewGUID]) VALUES ('" + dr["FormGUID"].ToString() + @"' ,'" + dr["ViewGUID"].ToString() + "')"; ExecuteNoneQuery(stmt, CommandType.Text); } //Delete data from table stmt = "Delete From FormProcessDependency"; ExecuteNoneQuery(stmt, CommandType.Text); //Insert Form Process Relation to table for (int i = 0; i < dtFormProcess.Rows.Count; i++) { DataRow dr = dtFormProcess.Rows[i]; stmt = @"INSERT INTO [dbo].[FormProcessDependency] ([FormGUID] ,[ProcessName]) VALUES ('" + dr["FormGUID"].ToString() + @"' ,'" + dr["ProcessName"].ToString() + "')"; ExecuteNoneQuery(stmt, CommandType.Text); } //Delete data from table stmt = "Delete From ViewSMODependency"; ExecuteNoneQuery(stmt, CommandType.Text); //Insert View SMO Relation to table for (int i = 0; i < dtViewSMO.Rows.Count; i++) { DataRow dr = dtViewSMO.Rows[i]; stmt = @"INSERT INTO [dbo].[ViewSMODependency] ([ViewGUID] ,[SmartObjectGUID]) VALUES ('" + dr["ViewGUID"].ToString() + @"' ,'" + dr["SmartObjectGUID"].ToString() + "')"; ExecuteNoneQuery(stmt, CommandType.Text); } //SmartObjectClientServer socs = new SmartObjectClientServer(); //socs.CreateConnection(); //socs.Connection.Open(sb.ToString()); //FormsManager fm = new FormsManager(sb.ToString()); //FormExplorer fe = fm.GetForms(); //foreach (FormInfo fi in fe.Forms) //{ // Console.WriteLine("Form: " + fi.DisplayName); // ViewExplorer ve = fm.GetViewsForForm(fi.Guid); // IEnumerable<string> x = fm.GetProcessesForForm(fi.Guid); // foreach (var y in x) // { // Console.WriteLine("Process: " + y); // } // foreach (ViewInfo vi in ve.Views) // { // Console.WriteLine("View: " + vi.DisplayName); // foreach(Guid soGuid in fm.GetObjectsForView(vi.Guid)) // { // try // { // SmartObject so = socs.GetSmartObject(soGuid); // Console.WriteLine("SmartObject: " + so.Name); // } // catch (Exception ex) // { // Console.WriteLine(ex.Message); // } // } // Console.WriteLine(); // } //} //fm.Connection.Close(); //socs.Connection.Close(); //Console.ReadLine(); }
static void Main(string[] args) { SmartObjectClientServer server = new SmartObjectClientServer(); try { SCConnectionStringBuilder cb = new SCConnectionStringBuilder(); cb.Host = "DLX"; cb.Port = 5555; cb.Integrated = true; cb.IsPrimaryLogin = true; //Connect to server server.CreateConnection(); server.Connection.Open(cb.ToString()); //-------------------------- //Get the Employee //Get SmartObject Definition SmartObject employee = server.GetSmartObject("Employee"); //Set properties employee.Properties["ID"].Value = "2"; //Get the record employee.MethodToExecute = "FindEmployee"; server.ExecuteScalar(employee); System.Diagnostics.Trace.WriteLine( employee.Properties["FirstName"].Value); System.Diagnostics.Trace.WriteLine( employee.Properties["LastName"].Value); System.Diagnostics.Trace.WriteLine( employee.Properties["Email"].Value); } catch (Exception ex) { throw new Exception("Error Creating Request >> " + ex.Message); } }