private void RefreshProviderOption(DatabasePlatform dbPlat, RadioButton opt)
        {
            PFConnectionManager connMgr = new PFConnectionManager();

            //test
            //if (this.chkShowInstalledProvidersOnly.Checked)
            //{
            //    if (dbPlat == DatabasePlatform.Informix
            //        || dbPlat == DatabasePlatform.SQLAnywhereUltraLite
            //        || dbPlat == DatabasePlatform.SQLServerCE40)
            //    {
            //        opt.Visible = false;
            //        return;
            //    }
            //}
            //end test

            if (connMgr.ProviderDefinitions.Count == 0)
            {
                connMgr.CreateProviderDefinitions();
            }
            else
            {
                connMgr.UpdateAllProvidersInstallationStatus();
            }

            if (this.chkShowInstalledProvidersOnly.Checked)
            {
                for (int i = 0; i < connMgr.ProviderDefinitions.Count; i++)
                {
                    PFProviderDefinition provDef = connMgr.ProviderDefinitions[i].Value;
                    if (provDef.DbPlatform == dbPlat)
                    {
                        if (provDef.InstallationStatus == enProviderInstallationStatus.IsInstalled)
                        {
                            opt.Visible = true;
                        }
                        else
                        {
                            opt.Visible = false;
                        }
                        break;
                    }
                }//end for loop
            }
            else
            {
                opt.Visible = true;
            }
        }
 private void RefreshListBoxes()
 {
     this.lstSelectedProviders.Items.Clear();
     this.lstSupportedProviders.Items.Clear();
     for (int i = 0; i < _connMgr.ProviderDefinitions.Count; i++)
     {
         PFProviderDefinition provDef = _connMgr.ProviderDefinitions[i].Value;
         if (this.chkShowInstalledProvidersOnly.Checked)
         {
             if (provDef.InstallationStatus == enProviderInstallationStatus.IsInstalled)
             {
                 if (provDef.AvailableForSelection)
                 {
                     this.lstSelectedProviders.Items.Add(_connMgr.ProviderDefinitions[i].Key);
                 }
                 else
                 {
                     this.lstSupportedProviders.Items.Add(_connMgr.ProviderDefinitions[i].Key);
                 }
             }
             else
             {
                 //update provdef to make it not selected
                 RefreshProviderDefinition(provDef, false);
             }
         }
         else
         {
             if (provDef.AvailableForSelection)
             {
                 this.lstSelectedProviders.Items.Add(_connMgr.ProviderDefinitions[i].Key);
             }
             else
             {
                 this.lstSupportedProviders.Items.Add(_connMgr.ProviderDefinitions[i].Key);
             }
         }
     }
     ResetSelectorControls();
 }
 private void RefreshProviderDefinition(PFProviderDefinition provDef, bool availableForSelection)
 {
     _connMgr.UpdateProviderAvailableForSelectionStatus(provDef.ProviderName, availableForSelection);
 }