public ConnectionDialogue LoadConnection(String Company) { try { oldname = Company; txtName.EditValue = Company; Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); BL.Configuration.CompleteDistributionConfig section = config.GetSection("CompleteDistributionConfig") as BL.Configuration.CompleteDistributionConfig; BL.Configuration.RegisteredCompanyCollection companies = section.RegisteredCompanies; string connectionString = null; foreach (BL.Configuration.RegisteredCompany company in companies) { if (company.Name == Company) { connectionString = company.ConnectionString; txtTimeout.EditValue = Convert.ToInt32(company.ConnectionTimeout) / 1000; selectedCompany = company; chkUpdateLocation.Checked = company.UpdateSite.Value; break; } } SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString); ddlServer.EditValue = builder["Data Source"]; ddlDatabase.EditValue = builder["Initial Catalog"]; ddlAuthentication.SelectedIndex = Convert.ToBoolean(builder["Integrated Security"]) ? 0 : 1; if (ddlAuthentication.SelectedIndex != 0) { txtUsername.EditValue = builder["User ID"]; txtPassword.EditValue = builder["Password"]; } if (!String.IsNullOrEmpty(builder["AttachDBFilename"].ToString())) { btnDBFileLocation.Text = builder["AttachDBFilename"].ToString(); } return(this); } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } return(null); } }
public ConnectionTestAlert(string Company) { InitializeComponent(); SetButton(Buttons.Ok); //using (new CDS.Client.Desktop.Essential.UTL.WaitCursor()) { Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); BL.Configuration.CompleteDistributionConfig section = config.GetSection("CompleteDistributionConfig") as BL.Configuration.CompleteDistributionConfig; BL.Configuration.RegisteredCompanyCollection companies = section.RegisteredCompanies; foreach (BL.Configuration.RegisteredCompany company in companies) { if (company.Name == Company) { this.ConnectionString = company.ConnectionString; break; } } } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnRemove_Click(object sender, EventArgs e) { try { if (BaseAlert.ShowAlert("Remove Company Connection", "You are about to permanently remove the selected Company Connection.\nAre you certain you wish to continue?", BaseAlert.Buttons.OkCancel, BaseAlert.Icons.Warning) == System.Windows.Forms.DialogResult.OK) { Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); BL.Configuration.CompleteDistributionConfig section = config.GetSection("CompleteDistributionConfig") as BL.Configuration.CompleteDistributionConfig; section.RegisteredCompanies.RemoveCompany(SelectedCompanyName); config.Save(ConfigurationSaveMode.Modified); // Refresh Connection list Application.Restart(); } } catch (Exception ex) { if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex)) { throw ex; } } }