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