private void LoadConfigExecute(object sender)
{
var fileDialog = new OpenFileDialog();
fileDialog.Multiselect = false;
fileDialog.CheckFileExists = true;
fileDialog.DefaultExt = "*.msConfigStore";
fileDialog.Filter = "ConfigFile (*.msConfigStore)|*.msConfigStore";
var result = fileDialog.ShowDialog();
if (result.HasValue && result.Value && File.Exists(fileDialog.FileName))
{
Tables.Clear();
Views.Clear();
StoredProcs.Clear();
SelectedTable = null;
var binFormatter = new BinaryFormatter();
ConfigStore options;
try
{
using (var fs = fileDialog.OpenFile())
{
options = (ConfigStore)binFormatter.Deserialize(fs);
}
}
catch (Exception)
{
Status = "File is an in invalid format";
return;
}
var version = typeof(SharedMethods).Assembly.GetName().Version;
if (new Version(options.Version) != version)
{
var messageBoxResult = MessageBox.Show(Application.Current.MainWindow,
"Warning Version missmatch",
string.Format("The current Entity Creator version ({0}) is not equals the version ({1}) you have provided.",
version, options.Version),
MessageBoxButton.OKCancel);
if (messageBoxResult == MessageBoxResult.Cancel)
{
return;
}
}
if (options.SourceConnectionString != null)
{
ConnectionString = options.SourceConnectionString;
CreateEntrysAsync(ConnectionString, "", string.Empty).ContinueWith(task =>
{
foreach (var optionsAction in options.Actions)
{
optionsAction.Replay(this);
}
});
}
}
}
async Task IDeactivate.Deactivate(bool close, CancellationToken cancellationToken)
{
if (IsActive || (IsInitialized && close))
{
var attemptingDeactivationHandler = AttemptingDeactivation;
if (attemptingDeactivationHandler != null)
{
attemptingDeactivationHandler(this, new DeactivationEventArgs
{
WasClosed = close
});
}
IsActive = false;
Log.Info("Deactivating {0}.", this);
await OnDeactivate(close, cancellationToken);
var deactivatedHandler = Deactivated;
if (deactivatedHandler != null)
{
deactivatedHandler(this, new DeactivationEventArgs
{
WasClosed = close
});
}
if (close)
{
Views.Clear();
Log.Info("Closed {0}.", this);
}
}
}
/// <summary>
/// Limpia los esquemas
/// </summary>
public void Clear()
{
Tables.Clear();
Triggers.Clear();
Views.Clear();
Routines.Clear();
}
void IDeactivate.Deactivate(bool close)
{
if (!IsActive && !IsInitialized)
{
return;
}
AttemptingDeactivation(this, new DeactivationEventArgs
{
WasClosed = close
});
IsActive = false;
Tracing.Tracer.LogVerboseText("Deactivating {0}.", this);
OnDeactivate(close);
Deactivated(this, new DeactivationEventArgs
{
WasClosed = close
});
if (close)
{
Views.Clear();
Tracing.Tracer.LogVerboseText("Closed {0}.", this);
}
}
void IDeactivate.Deactivate(bool close)
{
if (IsActive || (IsInitialized && close))
{
AttemptingDeactivation(this, new DeactivationEventArgs
{
WasClosed = close
});
IsActive = false;
Log.Info("Deactivating {0}.", this);
OnDeactivate(close);
Deactivated(this, new DeactivationEventArgs
{
WasClosed = close
});
if (close)
{
// needed because the DependencyObject implementation uses objects and should use WeakReference.
foreach (var view in Views)
{
var control = view.Value as Control;
if (control != null)
{
control?.Dispose();
}
}
Views.Clear();
Log.Info("Closed {0}.", this);
}
}
}
void IDeactivate.Deactivate(bool close)
{
if (IsActive || IsInitialized && close)
{
var attemptingDeactivationHandler = AttemptingDeactivation;
attemptingDeactivationHandler?.Invoke(this, new DeactivationEventArgs
{
WasClosed = close
});
IsActive = false;
Log.Info("Deactivating {0}.", this);
OnDeactivate(close);
var deactivatedHandler = Deactivated;
deactivatedHandler?.Invoke(this, new DeactivationEventArgs
{
WasClosed = close
});
if (close)
{
Views.Clear();
Log.Info("Closed {0}.", this);
}
}
}
/// <summary> Clear all the pre-existing views from this item </summary>
public void Clear_Views()
{
if (Views != null)
{
Views.Clear();
}
}
public MyViewData()
{
Views.Clear();
Views.Add(new TextEditor()
{
Tag = "Avalon TextEditor", Text = TestString
});
Views.Add(new TextEditor()
{
Tag = "Avalon TextEditor", Text = TestString
});
Views.Add(new RichTextBox(new FlowDocument(new Paragraph(new Run(TestString))))
{
Tag = "WPF RichTextBox", VerticalScrollBarVisibility = ScrollBarVisibility.Auto
});
Views.Add(new WindowsFormsHost()
{
Child = new System.Windows.Forms.TextBox()
{
Text = TestString, HideSelection = false, Multiline = true
}, Tag = "WinForms TextBox"
});
Views.Add(new WindowsFormsHost()
{
Child = new System.Windows.Forms.RichTextBox()
{
Text = TestString, HideSelection = false
}, Tag = "WinForms RichTextBox"
});
//Views.Add(new TextBox() { Tag = "WPF TextBox (*)", Text = TestString, VerticalScrollBarVisibility = ScrollBarVisibility.Auto });
ActiveView = Views[0];
}
public string reloadData(string newLibraryPath)
{
"In Reload data".info();
if (newLibraryPath.notNull())
{
var tmConfig = TMConfig.Current;
tmConfig.XmlLibrariesPath = newLibraryPath;
tmConfig.SaveTMConfig();
}
GuidanceItems_FileMappings.Clear();
GuidanceExplorers_XmlFormat.Clear();
Libraries.Clear();
Folders.Clear();
Views.Clear();
GuidanceItems.Clear();
if (newLibraryPath.valid())
{
setLibraryPath_and_LoadDataIntoMemory(newLibraryPath);
}
else
{
TM_Xml_Database.loadDataIntoMemory();
}
this.reCreate_GuidanceItemsCache();
this.xmlDB_Load_GuidanceItems();
this.createDefaultAdminUser(); // make sure this user exists
return("In the library '{0}' there are {1} library(ies), {2} views and {3} GuidanceItems".
format(TM_Xml_Database.Path_XmlLibraries.directoryName(), Libraries.size(), Views.size(), GuidanceItems.size()));
}
void IDeactivate.Deactivate(bool close)
{
if (IsActive || (IsInitialized && close))
{
AttemptingDeactivation(this, new DeactivationEventArgs
{
WasClosed = close
});
IsActive = false;
Log.Info("Deactivating {0}.", this);
OnDeactivate(close);
Deactivated(this, new DeactivationEventArgs
{
WasClosed = close
});
if (close)
{
Views.Clear();
Log.Info("Closed {0}.", this);
}
}
}
private void Views_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e)
{
switch (e.Action)
{
case NotifyCollectionChangedAction.Add:
Views.Add(e.NewItems[0].ToString());
break;
case NotifyCollectionChangedAction.Remove:
Views.Remove(e.OldItems[0].ToString());
break;
case NotifyCollectionChangedAction.Replace:
break;
case NotifyCollectionChangedAction.Move:
break;
case NotifyCollectionChangedAction.Reset:
Views.Clear();
foreach (var view in region.Views)
{
Views.Add(view.ToString());
}
break;
default:
break;
}
}
///<inheritdoc/>
public void Reset()
{
Tables.Clear();
Columns.Clear();
Views.Clear();
StoredProcedures.Clear();
SchemaNames.Clear();
}
private void GetViews()
{
Views.Clear();
foreach (DrawingView v in _sheet.DrawingViews)
{
Views.Add(new InventorView(v));
}
}
protected override void OnDisappearing()
{
Model.State = ViewModel.Base.ModelState.Undefined;
PanGesture.PanUpdated -= OnPaned;
TapGesture.Tapped -= GridTapped;
SelectedViews.Clear();
abslayout.Children.Clear();
Views.Clear();
base.OnDisappearing();
}
private void ImplementMVVM()
{
ImplementFiles();
MessageBox.Show("MVVM Implementated successful!", "Success!", MessageBoxButton.OK, MessageBoxImage.Information);
Models.Clear();
ViewModels.Clear();
Views.Clear();
}
public override void Clear()
{
Tables.Clear();
Views.Clear();
MaterializedViews.Clear();
Indexes.Clear();
Sequences.Clear();
Synonyms.Clear();
Triggers.Clear();
StoredProcedures.Clear();
}
protected override void OnDisappearing()
{
MessagingCenter.Unsubscribe <ZonesPlanViewModel>(this, "Rebuild");
MessagingCenter.Unsubscribe <ZonesPlanViewModel>(this, "Reshape");
MessagingCenter.Unsubscribe <ZonesPlanViewModel>(this, "BringToFront");
Model.State = ViewModel.Base.ModelState.Undefined;
PanGesture.PanUpdated -= OnPaned;
TapGesture.Tapped -= GridTapped;
SelectedViews.Clear();
Views.Clear();
abslayout.Children.Clear();
base.OnDisappearing();
}
private void Rebuild(RacksPlanViewModel rsmv)
{
SelectedViews.Clear();
abslayout.Children.Clear();
Views.Clear();
foreach (RackViewModel rvm in Model.RackViewModels)
{
RackSchemeView rsv = new RackSchemeView(rvm);
AbsoluteLayout.SetLayoutBounds(rsv, new Rectangle(rvm.ViewLeft, rvm.ViewTop, rvm.ViewWidth, rvm.ViewHeight));
abslayout.Children.Add(rsv);
Views.Add(rsv);
}
}
/// <summary>
/// Reset render objects and features. Should be called at beginning of Extract phase.
/// </summary>
public void Reset()
{
FrameCounter++;
try
{
// Clear render features node lists
foreach (var renderFeature in RenderFeatures)
{
renderFeature.Reset();
}
}
finally
{
// Clear views
foreach (var view in Views)
{
// Clear nodes
view.RenderObjects?.Clear(false);
foreach (var renderViewFeature in view.Features)
{
renderViewFeature.RenderNodes?.Clear(true);
renderViewFeature.ViewObjectNodes?.Clear(true);
renderViewFeature.Layouts?.Clear(false);
}
foreach (var renderViewStage in view.RenderStages)
{
// Slow clear, since type contains references
renderViewStage.RenderNodes?.Clear(false);
renderViewStage.SortedRenderNodes?.Clear(false);
if (renderViewStage.RenderNodes != null)
{
renderNodePool.Release(renderViewStage.RenderNodes);
}
if (renderViewStage.SortedRenderNodes != null)
{
sortedRenderNodePool.Release(renderViewStage.SortedRenderNodes);
}
}
// Clear view stages
view.RenderStages?.Clear();
}
// Clear views
Views?.Clear();
}
}
private void Rebuild(LocationsPlanViewModel lmv)
{
abslayout.Children.Clear();
SelectedViews.Clear();
Views.Clear();
foreach (LocationViewModel lvm1 in Model.LocationViewModels)
{
LocationView lv = new LocationView(lvm1);
AbsoluteLayout.SetLayoutBounds(lv, new Rectangle(lvm1.ViewLeft, lvm1.ViewTop, lvm1.ViewWidth, lvm1.ViewHeight));
abslayout.Children.Add(lv);
Views.Add(lv);
lvm1.LoadZones();
}
}
protected override void Dispose(bool disposing)
{
base.Dispose(disposing);
if (!disposing)
{
return;
}
RemoveOnClickListeners(true);
Views?.Clear();
Views = null;
}
private void Rebuild(ZonesPlanViewModel lmv)
{
SelectedViews.Clear();
abslayout.Children.Clear();
Views.Clear();
foreach (ZoneViewModel zvm in Model.ZoneViewModels)
{
ZoneView zv = new ZoneView(zvm);
AbsoluteLayout.SetLayoutBounds(zv, new Rectangle(zvm.ViewLeft, zvm.ViewTop, zvm.ViewWidth, zvm.ViewHeight));
abslayout.Children.Add(zv);
Views.Add(zv);
zvm.LoadRacks();
}
}
public void AssignPhaseData(DatabaseObjectInfo source, DatabaseAnalysePhase phase)
{
var src = (DatabaseInfo)source;
if ((phase & DatabaseAnalysePhase.Tables) != 0)
{
Tables.Clear();
foreach (var obj in src.Tables)
{
Tables.Add(obj.CloneTable(this));
}
}
if ((phase & DatabaseAnalysePhase.Views) != 0)
{
Views.Clear();
foreach (var obj in src.Views)
{
Views.Add(obj.CloneView(this));
}
}
if ((phase & DatabaseAnalysePhase.Functions) != 0)
{
StoredProcedures.Clear();
Functions.Clear();
Triggers.Clear();
foreach (var obj in src.StoredProcedures)
{
StoredProcedures.Add(obj.CloneStoredProcedure(this));
}
foreach (var obj in src.Functions)
{
Functions.Add(obj.CloneFunction(this));
}
foreach (var obj in src.Triggers)
{
Triggers.Add(obj.CloneTrigger(this));
}
}
if ((phase & DatabaseAnalysePhase.Settings) != 0)
{
Schemas.Clear();
foreach (var obj in src.Schemas)
{
Schemas.Add(obj.CloneSchema(this));
}
DefaultSchema = src.DefaultSchema;
}
}
void IDeactivate.Deactivate(bool close)
{
if (IsActive || (IsInitialized && close))
{
OnDeactivating(close);
IsActive = false;
Log.Info("Deactivating {0}.", this);
OnDeactivate(close);
OnDeactivated(close);
if (close)
{
Views.Clear();
Log.Info("Closed {0}.", this);
}
}
}
private void Rebuild(ZonesPlanViewModel lmv)
{
SelectedViews.Clear();
abslayout.Children.Clear();
Views.Clear();
foreach (ZoneViewModel zvm in Model.ZoneViewModels)
{
ZoneView zv = new ZoneView(zvm);
AbsoluteLayout.SetLayoutBounds(zv, new Rectangle(zvm.ViewLeft, zvm.ViewTop, zvm.ViewWidth, zvm.ViewHeight));
abslayout.Children.Add(zv);
Views.Add(zv);
int x = Task.Run(async() =>
{
await zvm.LoadRacks();
await zvm.LoadIndicators();
return(0);
}).Result;
}
}
private void SelectProject()
{
OpenFileDialog openFileDialog = new OpenFileDialog
{
Filter = "Visual studio solution file(*.sln*)|*.sln",
Title = "Select your Visual Studio project",
Multiselect = false
};
if (openFileDialog.ShowDialog() == true)
{
slnPath = openFileDialog.FileName;
}
Models.Clear();
Views.Clear();
ViewModels.Clear();
OnPropertyChanged("IsAddNewFilesEnabled");
OnPropertyChanged("CurrentProject");
}
public bool Show()
{
try
{
var proj = new XenProjectFile(_fs);
var loaded = proj.Load(ToolboxApp.Project.State.XenProjectFilePath);
if (!loaded)
{
return(false);
}
if (proj.Views == null)
{
return(false);
}
// clear the views after when know that we can save some output
Views.Clear();
var sorted = proj.Views.OrderBy(v => v.TypeName).ToArray();
foreach (var pv in sorted)
{
pv.Deleted = false;
pv.Persisted = true;
Views.Add(pv);
}
OnRecreateMenuItems(new RecreateMenuItemsEventArgs(proj.Views));
return(true);
}
catch (Exception ex)
{
ToolboxApp.Log.Error(ex, $"Error showing {nameof(RegisterNewViewModel)}.");
return(false);
}
}
private void RefreshViews()
{
//obtener lista de vistas de la BD actual
string sql_views;
sql_views = "SELECT \n" +
" sobj.id as OwnerId, \n"+
" sobj.name as OwnerName, \n"+
" cols.name as Nombre, \n"+
" type_name(cols.xusertype) as Tipo, \n"+
" isnull(cols.prec, 0) as Longitud, \n"+
" isnull(cols.Scale, 0) as Escala, \n"+
" isnull(cols.isnullable, 1) as Nullable, \n"+
" isnull(cols.iscomputed, 0) as Calculated \n"+
"FROM \n" +
" sysobjects sobj INNER JOIN syscolumns cols ON sobj.id=cols.id \n"+
"WHERE \n" +
" sobj.xtype = 'V' \n"+
" and sobj.name <> 'sysdiagrams' \n"+
"order by \n" +
" sobj.name, cols.colid \n";
//obtener lista de vistas de la BD actual
DataTable Info = new DataTable();
SqlCommand cmd = new SqlCommand(sql_views, Conx);
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.SelectCommand.Connection.Open();
da.Fill(Info);
da.SelectCommand.Connection.Close();
}
catch (Exception ex)
{
cmd.Connection.Close();
return;
}
cmd.Dispose();
if (Views != null)
{
Views.Clear();
}
else
{
Views = new List <SQLServer_Object>();
}
SQLServer_Object CurObj = null;
string curview = "";
int i, rowcount = Info.Rows.Count;
for (i = 0; i < rowcount; i++)
{
if (!curview.Equals(Info.Rows[i]["OwnerName"].ToString(), StringComparison.CurrentCultureIgnoreCase))
{//agregar solo el campo
CurObj = new SQLServer_Object(this, Convert.ToInt32(Info.Rows[i]["OwnerId"]), Info.Rows[i]["OwnerName"].ToString(), "Vista", DataType.View);
curview = CurObj.Name;
Views.Add(CurObj);
}
SQLServer_Object Field;
Field = new SQLServer_Object(null, 0, Info.Rows[i]["Nombre"].ToString(), "Campo", DataType.Field);
Field.LlaveForanea = false;
Field.LlavePrimaria = false;
Field.Tipo = Info.Rows[i]["Tipo"].ToString();
Field.Precision = Convert.ToInt32(Info.Rows[i]["Longitud"]);
Field.Nullable = Convert.ToInt32(Info.Rows[i]["Nullable"]) == 1;
Field.Calculado = false;
Field.Default = "";
Field.ReferenceID = 0;
Field.ReferenceTable = "";
Field.ReferenceField = "";
CurObj.Childs.Add(Field);
}
}
private void CleanEnries()
{
Tables.Clear();
Views.Clear();
Routines.Clear();
}
