| 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 .csv suffix or ?format=csv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /csv/reply/QueryProducts HTTP/1.1
Host: account.servicestack.net
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,"name":"String","createdDate":"\/Date(-62135596800000-0000)\/","modifiedDate":"\/Date(-62135596800000-0000)\/","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":"\/Date(-62135596800000-0000)\/","modifiedDate":"\/Date(-62135596800000-0000)\/","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"}}}