public GenerateSourceCodeWindow() { InitializeComponent(); this.SettingGrid.DataContext = AValue.SchemaData; this.OutputDirectoryPathTextBox.DataContext = AValue.ConfigData.GetCurrentRecentSchemaFile(); this.TableListBox.ItemsSource = _Tables; this.StoredProcedureListBox.ItemsSource = _StoredProcedures; this.UserDefinedTableTypeListBox.ItemsSource = _UserDefinedTableTypes; if (AValue.ConfigData.UseTableFeature) { _Tables.AddRange(AValue.SchemaData.Tables.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); } _StoredProcedures.AddRange(AValue.SchemaData.StoredProcedures.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); _UserDefinedTableTypes.AddRange(AValue.SchemaData.UserDefinedTableTypes.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); if (AValue.ConfigData.UseTableFeature) { this.TableSelectAllCheckBox.Visibility = Visibility.Visible; this.TableListBox.Visibility = Visibility.Visible; this.UseTableFeatureUnableText.Visibility = Visibility.Collapsed; } else { this.TableSelectAllCheckBox.Visibility = Visibility.Collapsed; this.TableListBox.Visibility = Visibility.Collapsed; this.UseTableFeatureUnableText.Visibility = Visibility.Visible; } AValue.ConfigData.GenerateSourceCodeWindow.Initialize(this); }
private void ImportTable(String connectionString, Int32 offsetHour) { var l = new List <DatabaseObject>(); DatabaseSchemaReader db = DatabaseSchemaReader.Create(AValue.SchemaData.DatabaseServer, connectionString); foreach (var item in db.GetTables()) { if (this.ImportAllCheckBox.IsChecked == false && item.LastAlteredTime + TimeSpan.FromHours(offsetHour) < AValue.SchemaData.LastExecuteTimeOfImportTable) { continue; } if (AValue.SchemaData.IgnoreObjects.Exists(el => el.Name == item.Name) == true) { continue; } l.Add(item); } _Tables.Clear(); foreach (var item in l.Select(el => CheckedItem.Create(el))) { item.IsChecked = true; _Tables.Add(item); } this.TableSelectAllCheckBox.IsChecked = true; }
private void InitializeIgnoreObjects() { foreach (var item in AValue.SchemaData.IgnoreObjects.Select(el => CheckedItem.Create(el))) { _IgnoreObjects.Add(item); } }
private void ImportUserDefinedTableType(String connectionString, Int32 offsetHour) { var l = new List <DatabaseObject>(); var db = ImportSchemaCommand.CreateDatabaseSchemaReader(AValue.SchemaData.DatabaseServer, connectionString); if (db.SupportUserDefinedTableType == false) { return; } foreach (var item in db.GetUserDefinedTableTypes()) { if (this.ImportAllCheckBox.IsChecked == false && item.LastAlteredTime + TimeSpan.FromHours(offsetHour) < AValue.SchemaData.LastExecuteTimeOfImportUserDefinedTableType) { continue; } if (AValue.SchemaData.IgnoreObjects.Exists(el => el.Name == item.Name) == true) { continue; } l.Add(item); } _UserDefinedTableTypes.Clear(); foreach (var item in l.Select(el => CheckedItem.Create(el))) { item.IsChecked = this.UserDefinedTableTypeSelectAllCheckBox.IsChecked ?? item.IsChecked; _UserDefinedTableTypes.Add(item); } }
public GenerateSourceCodeWindow() { InitializeComponent(); this.SettingGrid.DataContext = AValue.SchemaData; this.OutputDirectoryPathTextBox.DataContext = AValue.ConfigData.GetCurrentRecentSchemaFile(); this.TableListBox.ItemsSource = _Tables; this.StoredProcedureListBox.ItemsSource = _StoredProcedures; this.UserDefinedTableTypeListBox.ItemsSource = _UserDefinedTableTypes; _Tables.AddRange(AValue.SchemaData.Tables.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); _StoredProcedures.AddRange(AValue.SchemaData.StoredProcedures.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); _UserDefinedTableTypes.AddRange(AValue.SchemaData.UserDefinedTableTypes.Select(el => CheckedItem.Create(el, true)).OrderBy(el => el.Item.Name)); AValue.ConfigData.GenerateSourceCodeWindow.Initialize(this); }
private void ImportStoredProcedure() { DatabaseSchemaReader db = DatabaseSchemaReader.Create(AValue.SchemaData.DatabaseServer, this.GetSelectedConnectionString()); var l = db.GetStoredProcedures().ToList(); _StoredProcedures.Clear(); foreach (var item in AValue.SchemaData.StoredProcedures.Where(el => l.Exists(sp => sp.Name == el.Name) == false).Select(el => CheckedItem.Create(el))) { _StoredProcedures.Add(item); } this.StoredProcedureSelectAllCheckBox.IsChecked = true; }
private void ImportTable() { DatabaseSchemaReader db = ImportSchemaCommand.CreateDatabaseSchemaReader(AValue.SchemaData.DatabaseServer, this.GetSelectedConnectionString()); var l = db.GetTables().ToList(); _Tables.Clear(); foreach (var item in AValue.SchemaData.Tables.Where(el => l.Exists(t => t.Name == el.Name) == false).Select(el => CheckedItem.Create(el))) { _Tables.Add(item); } this.TableSelectAllCheckBox.IsChecked = true; }