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

namespace Comal.Classes
{
    public class LogikalFinish : LogikalItem, ILogikalFinish
    {

        public String Code { get; set; }

        public String Description { 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 \n" +
            $"  c.[PowderID] as {nameof(Code)}, \n" +
            $"  c.[ColorName] as {nameof(Description)} \n" +
            "from \n" +
            "  colors c \n" +
            "where \n" +
            "  c.[PowderID] is not null";

    }


}