/*==================================================================================================================================
* 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));
}
public questStatus Delete(TablesetId tablesetId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, tablesetId);
if (bLogging)
{
TablesetLog tablesetLog = new TablesetLog();
tablesetLog.Database = "";
tablesetLog.Name = "Tableset.Id=" + tablesetId.Id;
tablesetLog.Event = "DELETE";
tablesetLog.Data = status.ToString();
TablesetLogId tablesetLogId = null;
_dbTablesetLogsMgr.Create(tablesetLog, out tablesetLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, TablesetId tablesetId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, tablesetId);
if (bLogging)
{
TablesetLog tablesetLog = new TablesetLog();
tablesetLog.Database = "";
tablesetLog.Name = "Tableset.Id=" + tablesetId.Id;
tablesetLog.Event = "DELETE";
tablesetLog.Data = status.ToString();
TablesetLogId tablesetLogId = null;
_dbTablesetLogsMgr.Create(tablesetLog, out tablesetLogId);
}
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
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);
}
public questStatus Delete(DeleteLogItemsViewModel deleteLogItemsViewModel)
{
// Initialize
questStatus status = null;
// Build id list
List <TablesetLogId> tablesetLogIdList = new List <TablesetLogId>();
foreach (BaseId baseId in deleteLogItemsViewModel.Items)
{
TablesetLogId tablesetLogId = new TablesetLogId(baseId.Id);
tablesetLogIdList.Add(tablesetLogId);
}
// Delete items
TablesetLogsMgr tablesetLogsMgr = new TablesetLogsMgr(this.UserSession);
status = tablesetLogsMgr.Delete(tablesetLogIdList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
private questStatus update(MasterPricingEntities dbContext, Quest.Functional.Logging.TablesetLog tablesetLog)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
TablesetLogId tablesetLogId = new TablesetLogId(tablesetLog.Id);
Quest.Services.Dbio.MasterPricing.TablesetLogs _tablesetLog = null;
status = read(dbContext, tablesetLogId, out _tablesetLog);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the record.
BufferMgr.TransferBuffer(tablesetLog, _tablesetLog);
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));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* TablesetLogs
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.Logging.TablesetLog tablesetLog, out TablesetLogId tablesetLogId)
{
// Initialize
tablesetLogId = null;
// Initialize
tablesetLog.UserSessionId = this.UserSession.Id;
tablesetLog.Username = this.UserSession.User.Username;
tablesetLog.Created = DateTime.Now;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.TablesetLogs _tablesetLog = new Quest.Services.Dbio.MasterPricing.TablesetLogs();
BufferMgr.TransferBuffer(tablesetLog, _tablesetLog);
dbContext.TablesetLogs.Add(_tablesetLog);
dbContext.SaveChanges();
if (_tablesetLog.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.Logging.TablesetLog not created"));
}
tablesetLogId = new TablesetLogId(_tablesetLog.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 delete(MasterPricingEntities dbContext, TablesetId tablesetId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.Tablesets _tableset = null;
status = read(dbContext, tablesetId, out _tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.Tablesets.Remove(_tableset);
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, "Tableset successfully deleted. TablesetId.Id=" + tablesetId.Id);
if (bLogging)
{
TablesetLog tablesetLog = new TablesetLog();
tablesetLog.Name = "TablesetId.Id=" + tablesetId.Id;
tablesetLog.Event = "DELETE";
tablesetLog.Data = status.ToString();
TablesetLogId tablesetLogId = null;
_dbTablesetLogsMgr.Create(tablesetLog, out tablesetLogId);
}
return(status);
}
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));
}
