using System.Data.Common;
using AccountsDAL.DTO.Account;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.ResponseStandard;

namespace AccountsDAL.CustomCode.Account
{
    public interface IAccountDAL
    {
        Task<string> GetAccount(int AccountId, LoginDTO LoginDTO);
        Task<string> GetSelectListAccount(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);
        Task<string> GetAccountList(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO);
        Task<string> GetAccountParameter(int AccountId, LoginDTO LoginDTO);

        // Usage checks — called before delete
        Task<bool> AccountExistsInVouchers(int accountId, LoginDTO loginDTO);
        Task<bool> AccountLinkedToParty(int accountId, LoginDTO loginDTO);

        // Existence check for the Party<->Account shadow-account link (AccountId == PartyId)
        Task<bool> AccountExists(int accountId, LoginDTO loginDTO, DbTransaction tx);

        // Transactional write overloads — called from ExecuteSaveAsync callback
        Task<Result<string>> SaveAccount(AccountDTO dto, LoginDTO loginDTO, DbTransaction tx);
        Task<Result<string>> UpdateAccount(AccountDTO dto, LoginDTO loginDTO, DbTransaction tx);
        Task<Result<string>> DeleteAccount(int accountId, LoginDTO loginDTO, DbTransaction tx);

        // Additional read queries
        Task<string> GetAccountDetailsSQL(int accountId, LoginDTO loginDTO);
        Task<string> GetAccountPicklistForAccountPopup(CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<string> GetSelectListAccountVsCompany(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<string> GetPopUpDetails(int accountId, LoginDTO loginDTO);

        Task<string> GetControlAccountPicklist(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO);

        Task<string> GetSelectListGeneralLedger(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO);

        Task<string> GetAccountSelectlistFromQueryParametarized(
            int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO);
    }
}