namespace EntitlementDAL.QueryBuilders;

// SQL for MENTITLEMENTFEATUREMENUSETMAP exposed as its own MenuSetMap.svc CRUD surface.
// (FeatureQB also holds a by-feature read + insert used internally by feature saves; this QB is
// the standalone-service view: list-all / by-id / upsert / hard-delete.)
//
// Required indexes:
//   MENTITLEMENTFEATUREMENUSETMAP: UX (FEATUREID, MENUSETID)
//
// DBMS-neutral plain ANSI SQL — same dual-dialect discipline as the rest of EntitlementDAL.
public static class MenuSetMapQB
{
    private const string COLUMNS = @"
       FEATUREMENUSETMAPID AS FeatureMenuSetMapId,
       FEATUREID           AS FeatureId,
       MENUSETID           AS MenuSetId,
       SLNO                AS SlNo,
       ISDEFAULT           AS IsDefault";

    public const string GET_LIST = "SELECT" + COLUMNS + @"
FROM   MENTITLEMENTFEATUREMENUSETMAP
ORDER BY FEATUREID, SLNO";

    public const string GET_BY_ID = "SELECT" + COLUMNS + @"
FROM   MENTITLEMENTFEATUREMENUSETMAP
WHERE  FEATUREMENUSETMAPID = @FeatureMenuSetMapId";

    public const string GET_BY_FEATURE_AND_MENUSET = "SELECT" + COLUMNS + @"
FROM   MENTITLEMENTFEATUREMENUSETMAP
WHERE  FEATUREID = @FeatureId
  AND  MENUSETID = @MenuSetId";

    public const string INSERT = @"
INSERT INTO MENTITLEMENTFEATUREMENUSETMAP (FEATUREMENUSETMAPID, FEATUREID, MENUSETID, SLNO, ISDEFAULT)
VALUES (@FeatureMenuSetMapId, @FeatureId, @MenuSetId, @SlNo, @IsDefault)";

    public const string UPDATE = @"
UPDATE MENTITLEMENTFEATUREMENUSETMAP SET
    FEATUREID = @FeatureId,
    MENUSETID = @MenuSetId,
    SLNO      = @SlNo,
    ISDEFAULT = @IsDefault
WHERE  FEATUREMENUSETMAPID = @FeatureMenuSetMapId";

    public const string DELETE = @"
DELETE FROM MENTITLEMENTFEATUREMENUSETMAP WHERE FEATUREMENUSETMAPID = @FeatureMenuSetMapId";
}