using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using MercatorApi;
using MercatorExtensions;
using MercatorUi;

// <CompileWithRoslyn />

namespace MyNameSpace
{
    public class Class1 : MercatorUi.Interfaces.IExec
    {
        public void Main()
        {
            var premierClient = getNomAdresse();
            Dialogs.Stop($"De eerste klant is {premierClient.nom.TrimEnd()} en zijn adres is {premierClient.adresse.TrimEnd()}");
        }

        private (string nom, string adresse) getNomAdresse()
        {
            DataSet ds = Api.Zselect(Globals.RepData, "select top 1 c_nom,c_adresse from CLI");
            if (ds?.Tables[0].Rows.Count > 0)
                return (ds.Tables[0].Rows[0]["c_nom"].ToString(), ds.Tables[0].Rows[0]["c_adresse"].ToString());
            else
                return ("?", "?");
        }
    }
}