private void btnSave_Click(object sender, EventArgs e)
{
SimpleConnStr bassConnStr = new SimpleConnStr();
bassConnStr.UserID = txtUser.Text;
bassConnStr.DataSource = txtTNSName.Text;
bassConnStr.Password = txtPassword.Text;
bassConnStr.encode();
XmlDocument mXml = new XmlDocument();
mXml.Load(mFileLoc);
XmlNode node = null;
node = mXml.SelectSingleNode(string.Format(XPATH_FMT, KEY_DBCONN));
node.Attributes[TAG_VALUE].Value = EncryptionUtil.Encryption.Encrypt(bassConnStr.ConnStr);
mXml.Save(mFileLoc);
// Reads UTF8 file
StreamReader fileStream = new StreamReader(mFileLoc);
string fileContent = fileStream.ReadToEnd();
fileStream.Close();
// Now writes the content in ANSI
StreamWriter ansiWriter = new StreamWriter(mFileLoc, false, Encoding.GetEncoding(1250));
ansiWriter.Write(fileContent);
ansiWriter.Close();
MessageBox.Show("Successfully Save.", "DBConnection Setting", MessageBoxButtons.OK);
}
private void tsbtnConnect_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
bool bassConnect = false;
try
{
SimpleConnStr bassConnStr = new SimpleConnStr();
bassConnStr.UserID = txtUser.Text;
bassConnStr.DataSource = txtTNSName.Text;
bassConnStr.Password = txtPassword.Text;
bassConnStr.encode();
bassConnStr.test();
bassConnect = true;
MessageBox.Show(string.Format("Successful connect [{0}] to database.", bassConnStr.UserID), "DBConnection Setting", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
bassConnect = false;
MessageBox.Show(ex.Message, "DBConnection Setting", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
private void loadXmlFile()
{
try
{
XmlDocument mXml = new XmlDocument();
mXml.Load(mFileLoc);
SimpleConnStr connStr = null;
string mEncryptConn = string.Empty;
//if (mFileLocBASSnet.Length <= 0)
// return;
XmlNode node = null;
node = mXml.SelectSingleNode(string.Format(XPATH_FMT, "DBConn"));
if (node != null)
{
mEncryptConn = node.Attributes[TAG_VALUE].Value;
}
connStr = new SimpleConnStr();
connStr.ConnStr = EncryptionUtil.Encryption.Decrypt(mEncryptConn);
if (string.IsNullOrEmpty(connStr.ConnStr))
{
txtTNSName.Text = string.Empty;
txtUser.Text = string.Empty;
txtPassword.Text = string.Empty;
}
else
{
txtTNSName.Text = connStr.DataSource;
txtUser.Text = connStr.UserID;
txtPassword.Text = connStr.Password;
}
}
catch (Exception ex)
{
//lblStatusBASSnet.Text = DateTime.Now.ToString() + "\r\n" + ex.ToString();
}
}