private static void InitializeServerVariables(out SAPbobsCOM.BoDataServerTypes dbType, out String DatabaseName, out String Server, out String LicenseServer, out String User, out String Password
, out String sUseTrusted, out String dbUserName, out String dbPassword)
{
TWM_Licence.TWM_SAP oEncrypter = new TWM_Licence.TWM_SAP(new Byte[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 10, 73, 1, 5, 75, 1, 8 });
//Initialize all the environment variable for config file.
//If nonspecified strings, write the default to config file.
//Get the dbServerType
if (frmSetting.GetConfigLine(sConfig_File, "dbServerType") != null)
{
dbType = (SAPbobsCOM.BoDataServerTypes) int.Parse(frmSetting.GetConfigLine(sConfig_File, "dbServerType"));
}
else
{
dbType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2008;
frmSetting.WriteConfigFile(sConfig_File, "dbServerType", ((int)dbType).ToString(), frmSetting.WriteType.Append);
}
//Get the DatabaseName
if (frmSetting.GetConfigLine(sConfig_File, "DatabaseName") != null)
{
DatabaseName = frmSetting.GetConfigLine(sConfig_File, "DatabaseName");
}
else
{
DatabaseName = "UNZA";
frmSetting.WriteConfigFile(sConfig_File, "DatabaseName", DatabaseName, frmSetting.WriteType.Append);
}
//Get the Server
if (frmSetting.GetConfigLine(sConfig_File, "ServerName") != null)
{
Server = frmSetting.GetConfigLine(sConfig_File, "ServerName");
}
else
{
Server = "sapserver";
frmSetting.WriteConfigFile(sConfig_File, "ServerName", Server, frmSetting.WriteType.Append);
}
//Get the License Server
if (frmSetting.GetConfigLine(sConfig_File, "LicenseServer") != null)
{
LicenseServer = frmSetting.GetConfigLine(sConfig_File, "LicenseServer");
}
else
{
LicenseServer = "sapserver:30000";
frmSetting.WriteConfigFile(sConfig_File, "LicenseServer", LicenseServer, frmSetting.WriteType.Append);
}
//Get the User
if (frmSetting.GetConfigLine(sConfig_File, "User") != null)
{
User = frmSetting.GetConfigLine(sConfig_File, "User");
}
else
{
User = "******";
frmSetting.WriteConfigFile(sConfig_File, "User", User, frmSetting.WriteType.Append);
}
//Get the Password
if (frmSetting.GetConfigLine(sConfig_File, "Password") != null)
{
Password = frmSetting.GetConfigLine(sConfig_File, "Password");
Password = oEncrypter.Decrypt(Password);
}
else
{
Password = "******";
String EncryptedPass = oEncrypter.Encrypt(Password);
frmSetting.WriteConfigFile(sConfig_File, "Password", EncryptedPass, frmSetting.WriteType.Append);
}
//Get the UseTrusted
if (frmSetting.GetConfigLine(sConfig_File, "UseTrusted") != null)
{
sUseTrusted = frmSetting.GetConfigLine(sConfig_File, "UseTrusted");
}
else
{
sUseTrusted = "0";
frmSetting.WriteConfigFile(sConfig_File, "UseTrusted", sUseTrusted, frmSetting.WriteType.Append);
}
//if Not UseTrusted, Get The DBUserName And DBPassword
if (sUseTrusted != "1")
{
//Get the User
if (frmSetting.GetConfigLine(sConfig_File, "DBUserName") != null)
{
dbUserName = frmSetting.GetConfigLine(sConfig_File, "DBUserName");
}
else
{
dbUserName = "******";
frmSetting.WriteConfigFile(sConfig_File, "DBUserName", dbUserName, frmSetting.WriteType.Append);
}
//Get the Password
if (frmSetting.GetConfigLine(sConfig_File, "DBPassword") != null)
{
dbPassword = frmSetting.GetConfigLine(sConfig_File, "DBPassword");
dbPassword = oEncrypter.Decrypt(dbPassword);
}
else
{
dbPassword = "******";
String EncryptedPass = oEncrypter.Encrypt(dbPassword);
frmSetting.WriteConfigFile(sConfig_File, "DBPassword", EncryptedPass, frmSetting.WriteType.Append);
}
}
else
{
dbUserName = "";
dbPassword = "";
}
}
private void FillConfigLineToScreen()
{
String sValue = "";
ConfigLine ConfigItem = new ConfigLine();
for (int i = 0; i < ConfigLines.Count; i++)
{
sValue = "";
sValue = GetConfigLine(SBOAddon.sConfig_File, ConfigLines[i].Key);
ConfigItem.Group = ConfigLines[i].Group;
ConfigItem.Key = ConfigLines[i].Key;
if (sValue != null)
{
ConfigItem.Value = sValue;
}
else
{
ConfigItem.Value = "";
}
ConfigLines[i] = ConfigItem;
switch (ConfigItem.Key.ToUpper())
{
case "DBSERVERTYPE":
if (ConfigItem.Value == "")
{
ConfigItem.Value = "0";
}
cboDbType.SelectedIndex = int.Parse(ConfigItem.Value) - 1;
break;
case "DATABASENAME":
if (sValue == null)
{
txtDBName.Text = "Default : " + DatabaseName;
}
else
{
txtDBName.Text = ConfigItem.Value;
}
break;
case "SERVERNAME":
if (sValue == null)
{
txtSrvrName.Text = "Default : " + ServerName;
}
else
{
txtSrvrName.Text = ConfigItem.Value;
}
break;
case "LICENSESERVER":
String[] License = ConfigItem.Value.Split(':');
if (sValue == null)
{
txtLcnsSrvr.Text = "Default : " + LicenseServer;
txtLcnsPort.Text = LicensePort;
}
else
{
if (License.Length > 1)
{
txtLcnsSrvr.Text = License[0];
txtLcnsPort.Text = License[1];
}
else if (License.Length == 1)
{
txtLcnsSrvr.Text = License[0];
}
}
break;
case "USER":
if (sValue == null)
{
txtUserName.Text = "Default : " + User;
}
else
{
txtUserName.Text = ConfigItem.Value;
}
break;
case "PASSWORD":
if (sValue == null)
{
txtPassword.Text = "Default : " + Password;
}
else
{
String DecryptedString = "";
try
{
DecryptedString = encrypter.Decrypt(sValue);
txtPassword.Text = DecryptedString;
}
catch
{
MessageBox.Show("Password is not in expected format \n\r Please fill in correct password in 'Company tab'", "Password error", MessageBoxButtons.OK);
txtPassword.Text = "";
}
}
break;
case "USETRUSTED":
if (sValue == null)
{
if (ConfigItem.Value == "1")
{
chbTrusted.Checked = true;
}
else
{
chbTrusted.Checked = false;
}
}
else
{
if (sValue.ToUpper() == "Y" || sValue == "1")
{
chbTrusted.Checked = true;
}
else
{
chbTrusted.Checked = false;
}
}
if (chbTrusted.Checked)
{
grpTrusted.Enabled = false;
}
else
{
grpTrusted.Enabled = true;
}
break;
case "DBUSER":
if (sValue == null)
{
txtDBUser.Text = "Default : " + DBUser;
}
else
{
txtDBUser.Text = sValue;
}
break;
case "DBPASSWORD":
if (sValue == null)
{
txtDBPassword.Text = "Default : " + DBPassword;
}
else
{
String DecryptedString = "";
try
{
DecryptedString = encrypter.Decrypt(sValue);
txtDBPassword.Text = DecryptedString;
}
catch
{
MessageBox.Show("Password is not in expected format \r\nPlease fill in correct password.", "Password error", MessageBoxButtons.OK);
txtPassword.Text = "";
}
}
break;
}
}
}
