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

namespace AccountsDAL.CustomCode.Voucher
{
    public interface IVoucherDAL
    {
        // ── Save/Update Voucher — full-parity port (see VoucherQB.cs's Save/Update region for
        // context). Every insert takes the DTO + transaction; deletes/lookups take scalar ids.
        Task InsertVoucherHeader(VoucherDTO voucher, LoginDTO loginDTO, DbTransaction tx);
        Task UpdateVoucherHeader(VoucherDTO voucher, LoginDTO loginDTO, DbTransaction tx);
        Task InsertVoucherDetail(VoucherDetailDTO detail, DateTime headerVoucherDate, DateTime headerValidTillDate, LoginDTO loginDTO, DbTransaction tx);
        Task InsertVoucherAddon(VoucherAddonDTO addon, LoginDTO loginDTO, DbTransaction tx);
        Task InsertBillAllocation(VoucherBillAllocationDTO billAllocation, LoginDTO loginDTO, DbTransaction tx);
        Task InsertCostCenter(VoucherCostCenterDTO costCenter, LoginDTO loginDTO, DbTransaction tx);
        Task InsertInstrument(VoucherInstrumentDTO instrument, LoginDTO loginDTO, DbTransaction tx);
        Task InsertVoucherTDS(VoucherTDSDTO tds, LoginDTO loginDTO, DbTransaction tx);

        Task DeleteAllChildrenForVoucher(int voucherId, LoginDTO loginDTO, DbTransaction tx);

        // ── Delete/Cancel Voucher — full-parity port (see VoucherQB.cs's Delete/Cancel region) ──
        Task DeleteChildrenExceptDetailsForVoucher(int voucherId, LoginDTO loginDTO, DbTransaction tx);
        Task DetachBillAllocationAgainstReferences(int voucherId, LoginDTO loginDTO, DbTransaction tx);
        Task DeleteBizDimensionForVoucher(int voucherId, LoginDTO loginDTO, DbTransaction tx);
        Task DeleteVoucherHeader(int voucherId, LoginDTO loginDTO, DbTransaction tx);
        Task SoftCancelVoucherHeader(int voucherId, int modifiedById, DateTime modifiedOn, LoginDTO loginDTO, DbTransaction tx);
        Task DeleteVoucherDetailById(int voucherDetailId, LoginDTO loginDTO, DbTransaction tx);
        Task<List<int>> GetVoucherDetailIds(int voucherId, LoginDTO loginDTO);

        Task<BizTransactionTypeForSaveDTO?> GetBizTransactionTypeForSave(int bizTransactionTypeId, LoginDTO loginDTO);
        Task<PeriodDateRangeDTO?> GetPeriodDateRange(int periodId, LoginDTO loginDTO);
        Task<AccountTypeInfoDTO?> GetAccountTypeInfo(int accountId, LoginDTO loginDTO);

        Task<List<VoucherEndValidationRowDTO>> ExecutePostSaveDbObjects(int voucherId, int clientId, LoginDTO loginDTO, DbTransaction tx);

        // ── Read ──────────────────────────────────────────────────────────────
        // GetVoucher full-parity port — split into granular typed fetches so VoucherBLL.GetVoucher
        // can stitch the nested structure, run TDS/cost-center-applicability enrichment, and handle
        // cross-OU stitching itself (orchestration belongs in BLL, not DAL).
        Task<VoucherDTO?> GetVoucherHeader(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherDetailDTO>> GetVoucherDetails(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherAddonDTO>> GetVoucherAddons(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherBillAllocationDTO>> GetVoucherBillAllocationsForVoucher(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherBillAllocationDTO>> GetVoucherBillAllocationsForDetail(int voucherDetailId, LoginDTO loginDTO);
        Task<List<VoucherCostCenterDTO>> GetVoucherCostCentersForVoucher(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherInstrumentDTO>> GetVoucherInstrumentsForVoucher(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherTDSDTO>> GetVoucherTDSForVoucher(int voucherId, LoginDTO loginDTO);
        Task<List<VoucherDetailParameterDTO>> GetVoucherDetailParameters(int voucherId, LoginDTO loginDTO);
        Task<int> GetVoucherBizTypeCostCenterRequiredCount(int voucherId, LoginDTO loginDTO);
        Task<List<int>> GetCostCategoryConditionAccountGroupIds(LoginDTO loginDTO);
        Task<List<AccountsDAL.DTO.TDSCategory.TDSCategoryDTO>> GetAllTDSCategoryAccounts(LoginDTO loginDTO);
        Task<int?> GetInterVoucherDetailId(int interAccountId, int interVoucherId, double voucherDetailAmount, LoginDTO loginDTO);
        Task<InterSwapAccountDTO?> GetAccountForInterSwap(int accountId, LoginDTO loginDTO);

        Task<string> GetVoucherTDS(CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<string> GetSelectListVoucherTDS(CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<string> GetBillAllocation(int voucherId, LoginDTO loginDTO);
        Task<string> GetPendingBillAllocation(BillAllocationFilterDTO filterDTO, LoginDTO loginDTO);
        Task<string> GetSelectListBillAllocation(CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<int> PaymentEntryValidationCount(string referenceNumber, LoginDTO loginDTO);
        Task<string> GetSelectListVoucher(int FirstNumber, int MaxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO, bool IsCount = false);
        Task<string> GetSelectListVoucherInstrument(CriteriaDTO criteriaDTO, LoginDTO loginDTO);

        // ── Write ─────────────────────────────────────────────────────────────
        Task<string> UpdateBillAllocation(VoucherBillAllocationDTO dto, LoginDTO loginDTO);
        Task<List<VoucherBillAllocationDTO>> AutoPendingBillAllocation(BillAllocationFilterDTO filterDTO, LoginDTO loginDTO);
        Task<string> LoadBRS(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO, bool count = false);
        Task<string> UpdateBRS(List<BRSLoadDTO> brsLoadDTOs, LoginDTO loginDTO);
        Task<string> ReAccountPost(int voucherId, LoginDTO loginDTO);

        // ── Opening Balance Save/Update ─────────────────────────────────────────
        Task<int?> GetFirstPeriodId(LoginDTO loginDTO);
        Task<VoucherOnOUDTO?> GetVoucherOnOU(int bizTransactionTypeId, int ouId, LoginDTO loginDTO);
        Task SaveOpeningVoucherDetail(VoucherDetailDTO detail, int newVoucherDetailId, int voucherId, LoginDTO loginDTO, DbTransaction tx);
        Task UpdateOpeningVoucherDetail(VoucherDetailDTO detail, LoginDTO loginDTO, DbTransaction tx);
        Task SaveOpeningBillAllocation(VoucherBillAllocationDTO allocation, int newBillAllocationId, int voucherDetailId, LoginDTO loginDTO, DbTransaction tx);
        Task UpdateOpeningBillAllocation(VoucherBillAllocationDTO allocation, LoginDTO loginDTO, DbTransaction tx);

        // ── Re-Account-Post (period/account/OU-scoped ledger rebuild) ───────────
        Task<List<int>> GetActiveOUIds(LoginDTO loginDTO);
        Task ReAccountPostingFast(int periodId, int accountId, int ouId, LoginDTO loginDTO);

        Task<string> GetVoucherDetailForOpeningBalance(int bizTransactionTypeId, int ouId, int voucherAccountId, LoginDTO loginDTO);

        Task<string?> FindDuplicateReferenceNumberVoucher(int ouId, int periodId, int bizTransactionTypeId, int accountId, string referenceNumber, LoginDTO loginDTO);

        Task<string> GetUsedVoucherInBillAllocation(int voucherId, LoginDTO loginDTO);

        Task<string> GetVoucherSummaryInfo(int voucherId, LoginDTO loginDTO);
    }
}