namespace DMSDAL.Query.BulkIngestion
{
    public static class BulkIngestionQB
    {
        public const string INSERT_JOB = @"
            EXEC DBO.SP_INGESTION_JOB_INSERT
                @SourceFolder, @ManifestFilePath, @DocumentSetDetailId,
                @Mode, @ClientId, @CreatedByUserId";

        public const string UPDATE_JOB_STATUS = @"
            EXEC DBO.SP_INGESTION_JOB_UPDATE
                @JobId, @Status, @TotalFiles, @ProcessedFiles, @FailedFiles";

        public const string GET_JOB_STATUS = @"
            EXEC DBO.SP_INGESTION_JOB_GET @JobId, @ClientId";

        public const string INSERT_LOG = @"
            EXEC DBO.SP_INGESTION_LOG_INSERT
                @JobId, @FilePath, @ObjectTypeId, @ObjectId,
                @DocumentSetDetailId, @DisplayName, @AttachmentId, @Status, @ErrorMessage";

        // Resolve ObjectTypeCode → EntityId for folder-convention mode.
        // Requires MENTITY to have ENTITYCODE column (standard GB5 metadata table).
        public const string GET_OBJECTTYPEID_BY_CODE = @"
            SELECT ENTITYID
            FROM   DBO.MENTITY
            WHERE  ENTITYCODE = @Code";
    }
}