public questStatus Read(EntityType entityType, TableSetEntityId tableSetEntityId, out List <Quest.Functional.MasterPricing.TablesetColumn> tablesetColumnList)
{
// Initialize
questStatus status = null;
tablesetColumnList = null;
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.TablesetColumns> _tablesetColumnList = null;
status = read(dbContext, entityType, tableSetEntityId, out _tablesetColumnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetColumnList = new List <TablesetColumn>();
foreach (Quest.Services.Dbio.MasterPricing.TablesetColumns _tablesetColumn in _tablesetColumnList)
{
Quest.Functional.MasterPricing.TablesetColumn tablesetColumn = new TablesetColumn();
BufferMgr.TransferBuffer(_tablesetColumn, tablesetColumn);
tablesetColumnList.Add(tablesetColumn);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, EntityType entityType, TableSetEntityId tableSetEntityId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, entityType, tableSetEntityId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(EntityType entityType, TableSetEntityId tableSetEntityId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, entityType, tableSetEntityId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, EntityType entityType, TableSetEntityId tableSetEntityId)
{
// Initialize
questStatus status = null;
try
{
// Read the records.
List <Quest.Services.Dbio.MasterPricing.TablesetColumns> tablesetColumnList = null;
status = read(dbContext, entityType, tableSetEntityId, out tablesetColumnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the records.
dbContext.TablesetColumns.RemoveRange(tablesetColumnList);
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 read(MasterPricingEntities dbContext, EntityType entityType, TableSetEntityId tableSetEntityId, out List <Quest.Services.Dbio.MasterPricing.TablesetColumns> tablesetColumnList)
{
// Initialize
questStatus status = null;
tablesetColumnList = null;
try
{
tablesetColumnList = dbContext.TablesetColumns.Where(r => r.EntityTypeId == entityType.Id && r.TableSetEntityId == tableSetEntityId.Id).ToList();
if (tablesetColumnList == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("TablesetColumn for EntityType {0} TableSetEntityId {1} not found", entityType.Id, tableSetEntityId.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 ClearTablesetEntities(DbMgrTransaction trans, TablesetId tablesetId)
{
// Initialize
questStatus status = null;
// Read tableset.
Tableset tableset = null;
DbTablesetsMgr dbTablesetsMgr = new DbTablesetsMgr(this.UserSession);
status = dbTablesetsMgr.Read(tablesetId, out tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this.UserSession);
// Read all tableset tables
List <TablesetTable> tablesetTableList = null;
DbTablesetTablesMgr dbTablesetTablesMgr = new DbTablesetTablesMgr(this.UserSession);
status = dbTablesetTablesMgr.Read(tablesetId, out tablesetTableList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete all tablesetColumns to these tables. Then delete all tables in the tableset.
EntityType entityType = new EntityType();
entityType.Id = EntityType.Table;
foreach (TablesetTable tablesetTable in tablesetTableList)
{
TableSetEntityId tableSetEntityId = new TableSetEntityId(tablesetTable.Id);
status = dbTablesetColumnsMgr.Delete(trans, entityType, tableSetEntityId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
dbTablesetTablesMgr.Delete(trans, tablesetId);
// Read all tableset views
List <TablesetView> tablesetViewList = null;
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this.UserSession);
status = dbTablesetViewsMgr.Read(tablesetId, out tablesetViewList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete all tablesetColumns to these views. Then delete all views in the tableset.
entityType.Id = EntityType.View;
foreach (TablesetView tablesetView in tablesetViewList)
{
TableSetEntityId tableSetEntityId = new TableSetEntityId(tablesetView.Id);
status = dbTablesetColumnsMgr.Delete(trans, entityType, tableSetEntityId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
dbTablesetViewsMgr.Delete(trans, tablesetId);
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 ReadTablesetConfiguration(TablesetId tablesetId, out TablesetConfiguration tablesetConfiguration)
{
// Initialize
questStatus status = null;
tablesetConfiguration = null;
// Read tableset
Tableset tableset = null;
DbTablesetsMgr dbTablesetsMgr = new DbTablesetsMgr(this._userSession);
status = dbTablesetsMgr.Read(tablesetId, out tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read database
DatabaseId databaseId = new DatabaseId(tableset.DatabaseId);
Quest.Functional.MasterPricing.Database database = null;
DbDatabasesMgr dbDatabasesMgr = new DbDatabasesMgr(this._userSession);
status = dbDatabasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
/*
* Load tableset entities.
*/
DbTablesetColumnsMgr dbTablesetColumnsMgr = new DbTablesetColumnsMgr(this._userSession);
// Read tables in tableset
List <Quest.Functional.MasterPricing.TablesetTable> tablesetTableList = null;
DbTablesetTablesMgr dbTablesetTablesMgr = new DbTablesetTablesMgr(this._userSession);
status = dbTablesetTablesMgr.Read(tablesetId, out tablesetTableList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read table info.
EntityType entityType = new EntityType();
entityType.Id = EntityType.Table;
DbTablesMgr dbTablesMgr = new DbTablesMgr(this._userSession);
DbColumnsMgr dbColumnsMgr = new DbColumnsMgr(this._userSession);
foreach (TablesetTable tablesetTable in tablesetTableList)
{
TablesetId tableSetId = new TablesetId(tablesetTable.Id);
List <Quest.Functional.MasterPricing.TablesetColumn> tablesetColumnList = null;
TableSetEntityId tableSetEntityId = new TableSetEntityId(tablesetTable.Id);
status = dbTablesetColumnsMgr.Read(entityType, tableSetEntityId, out tablesetColumnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetTable.TablesetColumnList = tablesetColumnList;
Table table = null;
status = dbTablesMgr.Read(databaseId, tablesetTable.Schema, tablesetTable.Name, out table);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetTable.Table = table;
// Get column metadata
EntityTypeId entityTypeId = new EntityTypeId(EntityType.Table);
EntityId entityId = new EntityId(table.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;
}
}
// Read views in tableset
List <Quest.Functional.MasterPricing.TablesetView> tablesetViewList = null;
DbTablesetViewsMgr dbTablesetViewsMgr = new DbTablesetViewsMgr(this._userSession);
status = dbTablesetViewsMgr.Read(tablesetId, out tablesetViewList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read views columns in tableset
entityType.Id = EntityType.View;
DbViewsMgr dbViewsMgr = new DbViewsMgr(this._userSession);
foreach (TablesetView tablesetView in tablesetViewList)
{
TablesetViewId tablesetViewId = new TablesetViewId(tablesetView.Id);
List <Quest.Functional.MasterPricing.TablesetColumn> tablesetColumnList = null;
TableSetEntityId tableSetEntityId = new TableSetEntityId(tablesetView.Id);
status = dbTablesetColumnsMgr.Read(entityType, tableSetEntityId, out tablesetColumnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetView.TablesetColumnList = tablesetColumnList;
View view = null;
status = dbViewsMgr.Read(databaseId, tablesetView.Schema, tablesetView.Name, out view);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tablesetView.View = view;
// Get column metadata
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;
}
}
// Build tableset configuration
tablesetConfiguration = new TablesetConfiguration();
tablesetConfiguration.Tableset = tableset;
tablesetConfiguration.Database = database;
tablesetConfiguration.TablesetTables = tablesetTableList;
tablesetConfiguration.TablesetViews = tablesetViewList;
return(new questStatus(Severity.Success));
}
