#Script Pages

<back to all web services

QueryCustomers

import 'package:servicestack/servicestack.dart';

// @DataContract
abstract class QueryBase
{
    // @DataMember(Order=1)
    int? skip;

    // @DataMember(Order=2)
    int? take;

    // @DataMember(Order=3)
    String? orderBy;

    // @DataMember(Order=4)
    String? orderByDesc;

    // @DataMember(Order=5)
    String? include;

    // @DataMember(Order=6)
    String? fields;

    // @DataMember(Order=7)
    Map<String,String?>? meta;

    QueryBase({this.skip,this.take,this.orderBy,this.orderByDesc,this.include,this.fields,this.meta});
    QueryBase.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        skip = json['skip'];
        take = json['take'];
        orderBy = json['orderBy'];
        orderByDesc = json['orderByDesc'];
        include = json['include'];
        fields = json['fields'];
        meta = JsonConverters.toStringMap(json['meta']);
        return this;
    }

    Map<String, dynamic> toJson() => {
        'skip': skip,
        'take': take,
        'orderBy': orderBy,
        'orderByDesc': orderByDesc,
        'include': include,
        'fields': fields,
        'meta': meta
    };

    getTypeName() => "QueryBase";
    TypeContext? context = _ctx;
}

abstract class QueryDb<T> extends QueryBase
{
    QueryDb();
    QueryDb.fromJson(Map<String, dynamic> json) : super.fromJson(json);
    fromMap(Map<String, dynamic> json) {
        super.fromMap(json);
        return this;
    }

    Map<String, dynamic> toJson() => super.toJson();
    getTypeName() => "QueryDb<$T>";
    TypeContext? context = _ctx;
}

class Order implements IConvertible
{
    int? orderId;
    String? customerId;
    DateTime? orderDate;
    double? total;

    Order({this.orderId,this.customerId,this.orderDate,this.total});
    Order.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        orderId = json['orderId'];
        customerId = json['customerId'];
        orderDate = JsonConverters.fromJson(json['orderDate'],'DateTime',context!);
        total = JsonConverters.toDouble(json['total']);
        return this;
    }

    Map<String, dynamic> toJson() => {
        'orderId': orderId,
        'customerId': customerId,
        'orderDate': JsonConverters.toJson(orderDate,'DateTime',context!),
        'total': total
    };

    getTypeName() => "Order";
    TypeContext? context = _ctx;
}

class Customer implements IConvertible
{
    String? customerId;
    String? companyName;
    String? address;
    String? city;
    String? region;
    String? postalCode;
    String? country;
    String? phone;
    String? fax;
    List<Order>? orders;

    Customer({this.customerId,this.companyName,this.address,this.city,this.region,this.postalCode,this.country,this.phone,this.fax,this.orders});
    Customer.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        customerId = json['customerId'];
        companyName = json['companyName'];
        address = json['address'];
        city = json['city'];
        region = json['region'];
        postalCode = json['postalCode'];
        country = json['country'];
        phone = json['phone'];
        fax = json['fax'];
        orders = JsonConverters.fromJson(json['orders'],'List<Order>',context!);
        return this;
    }

    Map<String, dynamic> toJson() => {
        'customerId': customerId,
        'companyName': companyName,
        'address': address,
        'city': city,
        'region': region,
        'postalCode': postalCode,
        'country': country,
        'phone': phone,
        'fax': fax,
        'orders': JsonConverters.toJson(orders,'List<Order>',context!)
    };

    getTypeName() => "Customer";
    TypeContext? context = _ctx;
}

class QueryCustomers extends QueryDb<Customer> implements IConvertible
{
    String? customerId;
    String? companyNameContains;
    List<String>? countryIn;

    QueryCustomers({this.customerId,this.companyNameContains,this.countryIn});
    QueryCustomers.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        super.fromMap(json);
        customerId = json['customerId'];
        companyNameContains = json['companyNameContains'];
        countryIn = JsonConverters.fromJson(json['countryIn'],'List<String>',context!);
        return this;
    }

    Map<String, dynamic> toJson() => super.toJson()..addAll({
        'customerId': customerId,
        'companyNameContains': companyNameContains,
        'countryIn': JsonConverters.toJson(countryIn,'List<String>',context!)
    });

    getTypeName() => "QueryCustomers";
    TypeContext? context = _ctx;
}

// @DataContract
class QueryResponse<Customer> implements IConvertible
{
    // @DataMember(Order=1)
    int? offset;

    // @DataMember(Order=2)
    int? total;

    // @DataMember(Order=3)
    List<Customer>? results;

    // @DataMember(Order=4)
    Map<String,String?>? meta;

    // @DataMember(Order=5)
    ResponseStatus? responseStatus;

    QueryResponse({this.offset,this.total,this.results,this.meta,this.responseStatus});
    QueryResponse.fromJson(Map<String, dynamic> json) { fromMap(json); }

    fromMap(Map<String, dynamic> json) {
        offset = json['offset'];
        total = json['total'];
        results = JsonConverters.fromJson(json['results'],'List<${runtimeGenericTypeDefs(this,[0]).join(",")}>',context!);
        meta = JsonConverters.toStringMap(json['meta']);
        responseStatus = JsonConverters.fromJson(json['responseStatus'],'ResponseStatus',context!);
        return this;
    }

    Map<String, dynamic> toJson() => {
        'offset': offset,
        'total': total,
        'results': JsonConverters.toJson(results,'List<Customer>',context!),
        'meta': meta,
        'responseStatus': JsonConverters.toJson(responseStatus,'ResponseStatus',context!)
    };

    getTypeName() => "QueryResponse<$Customer>";
    TypeContext? context = _ctx;
}

TypeContext _ctx = TypeContext(library: 'sharpscript.net', types: <String, TypeInfo> {
    'Order': TypeInfo(TypeOf.Class, create:() => Order()),
    'Customer': TypeInfo(TypeOf.Class, create:() => Customer()),
    'List<Order>': TypeInfo(TypeOf.Class, create:() => <Order>[]),
    'QueryCustomers': TypeInfo(TypeOf.Class, create:() => QueryCustomers()),
    'List<Customer>': TypeInfo(TypeOf.Class, create:() => <Customer>[]),
    'QueryResponse<Customer>': TypeInfo(TypeOf.Class, create:() => QueryResponse<Customer>()),
});

Dart QueryCustomers 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/QueryCustomers HTTP/1.1 
Host: sharpscript.net 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"customerId":"String","companyNameContains":"String","countryIn":["String"],"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":[{"customerId":"String","companyName":"String","address":"String","city":"String","region":"String","postalCode":"String","country":"String","phone":"String","fax":"String","orders":[{"orderId":0,"customerId":"String","orderDate":"\/Date(-62135596800000-0000)\/","total":0}]}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}