private questStatus read(MasterPricingEntities dbContext, StoredProcedureParameterId storedProcedureParameterId, out Quest.Services.Dbio.MasterPricing.StoredProcedureParameters storedProcedureParameter)
{
// Initialize
questStatus status = null;
storedProcedureParameter = null;
try
{
storedProcedureParameter = dbContext.StoredProcedureParameters.Where(r => r.Id == storedProcedureParameterId.Id).SingleOrDefault();
if (storedProcedureParameter == null)
{
return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", storedProcedureParameterId.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 Delete(DbMgrTransaction trans, StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
// Delete storedProcedureParameter
status = _dbStoredProcedureParametersMgr.Delete(trans, storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(StoredProcedureParameterId storedProcedureParameterId, out StoredProcedureParameter storedProcedureParameter)
{
// Initialize
questStatus status = null;
storedProcedureParameter = null;
// Read storedProcedureParameter
status = _dbStoredProcedureParametersMgr.Read(storedProcedureParameterId, out storedProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* StoredProcedureParameters
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.StoredProcedureParameter storedProcedureParameter, out StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
storedProcedureParameterId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.StoredProcedureParameters _storedProcedureParameters = new Quest.Services.Dbio.MasterPricing.StoredProcedureParameters();
BufferMgr.TransferBuffer(storedProcedureParameter, _storedProcedureParameters);
dbContext.StoredProcedureParameters.Add(_storedProcedureParameters);
dbContext.SaveChanges();
if (_storedProcedureParameters.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.StoredProcedureParameter not created"));
}
storedProcedureParameterId = new StoredProcedureParameterId(_storedProcedureParameters.Id);
}
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));
}
public questStatus Read(DbMgrTransaction trans, StoredProcedureParameterId storedProcedureParameterId, out Quest.Functional.MasterPricing.StoredProcedureParameter storedProcedureParameter)
{
// Initialize
questStatus status = null;
storedProcedureParameter = null;
// Perform read
Quest.Services.Dbio.MasterPricing.StoredProcedureParameters _storedProcedureParameters = null;
status = read((MasterPricingEntities)trans.DbContext, storedProcedureParameterId, out _storedProcedureParameters);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
storedProcedureParameter = new Quest.Functional.MasterPricing.StoredProcedureParameter();
BufferMgr.TransferBuffer(_storedProcedureParameters, storedProcedureParameter);
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.MasterPricing.StoredProcedureParameters _storedProcedureParameters = null;
status = read(dbContext, storedProcedureParameterId, out _storedProcedureParameters);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.StoredProcedureParameters.Remove(_storedProcedureParameters);
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));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.Database database, Quest.Functional.MasterPricing.StoredProcedure storedProcedure, out Quest.Functional.MasterPricing.StoredProcedureId storedProcedureId)
{
// Initialize
questStatus status = null;
storedProcedureId = null;
// Create storedProcedure
status = _dbStoredProceduresMgr.Create(trans, storedProcedure, out storedProcedureId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Store parameters for procedure
List <StoredProcedureParameter> storedProcedureParameterList = null;
status = GetStoredProdecureParameters(database, storedProcedure.Name, out storedProcedureParameterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
StoredProcedureParametersMgr storedProcedureParametersMgr = new StoredProcedureParametersMgr(this.UserSession);
foreach (StoredProcedureParameter storedProcedureParameter in storedProcedureParameterList)
{
storedProcedureParameter.StoredProcedureId = storedProcedureId.Id;
StoredProcedureParameterId storedProcedureParameterId = null;
status = storedProcedureParametersMgr.Create(trans, database, storedProcedureParameter, out storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public questStatus MakeRequired(MakeRequiredViewModel makeRequiredViewModel)
{
// Initialize
questStatus status = null;
Mgr mgr = new Mgr(this.UserSession);
DbMgrTransaction trans = null;
// BEGIN TRANSACTION
status = mgr.BeginTransaction("MakeRequired" + Guid.NewGuid().ToString(), out trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update every parameter as required or not.
StoredProcedureParametersMgr storedProcedureParametersMgr = new StoredProcedureParametersMgr(this.UserSession);
foreach (BaseId baseId in makeRequiredViewModel.Items)
{
// Get the parameter
StoredProcedureParameterId storedProcedureParameterId = new StoredProcedureParameterId(baseId.Id);
StoredProcedureParameter storedProcedureParameter = null;
status = storedProcedureParametersMgr.Read(trans, storedProcedureParameterId, out storedProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
// Make sure same stored procedure
if (makeRequiredViewModel.StoredProcedureId != storedProcedureParameter.StoredProcedureId)
{
mgr.RollbackTransaction(trans);
return(new questStatus(Severity.Error, "All parameter Id's must be from the same stored procedure!"));
}
// Set required flag accordingly and update.
storedProcedureParameter.bRequired = true;
status = storedProcedureParametersMgr.Update(trans, storedProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
}
// Set all the OTHER parameters to false
List <StoredProcedureParameter> storedProcedureParameterList = null;
StoredProcedureId storedProcedureId = new StoredProcedureId(makeRequiredViewModel.StoredProcedureId);
status = storedProcedureParametersMgr.Read(trans, storedProcedureId, out storedProcedureParameterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
foreach (StoredProcedureParameter storedProcedureParameter in storedProcedureParameterList)
{
BaseId baseId = makeRequiredViewModel.Items.Find(delegate(BaseId _baseId) { return(_baseId.Id == storedProcedureParameter.Id); });
if (baseId == null)
{
storedProcedureParameter.bRequired = false;
status = storedProcedureParametersMgr.Update(trans, storedProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
mgr.RollbackTransaction(trans);
return(status);
}
}
}
// COMMIT TRANSACTION
// THIS HAS TO BE COMMITTED HERE TO AVOID DEADLOCKING ON UPDATING THE FILTERS, NEXT.
status = mgr.CommitTransaction(trans);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
////// BEGIN TRANSACTION
////status = mgr.BeginTransaction("MakeRequired_RefreshFilters" + Guid.NewGuid().ToString(), out trans);
////if (!questStatusDef.IsSuccess(status))
////{
//// return (status);
////}
////// Refresh filters using this sproc.
////List<Quest.Functional.MasterPricing.FilterId> updatedFilterIds = null;
////StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
////status = storedProceduresMgr.RefreshFilters(storedProcedureId, out updatedFilterIds);
////if (!questStatusDef.IsSuccess(status))
////{
//// mgr.RollbackTransaction(trans);
//// return (status);
////}
////// COMMIT TRANSACTION
////status = mgr.CommitTransaction(trans);
////if (!questStatusDef.IsSuccess(status))
////{
//// return (status);
////}
////// TODO: REFACTOR TO GET ALL-IN-ONE TRANSACTION
////foreach (FilterId filterId in updatedFilterIds)
////{
//// Quest.Functional.MasterPricing.Filter filterWithSQL = null;
//// FilterMgr filterMgr = new FilterMgr(this.UserSession);
//// status = filterMgr.GenerateFilterSQL(filterId, out filterWithSQL);
//// if (!questStatusDef.IsSuccess(status))
//// {
//// return (status);
//// }
//// // Update filter
//// FiltersMgr filtersMgr = new FiltersMgr(this.UserSession);
//// status = filtersMgr.Update(filterWithSQL);
//// 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));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.StoredProcedureParameter storedProcedureParameter, out StoredProcedureParameterId storedProcedureParameterId)
{
// Initialize
questStatus status = null;
storedProcedureParameterId = null;
// Data rules.
// Create the storedProcedureParameter
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, storedProcedureParameter, out storedProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
