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

namespace PRSDesktop.Integrations.V6
{
    public class V6Component : V6BOMItem, IV6Component
    {
        public double PackSize { get; set; }

        public override void ValidateQuery(string sql, List<string> errors)
        {
            base.ValidateQuery(sql, errors);
            ValidateField(sql, nameof(PackSize), errors);
        }

        public static String SQL = $@"select 
    bc.Part_Code as {nameof(Code)}, 
    c.descr as {nameof(Description)}, 
    1.0 as {nameof(PackSize)}, 
    bc.comp_qty as {nameof(Quantity)}, 
    bc.cost as {nameof(Cost)} 
from 
    bom_comp bc 
left outer join 
    quote_item qi on qi.quote_item_id = bc.quote_item_id 
left outer join 
    quote q on q.quote_id = qi.quote_id 
left outer join 
    componentry c on c.comp_lib_id = bc.comp_lib_id and c.comp_id = bc.comp_id 
where 
    1=1";
        
    }
}