namespace IceImportDAL.Query.IceMapValidationRule;

public static class IceMapValidationRuleQB
{
    public const string GET_ENABLED_VALIDATOR_KEYS = @"
        SELECT VALIDATORKEY
        FROM   MICEMAPVALIDATIONRULE
        WHERE  ICEMAPID  = @IceMapId
        AND    ISENABLED = 1
        ORDER  BY SORTORDER";

    // Backs IfscBankBranchValidator — a one-off business rule, opt-in only via
    // MICEMAPVALIDATIONRULE(ValidatorKey='IFSC_BANKBRANCH'). MBANKBRANCH is owned by the
    // Accounts module; IceImport has no project reference to AccountsDAL, so this is a small,
    // self-contained, fully parameterized existence check rather than a cross-module dependency.
    public const string EXISTS_IFSC = @"
        SELECT COUNT(1)
        FROM   MBANKBRANCH
        WHERE  IFSC = @Ifsc";
}