public DataBoxPropertiesChangedArgsWindows( SqlDatabaseTableWindows currentTable, EntityCacheUniqueWindows currentEntityCache, List <string> hiddenProperties, List <string> extensionManagedProperties, Dictionary <string, Control> inputControls, Control firstInputControl, object entityUnderUpdate, Nullable <Guid> entityIdUnderUpdate, string currentDataBoxFilePath, bool filtersEnabled, bool unsavedChanges, bool readOnlyMode, bool inUpdateMode) { _currentTable = currentTable; _currentEntityCache = currentEntityCache; _hiddenProperties = hiddenProperties; _extensionManagedProperties = extensionManagedProperties; _inputControls = inputControls; _firstInputControl = firstInputControl; _entityUnderUpdate = entityUnderUpdate; _entityIdUnderUpdate = entityIdUnderUpdate; _currentDataBoxFilePath = currentDataBoxFilePath; _filtersEnabled = filtersEnabled; _unsavedChanges = unsavedChanges; _readOnlyMode = readOnlyMode; _inUpdateMode = inUpdateMode; }
public MenuClickArgsWindows( SqlDatabaseTableWindows currentTable, object selectedEntity, bool dataBoxInUpdateMode) { _currentTable = currentTable; _selectedEntity = selectedEntity; _dataBoxInUpdateMode = dataBoxInUpdateMode; }
public AfterRefreshFromServerArgsWindows(bool presentLoadDataBoxForm, SqlDatabaseTableWindows currentTable) { _presentLoadDataBoxForm = presentLoadDataBoxForm; _currentTable = currentTable; }
public SqlDatabaseWindows GetSqlDatabase( bool createOrmAssembly, bool saveOrmAssembly, string ormAssemblyOutputDirectory, bool wrapWebException) { string rawOutput = string.Empty; SqlDatabaseWindows result = new SqlDatabaseWindows(); HttpStatusCode statusCode; string statusDescription = null; result.Name = GetSqlSchema <string>(DatabaseSchemaInfoTypeWindows.DatabaseName, null, out rawOutput, out statusCode, out statusDescription, wrapWebException); DataTable tablesSchema = GetSqlSchema <DataTable>(DatabaseSchemaInfoTypeWindows.Tables, null, out rawOutput, out statusCode, out statusDescription, wrapWebException); Dictionary <string, DatabaseTableKeyColumnsWindows> tablesKeyColumns = new Dictionary <string, DatabaseTableKeyColumnsWindows>(); //Primary keys of all the tables. GetSqlSchema <List <DatabaseTableKeyColumnsWindows> >(DatabaseSchemaInfoTypeWindows.TableKeyColumns, null, out rawOutput, out statusCode, out statusDescription, wrapWebException).ForEach(p => tablesKeyColumns.Add(p.TableName, p)); Dictionary <string, DatabaseTableForeignKeyColumnsWindows> tablesForeignKeyColumns = new Dictionary <string, DatabaseTableForeignKeyColumnsWindows>(); //Foreign keys of all tables. GetSqlSchema <List <DatabaseTableForeignKeyColumnsWindows> >(DatabaseSchemaInfoTypeWindows.TableForeignKeyColumns, null, out rawOutput, out statusCode, out statusDescription, wrapWebException).ForEach(p => tablesForeignKeyColumns.Add(p.TableName, p)); foreach (DataRow t in tablesSchema.Rows) { SqlDatabaseTableWindows table = new SqlDatabaseTableWindows(t); if (table.IsSystemTable) { continue; } if (!tablesKeyColumns.ContainsKey(table.TableName)) { throw new UserThrownException(string.Format("Could not find key columns for table {0}.", table.TableName), LoggingLevel.Minimum); } DatabaseTableKeyColumnsWindows tableKeys = tablesKeyColumns[table.TableName]; DatabaseTableForeignKeyColumnsWindows tableForeignKeys = tablesForeignKeyColumns[table.TableName]; if (result.Tables.Exists(table.TableName)) { throw new Exception(string.Format( "{0} with name {1} already added.", typeof(SqlDatabaseTableWindows).FullName, table.TableName)); } result.AddTable(table); DataTable columnsSchema = GetSqlSchema <DataTable>(DatabaseSchemaInfoTypeWindows.Columns, table.TableName, out rawOutput, out statusCode, out statusDescription, wrapWebException); table.PopulateColumnsFromSchema(columnsSchema); foreach (string keyColumn in tableKeys.KeyNames) { if (!table.Columns.Exists(keyColumn)) { throw new UserThrownException(string.Format("Could not find key column {0} on table {1}.", keyColumn, table.TableName), LoggingLevel.Minimum); } table.Columns[keyColumn].IsKey = true; } foreach (ForeignKeyInfoWindows foreignKeyColumn in tableForeignKeys.ForeignKeys) { if (!table.Columns.Exists(foreignKeyColumn.ChildTableForeignKeyName)) { throw new UserThrownException(string.Format("Could not find foreign key column {0} on table {1}.", foreignKeyColumn.ChildTableForeignKeyName, table.TableName), LoggingLevel.Minimum); } DatabaseTableColumnWindows c = table.Columns[foreignKeyColumn.ChildTableForeignKeyName]; c.IsForeignKey = true; c.ParentTableName = foreignKeyColumn.ParentTableName; c.ParentTablePrimaryKeyName = foreignKeyColumn.ParentTablePrimaryKeyName; c.ConstraintName = foreignKeyColumn.ConstraintName; } } PopulateSqlDatabaseChildrenTables(result); if (createOrmAssembly) { result.CreateOrmAssembly(saveOrmAssembly, ormAssemblyOutputDirectory); } return(result); }
public BeforeRefreshFromServerArgsWindows(bool presentLoadDataBoxForm, SqlDatabaseTableWindows selectedTable) { _presentLoadDataBoxForm = presentLoadDataBoxForm; _selectedTable = selectedTable; }