using FLSDAL.DTO.Survey;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;

namespace FLSDAL.CustomCode.Survey;

public interface ISurveyInstrumentDAL
{
    Task<IEnumerable<SurveyInstrumentTypePicklistDTO>> GetSelectListSurveyInstrumentType(
        int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO login);

    /// <summary>Returns the raw STATUS for one instrument type, or null if it doesn't exist.
    /// 0=Draft, 1=Active, 2=Archived/Retired (same convention as MSURVEYINSTRUMENTCONFIG.Status).</summary>
    Task<int?> GetInstrumentTypeStatusAsync(int instrumentTypeId, LoginDTO login, CancellationToken ct);

    Task<IEnumerable<SurveyQuestionTypePicklistDTO>> GetSelectListSurveyQuestionType(
        int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO login);

    // Single round trip, 4 result sets — Config, Sections, Questions (lang-resolved), Options (lang-resolved)
    Task<(SurveyInstrumentConfigRow? Config,
          List<SurveySectionRow> Sections,
          List<SurveyInstQuestionRow> Questions,
          List<SurveyInstOptionRow> Options)>
        GetInstrumentAsync(int instrumentConfigId, string langCode, LoginDTO login, CancellationToken ct);

    Task<int> GetConfigIdByRegistrationAsync(int flsRegistrationId, LoginDTO login, CancellationToken ct);

    Task LockInstrumentAsync(int instrumentConfigId, LoginDTO login, CancellationToken ct);

    Task InsertInstrumentConfigAsync(int instrumentConfigId, SaveSurveyInstrumentRequest req, LoginDTO login, CancellationToken ct);
    Task<bool> UpdateInstrumentConfigAsync(int instrumentConfigId, SaveSurveyInstrumentRequest req, LoginDTO login, CancellationToken ct);

    Task InsertSectionAsync(int instrumentSectionId, int instrumentConfigId, SaveSurveySectionRequest section, LoginDTO login, CancellationToken ct);
    Task UpdateSectionAsync(int instrumentSectionId, SaveSurveySectionRequest section, LoginDTO login, CancellationToken ct);
    Task DeactivateSectionsNotInAsync(int instrumentConfigId, List<int> keepIds, LoginDTO login, CancellationToken ct);

    Task InsertSectionOnlyAsync(int instrumentSectionId, SaveSurveySectionOnlyRequest req, LoginDTO login, CancellationToken ct);
    Task<bool> UpdateSectionOnlyAsync(int instrumentSectionId, SaveSurveySectionOnlyRequest req, LoginDTO login, CancellationToken ct);
    Task<bool> DeleteSectionAsync(int instrumentSectionId, LoginDTO login, CancellationToken ct);
    Task<SurveySectionRow?> GetSectionByIdAsync(int instrumentSectionId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<SurveySectionRow>> GetSectionsByConfigAsync(int instrumentConfigId, LoginDTO login, CancellationToken ct);

    Task<IEnumerable<SurveySectionPicklistDTO>> GetSelectListSurveySection(
        int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO login);

    Task InsertInstQuestionAsync(int instQuestionId, int instrumentSectionId, int instrumentConfigId, SaveSurveyInstQuestionRequest question, LoginDTO login, CancellationToken ct);
    Task UpdateInstQuestionAsync(int instQuestionId, SaveSurveyInstQuestionRequest question, LoginDTO login, CancellationToken ct);
    Task DeactivateInstQuestionsNotInAsync(int instrumentSectionId, List<int> keepIds, LoginDTO login, CancellationToken ct);

    Task InsertQuestionBankAsync(int questionId, SaveSurveyQuestionRequest req, LoginDTO login, CancellationToken ct);
    Task<bool> UpdateQuestionBankAsync(int questionId, SaveSurveyQuestionRequest req, LoginDTO login, CancellationToken ct);
    Task UpsertQuestionTransAsync(int questionId, int questionTransId, string langCode, string questionText, LoginDTO login, CancellationToken ct);

    Task InsertOptionAsync(int optionId, int questionId, SaveSurveyOptionRequest option, LoginDTO login, CancellationToken ct);
    Task UpdateOptionAsync(int optionId, SaveSurveyOptionRequest option, LoginDTO login, CancellationToken ct);
    Task DeactivateOptionsNotInAsync(int questionId, List<int> keepIds, LoginDTO login, CancellationToken ct);
    Task UpsertOptionTransAsync(int optionId, int optionTransId, string langCode, string optionText, LoginDTO login, CancellationToken ct);

    Task<IEnumerable<SurveyQuestionBankListRow>> GetQuestionBankListAsync(
        string searchText, string langCode, int firstNumber, int maxResult, LoginDTO login, CancellationToken ct);

    Task<(SurveyQuestionCoreRow? Question, List<SurveyQuestionOptionDetailDto> Options)> GetQuestionByIdAsync(
        int questionId, string langCode, LoginDTO login, CancellationToken ct);

    Task<IEnumerable<SurveyQuestionPicklistDTO>> GetSelectListSurveyQuestion(
        int firstNumber, int maxResult, string langCode, CriteriaDTO criteriaDTO, LoginDTO login);

    Task<IEnumerable<SurveyInstrumentPicklistDTO>> GetSelectListSurveyInstrument(
        int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO login);

    Task<bool> DeactivateQuestionBankAsync(int questionId, LoginDTO login, CancellationToken ct);
}