prs/prs.desktop/Integrations/Logikal/Grids/LogikalSettingsGrid.cs

using System;
using System.Collections.Generic;
using System.Linq;
using Comal.Classes;
using InABox.DynamicGrid;
using PRSDesktop.Integrations.Logikal;

namespace PRSDesktop;

public class LogikalSettingsGrid : DynamicItemsListGrid<LogikalSettings>
{

    private void ValidateSQL<T>(string tag, string sql, List<string> errors) where T : LogikalItem, new()
    {
        var t = new T();
        List<string> _e = new();
        t.ValidateQuery(sql.Replace("\r\n", " ").Replace('\r', ' ').Replace('\n', ' '), _e);
        if (_e.Any())
        {
            errors.Add($"The query for {tag} has some errors:");
            errors.AddRange(_e);
        }
    }
    
    protected override void DoValidate(LogikalSettings[] items, List<string> errors)
    {
        base.DoValidate(items, errors);

        var _item = items.FirstOrDefault();
        if (_item == null)
            return;
        
        if (Guid.Equals(_item.ProfileUom.ID, Guid.Empty))
            errors.Add("Profile UOM may not be blank");
        
        if (Guid.Equals(_item.GasketUom.ID, Guid.Empty))
            errors.Add("Gasket UOM may not be blank");
        
        if (Guid.Equals(_item.ComponentUom.ID, Guid.Empty))
            errors.Add("Component UOM may not be blank");
        
        if (Guid.Equals(_item.GlassUom.ID, Guid.Empty))
            errors.Add("Glass UOM may not be blank");
        

        CheckLogikalQueries(_item);
        ValidateSQL<LogikalFinish>("1. Finishes", _item.FinishSQL, errors);
        
        ValidateSQL<LogikalProfile>("2. Profiles - BOM", _item.BillOfMaterialsProfileSQL, errors);
        ValidateSQL<LogikalProfile>("2. Profiles - Design", _item.DesignProfileSQL, errors);
        ValidateSQL<LogikalGasket>("3. Gaskets", _item.GasketSQL, errors);
        ValidateSQL<LogikalComponent>("4. Components", _item.ComponentSQL, errors);
        ValidateSQL<LogikalGlass>("5. Glass", _item.GlassSQL, errors);
        ValidateSQL<LogikalLabour>("6. Labour", _item.LabourSQL, errors);
        

    }
    
    public void CheckLogikalQueries(LogikalSettings item)
    {
        item.FinishSQL = string.IsNullOrWhiteSpace(item.FinishSQL) ? LogikalFinish.SQL.Trim(' ','\r','\n') : item.FinishSQL;
            
        item.BillOfMaterialsProfileSQL = string.IsNullOrWhiteSpace(item.BillOfMaterialsProfileSQL) ? LogikalProfile.BillOfMaterialsSQL.Trim(' ','\r','\n')  : item.BillOfMaterialsProfileSQL;
        item.DesignProfileSQL = string.IsNullOrWhiteSpace(item.DesignProfileSQL) ? LogikalProfile.DesignSQL.Trim(' ','\r','\n')  : item.DesignProfileSQL;

        item.GasketSQL = string.IsNullOrWhiteSpace(item.GasketSQL) ? LogikalGasket.SQL.Trim(' ','\r','\n') : item.GasketSQL;
        item.ComponentSQL = string.IsNullOrWhiteSpace(item.ComponentSQL) ? LogikalComponent.SQL.Trim(' ','\r','\n')  : item.ComponentSQL;
        item.GlassSQL = string.IsNullOrWhiteSpace(item.GlassSQL) ? LogikalGlass.SQL.Trim(' ','\r','\n')  : item.GlassSQL;
        item.LabourSQL = string.IsNullOrWhiteSpace(item.LabourSQL) ? LogikalLabour.SQL.Trim(' ','\r','\n')  : item.LabourSQL;

    }
    
}