using System.Collections.Generic;

namespace Comal.Classes
{
 
    public class V6DrawingIndexEntry
    {
        public string FileName { get; set; }
        public string FileType { get; set; }
        public string NodeName { get; set; }
        public string FaceIndex { get; set; }
        public string CutDescriptor { get; set; }
        public string CutLocation { get; set; }
    }
    
    public class V6DrawingIndex
    {
        public V6DrawingIndexEntry[] Files { get; set; } = new V6DrawingIndexEntry[] { };
    
        public string? Version { get; set; }
        
    }
    
    public class V6Drawing
    {
        public string FileName { get; set; }
        public byte[] Data { get; set; }
    }
    
    public class V6Drawings : V6Object
    {

        public byte[] Drawings { get; set; }
        
        
        public override void ValidateQuery(string sql, List<string> errors)
        {
            ValidateField(sql, nameof(Drawings), errors);
        }

        public static string SQL = 
            "select \n" +
            $"  id.drawings as {nameof(Drawings)}  \n" +
            "from  \n" +
            "  quote_item_drawings id  \n" +
            "left outer join \n" +
            "  quote_item qi on qi.quote_item_id = id.quote_item_id \n" +
            "left outer join \n" +
            "  quote q on q.quote_id = qi.quote_id \n" +
            "where  \n" +
            "  1=1";
        
    }
}