private questStatus create(MasterPricingEntities dbContext, List <Quest.Functional.MasterPricing.FilterProcedureParameter> filterProcedureParameterList, out List <Quest.Functional.MasterPricing.FilterProcedureParameter> filterProcedureParameterIdList)
{
// Initialize
filterProcedureParameterIdList = null;
// Perform create
try
{
List <Quest.Services.Dbio.MasterPricing.FilterProcedureParameters> _filterProcedureParameterList = new List <Quest.Services.Dbio.MasterPricing.FilterProcedureParameters>();
foreach (Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter in filterProcedureParameterList)
{
Quest.Services.Dbio.MasterPricing.FilterProcedureParameters _filterProcedureParameter = new Quest.Services.Dbio.MasterPricing.FilterProcedureParameters();
BufferMgr.TransferBuffer(filterProcedureParameter, _filterProcedureParameter);
_filterProcedureParameterList.Add(_filterProcedureParameter);
}
dbContext.FilterProcedureParameters.AddRange(_filterProcedureParameterList);
dbContext.SaveChanges();
filterProcedureParameterIdList = new List <FilterProcedureParameter>();
foreach (Quest.Services.Dbio.MasterPricing.FilterProcedureParameters _filterProcedureParameter in _filterProcedureParameterList)
{
Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter = new FilterProcedureParameter();
filterProcedureParameter.Id = _filterProcedureParameter.Id;
filterProcedureParameterIdList.Add(filterProcedureParameter);
}
}
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 Update(DbMgrTransaction trans, FilterProcedureParameter filterProcedureParameter)
{
// Initialize
questStatus status = null;
// Update filterProcedureParameter
status = _dbFilterProcedureParametersMgr.Update(trans, filterProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.Database database, FilterProcedureParameter filterProcedureParameter, out FilterProcedureParameterId filterProcedureParameterId)
{
// Initialize
questStatus status = null;
filterProcedureParameterId = null;
// Create filterProcedureParameter
status = _dbFilterProcedureParametersMgr.Create(filterProcedureParameter, out filterProcedureParameterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public new questStatus GetStoredProdecureParameters(Quest.Functional.MasterPricing.Database database, string filterProcedureName, out List <FilterProcedureParameter> filterProcedureParameterList)
{
// Initialize
questStatus status = null;
filterProcedureParameterList = null;
// Get stored procedure
DatabaseId databaseId = new DatabaseId(database.Id);
StoredProcedure storedProcedure = null;
StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
status = storedProceduresMgr.Read(databaseId, filterProcedureName, out storedProcedure);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get stored procedure parameters
StoredProcedureId storedProcedureId = new StoredProcedureId(storedProcedure.Id);
List <StoredProcedureParameter> storedProcedureParameterList = null;
StoredProcedureParametersMgr storedProcedureParametersMgr = new StoredProcedureParametersMgr(this.UserSession);
storedProcedureParametersMgr.Read(storedProcedureId, out storedProcedureParameterList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer over to filter procedure.
filterProcedureParameterList = new List <FilterProcedureParameter>();
foreach (StoredProcedureParameter storedProcedureParameter in storedProcedureParameterList)
{
FilterProcedureParameter filterProcedureParameter = new FilterProcedureParameter();
BufferMgr.TransferBuffer(storedProcedureParameter, filterProcedureParameter);
filterProcedureParameterList.Add(filterProcedureParameter);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, FilterProcedureParameterId filterProcedureParameterId, out FilterProcedureParameter filterProcedureParameter)
{
// Initialize
questStatus status = null;
filterProcedureParameter = null;
// Read filterProcedureParameter
status = _dbFilterProcedureParametersMgr.Read(trans, filterProcedureParameterId, out filterProcedureParameter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
