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

namespace MarketingDAL.CustomCode.CustomerProductMatrixCell;

public interface ICustomerProductMatrixCellDAL
{
    /// <summary>
    /// Returns the raw DTO (not pre-serialized to JSON, unlike this module's other Get* DAL
    /// methods) because CustomerProductMatrixCellBLL must populate the computed, non-stored
    /// RevenueTargetAmount property before serializing the response.
    /// </summary>
    Task<CustomerProductMatrixCellDTO?> GetCustomerProductMatrixCell(int customerProductMatrixCellId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> GetSelectListCustomerProductMatrixCell(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct);

    Task<int> SaveCustomerProductMatrixCell(CustomerProductMatrixCellDTO customerProductMatrixCellDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<int> UpdateCustomerProductMatrixCell(CustomerProductMatrixCellDTO customerProductMatrixCellDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<string> DeleteCustomerProductMatrixCell(int customerProductMatrixCellId, LoginDTO loginDTO, CancellationToken ct);
}