using Microsoft.Extensions.Logging;

using System;

using System.Text.Json;

using System.Threading.Tasks;

​

namespace Celin

{

    class Program

    {

        static async Task Main(string[] args)

        {

            var loggerFactory = LoggerFactory.Create(builder =>

            {

                builder

                    .SetMinimumLevel(LogLevel.Information)

                    .AddConsole();

            });

            var logger = loggerFactory.CreateLogger<Program>();

            logger.LogInformation("Start program...");

​

            var e1 = new AIS.Server("https://demo.steltix.com/jderest/v2/", loggerFactory.CreateLogger<AIS.Server>());

            e1.AuthRequest.username = "demo";

            e1.AuthRequest.password = "demo";

            try

            {

                await e1.AuthenticateAsync();

​

                // Create request

                var def = await e1.RequestAsync<JsonElement>(new AIS.DatabrowserRequest

                {

                    // We are going to browse table data

                    dataServiceType = AIS.DatabrowserRequest.BROWSE,

                    // Table name

                    targetName = "F4311",

                    // It's a table, not a view

                    targetType = AIS.DatabrowserRequest.table,

                    // We only want the layout

                    formServiceDemo = "TRUE"

                });

                // Dump the Definition out

                Console.WriteLine(def);

​

                // Fetch some data using the concrete class definition

                var qry = await e1.RequestAsync<F4311.Response>(new F4311.Request

                {

                    // List PO Lines at status 400 using a query

                    query = new AIS.Query

                    {

                        // All conditions must match

                        matchType = AIS.Query.MATCH_ALL,

                        condition = new []

                        {

                            // Create condition

                            new AIS.Condition

                            {

                                // Specify the field name with the table prefix

                                controlId = "F4311.NXTR",

                                // Specify condition

                                @operator = AIS.Condition.EQUAL,

                                value = new []

                                {

                                    // Set the value for the condition

                                    new AIS.Value

                                    {

                                        content = "400",

                                        specialValueId = AIS.Value.LITERAL

                                    }

                                }

                            }

                        }

                    }

                });

                // Simplify the return parameter

                var d = qry.fs_DATABROWSE_F4311.data.gridData;

                // Dump the query result

                Console.WriteLine("Returned {0} records, there are {1}more.", d.summary.records, d.summary.moreRecords ? string.Empty : "no ");

                foreach (var r in d.rowset)

                {

                    Console.WriteLine("{0,8} {1} {2,8} {3,-20} {4,-30} {5,-30} {6,12} {7,14:N}", r.F4311_DOCO, r.F4311_DCTO, r.F4311_AN8, r.F4311_LITM, r.F4311_DSC1, r.F4311_DSC2, r.F4311_UORG, r.F4311_AEXP);

                }

            }

            catch (Exception ex)

            {

                Console.WriteLine(ex.Message);

            }

            await e1.LogoutAsync();

            logger.LogInformation("Program end!");

        }

    }

    // F4311 Definition

    namespace F4311

    {

            public class Row

        {

            public string F4311_KCOO { get; set; }

            public int F4311_DOCO { get; set; }

            public string F4311_DCTO { get; set; }

            public string F4311_SFXO { get; set; }

            public decimal F4311_LNID { get; set; }

            public string F4311_MCU { get; set; }

            public string F4311_CO { get; set; }

            public string F4311_OKCO { get; set; }

            public string F4311_OORN { get; set; }

            public string F4311_OCTO { get; set; }

            public decimal F4311_OGNO { get; set; }

            public string F4311_RKCO { get; set; }

            public string F4311_RORN { get; set; }

            public string F4311_RCTO { get; set; }

            public decimal F4311_RLLN { get; set; }

            public int F4311_AN8 { get; set; }

            public int F4311_SHAN { get; set; }

            public DateTime F4311_DRQJ { get; set; }

            public DateTime F4311_TRDJ { get; set; }

            public DateTime F4311_PDDJ { get; set; }

            public DateTime F4311_OPDJ { get; set; }

            public DateTime F4311_ADDJ { get; set; }

            public DateTime F4311_CNDJ { get; set; }

            public DateTime F4311_PEFJ { get; set; }

            public DateTime F4311_PPDJ { get; set; }

            public DateTime F4311_PSDJ { get; set; }

            public DateTime F4311_DSVJ { get; set; }

            public DateTime F4311_DGL { get; set; }

            public int F4311_PN { get; set; }

            public string F4311_VR01 { get; set; }

            public string F4311_VR02 { get; set; }

            public int F4311_ITM { get; set; }

            public string F4311_LITM { get; set; }

            public string F4311_LOCN { get; set; }

            public string F4311_LOTN { get; set; }

            public string F4311_DSC1 { get; set; }

            public string F4311_DSC2 { get; set; }

            public string F4311_LNTY { get; set; }

            public string F4311_NXTR { get; set; }

            public string F4311_LTTR { get; set; }

            public string F4311_UOM { get; set; }

            public decimal F4311_UORG { get; set; }

            public decimal F4311_UCHG { get; set; }

            public decimal F4311_UOPN { get; set; }

            public decimal F4311_UREC { get; set; }

            public decimal F4311_CREC { get; set; }

            public decimal F4311_URLV { get; set; }

            public string F4311_OTQY { get; set; }

            public decimal F4311_PRRC { get; set; }

            public decimal F4311_AEXP { get; set; }

            public decimal F4311_ACHG { get; set; }

            public decimal F4311_AOPN { get; set; }

            public decimal F4311_AREC { get; set; }

            public decimal F4311_ARLV { get; set; }

            public decimal F4311_AMC3 { get; set; }

            public decimal F4311_ECST { get; set; }

            public string F4311_CSTO { get; set; }

            public string F4311_CSMP { get; set; }

            public string F4311_PTC { get; set; }

            public string F4311_TX { get; set; }

            public string F4311_EXR1 { get; set; }

            public string F4311_TXA1 { get; set; }

            public string F4311_UOM1 { get; set; }

            public decimal F4311_PQOR { get; set; }

            public string F4311_UOM2 { get; set; }

            public decimal F4311_SQOR { get; set; }

            public int F4311_CTRY { get; set; }

            public int F4311_FY { get; set; }

            public string F4311_LT { get; set; }

            public string F4311_ANI { get; set; }

            public string F4311_AID { get; set; }

            public string F4311_OMCU { get; set; }

            public string F4311_OBJ { get; set; }

            public string F4311_SUB { get; set; }

            public string F4311_SBLT { get; set; }

            public string F4311_SBL { get; set; }

        }

        public class Response : AIS.FormResponse

        {

            public AIS.Form<AIS.FormData<Row>> fs_DATABROWSE_F4311 { get; set; }

        }

        public class Request : AIS.DatabrowserRequest

        {

            public Request()

            {

                outputType = GRID_DATA;

                dataServiceType = BROWSE;

                targetName = "F4311";

                targetType = table;

                returnControlIDs = @"KCOO|DOCO|DCTO|SFXO|LNID|MCU|CO|OKCO|OORN|OCTO|OGNO|RKCO|RORN|RCTO|RLLN|AN8|SHAN|

                    DRQJ|TRDJ|PDDJ|OPDJ|ADDJ|CNDJ|PEFJ|PPDJ|PSDJ|DSVJ|DGL|PN|VR01|VR02|ITM|LITM|LOCN|LOTN|DSC1|DSC2|

                    LNTY|NXTR|LTTR|UOM|UORG|UCHG|UOPN|UREC|CREC|URLV|OTQY|PRRC|AEXP|ACHG|AOPN|AREC|ARLV|AMC3|ECST|

                    CSTO|CSMP|PTC|TX|EXR1|TXA1|UOM1,PQOR|UOM2|SQOR|CTRY|FY|LT|ANI|AID|OMCU|OBJ|SUB|SBLT|SBL";

            }

        }

    }

}

​