private void cmbEdition_SelectedIndexChanged(object sender, EventArgs e)
{
cmbBranch.Enabled = true;
if (select == 1)
{
Edition = "ePlus Professional Edition";
//select = 0;
cmbEdition.Enabled = false;
}
else
{
Edition = cmbEdition.SelectedItem.ToString();
}
settings1.getconnectionstring(Edition);
settings = settings1.ReadSettings();
dbinfo1.ServerName = settings.serverName;
dbinfo1.DBName = settings.dbName;
dbinfo1.DBPort = settings.dbPort;
dbinfo1.DBUser = settings.userName;
dbinfo1.DBPWD = settings.password;
connectionString = dbinfo.getConnectionString(dbinfo1);
//Dgv.DataSource = null;
// Dgv.Rows.Clear();
cnn = new MySqlConnection(connectionString);
openconnection(cnn);
}
public xmlSettings ReadSettings()
{
xmlSettings settings = new xmlSettings();
//MessageBox.Show(xmlSettingsFile);
if (!File.Exists(xmlSettingsFile))
{
settings.success = false;
settings.errorMessage = "File not found (" + xmlSettingsFile + ")";
return(settings);
}
string xmlElement = "";
XmlTextReader reader = new XmlTextReader(xmlSettingsFile);
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element:
xmlElement = reader.Name;
//MessageBox.Show(objXmlTextReader.Name);
break;
case XmlNodeType.Text:
switch (xmlElement)
{
case "SERVER":
settings.serverName = reader.Value;
break;
case "DATABASE":
settings.dbName = reader.Value;
break;
case "PORT":
settings.dbPort = reader.Value;
break;
case "USER":
settings.userName = reader.Value;
break;
case "PWD":
settings.password = reader.Value;
break;
case "TIMER":
settings.timer = reader.Value;
break;
}
break;
}
}
reader.Close();
settings.success = true;
settings.errorMessage = "";
return(settings);
}
private void cmbEdition_SelectedIndexChanged(object sender, EventArgs e)
{
cmbBranch.Enabled = true;
Edition = cmbEdition.SelectedItem.ToString();
//MessageBox.Show(Edition);
settings1.getconnectionstring(Edition);
settings = settings1.ReadSettings();
dbinfo1.ServerName = settings.serverName;
dbinfo1.DBName = settings.dbName;
dbinfo1.DBPort = settings.dbPort;
dbinfo1.DBUser = settings.userName;
dbinfo1.DBPWD = settings.password;
connectionString = dbinfo.getConnectionString(dbinfo1);
//Dgv.DataSource = null;
// Dgv.Rows.Clear();
cnn = new MySqlConnection(connectionString);
openconnection(cnn);
}