using System.Data.Common;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using MarketingDAL.DTO.BusinessAspirationGoal;

namespace MarketingDAL.CustomCode.BusinessAspirationGoal;

public interface IBusinessAspirationGoalDAL
{
    Task<string> GetBusinessAspirationGoal(int businessAspirationGoalId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> GetSelectListBusinessAspirationGoal(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct);

    /// <summary>Used by CustomerProductMatrixCellBLL to compute RevenueTargetAmount. Returns null
    /// (no active row) rather than throwing when none exists yet.</summary>
    Task<BusinessAspirationGoalDTO?> GetLatestBusinessAspirationGoal(LoginDTO loginDTO, CancellationToken ct);

    Task<int> SaveBusinessAspirationGoal(BusinessAspirationGoalDTO businessAspirationGoalDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<int> UpdateBusinessAspirationGoal(BusinessAspirationGoalDTO businessAspirationGoalDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<string> DeleteBusinessAspirationGoal(int businessAspirationGoalId, LoginDTO loginDTO, CancellationToken ct);
}