using CMSDAL.DTO.Content;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CMSDAL.CustomCode.Content
{
    public interface IContentDAL
    {
        Task<string> GetContent(int ContentId, LoginDTO LoginDTO);
        Task<ContentPickListDTO?> GetContentBySlug(string Slug, LoginDTO LoginDTO);
        Task<string> GetSelectListContent(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);

        // Transaction-aware — must be called from inside ExecuteSaveAsync's persistFunc so the
        // Content row and its outbox/event-publish commit or roll back together. Returns the
        // Content's PK (new identity on insert, dto.ContentId echoed back on update) per the
        // persistFunc: Func<DbTransaction, Task<int>> contract.
        Task<int> SaveContent(ContentDTO ContentDTO, LoginDTO LoginDTO, DbTransaction? tx = null, CancellationToken ct = default);
        Task<int> UpdateContent(ContentDTO ContentDTO, LoginDTO LoginDTO, DbTransaction? tx = null, CancellationToken ct = default);

        Task<string> DeleteContent(int ContentId, LoginDTO LoginDTO);
        Task<string> GetContentListAsync(int spaceId, int contentTypeId, int contentStatus, int authorId, DateTime? fromDate, DateTime? toDate, LoginDTO loginDTO);
        Task<string> SearchContentAsync(string searchText, int spaceId, int contentTypeId, LoginDTO loginDTO);

        // Transaction-aware — used from ContentBLL's workflow-transition ExecuteSaveAsync
        // persistFunc so the status flip and its ContentVersion snapshot are atomic.
        Task<string> UpdateContentStatusAsync(int contentId, byte status, LoginDTO loginDTO, DbTransaction? tx = null, CancellationToken ct = default);
        Task<string> UpdateContentStatusWithPublishAsync(int contentId, byte status, LoginDTO loginDTO, DbTransaction? tx = null, CancellationToken ct = default);
        Task<byte?> GetContentStatusAsync(int contentId, LoginDTO loginDTO, DbTransaction? tx = null, CancellationToken ct = default);
    }
}