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"); } }