| Required role: | Admin |
using System;
using System.IO;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using MyApp.ServiceInterface;
using MyApp.ServiceModel;
namespace MyApp.ServiceInterface
{
[ValidateRequest("IsAdmin")]
public partial class QueryProducts
: QueryDb<Product>
{
}
}
namespace MyApp.ServiceModel
{
public partial class Customer
: IAddress
{
public virtual int Id { get; set; }
public virtual string Email { get; set; }
public virtual string DisplayName { get; set; }
public virtual string FirstName { get; set; }
public virtual string LastName { get; set; }
public virtual string Company { get; set; }
public virtual string PhoneNumber { get; set; }
public virtual string AddressLine1 { get; set; }
public virtual string AddressLine2 { get; set; }
public virtual string AddressCity { get; set; }
public virtual string AddressZip { get; set; }
public virtual string AddressState { get; set; }
public virtual string AddressCountry { get; set; }
public virtual string StripeCustomerId { get; set; }
public virtual string StripeCouponId { get; set; }
public virtual string Plan { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual bool IsReferrer { get; set; }
public virtual List<Order> Orders { get; set; }
public virtual List<Subscription> Subscriptions { get; set; }
}
public partial class Order
: IAddress
{
public virtual int Id { get; set; }
public virtual int CustomerId { get; set; }
public virtual string ProductName { get; set; }
public virtual string FirstName { get; set; }
public virtual string LastName { get; set; }
public virtual string Email { get; set; }
public virtual string Company { get; set; }
public virtual string PhoneNumber { get; set; }
public virtual string AddressLine1 { get; set; }
public virtual string AddressLine2 { get; set; }
public virtual string AddressCity { get; set; }
public virtual string AddressZip { get; set; }
public virtual string AddressState { get; set; }
public virtual string AddressCountry { get; set; }
public virtual bool AgreeTerms { get; set; }
public virtual string Notes { get; set; }
public virtual string Last4 { get; set; }
public virtual int SubTotal { get; set; }
public virtual string CouponId { get; set; }
public virtual int Discount { get; set; }
public virtual int Tax { get; set; }
public virtual int Total { get; set; }
public virtual int ItemQuantity { get; set; }
public virtual int? AuthorizedQuantity { get; set; }
public virtual int? SubscriptionId { get; set; }
public virtual string LicenseRef { get; set; }
public virtual int? PaymentId { get; set; }
public virtual int? EmailId { get; set; }
public virtual bool Paid { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime ModifiedDate { get; set; }
public virtual string ModifiedBy { get; set; }
public virtual DateTime? CancelledDate { get; set; }
public virtual string CancelledReason { get; set; }
public virtual string IpAddress { get; set; }
public virtual List<OrderDetail> OrderDetails { get; set; }
}
public partial class OrderDetail
{
public virtual int Id { get; set; }
public virtual int OrderId { get; set; }
public virtual int SkuId { get; set; }
public virtual SkuType SkuType { get; set; }
public virtual int Price { get; set; }
public virtual string Description { get; set; }
public virtual int Quantity { get; set; }
public virtual int Total { get; set; }
}
public partial class Product
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime ModifiedDate { get; set; }
public virtual List<Sku> Skus { get; set; }
public virtual bool Active { get; set; }
}
public partial class Sku
{
public virtual int Id { get; set; }
public virtual int ProductId { get; set; }
public virtual SkuType Type { get; set; }
public virtual LicenseFeature Feature { get; set; }
public virtual string Code { get; set; }
public virtual string Name { get; set; }
public virtual string Notes { get; set; }
[Ignore]
public virtual int? MinQty { get; set; }
public virtual int? MaxQty { get; set; }
public virtual int Price { get; set; }
public virtual string Plan { get; set; }
public virtual int DiscountOff { get; set; }
public virtual string DiscountLabelOff { get; set; }
public virtual int ActualPrice { get; set; }
public virtual bool IsPlan { get; set; }
public virtual bool IsRenewal { get; set; }
public virtual int? SubscriptionDurationDays { get; set; }
public virtual int? ExpiryDurationDays { get; set; }
public virtual int? TrialPeriodDays { get; set; }
public virtual int SupportQty { get; set; }
public virtual int? CoresQty { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime ModifiedDate { get; set; }
public virtual LicenseType LicenseType { get; set; }
public virtual bool Active { get; set; }
}
public enum SkuType
{
Product,
PerDev,
PerCore,
Site,
Support,
Training,
Register,
Payment,
}
public partial class Subscription
{
public virtual int Id { get; set; }
public virtual int CustomerId { get; set; }
public virtual string Email { get; set; }
public virtual int SkuId { get; set; }
public virtual string SkuName { get; set; }
public virtual SkuType SkuType { get; set; }
public virtual string Code { get; set; }
public virtual int Quantity { get; set; }
public virtual int SupportQuantity { get; set; }
public virtual int Total { get; set; }
public virtual bool IsPlan { get; set; }
public virtual bool IsRenewal { get; set; }
public virtual int SubscriptionDurationDays { get; set; }
public virtual DateTime? RenewalDate { get; set; }
public virtual string LicenseRef { get; set; }
public virtual string LicenseName { get; set; }
public virtual string LicenseAddress { get; set; }
public virtual LicenseType LicenseType { get; set; }
public virtual DateTime ExpiryDate { get; set; }
public virtual LicenseKey LicenseKey { get; set; }
public virtual string LicenseKeyText { get; set; }
public virtual DateTime CreatedDate { get; set; }
public virtual DateTime ModifiedDate { get; set; }
public virtual DateTime? CancelledDate { get; set; }
public virtual string StripeSubscriptionId { get; set; }
public virtual int? EmailId { get; set; }
public virtual int? EmailRenewalId { get; set; }
public virtual int? EmailExpiredId { get; set; }
public virtual int? RenewalSubscriptionId { get; set; }
public virtual string ExternalRef { get; set; }
public virtual string Notes { get; set; }
public virtual string Error { get; set; }
}
}
namespace ServiceStack
{
[Flags]
public enum LicenseFeature
{
None = 0,
Free = 0,
Premium = 1,
Text = 2,
Client = 4,
Common = 8,
Redis = 16,
RedisSku = 18,
OrmLite = 32,
OrmLiteSku = 34,
ServiceStack = 64,
Server = 128,
Razor = 256,
Admin = 512,
Aws = 1024,
AwsSku = 1026,
All = 2047,
}
public partial class LicenseKey
{
public virtual string Ref { get; set; }
public virtual string Name { get; set; }
public virtual LicenseType Type { get; set; }
public virtual long Meta { get; set; }
public virtual string Hash { get; set; }
public virtual string Halg { get; set; }
public virtual DateTime Expiry { get; set; }
}
public enum LicenseType
{
Free,
FreeIndividual,
FreeOpenSource,
Indie,
Business,
Enterprise,
TextIndie,
TextBusiness,
OrmLiteIndie,
OrmLiteBusiness,
RedisIndie,
RedisBusiness,
AwsIndie,
AwsBusiness,
Trial,
Site,
TextSite,
RedisSite,
OrmLiteSite,
}
[DataContract]
public partial class QueryBase
{
[DataMember(Order=1)]
public virtual int? Skip { get; set; }
[DataMember(Order=2)]
public virtual int? Take { get; set; }
[DataMember(Order=3)]
public virtual string OrderBy { get; set; }
[DataMember(Order=4)]
public virtual string OrderByDesc { get; set; }
[DataMember(Order=5)]
public virtual string Include { get; set; }
[DataMember(Order=6)]
public virtual string Fields { get; set; }
[DataMember(Order=7)]
public virtual Dictionary<string, string> Meta { get; set; }
}
public partial class QueryDb<T>
: QueryBase
{
}
[DataContract]
public partial class QueryResponse<T>
{
[DataMember(Order=1)]
public virtual int Offset { get; set; }
[DataMember(Order=2)]
public virtual int Total { get; set; }
[DataMember(Order=3)]
public virtual List<Customer> Results { get; set; } = [];
[DataMember(Order=4)]
public virtual Dictionary<string, string> Meta { get; set; }
[DataMember(Order=5)]
public virtual ResponseStatus ResponseStatus { get; set; }
}
}
To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /jsv/reply/QueryProducts HTTP/1.1
Host: account.servicestack.net
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,
name: String,
createdDate: 0001-01-01,
modifiedDate: 0001-01-01,
skus:
[
{
id: 0,
productId: 0,
type: Product,
feature: 0,
code: String,
name: String,
notes: String,
maxQty: 0,
price: 0,
plan: String,
discountOff: 0,
discountLabelOff: String,
actualPrice: 0,
isPlan: False,
isRenewal: False,
subscriptionDurationDays: 0,
expiryDurationDays: 0,
trialPeriodDays: 0,
supportQty: 0,
coresQty: 0,
createdDate: 0001-01-01,
modifiedDate: 0001-01-01,
licenseType: Free,
active: False
}
],
active: False
}
],
meta:
{
String: String
},
responseStatus:
{
errorCode: String,
message: String,
stackTrace: String,
errors:
[
{
errorCode: String,
fieldName: String,
message: String,
meta:
{
String: String
}
}
],
meta:
{
String: String
}
}
}