/// <summary> /// Creates the standard settings. /// </summary> /// <param name="server">The server.</param> /// <param name="dbUserName">Name of the database user.</param> /// <param name="dbPassword">The database password.</param> /// <param name="userName">Company username.</param> /// <param name="password">Company password.</param> /// <param name="language">The language.</param> /// <param name="licenseServer">The license server in <ServerName:Port> format.</param> /// <param name="dbServerType">Type of the database server.</param> /// <param name="companyDb">The company database.</param> /// <returns></returns> public static DiApiConnectionSettings CreateStandardSettings( string server, string dbUserName, string dbPassword, string userName, string password, BoSuppLangs language, string licenseServer, BoDataServerTypes dbServerType, string companyDb) { return(new DiApiConnectionSettings { Server = server, UseTrusted = false, DbUserName = dbUserName, DbPassword = dbPassword, UserName = userName, Password = password, Language = language, LicenseServer = licenseServer, DbServerType = dbServerType, CompanyDb = companyDb }); }
private void metroButtonConnect_Click(object sender, EventArgs e) { try { metroLinkWaiting.Visible = true; metroLinkWaiting.Refresh(); ValidFields(); _selectedServerType = (BoDataServerTypes)metroComboBoxServerType.SelectedItem; //Thread thread = new Thread(ConnectOnSAP); //thread.Start(); ConnectOnSAP(); SaveConnectionParam(); EnableSelecionTables(); FillSAPTables(); this.ShowSucess("Conexão realizada com sucesso!"); metroTabControl1.SelectedIndex = 1; metroTabControlFields.SelectedIndex = 0; } catch (Exception ex) { this.ShowError(ex.Message); } finally { metroLinkWaiting.Visible = false; this.Select(); } }
public DIApiConnector() { String baseDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location.ToString()); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(baseDir + @"\Xml\DataAccess.xml"); XmlNodeList nodeList = xmlDoc.ChildNodes[1].ChildNodes; XmlNode sqlServerNode = null; XmlNode sapB1Node = null; BoDataServerTypes sqlServerType = BoDataServerTypes.dst_MSSQL; foreach (XmlNode node in nodeList) { if (node.Attributes["name"].Value == "SQL Server 2005") { sqlServerNode = node; sqlServerType = BoDataServerTypes.dst_MSSQL2005; } if (node.Attributes["name"].Value == "SQL Server 2008") { sqlServerNode = node; sqlServerType = BoDataServerTypes.dst_MSSQL2008; } if (node.Attributes["name"].Value == "SAP B1") { sapB1Node = node; } } if (sqlServerNode == null) { return; } if (sapB1Node == null) { return; } String dbServer = sqlServerNode.SelectSingleNode("server").InnerText; String dbUsername = sqlServerNode.SelectSingleNode("username").InnerText; String dbPassword = sqlServerNode.SelectSingleNode("password").InnerText; String database = sapB1Node.SelectSingleNode("database").InnerText; String sapUsername = sapB1Node.SelectSingleNode("username").InnerText; String sapPassword = sapB1Node.SelectSingleNode("password").InnerText; sboCompany = new SAPbobsCOM.Company(); sboCompany.DbServerType = sqlServerType; sboCompany.Server = dbServer; sboCompany.DbUserName = dbUsername; sboCompany.DbPassword = dbPassword; sboCompany.CompanyDB = database; sboCompany.UserName = sapUsername; sboCompany.Password = sapPassword; sboCompany.UseTrusted = false; sboCompany.language = BoSuppLangs.ln_Portuguese_Br; }
public static void ConnectViaDI(String dbServer, BoDataServerTypes dbServerType, String companyDb, String user, String password, String licenseServer, BoSuppLangs language = BoSuppLangs.ln_English) { try { // 1. Initiate the company instance for the first time if (oCompany == null) { oCompany = new SAPbobsCOM.Company(); } // 2. Set Company Property for login oCompany.Server = dbServer; oCompany.DbServerType = dbServerType; oCompany.CompanyDB = companyDb; oCompany.UserName = user; oCompany.Password = password; oCompany.LicenseServer = licenseServer; oCompany.language = language; oCompany.UseTrusted = false; IRetCode = oCompany.Connect(); // 4. Error Handling if (IRetCode != 0) { MsgBoxWrapper(oCompany.GetLastErrorDescription()); } // 5. (Optional) XML Export Configuration oCompany.XmlExportType = BoXmlExportTypes.xet_ExportImportMode; } catch (Exception ex) { MsgBoxWrapper(ex.Message + " " + ex.StackTrace); } }
public static void ConnectViaDI() { String serverName, databaseName, sapUserName, sapPassword, licenseServer; //if (Resources.AppStage.ToString().ToLower() == "deployment") //{ // // lcm assignment - Parameters | lcm_deployment - shared parameters // serverName = oApplication.Company.GetExtensionProperty(connectionString, SAPbouiCOM.BoExtensionLCMStageType.lcm_assignment, "servername"); // databaseName = oApplication.Company.GetExtensionProperty(connectionString, SAPbouiCOM.BoExtensionLCMStageType.lcm_assignment, "databasename"); // sapUserName = oApplication.Company.GetExtensionProperty(connectionString, SAPbouiCOM.BoExtensionLCMStageType.lcm_assignment, "username"); // sapPassword = oApplication.Company.GetExtensionProperty(connectionString, SAPbouiCOM.BoExtensionLCMStageType.lcm_assignment, "password"); // licenseServer = oApplication.Company.GetExtensionProperty(connectionString, SAPbouiCOM.BoExtensionLCMStageType.lcm_assignment, "licenseserver"); //} //else //{ // serverName = AccessMatrix.Properties.Settings.Default.ServerName.ToString(); // databaseName = AccessMatrix.Properties.Settings.Default.DatabaseName.ToString(); // sapUserName = AccessMatrix.Properties.Settings.Default.SAPUserName.ToString(); // sapPassword = AccessMatrix.Properties.Settings.Default.SAPPassword.ToString(); // licenseServer = AccessMatrix.Properties.Settings.Default.LicenseServer.ToString(); //} serverName = ConfigurationManager.AppSettings["ServerName"]; databaseName = ConfigurationManager.AppSettings["DatabaseName"]; sapUserName = ConfigurationManager.AppSettings["SAPUserName"]; sapPassword = ConfigurationManager.AppSettings["SAPPassword"]; licenseServer = ConfigurationManager.AppSettings["LicenseServer"]; BoDataServerTypes dbType = BoDataServerTypes.dst_HANADB; if (ConfigurationManager.AppSettings["DbType"] == "SQL") { dbType = ConfigurationManager.AppSettings["DbType"] == "2012" ? BoDataServerTypes.dst_MSSQL2012 : BoDataServerTypes.dst_MSSQL2014; } else { dbType = BoDataServerTypes.dst_HANADB; } ConnectViaDI(serverName, dbType, databaseName, sapUserName, sapPassword, licenseServer, BoSuppLangs.ln_English); }