prs/prs.desktop/Integrations/Logikal/Classes/LogikalDiscount.cs

using System.Collections.Generic;
using InABox.Integration.Logikal;

namespace PRSDesktop.Integrations.Logikal;

public class LogikalDiscount : LogikalItem, ILogikalDiscount
{
    public string Code { get; set; }
    public string Description { get; set; }
    public string SupplierCode { get; set; }
    public double Discount { get; set; }
    
    public override void ValidateQuery(string sql, List<string> errors)
    {
        ValidateField(sql, nameof(Code), errors);
        ValidateField(sql, nameof(Description), errors);
        ValidateField(sql, nameof(SupplierCode), errors);
        ValidateField(sql, nameof(Discount), errors);
    }

    public static string SQL =
        $@"select distinct 
	upper(ed.name) as [{nameof(Code)}], 
	ed.name as [{nameof(Description)}], 
	upper(coalesce(s.[CustomerNo],s.[ActiveTitle])) as [{nameof(SupplierCode)}], 
	ed.Discount as [{nameof(Discount)}]
from 
    estimationdiscounts ed
join 
    (select distinct supplierid,lk_discountid from allprofiles union select distinct supplierid,lk_discountid from allarticles) a on a.lk_discountid = ed.estimationdiscountid
join 
    suppliers s on a.supplierid = S.supplierid";
}