Пример #1
0
        private bool RetrieveParameters(ref Bob.DataClasses.Parameters.spI_Job 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);
                }

                if (sqlCommand.Parameters["@JobId"].Value != System.DBNull.Value)
                {
                    try {
                        parameters.Param_JobId = (System.Data.SqlTypes.SqlInt32)sqlCommand.Parameters["@JobId"].Value;
                    }
                    catch (System.InvalidCastException) {
                        parameters.Param_JobId = (System.Int32)sqlCommand.Parameters["@JobId"].Value;
                    }
                }
                else
                {
                    parameters.Param_JobId = System.Data.SqlTypes.SqlInt32.Null;
                }
                parameters.internal_Param_JobId_UseDefaultValue = false;

                return(true);
            }

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

            catch (System.Exception exception) {
                parameters.internal_UpdateExceptionInformation(exception);
                return(false);
            }
        }
Пример #2
0
 private void ResetParameter(ref Bob.DataClasses.Parameters.spI_Job parameters)
 {
     parameters.internal_Set_RETURN_VALUE(System.Data.SqlTypes.SqlInt32.Null);
 }