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

namespace Comal.Classes
{
    public class LogikalLabour : LogikalBOMItem, ILogikalLabour
    {

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

        public static String SQL =
            "select \n" +
            $"  t.[labourtimeid] as {nameof(Code)}, \n" +
            $"  t.[name] as {nameof(Description)}, \n" +
            $"  t.[totalminutes] as {nameof(Quantity)}, \n" +
            $"  c.[price] as {nameof(Cost)} \n" +
            "from \n" +
            "  labourtimes t \n" +
            "join \n" +
            "  labourcosts c  on t.[timetype] = c.[type] \n" +
            "left outer join \n" +
            "  elevations e on t.[elevationid] = e.[elevationid] \n" +
            "where \n" +
            "  t.[totalminutes] > 0";

    }


}