public static int ExecuteStoreProcedureHasReturn(string spName, DataAccessParameterCollection parameters) { using (DataAccessBroker broker = DataAccessFactory.Instance()) { var rowsaffected = broker.ExecuteCommand(spName, parameters); return(1); } }