private bool RetrieveParameters(ref Bob.DataClasses.Parameters.spIU_JobPartType 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["@JobPartTypeId"].Value != System.DBNull.Value) { try { parameters.Param_JobPartTypeId = (System.Data.SqlTypes.SqlInt32)sqlCommand.Parameters["@JobPartTypeId"].Value; } catch (System.InvalidCastException) { parameters.Param_JobPartTypeId = (System.Int32)sqlCommand.Parameters["@JobPartTypeId"].Value; } } else { parameters.Param_JobPartTypeId = System.Data.SqlTypes.SqlInt32.Null; } parameters.internal_Param_JobPartTypeId_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); } }
private void ResetParameter(ref Bob.DataClasses.Parameters.spIU_JobPartType parameters) { parameters.internal_Set_RETURN_VALUE(System.Data.SqlTypes.SqlInt32.Null); }