namespace CMSDAL.Query.ContentContainerType;
public static class ContentContainerTypeQB
{
    public const string GET_LIST = @"
        SELECT CONTAINERTYPEID AS ContainerTypeId, CONTAINERTYPECODE AS ContainerTypeCode,
               CONTAINERTYPENAME AS ContainerTypeName, ZONEDEFINITIONSJSON AS ZoneDefinitionsJson,
               STATUS AS Status
        FROM DBO.MCONTENTCONTAINERTYPE
        WHERE STATUS = 1 AND (TENANTID = @TenantId OR TENANTID = -1)
        ORDER BY CONTAINERTYPENAME";

    public const string GET_BY_ID = @"
        SELECT CONTAINERTYPEID AS ContainerTypeId, CONTAINERTYPECODE AS ContainerTypeCode,
               CONTAINERTYPENAME AS ContainerTypeName, ZONEDEFINITIONSJSON AS ZoneDefinitionsJson,
               STATUS AS Status, TENANTID AS TenantId
        FROM DBO.MCONTENTCONTAINERTYPE
        WHERE CONTAINERTYPEID = @ContainerTypeId AND (TENANTID = @TenantId OR TENANTID = -1)";

    // Site/Page platform Phase 14 — the template materializer authors ContainerTreeJson by
    // ContainerTypeCode (human-readable, matches ContentContainerFullDTO's own shape) but
    // TCONTENTCONTAINER.INSERT requires the real ContainerTypeId FK; this resolves one to the
    // other. Same "own tenant OR system-wide (-1)" resolution as GET_BY_ID.
    public const string GET_BY_CODE = @"
        SELECT CONTAINERTYPEID AS ContainerTypeId, CONTAINERTYPECODE AS ContainerTypeCode,
               CONTAINERTYPENAME AS ContainerTypeName, ZONEDEFINITIONSJSON AS ZoneDefinitionsJson,
               STATUS AS Status, TENANTID AS TenantId
        FROM DBO.MCONTENTCONTAINERTYPE
        WHERE CONTAINERTYPECODE = @ContainerTypeCode AND (TENANTID = @TenantId OR TENANTID = -1)
          AND STATUS = 1";

    public const string GET_SELECT_LIST = @"
        SELECT CONTAINERTYPEID AS ContainerTypeId, CONTAINERTYPECODE AS ContainerTypeCode,
               CONTAINERTYPENAME AS ContainerTypeName, ZONEDEFINITIONSJSON AS ZoneDefinitionsJson
        FROM DBO.MCONTENTCONTAINERTYPE
        WHERE STATUS = 1 AND (TENANTID = @TenantId OR TENANTID = -1)
        ORDER BY CONTAINERTYPENAME";

    public const string INSERT = @"
        INSERT INTO DBO.MCONTENTCONTAINERTYPE
            (CONTAINERTYPECODE, CONTAINERTYPENAME, ZONEDEFINITIONSJSON, STATUS, TENANTID, CREATEDBYID, MODIFIEDBYID)
        VALUES
            (@ContainerTypeCode, @ContainerTypeName, @ZoneDefinitionsJson, @Status, @TenantId, @CreatedById, @ModifiedById)";

    public const string UPDATE = @"
        UPDATE DBO.MCONTENTCONTAINERTYPE
        SET CONTAINERTYPENAME = @ContainerTypeName, ZONEDEFINITIONSJSON = @ZoneDefinitionsJson,
            STATUS = @Status, MODIFIEDBYID = @ModifiedById, MODIFIEDON = GETDATE()
        WHERE CONTAINERTYPEID = @ContainerTypeId AND TENANTID = @TenantId";
}