/*==================================================================================================================================
* 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(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 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 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 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));
}
