Test

<back to all web services

QueryRockstarAuditSubOr

Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports Test.ServiceModel
Imports Test.ServiceModel.Types

Namespace Global

    Namespace ServiceStack

        <DataContract>
        Public Partial Class AuditBase
            <DataMember(Order:=1)>
            Public Overridable Property CreatedDate As Date

            <DataMember(Order:=2)>
            <Required>
            Public Overridable Property CreatedBy As String

            <DataMember(Order:=3)>
            Public Overridable Property ModifiedDate As Date

            <DataMember(Order:=4)>
            <Required>
            Public Overridable Property ModifiedBy As String

            <DataMember(Order:=5)>
            Public Overridable Property DeletedDate As Nullable(Of Date)

            <DataMember(Order:=6)>
            Public Overridable Property DeletedBy As String
        End Class

        <DataContract>
        Public Partial Class QueryBase
            Public Sub New()
                Meta = New Dictionary(Of String, String)
            End Sub

            <DataMember(Order:=1)>
            Public Overridable Property Skip As Nullable(Of Integer)

            <DataMember(Order:=2)>
            Public Overridable Property Take As Nullable(Of Integer)

            <DataMember(Order:=3)>
            Public Overridable Property OrderBy As String

            <DataMember(Order:=4)>
            Public Overridable Property OrderByDesc As String

            <DataMember(Order:=5)>
            Public Overridable Property Include As String

            <DataMember(Order:=6)>
            Public Overridable Property Fields As String

            <DataMember(Order:=7)>
            Public Overridable Property Meta As Dictionary(Of String, String)
        End Class

        Public Partial Class QueryDb(Of From, Into)
            Inherits QueryBase
        End Class

        <DataContract>
        Public Partial Class QueryResponse(Of Poco)
            Public Sub New()
                Results = New List(Of Poco)
                Meta = New Dictionary(Of String, String)
            End Sub

            <DataMember(Order:=1)>
            Public Overridable Property Offset As Integer

            <DataMember(Order:=2)>
            Public Overridable Property Total As Integer

            <DataMember(Order:=3)>
            Public Overridable Property Results As List(Of Poco)

            <DataMember(Order:=4)>
            Public Overridable Property Meta As Dictionary(Of String, String)

            <DataMember(Order:=5)>
            Public Overridable Property ResponseStatus As ResponseStatus
        End Class
    End Namespace

    Namespace Test.ServiceModel

        Public Enum LivingStatus
            Alive
            Dead
        End Enum

        Public Partial Class QueryRockstarAuditSubOr
            Inherits QueryDb(Of RockstarAuditTenant, RockstarAuto)
            Public Overridable Property FirstNameStartsWith As String
            Public Overridable Property AgeOlderThan As Nullable(Of Integer)
        End Class

        Public Partial Class RockstarAuditTenant
            Inherits AuditBase
            Public Overridable Property TenantId As Integer
            Public Overridable Property Id As Integer
            Public Overridable Property FirstName As String
            Public Overridable Property LastName As String
            Public Overridable Property Age As Nullable(Of Integer)
            Public Overridable Property DateOfBirth As Date
            Public Overridable Property DateDied As Nullable(Of Date)
            Public Overridable Property LivingStatus As LivingStatus
        End Class

        Public Partial Class RockstarAuto
            Inherits RockstarBase
            Public Overridable Property Id As Integer
        End Class

        Public Partial Class RockstarBase
            Public Overridable Property FirstName As String
            Public Overridable Property LastName As String
            Public Overridable Property Age As Nullable(Of Integer)
            Public Overridable Property DateOfBirth As Date
            Public Overridable Property DateDied As Nullable(Of Date)
            Public Overridable Property LivingStatus As LivingStatus
        End Class
    End Namespace

    Namespace Test.ServiceModel.Types

        Public Partial Class Poco
            Public Overridable Property Name As String
        End Class
    End Namespace
End Namespace

VB.NET QueryRockstarAuditSubOr DTOs

POST /csv/reply/QueryRockstarAuditSubOr HTTP/1.1 
Host: test.servicestack.net 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"firstNameStartsWith":"String","ageOlderThan":0,"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"offset":0,"total":0,"results":[{"id":0,"firstName":"String","lastName":"String","age":0,"dateOfBirth":"\/Date(-62135596800000-0000)\/","dateDied":"\/Date(-62135596800000-0000)\/","livingStatus":"Alive"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}