private questStatus read(MasterPricingEntities dbContext, TablesetColumnId tablesetColumnId, out Quest.Services.Dbio.MasterPricing.TablesetColumns tablesetColumn)
{
// Initialize
questStatus status = null;
tablesetColumn = null;
try
{
tablesetColumn = dbContext.TablesetColumns.Where(r => r.Id == tablesetColumnId.Id).SingleOrDefault();
if (tablesetColumn == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", tablesetColumnId.Id))));
}
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* TablesetColumns
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.TablesetColumn tablesetColumn, out TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
tablesetColumnId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.TablesetColumns _tablesetColumn = new Quest.Services.Dbio.MasterPricing.TablesetColumns();
BufferMgr.TransferBuffer(tablesetColumn, _tablesetColumn);
dbContext.TablesetColumns.Add(_tablesetColumn);
dbContext.SaveChanges();
if (_tablesetColumn.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.TablesetColumn not created"));
}
tablesetColumnId = new TablesetColumnId(_tablesetColumn.Id);
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, fullErrorMessage);
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage));
LogException(ex, status);
return(status);
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, TablesetColumnId tablesetColumnId, out Quest.Functional.MasterPricing.TablesetColumn tablesetColumn)
{
// Initialize
questStatus status = null;
tablesetColumn = null;
// Perform read.
Quest.Services.Dbio.MasterPricing.TablesetColumns _tablesetColumn = null;
status = read((MasterPricingEntities)trans.DbContext, tablesetColumnId, out _tablesetColumn);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetColumn = new Quest.Functional.MasterPricing.TablesetColumn();
BufferMgr.TransferBuffer(_tablesetColumn, tablesetColumn);
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.TablesetColumns _tablesetColumn = null;
status = read(dbContext, tablesetColumnId, out _tablesetColumn);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.TablesetColumns.Remove(_tablesetColumn);
dbContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, fullErrorMessage);
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage));
LogException(ex, status);
return(status);
}
catch (System.Exception ex)
{
status = new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message));
LogException(ex, status);
return(status);
}
return(new questStatus(Severity.Success));
}
private questStatus getJoinTarget(TablesetColumnId tablesetColumnId, out TablesetTable tablesetTable, out TablesetView tablesetView)
{
// Initialize
questStatus status = null;
tablesetTable = null;
tablesetView = null;
// Get TablesetColumn
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this.UserSession);
TablesetColumn tablesetColumn = null;
status = dbTablesetColumnsMgr.Read(tablesetColumnId, out tablesetColumn);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
if (tablesetColumn.EntityTypeId == EntityType.Table)
{
TablesetTableId tablesetTableId = new TablesetTableId(tablesetColumn.TableSetEntityId);
DbTablesetTablesMgr dbTablesetTablesMgr = new DbTablesetTablesMgr(this.UserSession);
status = dbTablesetTablesMgr.Read(tablesetTableId, out tablesetTable);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
}
else if (tablesetColumn.EntityTypeId == EntityType.View)
{
TablesetViewId tablesetViewId = new TablesetViewId(tablesetColumn.TableSetEntityId);
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this.UserSession);
status = dbTablesetViewsMgr.Read(tablesetViewId, out tablesetView);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.TablesetColumn tablesetColumn, out TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
tablesetColumnId = null;
// Data rules.
// Create the tablesetColumn in this transaction.
status = create((MasterPricingEntities)trans.DbContext, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.TablesetColumn tablesetColumn, out TablesetColumnId tablesetColumnId)
{
// Initialize
questStatus status = null;
tablesetColumnId = null;
// Data rules.
// Create the tablesetColumn
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Save(DbMgrTransaction trans, FilterId filterId, Filter filter)
{
// Initialize
questStatus status = null;
Mgr mgr = new Mgr(this.UserSession);
ColumnsMgr columnMgr = new ColumnsMgr(this.UserSession);
try
{
// Validate filter
status = Verify(filterId, filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Remove filter entities, items and values. Also, tables and columns.
status = _dbFilterMgr.Clear(trans, filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Save filter tables
FilterTablesMgr filterTablesMgr = new FilterTablesMgr(this.UserSession);
foreach (FilterTable filterTable in filter.FilterTableList)
{
filterTable.FilterId = filter.Id;
FilterTableId filterTableId = null;
status = filterTablesMgr.Create(trans, filterTable, out filterTableId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterTable.Id = filterTableId.Id;
}
// Save filter views
FilterViewsMgr filterViewsMgr = new FilterViewsMgr(this.UserSession);
foreach (FilterView _filterView in filter.FilterViewList)
{
_filterView.FilterId = filter.Id;
FilterViewId filterViewId = null;
status = filterViewsMgr.Create(trans, _filterView, out filterViewId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
_filterView.Id = filterViewId.Id;
}
// Save filter columns
DbFilterMgr dbFilterMgr = new DbFilterMgr(this.UserSession);
FilterColumnsMgr filterColumnsMgr = new FilterColumnsMgr(this.UserSession);
foreach (FilterColumn filterColumn in filter.FilterColumnList)
{
if (filterColumn.FilterEntityId < BaseId.VALID_ID)
{
// Get the FilterTable or FilterView Id.
// This is a klugie. Gotta rework DataManager panel first, though. No time to do that.
if (filterColumn.FilterEntityTypeId == FilterEntityType.Table)
{
TablesetTable tablesetTable = null;
status = dbFilterMgr.GetTablesetTable(filterColumn, out tablesetTable);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
FilterTable filterTable = filter.FilterTableList.Find(delegate(FilterTable t) { return(t.Schema == tablesetTable.Schema && t.Name == tablesetTable.Name); });
if (filterTable == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: FilterTable not found for TableSetTable Schema:{0} Name:{1}",
tablesetTable.Schema, tablesetTable.Name)));
}
filterColumn.FilterEntityId = filterTable.Id;
}
else if (filterColumn.FilterEntityTypeId == FilterEntityType.View)
{
TablesetView tablesetView = null;
status = dbFilterMgr.GetTablesetView(filterColumn, out tablesetView);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
FilterView filterView = filter.FilterViewList.Find(delegate(FilterView v) { return(v.Schema == tablesetView.Schema && v.Name == tablesetView.Name); });
if (filterView == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: FilterView not found for TableSetTable Schema:{0} Name:{1}",
tablesetView.Schema, tablesetView.Name)));
}
filterColumn.FilterEntityId = filterView.Id;
}
else
{
return(new questStatus(Severity.Error, String.Format("ERROR: FilterColumn FilterEntityTypeId {0} not supported. FilterColumn {1}",
filterColumn.FilterEntityTypeId, filterColumn.Id)));
}
}
// Save
FilterColumnId filterColumnId = null;
status = filterColumnsMgr.Create(trans, filterColumn, out filterColumnId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterColumn.Id = filterColumnId.Id;
}
// Save filter items.
FilterItemsMgr filterItemsMgr = new FilterItemsMgr(this.UserSession);
FilterItemJoinsMgr filterItemJoinsMgr = new FilterItemJoinsMgr(this.UserSession);
FilterOperationsMgr filterOperationsMgr = new FilterOperationsMgr(this.UserSession);
FilterValuesMgr filterValuesMgr = new FilterValuesMgr(this.UserSession);
foreach (FilterItem filterItem in filter.FilterItemList)
{
FilterColumn filterColumn = null;
// Get filterItem FilterEntityId
if (filterItem.FilterEntityId < BaseId.VALID_ID)
{
status = dbFilterMgr.GetFilterColumn(filter, filterItem, out filterColumn);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterItem.FilterEntityId = filterColumn.Id;
filterItem.FilterColumn = filterColumn; // helps with bookkeeping further down.
}
// Save FilterItem
FilterItemId filterItemId = null;
status = filterItemsMgr.Create(trans, filterItem, out filterItemId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterItem.Id = filterItemId.Id;
// Save filter item joins
foreach (FilterItemJoin filterItemJoin in filterItem.JoinList)
{
filterItemJoin.FilterItemId = filterItemId.Id;
if (string.IsNullOrEmpty(filterItemJoin.SourceSchema) || string.IsNullOrEmpty(filterItemJoin.SourceEntityName) || string.IsNullOrEmpty(filterItemJoin.SourceColumnName))
{
// Get join target type (Table or View)
TablesetColumnId tablesetColumnId = new TablesetColumnId(filterItemJoin.ColumnId);
TablesetTable tablesetTable = null;
TablesetView tablesetView = null;
status = getJoinTarget(tablesetColumnId, out tablesetTable, out tablesetView);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterItemJoin.TargetEntityTypeId = tablesetTable == null ? FilterEntityType.View : FilterEntityType.Table;
// Get target identifier parts.
string targetSchema = null;
string targetEntityName = null;
string targetColumnName = null;
SQLIdentifier.ParseThreePartIdentifier(filterItemJoin.Identifier, out targetSchema, out targetEntityName, out targetColumnName);
filterItemJoin.TargetSchema = targetSchema;
filterItemJoin.TargetEntityName = targetEntityName;
filterItemJoin.TargetColumnName = targetColumnName;
// Get source identifier parts.
string sourceSchema = null;
string sourceEntityName = null;
string sourceColumnName = null;
if (filterColumn.FilterEntityTypeId == FilterEntityType.Table)
{
FilterTable filterTable = filter.FilterTableList.Find(delegate(FilterTable t) { return(filterColumn.FilterEntityId == t.Id); });
if (filterTable == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: building Join on {0}, FilterTable {1} not found",
filterItemJoin.Identifier, filterColumn.FilterEntityId)));
}
sourceSchema = filterTable.Schema;
sourceEntityName = filterTable.Name;
}
else if (filterColumn.FilterEntityTypeId == FilterEntityType.View)
{
FilterView filterView = filter.FilterViewList.Find(delegate(FilterView v) { return(filterColumn.FilterEntityId == v.Id); });
if (filterView == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: building Join on {0}, FilterView {1} not found",
filterItemJoin.Identifier, filterColumn.FilterEntityId)));
}
sourceSchema = filterView.Schema;
sourceEntityName = filterView.Name;
}
sourceColumnName = filterColumn.Name;
filterItemJoin.SourceSchema = sourceSchema;
filterItemJoin.SourceEntityName = sourceEntityName;
filterItemJoin.SourceColumnName = sourceColumnName;
}
// Create FilterItemJoin
FilterItemJoinId filterItemJoinId = null;
status = filterItemJoinsMgr.Create(trans, filterItemJoin, out filterItemJoinId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
// Save filter operations
foreach (FilterOperation filterOperation in filterItem.OperationList)
{
filterOperation.FilterItemId = filterItem.Id;
FilterOperationId filterOperationId = null;
status = filterOperationsMgr.Create(trans, filterOperation, out filterOperationId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Save filter values
foreach (FilterValue filterValue in filterOperation.ValueList)
{
filterValue.FilterOperationId = filterOperationId.Id;
FilterValueId filterValueId = null;
status = filterValuesMgr.Create(trans, filterValue, out filterValueId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
}
}
// Save filter procedures
// Get the filter's database.
Quest.Functional.MasterPricing.Database database = null;
status = GetFilterDatabase(filterId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// NOTE: business rules reads in procedure parameters and writes them.
FilterProceduresMgr filterProceduresMgr = new FilterProceduresMgr(this.UserSession);
foreach (FilterProcedure filterProcedure in filter.FilterProcedureList)
{
if (string.IsNullOrEmpty(filterProcedure.Name))
{
continue;
}
filterProcedure.FilterId = filter.Id;
FilterProcedureId filterProcedureId = null;
status = filterProceduresMgr.Create(trans, database, filterProcedure, out filterProcedureId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
// NOTE: YOU STILL HAVE TO UPDATE THE FILTER'S SQL. BUT, CAN'T HERE, B/C YOU'RE IN A TRANSACTION.
// TODO: REFACTOR SO YOU CAN, BUT GOTTA GET A PARAMETERS MAKE-REQUIRED UPDATE OUT THERE FIRST.
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus GetTablesetView(DatabaseId databaseId, FilterViewTablesetViewId filterViewTablesetViewId, out TablesetView tablesetView)
{
// Initialize
questStatus status = null;
tablesetView = null;
// Get tableset view
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this._userSession);
status = dbTablesetViewsMgr.Read(filterViewTablesetViewId, out tablesetView);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get tableset columns
EntityType entityType = new EntityType();
entityType.Id = EntityType.View;
TableSetEntityId tableSetEntityId = new TableSetEntityId(tablesetView.Id);
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this._userSession);
List <TablesetColumn> tablesetColumnList = null;
TablesetColumnId tablesetColumnId = new TablesetColumnId();
status = dbTablesetColumnsMgr.Read(entityType, tableSetEntityId, out tablesetColumnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetView.TablesetColumnList = tablesetColumnList;
// Get view
View view = null;
status = GetViewInfo(databaseId, tablesetView, out view);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetView.View = view;
// Get column info
DbColumnsMgr dbColumnsMgr = new DbColumnsMgr(this._userSession);
EntityTypeId entityTypeId = new EntityTypeId(EntityType.View);
EntityId entityId = new EntityId(view.Id);
foreach (TablesetColumn tablesetColumn in tablesetColumnList)
{
Column column = null;
status = dbColumnsMgr.Read(entityTypeId, entityId, tablesetColumn.Name, out column);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetColumn.Column = column;
}
return(new questStatus(Severity.Success));
}
public questStatus SaveTablesetConfiguration(TablesetConfiguration tablesetConfiguration, out TablesetId tablesetId)
{
// Initialize
questStatus status = null;
tablesetId = null;
DbMgrTransaction trans = null;
bool bFiltersRemoved = false;
questStatus status2 = null;
try
{
// BEGIN TRANSACTION
status = BeginTransaction("SaveTablesetConfiguration" + Guid.NewGuid().ToString(), out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
/*
* Update tableset info.
*/
// Read the tableset
TablesetsMgr tablesetsMgr = new TablesetsMgr(this.UserSession);
TablesetId _tablesetId = new TablesetId(tablesetConfiguration.Tableset.Id);
Tableset _tableset = null;
status = tablesetsMgr.Read(trans, _tablesetId, out _tableset);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
/*
* Remove all tableset entities.
*/
status = ClearTablesetEntities(trans, _tablesetId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
// TESTING ONLY: COMMIT TRANSACTION
bool bKlugie = false;
if (bKlugie)
{
status = CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
/*
* Get database entites.
*/
DatabaseId databaseId = new DatabaseId(tablesetConfiguration.Database.Id);
DatabaseMgr databaseMgr = new DatabaseMgr(this.UserSession);
DatabaseEntities databaseEntities = null;
status = databaseMgr.ReadDatabaseEntities(databaseId, out databaseEntities);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
#region Save tableset info.
/*
* Save tableset info.
*/
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this.UserSession);
// Save table info.
DbTablesetTablesMgr dbTablesetTablesMgr = new DbTablesetTablesMgr(this.UserSession);
List <TablesetTable> tablesetTableList = new List <TablesetTable>();
foreach (TablesetTable tablesetTable in tablesetConfiguration.TablesetTables)
{
Table _table = databaseEntities.TableList.Find(delegate(Table t) { return(t.Schema == tablesetTable.Schema && t.Name == tablesetTable.Name); });
if (_table == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: tableset table [{0}].[{1}] not found in database metainfo. Try refreshing database schema info",
tablesetTable.Schema, tablesetTable.Name)));
}
tablesetTable.TablesetId = _tableset.Id;
tablesetTable.Table = _table;
tablesetTableList.Add(tablesetTable);
// Create tableset table.
TablesetTableId tablesetTableId = null;
status = dbTablesetTablesMgr.Create(trans, tablesetTable, out tablesetTableId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
foreach (Column column in _table.ColumnList)
{
Column _column = _table.ColumnList.Find(delegate(Column c) { return(c.Name == column.Name); });
if (_column == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: column [{0}] not found in table [{1}].[{2}] in database metainfo. Try refreshing database schema info",
column.Name, _table.Schema, _table.Name)));
}
TablesetColumn tablesetColumn = new TablesetColumn();
tablesetColumn.EntityTypeId = EntityType.Table;
tablesetColumn.TableSetEntityId = tablesetTableId.Id;
tablesetColumn.Name = column.Name;
TablesetColumnId tablesetColumnId = null;
status = dbTablesetColumnsMgr.Create(trans, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
}
}
// Save view info.
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this.UserSession);
List <TablesetView> tablesetViewList = new List <TablesetView>();
foreach (TablesetView tablesetView in tablesetConfiguration.TablesetViews)
{
View _view = databaseEntities.ViewList.Find(delegate(View v) { return(v.Schema == tablesetView.Schema && v.Name == tablesetView.Name); });
if (_view == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: tableset view [{0}].[{1}] not found in database metainfo. Try refreshing database schema info",
tablesetView.Schema, tablesetView.Name)));
}
tablesetView.TablesetId = _tableset.Id;
tablesetView.View = _view;
tablesetViewList.Add(tablesetView);
// Create tableset view.
TablesetViewId tablesetViewId = null;
status = dbTablesetViewsMgr.Create(trans, tablesetView, out tablesetViewId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
foreach (Column column in _view.ColumnList)
{
Column _column = _view.ColumnList.Find(delegate(Column c) { return(c.Name == column.Name); });
if (_column == null)
{
RollbackTransaction(trans);
return(new questStatus(Severity.Error, String.Format("ERROR: column [{0}] not found in view [{1}].[{2}] in database metainfo. Try refreshing database schema info",
column.Name, _view.Schema, _view.Name)));
}
TablesetColumn tablesetColumn = new TablesetColumn();
tablesetColumn.EntityTypeId = EntityType.View;
tablesetColumn.TableSetEntityId = tablesetViewId.Id;
tablesetColumn.Name = column.Name;
TablesetColumnId tablesetColumnId = null;
status = dbTablesetColumnsMgr.Create(trans, tablesetColumn, out tablesetColumnId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
}
}
#endregion
// Update tableset.
bFiltersRemoved = false;
_tableset.DatabaseId = tablesetConfiguration.Database.Id;
status2 = tablesetsMgr.Update(trans, _tableset);
if (!questStatusDef.IsSuccess(status2))
{
if (questStatusDef.IsWarning(status2))
{
bFiltersRemoved = true;
}
else
{
RollbackTransaction(trans);
return(status);
}
}
// COMMIT TRANSACTION
status = CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Return the tableset id
tablesetId = new TablesetId(tablesetConfiguration.Tableset.Id);
}
catch (System.Exception ex)
{
if (trans != null)
{
RollbackTransaction(trans);
}
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
if (bFiltersRemoved)
{
return(status2);
}
return(new questStatus(Severity.Success));
}
