Beispiel #1
0
        private bool RetrieveParameters(ref OlymarsDemo.DataClasses.Parameters.spS_tblCategory_Display parameters, ref System.Data.SqlClient.SqlCommand sqlCommand)
        {
            try {
                if (sqlCommand.Parameters["@RETURN_VALUE"].Value != System.DBNull.Value)
                {
                    parameters.internal_Set_RETURN_VALUE((System.Int32)sqlCommand.Parameters["@RETURN_VALUE"].Value);
                }
                else
                {
                    parameters.internal_Set_RETURN_VALUE(System.Data.SqlTypes.SqlInt32.Null);
                }

                return(true);
            }

            catch (System.Data.SqlClient.SqlException sqlException) {
                parameters.internal_UpdateExceptionInformation(sqlException);
                return(false);
            }

            catch (System.Exception exception) {
                parameters.internal_UpdateExceptionInformation(exception);
                return(false);
            }
        }
Beispiel #2
0
 private void ResetParameter(ref OlymarsDemo.DataClasses.Parameters.spS_tblCategory_Display parameters)
 {
     parameters.internal_Set_RETURN_VALUE(System.Data.SqlTypes.SqlInt32.Null);
 }