private questStatus delete(MasterPricingEntities dbContext, Quest.Functional.Logging.FilterLogId filterLogId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.FilterLogs _filterLog = null;
status = read(dbContext, filterLogId, out _filterLog);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.FilterLogs.Remove(_filterLog);
dbContext.SaveChanges();
}
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 Read(ViewId viewId, out List <Quest.Functional.MasterPricing.Column> columnList)
{
// Initialize
questStatus status = null;
columnList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.Columns> _columnsList = null;
status = read(dbContext, viewId, out _columnsList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
columnList = new List <Column>();
foreach (Quest.Services.Dbio.MasterPricing.Columns _column in _columnsList)
{
Quest.Functional.MasterPricing.Column column = new Quest.Functional.MasterPricing.Column();
BufferMgr.TransferBuffer(_column, column);
columnList.Add(column);
}
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.Database database, out Quest.Functional.MasterPricing.DatabaseId databaseId)
{
// Initialize
questStatus status = null;
databaseId = null;
// Data rules.
// Create the database
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, database, out databaseId);
if (bLogging)
{
DatabaseLog databaseLog = new DatabaseLog();
databaseLog.Name = database.Name == null ? "(null)" : database.Name;
databaseLog.Event = "CREATE";
databaseLog.Data = status.ToString();
DatabaseLogId databaseLogId = null;
_dbDatabaseLogsMgr.Create(databaseLog, out databaseLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.DatabaseId databaseId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.Databases _database = null;
status = read(dbContext, databaseId, out _database);
if (!questStatusDef.IsSuccess(status))
{
if (bLogging)
{
DatabaseLog databaseLog = new DatabaseLog();
databaseLog.Name = "Database.Id=" + databaseId.Id;
databaseLog.Event = "DELETE";
databaseLog.Data = status.ToString();
DatabaseLogId databaseLogId = null;
_dbDatabaseLogsMgr.Create(databaseLog, out databaseLogId);
}
return(status);
}
// Delete the record.
dbContext.Databases.Remove(_database);
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);
}
status = new questStatus(Severity.Success, "Database successfully deleted. Database.Id=" + databaseId.Id);
if (bLogging)
{
DatabaseLog databaseLog = new DatabaseLog();
databaseLog.Name = "Database.Id=" + databaseId.Id;
databaseLog.Event = "DELETE";
databaseLog.Data = status.ToString();
DatabaseLogId databaseLogId = null;
_dbDatabaseLogsMgr.Create(databaseLog, out databaseLogId);
}
return(status);
}
private questStatus delete(MasterPricingEntities dbContext, ViewId viewId)
{
// Initialize
questStatus status = null;
try
{
// Read all columns for this view.
List <Quest.Services.Dbio.MasterPricing.Columns> _columnsList = null;
status = read(dbContext, viewId, out _columnsList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the records.
dbContext.Columns.RemoveRange(_columnsList);
dbContext.SaveChanges();
}
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));
}
private questStatus update(MasterPricingEntities dbContext, Quest.Functional.Logging.LogSetting logSetting)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
LogSettingId logSettingId = new LogSettingId(logSetting.Id);
Quest.Services.Dbio.MasterPricing.LogSettings _logSetting = null;
status = read(dbContext, out _logSetting);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the record.
BufferMgr.TransferBuffer(logSetting, _logSetting);
dbContext.SaveChanges();
}
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));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* HTTPRequestLogs
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.Logging.HTTPRequestLog httpRequestLog, out HTTPRequestLogId httpRequestLogId)
{
// Initialize
httpRequestLogId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.HTTPRequestLogs _httpRequestLog = new Quest.Services.Dbio.MasterPricing.HTTPRequestLogs();
BufferMgr.TransferBuffer(httpRequestLog, _httpRequestLog);
dbContext.HTTPRequestLogs.Add(_httpRequestLog);
dbContext.SaveChanges();
if (_httpRequestLog.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.Logging.HTTPRequestLog not created"));
}
httpRequestLogId = new HTTPRequestLogId(_httpRequestLog.Id);
}
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));
}
private questStatus read(MasterPricingEntities dbContext, FilterColumnTablesetColumnId filterColumnTablesetColumnId, out Quest.Services.Dbio.MasterPricing.TablesetColumns tablesetColumn)
{
// Initialize
questStatus status = null;
tablesetColumn = null;
try
{
tablesetColumn = dbContext.TablesetColumns.Where(r => r.EntityTypeId == filterColumnTablesetColumnId.EntityTypeId.Id &&
r.TableSetEntityId == filterColumnTablesetColumnId.EntityId.Id &&
r.Name == filterColumnTablesetColumnId.Name).SingleOrDefault();
if (tablesetColumn == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("FilterColumnTablesetColumnId EntityTypeId: {0} EntityId: {1} Name: {2} not found",
filterColumnTablesetColumnId.EntityTypeId.Id, filterColumnTablesetColumnId.EntityId.Id, filterColumnTablesetColumnId.Name))));
}
}
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 Read(DatabaseId databaseId, out List <Quest.Functional.MasterPricing.View> viewList)
{
// Initialize
questStatus status = null;
viewList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.Views> _viewList = null;
status = read(dbContext, databaseId, out _viewList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
viewList = new List <View>();
foreach (Quest.Services.Dbio.MasterPricing.Views _view in _viewList)
{
Quest.Functional.MasterPricing.View view = new View();
BufferMgr.TransferBuffer(_view, view);
viewList.Add(view);
}
}
return(new questStatus(Severity.Success));
}
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(TablesetId tablesetId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, tablesetId);
if (bLogging)
{
FilterLog filterLog = new FilterLog();
filterLog.Database = "";
filterLog.Tableset = "";
filterLog.Name = "Tableset.Id=" + tablesetId.Id.ToString();
filterLog.Event = "DELETE";
filterLog.Data = status.ToString();
FilterLogId filterLogId = null;
_dbFilterLogsMgr.Create(filterLog, out filterLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.Filter filter, out FilterId filterId)
{
// Initialize
questStatus status = null;
filterId = null;
// Data rules.
// Create the filter
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, filter, out filterId);
if (bLogging)
{
FilterLog filterLog = new FilterLog();
filterLog.Database = "";
filterLog.Tableset = "Tableset.Id=" + filter.TablesetId.ToString();
filterLog.Name = filter.Name == null ? "(null)" : filter.Name;
filterLog.Event = "CREATE";
filterLog.Data = status.ToString();
FilterLogId filterLogId = null;
_dbFilterLogsMgr.Create(filterLog, out filterLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus read(MasterPricingEntities dbContext, FilterTableNameIdentifier filterTableNameIdentifier, out Quest.Services.Dbio.MasterPricing.FilterTables filterTable)
{
// Initialize
filterTable = null;
try
{
filterTable = dbContext.FilterTables.Where(r => r.FilterId == filterTableNameIdentifier.FilterId.Id && r.Schema == filterTableNameIdentifier.Schema && r.Name == filterTableNameIdentifier.Name).SingleOrDefault();
if (filterTable == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("FilterTableNameIdentifier FilterId:{0} Schema:{1} Name:{2} not found",
filterTableNameIdentifier.FilterId.Id, filterTableNameIdentifier.Schema, filterTableNameIdentifier.Name))));
}
}
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 Read(DatabaseId databaseId, out List <Quest.Functional.MasterPricing.Table> tableList)
{
// Initialize
questStatus status = null;
tableList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.Tables> _tableList = null;
status = read(dbContext, databaseId, out _tableList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
tableList = new List <Table>();
foreach (Quest.Services.Dbio.MasterPricing.Tables _table in _tableList)
{
Quest.Functional.MasterPricing.Table table = new Table();
BufferMgr.TransferBuffer(_table, table);
tableList.Add(table);
}
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.Tableset tableset, out TablesetId tablesetId)
{
// Initialize
questStatus status = null;
tablesetId = null;
// Data rules.
// Create the tableset
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, tableset, out tablesetId);
if (bLogging)
{
TablesetLog tablesetLog = new TablesetLog();
tablesetLog.Database = "Database.Id=" + tableset.DatabaseId.ToString();
tablesetLog.Name = tableset.Name == null ? "(null)" : tableset.Name;
tablesetLog.Event = "CREATE";
tablesetLog.Data = status.ToString();
TablesetLogId tablesetLogId = null;
_dbTablesetLogsMgr.Create(tablesetLog, out tablesetLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus read(MasterPricingEntities dbContext, FolderId folderId, out List <Quest.Services.Dbio.MasterPricing.FilterFolders> filterFolderList)
{
// Initialize
filterFolderList = null;
try
{
if (folderId == null || folderId.Id < BaseId.VALID_ID)
{
filterFolderList = dbContext.FilterFolders.Where(r => r.FolderId == null).ToList();
}
else
{
filterFolderList = dbContext.FilterFolders.Where(r => r.FolderId == folderId.Id).ToList();
}
if (filterFolderList == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("FolderId {0} not found", folderId.Id))));
}
}
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));
}
private questStatus read(MasterPricingEntities dbContext, TablesetId tablesetId, out Quest.Services.Dbio.MasterPricing.Tablesets tableset)
{
// Initialize
questStatus status = null;
tableset = null;
try
{
tableset = dbContext.Tablesets.Where(r => r.Id == tablesetId.Id).SingleOrDefault();
if (tableset == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", tablesetId.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 Update(Quest.Functional.MasterPricing.Tableset tableset)
{
// Initialize
questStatus status = null;
// If the database was changed, delete the tablset configuration and any filters based on the tableset
questStatus status2 = RemoveTablesetInfoIFDbChanged(tableset);
if (!questStatusDef.IsSuccess(status2))
{
return(status2);
}
// Perform update.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = update(dbContext, tableset);
if (bLogging)
{
TablesetLog tablesetLog = new TablesetLog();
tablesetLog.Database = "Database.Id=" + tableset.DatabaseId.ToString();
tablesetLog.Name = tableset.Name == null ? "(null)" : tableset.Name;
tablesetLog.Event = "UPDATE";
tablesetLog.Data = status.ToString();
TablesetLogId tablesetLogId = null;
_dbTablesetLogsMgr.Create(tablesetLog, out tablesetLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(status2);
}
private questStatus read(MasterPricingEntities dbContext, DatabaseId databaseId, out List <Quest.Services.Dbio.MasterPricing.Views> viewsList)
{
// Initialize
questStatus status = null;
viewsList = null;
try
{
viewsList = dbContext.Views.Where(r => r.DatabaseId == databaseId.Id).ToList();
if (viewsList == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("DatabaseId {0} not found", databaseId.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));
}
private questStatus read(MasterPricingEntities dbContext, string name, out Quest.Services.Dbio.MasterPricing.Lookups lookup)
{
// Initialize
questStatus status = null;
lookup = null;
try
{
lookup = dbContext.Lookups.Where(r => r.Name == name).SingleOrDefault();
if (lookup == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Name {0} not found", name))));
}
}
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));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* FilterLogs
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.Logging.FilterLog filterLog, out FilterLogId filterLogId)
{
// Initialize
filterLogId = null;
// Initialize
filterLog.UserSessionId = this.UserSession.Id;
filterLog.Username = this.UserSession.User.Username;
filterLog.Created = DateTime.Now;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.FilterLogs _filterLog = new Quest.Services.Dbio.MasterPricing.FilterLogs();
BufferMgr.TransferBuffer(filterLog, _filterLog);
dbContext.FilterLogs.Add(_filterLog);
dbContext.SaveChanges();
if (_filterLog.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.Logging.FilterLog not created"));
}
filterLogId = new FilterLogId(_filterLog.Id);
}
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 Read(FolderId folderId, out List <Quest.Functional.MasterPricing.Filter> filterList)
{
// Initialize
questStatus status = null;
filterList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.Filters> _filtersList = null;
status = read(dbContext, folderId, out _filtersList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterList = new List <Filter>();
foreach (Quest.Services.Dbio.MasterPricing.Filters _filter in _filtersList)
{
Quest.Functional.MasterPricing.Filter filter = new Quest.Functional.MasterPricing.Filter();
BufferMgr.TransferBuffer(_filter, filter);
filterList.Add(filter);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Read(StoredProcedureId storedProcedureId, out List <Quest.Functional.MasterPricing.StoredProcedureParameter> storedProcedureParameterList)
{
// Initialize
questStatus status = null;
storedProcedureParameterList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.StoredProcedureParameters> _storedProcedureParametersList = null;
status = read(dbContext, storedProcedureId, out _storedProcedureParametersList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
storedProcedureParameterList = new List <StoredProcedureParameter>();
foreach (Quest.Services.Dbio.MasterPricing.StoredProcedureParameters _storedProcedureParameter in _storedProcedureParametersList)
{
Quest.Functional.MasterPricing.StoredProcedureParameter storedProcedureParameter = new Quest.Functional.MasterPricing.StoredProcedureParameter();
BufferMgr.TransferBuffer(_storedProcedureParameter, storedProcedureParameter);
storedProcedureParameterList.Add(storedProcedureParameter);
}
}
return(new questStatus(Severity.Success));
}
private questStatus create(MasterPricingEntities dbContext, List <Quest.Functional.MasterPricing.Filter> filterList, out List <Quest.Functional.MasterPricing.Filter> filterIdList)
{
// Initialize
filterIdList = null;
// Perform create
try
{
List <Quest.Services.Dbio.MasterPricing.Filters> _filterList = new List <Quest.Services.Dbio.MasterPricing.Filters>();
foreach (Quest.Functional.MasterPricing.Filter filter in filterList)
{
Quest.Services.Dbio.MasterPricing.Filters _filter = new Quest.Services.Dbio.MasterPricing.Filters();
BufferMgr.TransferBuffer(filter, _filter);
_filterList.Add(_filter);
}
dbContext.Filters.AddRange(_filterList);
dbContext.SaveChanges();
filterIdList = new List <Filter>();
foreach (Quest.Services.Dbio.MasterPricing.Filters _filter in _filterList)
{
Quest.Functional.MasterPricing.Filter filter = new Filter();
filter.Id = _filter.Id;
filterIdList.Add(filter);
}
}
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));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* FilterColumns
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.FilterOperator filterOperator, out FilterOperatorId filterOperatorId)
{
// Initialize
filterOperatorId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.FilterOperators _filterOperators = new Quest.Services.Dbio.MasterPricing.FilterOperators();
BufferMgr.TransferBuffer(filterOperator, _filterOperators);
dbContext.FilterOperators.Add(_filterOperators);
dbContext.SaveChanges();
if (_filterOperators.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.FilterOperator not created"));
}
filterOperatorId = new FilterOperatorId(_filterOperators.Id);
}
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));
}
private questStatus read(MasterPricingEntities dbContext, DatabaseId databaseId, string schema, string name, out Quest.Services.Dbio.MasterPricing.Tables table)
{
// Initialize
questStatus status = null;
table = null;
try
{
table = dbContext.Tables.Where(r => r.DatabaseId == databaseId.Id && r.Schema == schema && r.Name == name).SingleOrDefault();
if (table == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Schema {0} Name {1} not found", schema, name))));
}
}
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 Methods
*=================================================================================================================================*/
#region Filters
//
// Filters
//
public questStatus DeleteFilter(FilterId filterId)
{
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
int numRows = dbContext.DeleteFilterById(filterId.Id);
if (numRows < 1)
{
return(new questStatus(Severity.Error, String.Format("Filter {0} was not deleted", filterId.Id)));
}
}
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, DatabaseId databaseId)
{
// Initialize
questStatus status = null;
try
{
// Read all storedProcedures for this stored.
List <Quest.Services.Dbio.MasterPricing.StoredProcedures> _storedProceduresList = null;
status = read(dbContext, databaseId, out _storedProceduresList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete their parameters.
DbStoredProcedureParametersMgr dbStoredProcedureParametersMgr = new DbStoredProcedureParametersMgr(this.UserSession);
foreach (Quest.Services.Dbio.MasterPricing.StoredProcedures _storedProcedure in _storedProceduresList)
{
StoredProcedureId storedProcedureId = new StoredProcedureId(_storedProcedure.Id);
status = dbStoredProcedureParametersMgr.Delete(storedProcedureId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
// Delete the records.
dbContext.StoredProcedures.RemoveRange(_storedProceduresList);
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 create(MasterPricingEntities dbContext, List <Quest.Functional.MasterPricing.Table> tableList, out List <Quest.Functional.MasterPricing.Table> tableIdList)
{
// Initialize
questStatus status = null;
tableIdList = null;
// Perform create
try
{
List <Quest.Services.Dbio.MasterPricing.Tables> _tableList = new List <Tables>();
foreach (Quest.Functional.MasterPricing.Table table in tableList)
{
Quest.Services.Dbio.MasterPricing.Tables _table = new Quest.Services.Dbio.MasterPricing.Tables();
BufferMgr.TransferBuffer(table, _table);
_tableList.Add(_table);
}
dbContext.Tables.AddRange(_tableList);
dbContext.SaveChanges();
tableIdList = new List <Table>();
foreach (Quest.Services.Dbio.MasterPricing.Tables _table in _tableList)
{
Quest.Functional.MasterPricing.Table table = new Table();
BufferMgr.TransferBuffer(_table, table);
tableIdList.Add(table);
}
}
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));
}