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