public questStatus Read(Quest.Functional.MasterPricing.StoredProcedureId storedProcedureId, out Quest.Functional.MasterPricing.StoredProcedure storedProcedure)
{
// Initialize
questStatus status = null;
storedProcedure = null;
// Read storedProcedure
status = _dbStoredProceduresMgr.Read(storedProcedureId, out storedProcedure);
if (!questStatusDef.IsSuccess(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));
}