sfgboxapi

<back to all web services

UsersDetailsAutoQueryLookup

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

Namespace Global

    Namespace ServiceStack

        <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 T)
            Inherits QueryBase
        End Class

        <DataContract>
        Public Partial Class QueryResponse(Of Tenants)
            Public Sub New()
                Results = New List(Of Tenants)
                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 Tenants)

            <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 sfgboxapi.ServiceModel

        Public Partial Class UsersDetailsAutoQueryLookup
            Inherits QueryDb(Of UsersDetails)
        End Class
    End Namespace

    Namespace sfgboxapi.ServiceModel.Types

        Public Partial Class Tenants
            <DataMember(Order:=1)>
            <Required>
            Public Overridable Property Id As Long

            <DataMember(Order:=2)>
            <Required>
            <References(GetType(Zones))>
            Public Overridable Property MainZonesId As Long

            <DataMember(Order:=3)>
            Public Overridable Property IsPublic As Boolean
        End Class

        Public Partial Class UsersDetails
            <DataMember(Order:=1)>
            <Required>
            Public Overridable Property Id As Long

            <DataMember(Order:=2)>
            <Required>
            <References(GetType(AppUser))>
            Public Overridable Property AppUserId As Long

            <DataMember(Order:=3)>
            Public Overridable Property Approved As Boolean

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

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

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

            <DataMember(Order:=7)>
            Public Overridable Property Latitude As Double

            <DataMember(Order:=8)>
            Public Overridable Property Longitude As Double

            <DataMember(Order:=9)>
            Public Overridable Property Age As Integer

            <DataMember(Order:=10)>
            Public Overridable Property EthnicGroup As String

            <DataMember(Order:=11)>
            Public Overridable Property Gender As String

            <DataMember(Order:=12)>
            Public Overridable Property IsDisabled As Boolean

            <DataMember(Order:=13)>
            Public Overridable Property DocumentUrl As String

            <DataMember(Order:=14)>
            Public Overridable Property ApplicationDate As Date

            <DataMember(Order:=15)>
            Public Overridable Property ApprovalDate As Date

            <DataMember(Order:=16)>
            Public Overridable Property IsZoneMain As Boolean

            <DataMember(Order:=16)>
            Public Overridable Property PublicAccessGuid As Guid
        End Class
    End Namespace
End Namespace

VB.NET UsersDetailsAutoQueryLookup DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /csv/reply/UsersDetailsAutoQueryLookup HTTP/1.1 
Host: api-stage.smartfarmertech.com 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"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,"appUserId":0,"approved":false,"identificationNumber":"String","passportNumber":"String","address":"String","latitude":0,"longitude":0,"age":0,"ethnicGroup":"String","gender":"String","isDisabled":false,"documentUrl":"String","applicationDate":"\/Date(-62135596800000-0000)\/","approvalDate":"\/Date(-62135596800000-0000)\/","isZoneMain":false,"publicAccessGuid":"00000000000000000000000000000000"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}