using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using RecruitmentDAL.DTO.FlsBridge;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;

namespace RecruitmentDAL.CustomeCode.FlsBridge
{
    public interface IRecruitmentFlsActionDAL
    {
        Task<string> GetRecruitmentFlsAction(int RecruitmentFlsActionId, LoginDTO LoginDTO, CancellationToken ct);
        Task<string> GetSelectListRecruitmentFlsAction(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct);

        // Transactional write overloads — called from BaseEntityAppService.ExecuteSaveAsync's
        // persistFunc so the save participates in the single pipeline transaction.
        Task<int> SaveRecruitmentFlsAction(RecruitmentFlsActionDTO RecruitmentFlsActionDTO, LoginDTO LoginDTO, DbTransaction tx, CancellationToken ct);
        Task<int> UpdateRecruitmentFlsAction(RecruitmentFlsActionDTO RecruitmentFlsActionDTO, LoginDTO LoginDTO, DbTransaction tx, CancellationToken ct);
        Task<string> DeleteRecruitmentFlsAction(int RecruitmentFlsActionId, LoginDTO LoginDTO, CancellationToken ct);

        // Cross-tenant, pre-authentication lookup by the FLS respondent id a token resolved to
        // — used by RecruitmentFlsBridgeBLL.GetActionAsync/SubmitActionAsync, mirroring
        // AssessmentFlsBridgeDAL.GetBridgeByRespondentId's identical pattern.
        Task<RecruitmentFlsActionDTO?> GetRecruitmentFlsActionByRespondentId(int FlsRespondentId, LoginDTO LoginDTO, CancellationToken ct);

        // ── Coordinator natural-key lookups (no separate coordinator table — see migration
        //    header for rationale) ──
        Task<int> ResolveFormTemplateIdByCode(string FormTemplateCode, LoginDTO LoginDTO, CancellationToken ct);
        Task<int> ResolveModuleIdByCode(string ModuleCode, LoginDTO LoginDTO, CancellationToken ct);
        Task<int> ResolveRegistrationIdByCode(string RegistrationCode, LoginDTO LoginDTO, CancellationToken ct);
        Task<int> ResolveInstanceIdByCode(string InstanceCode, int FlsRegistrationId, LoginDTO LoginDTO, CancellationToken ct);
        Task<int> ResolveGroupIdByCode(string GroupCode, int FlsInstanceId, LoginDTO LoginDTO, CancellationToken ct);
        Task InsertFlsInstanceOpen(int FlsInstanceId, int FlsRegistrationId, string InstanceCode, string InstanceName, LoginDTO LoginDTO, CancellationToken ct);
        Task InsertFlsInstanceGroup(int GroupId, int FlsInstanceId, string GroupCode, string GroupName, LoginDTO LoginDTO, CancellationToken ct);
    }
}