C#

Public Function AddPortalInfo(ByVal PortalName As String, 
   ByVal PortalAlias As String, Optional ByVal Currency As String = "",
   Optional ByVal FirstName As String = "", Optional ByVal LastName As String = "", 
   Optional ByVal Username As String = "", Optional ByVal Password As String = "", 
   Optional ByVal Email As String = "", Optional ByVal ExpiryDate As String = "", 
   Optional ByVal HostFee As Double = 0, Optional ByVal HostSpace As Double = 0, 
   Optional ByVal SiteLogHistory As Integer = -1, <SqlParameter(, , , , , ParameterDirection.Output)> 
   Optional ByVal PortalId As Integer = -1) As Integer
   Dim myConnection As New SqlConnection(GetDBConnectionString)

   ' Generate Command Object based on Method
   Dim myCommand As SqlCommand = SqlCommandGenerator.GenerateCommand(myConnection, _
      CType(MethodBase.GetCurrentMethod(), MethodInfo), _
      New Object() {PortalName, PortalAlias, IIf(Currency <> "", Currency, "USD"), 
      FirstName, LastName, Username, Password, Email, IIf(ExpiryDate <> "", ExpiryDate, SqlInt16.Null), 
      HostFee, HostSpace, IIf(SiteLogHistory <> -1, SiteLogHistory, SqlInt16.Null), PortalId})

   myConnection.Open()
   myCommand.ExecuteNonQuery()
   myConnection.Close()

   Return CInt(myCommand.Parameters("@PortalID").Value)
End Function