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);
}
}
private void ImportStoredProcedure()
{
DatabaseSchemaReader db = ImportSchemaCommand.CreateDatabaseSchemaReader(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 ExecuteButton_Click(object sender, RoutedEventArgs e)
{
Analytics.TrackEvent("GenerateSqlScript Execute");
AValue.ConfigData.SetSqlScriptOutputDirectoryPath(this.OutputDirectoryPathTextBox.Text);
String path = this.OutputDirectoryPathTextBox.Text;
var gen = new SqlScriptFileGenerator(ImportSchemaCommand.CreateTableStoredProcedureFactory(AValue.SchemaData.DatabaseServer, ""));
gen.Tables.AddRange(AValue.SchemaData.Tables);
gen.FolderPath = path;
gen.FileGenerated += this.Dispatcher.CreateEventHander <SqlScriptFileGeneratedEventArgs>(SqlScriptFile_FileGenerated);
gen.Completed += this.Dispatcher.CreateEventHander(SqlScriptFile_Completed);
this.ResultLabel.Text = "";
gen.Start();
}
