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

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

namespace PRSDesktop.Integrations.Logikal
{

    public enum LogikalFinishType
    {
        Mill = 0,
        Powdercoated = 1,
        Anodised = 2,
        Galvanised = 3,
        Stainless = 4
    }
    
    public class LogikalFinish : LogikalItem, ILogikalFinish
    {

        public String Code { get; set; }

        public String Description { get; set; }
        
        public double Price { get; set; }

        public override  void ValidateQuery(string sql, List<string> errors)
        {
            ValidateField(sql, nameof(Code), errors);
            ValidateField(sql, nameof(Description), errors);
        }

        public static String SQL = $@"
select distinct 
    c.[ColorName] as {nameof(Code)}, 
    c.[ColorDescription] as {nameof(Description)} 
    b.[PriceCoating] as {nameof(Price)}
from 
    Colors c
left outer join
        profilebars b on c.[ColorId] = b.[LK_ColorId]
where
    coalesce(c.[ColorName],'') <> ''";

    }


}