namespace FLSDAL.Query.Bridge;

public static class FlsBridgeQB
{
    public const string GET_ACTIVE_BRIDGES = @"
        SELECT  BRIDGECONFIGID, MODULEID, MODULECODE,
                EVENTHANDLERURL, DAPRPUBSUBTOPIC,
                CAST(ISDAPR AS INT) AS ISDAPR,
                SUMMARYSPNAME,
                CAST(RESPONSEVISIBILITY AS INT) AS RESPONSEVISIBILITY,
                CAST(ALLOWRESPONDENTADD AS INT) AS ALLOWRESPONDENTADD,
                CAST(ALLOWMANUALCLOSE AS INT) AS ALLOWMANUALCLOSE
        FROM    MFLSBRIDGECONFIG
        WHERE   STATUS = 1";

    public const string GET_BRIDGE_BY_MODULE = @"
        SELECT  BRIDGECONFIGID, MODULEID, MODULECODE,
                EVENTHANDLERURL, DAPRPUBSUBTOPIC,
                CAST(ISDAPR AS INT) AS ISDAPR,
                SUMMARYSPNAME,
                CAST(RESPONSEVISIBILITY AS INT) AS RESPONSEVISIBILITY,
                CAST(ALLOWRESPONDENTADD AS INT) AS ALLOWRESPONDENTADD,
                CAST(ALLOWMANUALCLOSE AS INT) AS ALLOWMANUALCLOSE
        FROM    MFLSBRIDGECONFIG
        WHERE   MODULEID = @ModuleId
        AND     STATUS   = 1";
}