public IEnumerable <MetadataDto> GetMetadata() { using (IUnitOfWork uow = UnitOfWorkFactory.Instance.Start(DataStoreResolver.CMSDataStoreKey)) { MetadataFacade facade = new MetadataFacade(uow); IEnumerable <MetadataDto> result = facade.RetrieveAll(new MetadataConverter()); return(result.Where(x => !string.IsNullOrEmpty(x.MetaContent))); } }
public MainWindowViewModel() { _metaAccess = new MetadataFacade(); SaveTableCommand = new DelegateCommand <TableMetadata>(tmd => { SaveChangesForTable(tmd, ConnectionString); }); LoadDatabaseCommand = new DelegateCommand(() => { try { ReloadDBMetaData(ConnectionString); } catch (DbException ex) { MessageBox.Show("Could not connect to the database, make sure you have entered the correct information: " + ex.ToString()); } catch (Exception exx) { MessageBox.Show("Critical error somewhere: " + exx.ToString()); } }); CreateWikiMarkupForTablesCommand = new DelegateCommand(() => { string result = _metaAccess.GenerateWikiMarkupForTablesAndViews(ConnectionString, null, Level1Types.Table); var d = new SaveFileDialog(); d.Title = "Save markup to file:"; var res = d.ShowDialog(); System.IO.File.WriteAllText(d.FileName, result); }); CreateWikiMarkupForAllIndexesCommand = new DelegateCommand(() => { string result = _metaAccess.CreateWikiMarkupForIndexesOnAllTables(ConnectionString); var d = new SaveFileDialog(); d.Title = "Save markup to file:"; var res = d.ShowDialog(); System.IO.File.WriteAllText(d.FileName, result); }); CreateWikiMarkupForSPsCommand = new DelegateCommand(() => { string result = _metaAccess.GenerateWikiMarkupForStoredProcedures(ConnectionString); var d = new SaveFileDialog(); d.Title = "Save markup to file:"; var res = d.ShowDialog(); System.IO.File.WriteAllText(d.FileName, result); }); CreateWikiMarkupForSelectedTableCommand = new DelegateCommand <TableMetadata>(tmd => { string result = _metaAccess.GenerateWikiMarkupForTablesAndViews(ConnectionString, tmd, Level1Types.Table); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); CreateWikiMarkupForIndexOnSelectedTableCommand = new DelegateCommand <TableMetadata>(tmd => { string result = _metaAccess.CreateWikiMarkupForIndexesOnTable(tmd, ConnectionString); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); CreateWikiMarkupForSelectedStoredProcedureCommand = new DelegateCommand <StoredProcedureMetaData>(spMetadata => { string result = _metaAccess.GenerateWikiMarkupForSelectedStoredProcedure(spMetadata, ConnectionString); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); SaveStoreProcedureCommand = new DelegateCommand <StoredProcedureMetaData>(spMetadata => { _metaAccess.SaveStoredProcedureMetadata(_selectedSPMetadata, ConnectionString); }); OpenSqlConnectionBuilder = new DelegateCommand(() => { ConnectionStringCreatorGUI.SqlConnectionString initialConnStr; try { initialConnStr = new ConnectionStringCreatorGUI.SqlConnectionString(ConnectionString); } catch (Exception) { initialConnStr = new ConnectionStringCreatorGUI.SqlConnectionString(); } Window win = new ConnectionStringCreatorGUI.ConnectionStringBuilderWindow(initialConnStr, returnConnBuilder => { ConnectionString = returnConnBuilder.ToString(); }); win.Show(); }); OpenOptionsCommand = new DelegateCommand(() => { Window win = new ExtendedPropertiesDocumentationTool.ModalWindows.ConfigurationWindow(AppSettings); win.Show(); }); SaveViewCommand = new DelegateCommand <ViewMetadata>(vw => { _metaAccess.SaveViewMetaData(vw, ConnectionString); }); CreateWikiMarkupForSelectedViewCommand = new DelegateCommand <ViewMetadata>(vw => { string result = _metaAccess.GenerateWikiMarkupForTablesAndViews(ConnectionString, vw, Level1Types.View); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); CreateWikiMarkupFoViewsCommand = new DelegateCommand(() => { string result = _metaAccess.GenerateWikiMarkupForTablesAndViews(ConnectionString, null, Level1Types.View); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); CreateSQLStatementsForSelectedTableCommand = new DelegateCommand <TableMetadata>(tmd => { string result = _metaAccess.GenerateSQLStatementForTable(ConnectionString, tmd, Level1Types.Table); ModalWindows.WikiMarkupDisplay disp = new ModalWindows.WikiMarkupDisplay(); disp.Show(result); }); }