ClubManager.Api

FindJournal

**Requires Authentication**
Required role:	API

The following routes are available for this service:
All Verbs	/api/Query/Journal

Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports ClubManager.Api.Services.Query

Namespace Global

    Namespace ClubManager.Api.Services.Query

        <AutoQueryViewer(Description:="", IconUrl:="octicon:database", Title:="Journal")>
        Public Partial Class FindJournal
            Inherits QueryDb(Of JournalInstance)
        End Class

        Public Partial Class JournalInstance
            Public Overridable Property JournalId As Integer
            Public Overridable Property JournalDate As Date
            Public Overridable Property Title As String
            Public Overridable Property Comment As String
            Public Overridable Property MessageType As Integer
            Public Overridable Property UserName As String
            Public Overridable Property Member As MemberInstance
            <References(GetType(MemberInstance))>
            Public Overridable Property MemberId As Integer

            Public Overridable Property Message As MessageInstance
            <References(GetType(MessageInstance))>
            Public Overridable Property MessageId As Nullable(Of Integer)

            Public Overridable Property ViewedDate As Nullable(Of Date)
            Public Overridable Property Deleted As Boolean
            Public Overridable Property Demo As Boolean
            Public Overridable Property Permanent As Boolean
            Public Overridable Property alertDate As Nullable(Of Date)
            Public Overridable Property AssignedToUserId As Nullable(Of Integer)
            Public Overridable Property Completed As Nullable(Of Boolean)
            Public Overridable Property CompletedDate As Nullable(Of Date)
            Public Overridable Property CreatedByUserId As Nullable(Of Integer)
            Public Overridable Property PostponedCount As Integer
            Public Overridable Property SendSMSReminder As Boolean
            Public Overridable Property NoShow As Nullable(Of Boolean)
        End Class

        Public Partial Class LossReasonInstance
            Public Overridable Property LossReasonId As Integer
            Public Overridable Property Reason As String
            Public Overridable Property Deleted As Boolean
            Public Overridable Property Demo As Boolean
            Public Overridable Property Selectable As Boolean
        End Class

        Public Partial Class MemberInstance
            Public Sub New()
                Photo = New Byte(){}
            End Sub

            Public Overridable Property MemberId As Integer
            Public Overridable Property MemberType As Integer
            Public Overridable Property MembershipNumber As String
            Public Overridable Property CardNumber As String
            Public Overridable Property CompanyName As String
            Public Overridable Property Surname As String
            Public Overridable Property Forenames As String
            Public Overridable Property Title As String
            Public Overridable Property Gender As Integer
            Public Overridable Property DateOfBirth As Nullable(Of Date)
            Public Overridable Property Address1 As String
            Public Overridable Property Address2 As String
            Public Overridable Property City As String
            Public Overridable Property County As String
            Public Overridable Property Postcode As String
            Public Overridable Property HomePhone As String
            Public Overridable Property MobilePhone As String
            Public Overridable Property EmailAddress As String
            Public Overridable Property EmailOptOut As Boolean
            Public Overridable Property SmsOptOut As Boolean
            Public Overridable Property PhoneOptOut As Boolean
            Public Overridable Property LetterOptOut As Boolean
            Public Overridable Property DirectDebitAccountHolder As String
            Public Overridable Property DirectDebitAccountNumber As String
            Public Overridable Property DirectDebitSortCode As String
            Public Overridable Property JoinedDate As Nullable(Of Date)
            Public Overridable Property DirectDebitBankAddress As String
            Public Overridable Property FullName As String
            Public Overridable Property ExternalReference As String
            Public Overridable Property Photo As Byte()
            Public Overridable Property PhotoModifiedDate As Nullable(Of Date)
            Public Overridable Property Notes As String
            Public Overridable Property Deleted As Boolean
            Public Overridable Property Demo As Boolean
            Public Overridable Property UseExternalStatus As Boolean
            Public Overridable Property ExternalStatus As Integer
            Public Overridable Property FreeText As String
            Public Overridable Property MemberKey As Nullable(Of Guid)
            Public Overridable Property Balance As Decimal
            Public Overridable Property CreditLimit As Decimal
            Public Overridable Property CreatedDate As Date
            Public Overridable Property ModifiedDate As Nullable(Of Date)
            Public Overridable Property DeletedDate As Nullable(Of Date)
            Public Overridable Property ExternalSource As Integer
            Public Overridable Property RetentionMetric As Nullable(Of Decimal)
            Public Overridable Property MonthlyAttendanceFrequency As Nullable(Of Decimal)
            Public Overridable Property AssignedToUserId As Nullable(Of Integer)
            Public Overridable Property CreatedByUserId As Nullable(Of Integer)
            Public Overridable Property DeletedByUserId As Nullable(Of Integer)
            Public Overridable Property LossReason As LossReasonInstance
            <References(GetType(LossReasonInstance))>
            Public Overridable Property LossReasonId As Nullable(Of Integer)

            Public Overridable Property WonOrLost As Nullable(Of Integer)
            Public Overridable Property WonOrLostDate As Nullable(Of Date)
            Public Overridable Property GiftAidPermission As Boolean
            Public Overridable Property PhotoPermission As Nullable(Of Boolean)
            Public Overridable Property FirstAidPermission As Nullable(Of Boolean)
            Public Overridable Property EmergencyContact As String
            Public Overridable Property WonOrLostByUser As UserInstance
            <References(GetType(UserInstance))>
            Public Overridable Property WonOrLostByUserId As Nullable(Of Integer)

            Public Overridable Property AgreedToTerms As Nullable(Of Date)
            Public Overridable Property OnlineBookingBanned As Boolean
            Public Overridable Property Country As String
            Public Overridable Property FingerprintEnrolled As Nullable(Of Date)
            Public Overridable Property LastPaymentAmount As Nullable(Of Decimal)
            Public Overridable Property Pin As String
            Public Overridable Property ProspectingPoints As Integer
            Public Overridable Property AchievementPoints As Integer
            Public Overridable Property ParentForenames As String
            Public Overridable Property ParentSurname As String
        End Class

        Public Partial Class MessageInstance
            Public Overridable Property MessageId As Integer
            Public Overridable Property DueDate As Date
            Public Overridable Property SentDate As Nullable(Of Date)
            Public Overridable Property Processed As Boolean
            Public Overridable Property Failures As Integer
            Public Overridable Property InstanceId As Nullable(Of Integer)
            Public Overridable Property MessageSid As String
            Public Overridable Property MessageTemplate As MessageTemplateInstance
            <References(GetType(MessageTemplateInstance))>
            Public Overridable Property MessageTemplateId As Nullable(Of Integer)

            Public Overridable Property OpenedDate As Nullable(Of Date)
            Public Overridable Property BouncedDate As Nullable(Of Date)
            Public Overridable Property DeliveredDate As Nullable(Of Date)
            Public Overridable Property UnsubscribedDate As Nullable(Of Date)
            Public Overridable Property SpamReportDate As Nullable(Of Date)
            Public Overridable Property User As UserInstance
            <References(GetType(UserInstance))>
            Public Overridable Property UserId As Nullable(Of Integer)

            Public Overridable Property InstanceType As Nullable(Of Integer)
        End Class

        Public Partial Class MessageTemplateInstance
            Public Overridable Property MessageTemplateId As Integer
            Public Overridable Property Name As String
            Public Overridable Property Subject As String
            Public Overridable Property Body As String
            Public Overridable Property ReportId As Nullable(Of Integer)
            Public Overridable Property TemplateType As Integer
            Public Overridable Property Created As Nullable(Of Date)
            Public Overridable Property CreatedBy As Nullable(Of Integer)
            Public Overridable Property Modified As Nullable(Of Date)
            Public Overridable Property ModifiedBy As Nullable(Of Integer)
            Public Overridable Property Deleted As Nullable(Of Date)
            Public Overridable Property DeletedBy As Nullable(Of Integer)
            Public Overridable Property EventType As Integer
            Public Overridable Property ContentType As Integer
            Public Overridable Property Hidden As Nullable(Of Boolean)
            Public Overridable Property ParentMessageTemplateId As Nullable(Of Integer)
            Public Overridable Property InclusionTags As String
            Public Overridable Property ExclusionTags As String
        End Class

        Public Partial Class UserInstance
            Public Overridable Property UserId As Integer
            Public Overridable Property UserName As String
            Public Overridable Property Name As String
            Public Overridable Property Email As String
            Public Overridable Property MobilePhone As String
            Public Overridable Property Enabled As Boolean
            Public Overridable Property LastLogin As Nullable(Of Date)
            Public Overridable Property Created As Date
            Public Overridable Property Training As Boolean
            Public Overridable Property Deleted As Boolean
            Public Overridable Property CoursesCompleted As Integer
            Public Overridable Property DisplayHomeNotification As Nullable(Of Boolean)
            Public Overridable Property TwoFactorEnabled As Boolean
            Public Overridable Property EmailConfirmed As Boolean
            Public Overridable Property MobilePhoneConfirmed As Boolean
            Public Overridable Property Notifications As Boolean
            Public Overridable Property ChangePassword As Nullable(Of Date)
            Public Overridable Property Activated As Nullable(Of Date)
        End Class
    End Namespace

    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 T)
            Public Sub New()
                Results = New List(Of T)
                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 T)

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

VB.NET FindJournal 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 /api/Query/Journal HTTP/1.1 
Host: api.clubmanagercentral.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: 
	[
		{
			JournalId: 0,
			JournalDate: 0001-01-01,
			Title: String,
			Comment: String,
			MessageType: 0,
			UserName: String,
			Member: 
			{
				MemberId: 0,
				MemberType: 0,
				MembershipNumber: String,
				CardNumber: String,
				CompanyName: String,
				Surname: String,
				Forenames: String,
				Title: String,
				Gender: 0,
				DateOfBirth: 0001-01-01,
				Address1: String,
				Address2: String,
				City: String,
				County: String,
				Postcode: String,
				HomePhone: String,
				MobilePhone: String,
				EmailAddress: String,
				EmailOptOut: False,
				SmsOptOut: False,
				PhoneOptOut: False,
				LetterOptOut: False,
				DirectDebitAccountHolder: String,
				DirectDebitAccountNumber: String,
				DirectDebitSortCode: String,
				JoinedDate: 0001-01-01,
				DirectDebitBankAddress: String,
				FullName: String,
				ExternalReference: String,
				Photo: AA==,
				PhotoModifiedDate: 0001-01-01,
				Notes: String,
				Deleted: False,
				Demo: False,
				UseExternalStatus: False,
				ExternalStatus: 0,
				FreeText: String,
				MemberKey: 00000000000000000000000000000000,
				Balance: 0,
				CreditLimit: 0,
				CreatedDate: 0001-01-01,
				ModifiedDate: 0001-01-01,
				DeletedDate: 0001-01-01,
				ExternalSource: 0,
				RetentionMetric: 0,
				MonthlyAttendanceFrequency: 0,
				AssignedToUserId: 0,
				CreatedByUserId: 0,
				DeletedByUserId: 0,
				LossReason: 
				{
					LossReasonId: 0,
					Reason: String,
					Deleted: False,
					Demo: False,
					Selectable: False
				},
				LossReasonId: 0,
				WonOrLost: 0,
				WonOrLostDate: 0001-01-01,
				GiftAidPermission: False,
				PhotoPermission: False,
				FirstAidPermission: False,
				EmergencyContact: String,
				WonOrLostByUser: 
				{
					UserId: 0,
					UserName: String,
					Name: String,
					Email: String,
					MobilePhone: String,
					Enabled: False,
					LastLogin: 0001-01-01,
					Created: 0001-01-01,
					Training: False,
					Deleted: False,
					CoursesCompleted: 0,
					DisplayHomeNotification: False,
					TwoFactorEnabled: False,
					EmailConfirmed: False,
					MobilePhoneConfirmed: False,
					Notifications: False,
					ChangePassword: 0001-01-01,
					Activated: 0001-01-01
				},
				WonOrLostByUserId: 0,
				AgreedToTerms: 0001-01-01,
				OnlineBookingBanned: False,
				Country: String,
				FingerprintEnrolled: 0001-01-01,
				LastPaymentAmount: 0,
				Pin: String,
				ProspectingPoints: 0,
				AchievementPoints: 0,
				ParentForenames: String,
				ParentSurname: String
			},
			MemberId: 0,
			Message: 
			{
				MessageId: 0,
				DueDate: 0001-01-01,
				SentDate: 0001-01-01,
				Processed: False,
				Failures: 0,
				InstanceId: 0,
				MessageSid: String,
				MessageTemplate: 
				{
					MessageTemplateId: 0,
					Name: String,
					Subject: String,
					Body: String,
					ReportId: 0,
					TemplateType: 0,
					Created: 0001-01-01,
					CreatedBy: 0,
					Modified: 0001-01-01,
					ModifiedBy: 0,
					Deleted: 0001-01-01,
					DeletedBy: 0,
					EventType: 0,
					ContentType: 0,
					Hidden: False,
					ParentMessageTemplateId: 0,
					InclusionTags: String,
					ExclusionTags: String
				},
				MessageTemplateId: 0,
				OpenedDate: 0001-01-01,
				BouncedDate: 0001-01-01,
				DeliveredDate: 0001-01-01,
				UnsubscribedDate: 0001-01-01,
				SpamReportDate: 0001-01-01,
				User: 
				{
					UserId: 0,
					UserName: String,
					Name: String,
					Email: String,
					MobilePhone: String,
					Enabled: False,
					LastLogin: 0001-01-01,
					Created: 0001-01-01,
					Training: False,
					Deleted: False,
					CoursesCompleted: 0,
					DisplayHomeNotification: False,
					TwoFactorEnabled: False,
					EmailConfirmed: False,
					MobilePhoneConfirmed: False,
					Notifications: False,
					ChangePassword: 0001-01-01,
					Activated: 0001-01-01
				},
				UserId: 0,
				InstanceType: 0
			},
			MessageId: 0,
			ViewedDate: 0001-01-01,
			Deleted: False,
			Demo: False,
			Permanent: False,
			alertDate: 0001-01-01,
			AssignedToUserId: 0,
			Completed: False,
			CompletedDate: 0001-01-01,
			CreatedByUserId: 0,
			PostponedCount: 0,
			SendSMSReminder: False,
			NoShow: False
		}
	],
	Meta: 
	{
		String: String
	},
	ResponseStatus: 
	{
		ErrorCode: String,
		Message: String,
		StackTrace: String,
		Errors: 
		[
			{
				ErrorCode: String,
				FieldName: String,
				Message: String,
				Meta: 
				{
					String: String
				}
			}
		],
		Meta: 
		{
			String: String
		}
	}
}