public int Execute(object[] storedProcedureParam, string storedProcedureName)
{
const string outParameterName = "result";
InitSimple(storedProcedureName);
foreach (ParameterItem parameterItem in storedProcedureParam)
{
dataProvider.AddInParameter(
parameterItem.ParameterValue,
parameterItem.ParameterName
);
}
dataProvider.AddOutParameter(outParameterName);
try
{
return(dataProvider.ExecuteSpGetResultValue(outParameterName));
}catch
{
}
return(0);
}
public int Execute(StoredProcedure storedProcedure)
{
/// The result value must have some name
const string outParameterName = "result";
int result = 0;
InitSimple(storedProcedure.Name);
foreach (ParameterItem parameterItem in storedProcedure.ParameterValueCollection)
{
dataProvider.AddInParameter(
parameterItem.ParameterValue,
parameterItem.ParameterName);
}
dataProvider.AddOutParameter(outParameterName);
try
{
result = dataProvider.ExecuteSpGetResultValue(outParameterName);
}
catch
{
throw new Exception("Execute(StoredProcedure storedProcedure) has failed to execute");
result = 0;
}
return(result);
}
