using System.Collections.Generic;

namespace Comal.Classes
{
    public class V6Glass : V6BOMItem
    {
        
        public string Treatment { get; set; }
        public double Height { get; set; }
        public double Width { get; set; }
        public string Location { get; set; }

        public override void ValidateQuery(string sql, List<string> errors)
        {
            base.ValidateQuery(sql, errors);
            ValidateField(sql, nameof(Treatment), errors);
            ValidateField(sql, nameof(Height), errors);
            ValidateField(sql, nameof(Width), errors);
            ValidateField(sql, nameof(Location), errors);
        }
        
        public static string SQL =
            "select \n" +
            $"  bf.location as {nameof(Location)}, \n" +
            $"  f.fill_code as {nameof(Code)}, \n" +
            $"  f.descr as {nameof(Description)}, \n" +
            $"  bf.fill_height as {nameof(Height)}, \n" +
            $"  bf.fill_width as {nameof(Width)}, \n" +
            $"  bf.fill_count as {nameof(Quantity)}, \n" +
            $"  bf.treatment as {nameof(Treatment)}, \n" +
            $"  bf.cost as {nameof(Cost)} \n" +
            "from \n" +
            "  bom_fill bf \n" +
            "left outer join \n" +
            "  fill f on bf.fill_lib_id = f.fill_lib_id and bf.fill_id = f.fill_id \n" +
            "left outer join \n" +
            "  quote_item qi on qi.quote_item_id = bf.quote_item_id \n" +
            "left outer join \n" +
            "  quote q on q.quote_id = qi.quote_id \n" +
            "where \n" +
            "  1=1";

        

    }
}