using System.Collections.Generic;
using InABox.Core;

namespace Comal.Classes
{
    public class V6Elevation : V6Object
    {
        [NullEditor]
        public int ID { get; set; }
    
        public string Description { get; set; }
    
        public int Quantity { get; set; }

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

        public static string SQL = 
            "select  \n" +
            $"  qi.quote_item_id as {nameof(ID)}, \n" +
            $"  qi.descr as {nameof(Description)}, \n" +
            $"  qi.quantity as {nameof(Quantity)}  \n" +
            "from  \n" +
            "  Quote_item qi  \n" +
            "left outer join  \n" +
            "  quote q on qi.quote_id = q.quote_id and qi.quote_vers_start >= q.quote_vers and qi.quote_vers_stop <= q.quote_vers  \n" +
            "where  \n" +
            "  1=1";

    }
}