private void Init() { InitializeComponent(); cbEdition.Items.Add(Properties.Resources.CreateDatabaseWebEdition); cbEdition.Items.Add(Properties.Resources.CreateDatabaseBusinessEdition); cbEdition.SelectedIndex = 0; List <Collation> colList = CollationHelper.GetCollationList(); cbCollations.DataSource = colList; string dbCol = CommonFunc.GetAppSettingsStringValue("DBCollation"); if (dbCol.Length == 0) { return; } int index = 0; foreach (Collation col in colList) { if (dbCol.Equals(col.Name, StringComparison.CurrentCultureIgnoreCase)) { cbCollations.SelectedIndex = index; break; } ++index; } }
private void Init() { List <Collation> colList = CollationHelper.GetCollationList(); cbCollations.DataSource = colList; string dbCol = CommonFunc.GetAppSettingsStringValue("DBCollation"); if (dbCol.Length > 0) { int index = 0; foreach (Collation col in colList) { if (dbCol.Equals(col.Name, StringComparison.CurrentCultureIgnoreCase)) { cbCollations.SelectedIndex = index; break; } ++index; } } if (_TargetServerInfo.ServerType != ServerTypes.AzureSQLDB) { gbDatabaseSize.Enabled = false; return; } gbDatabaseSize.Enabled = true; _major = Convert.ToInt32(_TargetServerInfo.Version.Substring(0, 2)); List <DatabaseEdition> editions = new List <DatabaseEdition>(); // Web = 100 MB, 1 GB, 5 GB // Business = 10, 20, 30, 40, 50, 100, 150 // Basic = 100 MB, 500 MB, 1, 2 // Standard = 100 MB, 500 MB, 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250 // Premium = 100 MB, 500 MB, 1, 2, 5, 10, 20, 30, 40, 50, 100, 150, 200, 250, 300, 400, 500 DatabaseEdition webEdition = new DatabaseEdition(new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseWebEdition, "web")); DatabaseEdition busEdition = new DatabaseEdition(new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseBusinessEdition, "business")); DatabaseEdition basEdition = new DatabaseEdition(new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseBasicEdition, "basic")); DatabaseEdition stdEdition = new DatabaseEdition(new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseStandardEdition, "standard")); DatabaseEdition preEdition = new DatabaseEdition(new KeyValuePair <string, string>(Properties.Resources.CreateDatabasePremiumEdition, "premium")); KeyValuePair <string, string> dbSize100mb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeOneHundredMB, "100 MB"); KeyValuePair <string, string> dbSize500mb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFiveHundredMB, "500 MB"); KeyValuePair <string, string> dbSize1gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeOneGB, "1 GB"); KeyValuePair <string, string> dbSize2gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeTwoGB, "2 GB"); KeyValuePair <string, string> dbSize5gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFiveGB, "5 GB"); KeyValuePair <string, string> dbSize10gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeTenGB, "10 GB"); KeyValuePair <string, string> dbSize20gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeTwentyGB, "20 GB"); KeyValuePair <string, string> dbSize30gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeThirtyGB, "30 GB"); KeyValuePair <string, string> dbSize40gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFourtyGB, "40 GB"); KeyValuePair <string, string> dbSize50gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFiftyGB, "50 GB"); KeyValuePair <string, string> dbSize100gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeOneHundredGB, "100 GB"); KeyValuePair <string, string> dbSize150gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeOneHundredFiftyGB, "150 GB"); KeyValuePair <string, string> dbSize200gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeTwoHundredGB, "200 GB"); KeyValuePair <string, string> dbSize250gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeTwoHundredFiftyGB, "250 GB"); KeyValuePair <string, string> dbSize300gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeThreeHundredGB, "300 GB"); KeyValuePair <string, string> dbSize400gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFourHundredGB, "400 GB"); KeyValuePair <string, string> dbSize500gb = new KeyValuePair <string, string>(Properties.Resources.CreateDatabaseSizeFiveHundredGB, "500 GB"); webEdition.Size.Add(dbSize100mb); webEdition.Size.Add(dbSize1gb); webEdition.Size.Add(dbSize5gb); busEdition.Size.Add(dbSize10gb); busEdition.Size.Add(dbSize20gb); busEdition.Size.Add(dbSize30gb); busEdition.Size.Add(dbSize40gb); busEdition.Size.Add(dbSize50gb); busEdition.Size.Add(dbSize100gb); busEdition.Size.Add(dbSize150gb); basEdition.Size.Add(dbSize100mb); basEdition.Size.Add(dbSize500mb); basEdition.Size.Add(dbSize1gb); basEdition.Size.Add(dbSize2gb); stdEdition.Size.Add(dbSize100mb); stdEdition.Size.Add(dbSize500mb); stdEdition.Size.Add(dbSize1gb); stdEdition.Size.Add(dbSize2gb); stdEdition.Size.Add(dbSize5gb); stdEdition.Size.Add(dbSize10gb); stdEdition.Size.Add(dbSize20gb); stdEdition.Size.Add(dbSize30gb); stdEdition.Size.Add(dbSize40gb); stdEdition.Size.Add(dbSize50gb); stdEdition.Size.Add(dbSize100gb); stdEdition.Size.Add(dbSize150gb); stdEdition.Size.Add(dbSize200gb); stdEdition.Size.Add(dbSize250gb); preEdition.Size.Add(dbSize100mb); preEdition.Size.Add(dbSize500mb); preEdition.Size.Add(dbSize1gb); preEdition.Size.Add(dbSize2gb); preEdition.Size.Add(dbSize5gb); preEdition.Size.Add(dbSize10gb); preEdition.Size.Add(dbSize20gb); preEdition.Size.Add(dbSize30gb); preEdition.Size.Add(dbSize40gb); preEdition.Size.Add(dbSize50gb); preEdition.Size.Add(dbSize100gb); preEdition.Size.Add(dbSize150gb); preEdition.Size.Add(dbSize200gb); preEdition.Size.Add(dbSize250gb); preEdition.Size.Add(dbSize300gb); preEdition.Size.Add(dbSize400gb); preEdition.Size.Add(dbSize500gb); webEdition.PerformanceLevel.Add(new KeyValuePair <string, string>("", "")); busEdition.PerformanceLevel.Add(new KeyValuePair <string, string>("", "")); basEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelBasicFiveDTUs, "")); int eol_Year = Convert.ToInt32(CommonFunc.GetAppSettingsStringValue("EndOfLife_Year")); int eol_Month = Convert.ToInt32(CommonFunc.GetAppSettingsStringValue("EndOfLife_Month")); int eol_Day = Convert.ToInt32(CommonFunc.GetAppSettingsStringValue("EndOfLife_Day")); DateTime eol_dt = new DateTime(eol_Year, eol_Month, eol_Day); bool past_eol = DateTime.Compare(DateTime.Now, eol_dt) < 0 ? false : true; stdEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelStandardS0, "S0")); stdEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelStandardS1, "S1")); stdEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelStandardS2, "S2")); preEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelPremiumP1, "P1")); preEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelPremiump2, "P2")); preEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelPremiumP3, "P3")); if (_major > 11) { stdEdition.PerformanceLevel.Add(new KeyValuePair <string, string>(Properties.Resources.PerformanceLevelStandardS3, "S3")); } else { if (!past_eol) { editions.Add(webEdition); } if (!past_eol) { editions.Add(busEdition); } } editions.Add(basEdition); editions.Add(stdEdition); editions.Add(preEdition); cbEdition.DataSource = editions; cbEdition.DisplayMember = "Display"; cbEdition.SelectedItem = stdEdition; }