private void SetDefaultServerSettings()
{
try
{
PopulateServers();
ServerSetting oServerSetting = settingBL.GetServerSetting();
if (oServerSetting != null)
{
lkeServer.EditValue = oServerSetting.Name;
if (lkeServer.EditValue != null)
{
PopulateDatabases(lkeServer.EditValue.ToString());
lkeDatabases.EditValue = oServerSetting.Database;
}
txtUserName.Text = oServerSetting.UserName;
txtPassword.Text = oServerSetting.Password;
}
else
{
DbUtilityHelper.DisplayMessageBox("Default server setting could not be loaded. Try again.", "warning");
}
}
catch (Exception ex)
{
DbUtilityHelper.DisplayMessageBox("Default server setting could not be loaded. Try again.\n" + ex.Message, "error");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (lkeServer.EditValue != null && lkeDatabase.EditValue != null && !String.IsNullOrEmpty(txtUserName.Text) && !String.IsNullOrEmpty(txtPassword.Text))
{
oServerSettingBL = new ServerSetting()
{
Name = lkeServer.EditValue.ToString(),
UserName = txtUserName.Text.Trim(),
Password = EncryptDecrypt.Encrypt(txtPassword.Text.Trim(), "123"),
Database = lkeDatabase.EditValue.ToString()
};
if (oSettingBL.Add(oServerSettingBL))
{
DbUtilityHelper.DisplayMessageBox("Server setting successfully saved", "information");
}
else
{
DbUtilityHelper.DisplayMessageBox("Server setting could not be saved. Please try agin!", "error");
}
}
else
{
DbUtilityHelper.DisplayMessageBox("Required fields can not be blank.", "warning");
}
}
catch (Exception ex)
{
DbUtilityHelper.DisplayMessageBox(ex.Message, "error");
}
}
public ServerSetting GetServerSetting()
{
try
{
if (System.IO.File.Exists(SERVER_SETTING_PATH))
{
XmlDocument _doc = new XmlDocument();
_doc.Load(SERVER_SETTING_PATH);
//Get root element
XmlElement _root = _doc.DocumentElement;
//Get the record at the current index
XmlElement _currentServer = (XmlElement)_root.ChildNodes[0];
if (_currentServer.ChildNodes.Count > 0)
{
//Show the record information
ServerSetting _setting = new ServerSetting();
_setting.Name = _currentServer.Attributes["Name"].Value;
_setting.UserName = _currentServer.GetElementsByTagName("UserName")[0].InnerText;
_setting.Password = EncryptDecrypt.Decrypt(_currentServer.GetElementsByTagName("Password")[0].InnerText, "123");
_setting.Database = _currentServer.GetElementsByTagName("DefaultDatabase")[0].InnerText;
return(_setting);
}
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
public frmServerSetting()
{
InitializeComponent();
oDbUtilityBL = new DbUtilityBL();
oSettingBL = new SettingBL();
oServerSettingBL = new ServerSetting();
PopulateServers();
PopulateData();
}
public bool Add(ServerSetting setting)
{
try
{
XmlDocument _doc = new XmlDocument();
//Create neccessary nodes
XmlDeclaration _declaration = _doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");
XmlElement _root = _doc.CreateElement("Settings");
XmlElement _server = _doc.CreateElement("Server");
XmlAttribute _name = _doc.CreateAttribute("Name");
XmlElement _userName = _doc.CreateElement("UserName");
XmlElement _password = _doc.CreateElement("Password");
XmlElement _database = _doc.CreateElement("DefaultDatabase");
//Add the values for each nodes
_name.Value = setting.Name;
_userName.InnerText = setting.UserName;
_password.InnerText = setting.Password;
_database.InnerText = setting.Database;
//Construct the document
_doc.AppendChild(_declaration);
//doc.AppendChild(comment);
_doc.AppendChild(_root);
_root.AppendChild(_server);
_server.Attributes.Append(_name);
_server.AppendChild(_userName);
_server.AppendChild(_password);
_server.AppendChild(_database);
if (!Directory.Exists(LOCAL_APP_DATA))
{
Directory.CreateDirectory(LOCAL_APP_DATA);
}
_doc.Save(SERVER_SETTING_PATH);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void PopulateData()
{
try
{
oServerSettingBL = oSettingBL.GetServerSetting();
if (oServerSettingBL != null)
{
lkeServer.EditValue = oServerSettingBL.Name;
txtUserName.Text = oServerSettingBL.UserName;
txtPassword.Text = oServerSettingBL.Password;
lkeDatabase.EditValue = oServerSettingBL.Database;
}
}
catch (Exception ex)
{
DbUtilityHelper.DisplayMessageBox(ex.Message, "error");
}
}
