ASP.NET

If Not (Profile.UserId = -1) Then<br />
                myContactInfo.UserID = Profile.UserId<br />
<br />
                [ContactInfoManager].Save(myContactInfo)<br />
               <br />
            Else<br />
                Dim result As Integer = ContactInfoManager.Save(myContactInfo)<br />
                Profile.UserId = result<br />
                                )<br />
            End If

Public Shared Function Save(ByVal myContactInfo As ContactInfo) As Integer<br />
            Dim result As Integer = 0<br />
            ' Using<br />
            Dim myConnection As SqlConnection = New SqlConnection(AppConfiguration.ConnectionString)<br />
            Try<br />
                Dim myCommand As SqlCommand = New SqlCommand("JobsDb_ContactInfo_InsertUpdateSingleItem", myConnection)<br />
                myCommand.CommandType = CommandType.StoredProcedure<br />
                                    myCommand.Parameters.AddWithValue("@Userid", UserId)<br />
                <br />
                Dim returnValue As DbParameter<br />
                returnValue = myCommand.CreateParameter<br />
                returnValue.Direction = ParameterDirection.ReturnValue<br />
                myCommand.Parameters.Add(returnValue)<br />
                myConnection.Open()<br />
                myCommand.ExecuteNonQuery()<br />
                result = Convert.ToInt32(returnValue.Value)<br />
<br />
                myConnection.Close()            Finally<br />
                CType(myConnection, IDisposable).Dispose()<br />
            End Try<br />
            Return result<br />
<br />
        End Function