public questStatus Update(DbMgrTransaction trans, GroupPrivilege groupPrivilege)
{
// Initialize
questStatus status = null;
bool bCreateTransaction = trans == null;
// Perform update in this transaction.
status = update((FMSEntities)trans.DbContext, groupPrivilege);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, FolderId folderId, out List <Quest.Functional.MasterPricing.Filter> filterList)
{
// Initialize
questStatus status = null;
filterList = null;
// Read filter
status = _dbFiltersMgr.Read(trans, folderId, out filterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Update(DbMgrTransaction trans, Quest.Functional.Logging.StoredProcedureLog storedProcedureLog)
{
// Initialize
questStatus status = null;
bool bCreateTransaction = trans == null;
// Perform update in this transaction.
status = update((MasterPricingEntities)trans.DbContext, storedProcedureLog);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, UserPrivilegeId userPrivilegeId, out UserPrivilege userPrivilege)
{
// Initialize
questStatus status = null;
userPrivilege = null;
// Read userPrivilege
status = _dbUserPrivilegesMgr.Read(trans, userPrivilegeId, out userPrivilege);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, PrivilegeId privilegeId, out PrivilegeUserList privilegeUserList)
{
// Initialize
questStatus status = null;
privilegeUserList = null;
// Read userPrivilege
status = _dbUserPrivilegesMgr.Read(trans, privilegeId, out privilegeUserList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, TableId tableId, out Table table)
{
// Initialize
questStatus status = null;
table = null;
// Read table
status = _dbTablesMgr.Read(trans, tableId, out table);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Table table, out TableId tableId)
{
// Initialize
questStatus status = null;
tableId = null;
// Create table
status = _dbTablesMgr.Create(trans, table, out tableId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, List <Quest.Functional.MasterPricing.FilterValue> filterValueList, out List <Quest.Functional.MasterPricing.FilterValue> filterValueIdList)
{
// Initialize
questStatus status = null;
filterValueIdList = null;
// Create filterValue
status = _dbFilterValuesMgr.Create(trans, filterValueList, out filterValueIdList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, List <Quest.Functional.MasterPricing.Table> tableList, out List <Quest.Functional.MasterPricing.Table> tableIdList)
{
// Initialize
questStatus status = null;
tableIdList = null;
// Create table
status = _dbTablesMgr.Create(trans, tableList, out tableIdList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Filter filter, out FilterId filterId)
{
// Initialize
questStatus status = null;
filterId = null;
// Create filter
status = _dbFiltersMgr.Create(trans, filter, out filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, FilterOperationId filterOperationId, out List <FilterValue> filterValueList)
{
// Initialize
questStatus status = null;
filterValueList = null;
// Read filterValue
status = _dbFilterValuesMgr.Read(trans, filterOperationId, out filterValueList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, UserId userId, out UserGroupList userGroupList)
{
// Initialize
questStatus status = null;
userGroupList = null;
// Read groupUser
status = _dbGroupUsersMgr.Read(trans, userId, out userGroupList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, GroupUserId groupUserId, out GroupUser groupUser)
{
// Initialize
questStatus status = null;
groupUser = null;
// Read groupUser
status = _dbGroupUsersMgr.Read(trans, groupUserId, out groupUser);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, string name, out Quest.Functional.MasterPricing.Filter filter)
{
// Initialize
questStatus status = null;
filter = null;
// Read filter
status = _dbFiltersMgr.Read(trans, name, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, FilterId filterId, out Filter filter)
{
// Initialize
questStatus status = null;
filter = null;
// Read filter
status = _dbFiltersMgr.Read(trans, filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(List <FilterLogId> filterLogIdList)
{
// Initialize
questStatus status = null;
DbMgrTransaction trans = null;
Mgr mgr = new Mgr(this.UserSession);
try
{
// BEGIN TRANSACTION
status = mgr.BeginTransaction("Delete_FilterLogEntries_" + Guid.NewGuid().ToString(), out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete filterLogId
foreach (FilterLogId filterLogId in filterLogIdList)
{
status = _dbFilterLogsMgr.Delete(trans, filterLogId);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
}
// COMMIT TRANSACTION
status = mgr.CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
catch (System.Exception ex)
{
if (trans != null)
{
mgr.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)));
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
questStatus status = null;
userPrivilegeId = null;
// Create userPrivilege
status = _dbUserPrivilegesMgr.Create(trans, userPrivilege, out userPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, TablesetId tablesetId, out List <Filter> filterList)
{
// Initialize
questStatus status = null;
filterList = null;
// Get all filters for this tableset.
DbFilterMgr dbFilterMgr = new DbFilterMgr(this.UserSession);
status = dbFilterMgr.Read(trans, tablesetId, out filterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, GroupPrivilege groupPrivilege, out GroupPrivilegeId groupPrivilegeId)
{
// Initialize
questStatus status = null;
groupPrivilegeId = null;
// Create groupPrivilege
status = _dbGroupPrivilegesMgr.Create(trans, groupPrivilege, out groupPrivilegeId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus RemoveTablesetInfoIFDbChanged(Tableset tableset)
{
// Initialize
questStatus status = null;
// Start a new transaction
string transactionName = null;
status = GetUniqueTransactionName("ClearTablesetConfiguration" + tableset.Id.ToString(), out transactionName);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
DbMgrTransaction trans = null;
status = BeginTransaction(transactionName, out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Remove all tableset configuration and filters based on the tableset.
questStatus status2 = RemoveTablesetInfoIFDbChanged(trans, tableset);
if (!questStatusDef.IsSuccess(status2))
{
// IF warning, it means the filters were removed due to the database changing on the tableset.
if (!questStatusDef.IsWarning(status2))
{
RollbackTransaction(trans);
return(status);
}
}
// Commit transaction
status = CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(status2);
}
public questStatus Update(DbMgrTransaction trans, Quest.Functional.MasterPricing.Tableset tableset)
{
// Initialize
questStatus status = null;
bool bCreateTransaction = trans == null;
// Remove all tableset info and filters based on the tableset if the database changed.
bool bFiltersRemoved = false;
status = RemoveTablesetInfoIFDbChanged(trans, tableset);
if (!questStatusDef.IsSuccess(status))
{
if (questStatusDef.IsWarning(status))
{
bFiltersRemoved = true;
}
else
{
return(status);
}
}
// Perform update in this transaction.
status = update((MasterPricingEntities)trans.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);
}
if (bFiltersRemoved)
{
return(new questStatus(Severity.Warning, "Tableset database was changed. All tableset filters were deleted."));
}
return(new questStatus(Severity.Success));
}
public questStatus Update(DbMgrTransaction trans, Tableset tableset)
{
// Initialize
questStatus status = null;
// Last refresh is creation date
tableset.LastRefresh = DateTime.Now;
// Update tableset
status = _dbTablesetsMgr.Update(trans, tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, List <Quest.Functional.MasterPricing.FilterValue> filterValueList, out List <Quest.Functional.MasterPricing.FilterValue> filterValueIdList)
{
// Initialize
questStatus status = null;
filterValueIdList = null;
// Data rules.
// Create the filterValues in this transaction.
status = create((MasterPricingEntities)trans.DbContext, filterValueList, out filterValueIdList);
if (!questStatusDef.IsSuccess(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));
}
public questStatus SetPassword(DbMgrTransaction trans, PasswordPair passwordPair)
{
// Initialize
questStatus status = null;
// Data rules.
passwordPair.Modified = DateTime.Now;
passwordPair.Password = _aesEncryption.Encrypt(passwordPair.Password);
// Set the password in this transaction.
status = setPassword((FMSEntities)trans.DbContext, passwordPair);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.StoredProcedureParameter storedProcedureParameter, out StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
storedProcedureParameterId = null;
// Data rules.
// Create the storedProcedureParameter in this transaction.
status = create((MasterPricingEntities)trans.DbContext, storedProcedureParameter, out storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.Lookup lookup, out LookupId lookupId)
{
// Initialize
questStatus status = null;
lookupId = null;
// Data rules.
// Create the lookup in this transaction.
status = create((MasterPricingEntities)trans.DbContext, lookup, out lookupId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Quest.Functional.Logging.FilterLog filterLog, out Quest.Functional.Logging.FilterLogId filterLogId)
{
// Initialize
questStatus status = null;
filterLogId = null;
// Data rules.
// Create the filterLog in this transaction.
status = create((MasterPricingEntities)trans.DbContext, filterLog, out filterLogId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Create(DbMgrTransaction trans, Log log, out LogId logId)
{
// Initialize
questStatus status = null;
logId = null;
// Data rules.
log.Created = DateTime.Now;
// Create the log in this transaction.
status = create((PWTrackerLoggingEntities)trans.DbContext, log, out logId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, string name, out Quest.Functional.MasterPricing.Filter filter)
{
// Initialize
questStatus status = null;
filter = null;
// Perform read
Quest.Services.Dbio.MasterPricing.Filters _filters = null;
status = read((MasterPricingEntities)trans.DbContext, name, out _filters);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filter = new Quest.Functional.MasterPricing.Filter();
BufferMgr.TransferBuffer(_filters, filter);
return(new questStatus(Severity.Success));
}
