sfgboxapi

<back to all web services

ProductsMetricsAutoQueryLookup

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 ProductsMetricsAutoQueryLookup
            Inherits QueryDb(Of ProductsMetrics)
        End Class
    End Namespace

    Namespace sfgboxapi.ServiceModel.Types

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

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

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

            <DataMember(Order:=4)>
            <Required>
            <References(GetType(Products))>
            Public Overridable Property ProductsId As Long

            <DataMember(Order:=5)>
            <Required>
            Public Overridable Property PriceKg As Double

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

            <DataMember(Order:=8)>
            Public Overridable Property BetaineMg As Nullable(Of Double)

            <DataMember(Order:=10)>
            Public Overridable Property CalciumMg As Nullable(Of Double)

            <DataMember(Order:=18)>
            Public Overridable Property CholineMg As Nullable(Of Double)

            <DataMember(Order:=20)>
            Public Overridable Property CopperMg As Nullable(Of Double)

            <DataMember(Order:=25)>
            Public Overridable Property FiberG As Nullable(Of Double)

            <DataMember(Order:=27)>
            Public Overridable Property FluorideMg As Nullable(Of Double)

            <DataMember(Order:=29)>
            Public Overridable Property FolateMcg As Nullable(Of Double)

            <DataMember(Order:=31)>
            Public Overridable Property IronMg As Nullable(Of Double)

            <DataMember(Order:=34)>
            Public Overridable Property MagnesiumMg As Nullable(Of Double)

            <DataMember(Order:=36)>
            Public Overridable Property MangeneseMg As Nullable(Of Double)

            <DataMember(Order:=37)>
            Public Overridable Property MonoG As Nullable(Of Double)

            <DataMember(Order:=39)>
            Public Overridable Property NiacinMg As Nullable(Of Double)

            <DataMember(Order:=40)>
            Public Overridable Property Omega3Mg As Nullable(Of Double)

            <DataMember(Order:=41)>
            Public Overridable Property Omega6Mg As Nullable(Of Double)

            <DataMember(Order:=43)>
            Public Overridable Property PanthenicAcidMg As Nullable(Of Double)

            <DataMember(Order:=45)>
            Public Overridable Property PhosphorusMg As Nullable(Of Double)

            <DataMember(Order:=46)>
            Public Overridable Property PolyG As Nullable(Of Double)

            <DataMember(Order:=48)>
            Public Overridable Property PotassiumMg As Nullable(Of Double)

            <DataMember(Order:=50)>
            Public Overridable Property ProteinG As Nullable(Of Double)

            <DataMember(Order:=54)>
            Public Overridable Property RiboflavinMg As Nullable(Of Double)

            <DataMember(Order:=55)>
            Public Overridable Property SaturatedG As Nullable(Of Double)

            <DataMember(Order:=57)>
            Public Overridable Property SeleniumMcg As Nullable(Of Double)

            <DataMember(Order:=59)>
            Public Overridable Property SodiumMg As Nullable(Of Double)

            <DataMember(Order:=60)>
            Public Overridable Property StarchG As Nullable(Of Double)

            <DataMember(Order:=61)>
            Public Overridable Property SugarsG As Nullable(Of Double)

            <DataMember(Order:=63)>
            Public Overridable Property ThiaminMg As Nullable(Of Double)

            <DataMember(Order:=65)>
            Public Overridable Property VitaminAMcg As Nullable(Of Double)

            <DataMember(Order:=67)>
            Public Overridable Property VitaminB12Mcg As Nullable(Of Double)

            <DataMember(Order:=69)>
            Public Overridable Property VitaminB6Mg As Nullable(Of Double)

            <DataMember(Order:=71)>
            Public Overridable Property VitaminCMg As Nullable(Of Double)

            <DataMember(Order:=73)>
            Public Overridable Property VitaminDMg As Nullable(Of Double)

            <DataMember(Order:=75)>
            Public Overridable Property VitaminEMg As Nullable(Of Double)

            <DataMember(Order:=77)>
            Public Overridable Property VitaminKMcg As Nullable(Of Double)

            <DataMember(Order:=79)>
            Public Overridable Property ZincMg As Nullable(Of Double)

            <DataMember(Order:=80)>
            Public Overridable Property TransG As Nullable(Of Double)
        End Class

        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
    End Namespace
End Namespace

VB.NET ProductsMetricsAutoQueryLookup DTOs

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

HTTP + JSV

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

POST /jsv/reply/ProductsMetricsAutoQueryLookup HTTP/1.1 
Host: api-stage.smartfarmertech.com 
Accept: text/jsv
Content-Type: text/jsv
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/jsv
Content-Length: length

{
	offset: 0,
	total: 0,
	results: 
	[
		{
			id: 0,
			tenantsId: 0,
			zonesId: 0,
			productsId: 0,
			priceKg: 0,
			priceDescription: String,
			betaineMg: 0,
			calciumMg: 0,
			cholineMg: 0,
			copperMg: 0,
			fiberG: 0,
			fluorideMg: 0,
			folateMcg: 0,
			ironMg: 0,
			magnesiumMg: 0,
			mangeneseMg: 0,
			monoG: 0,
			niacinMg: 0,
			omega3Mg: 0,
			omega6Mg: 0,
			panthenicAcidMg: 0,
			phosphorusMg: 0,
			polyG: 0,
			potassiumMg: 0,
			proteinG: 0,
			riboflavinMg: 0,
			saturatedG: 0,
			seleniumMcg: 0,
			sodiumMg: 0,
			starchG: 0,
			sugarsG: 0,
			thiaminMg: 0,
			vitaminAMcg: 0,
			vitaminB12Mcg: 0,
			vitaminB6Mg: 0,
			vitaminCMg: 0,
			vitaminDMg: 0,
			vitaminEMg: 0,
			vitaminKMcg: 0,
			zincMg: 0,
			transG: 0
		}
	],
	meta: 
	{
		String: String
	},
	responseStatus: 
	{
		errorCode: String,
		message: String,
		stackTrace: String,
		errors: 
		[
			{
				errorCode: String,
				fieldName: String,
				message: String,
				meta: 
				{
					String: String
				}
			}
		],
		meta: 
		{
			String: String
		}
	}
}