using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using MMDAL.DTO.Routing;
using System.Data.Common;

namespace MMDAL.CustomCode.Routing
{
    public interface IRoutingDAL
    {
        Task<string> GetSelectListRouting(CriteriaDTO criteriaDTO, LoginDTO loginDTO);
        Task<string> GetSelectListRoutingVersion(int firstNumber, int maxResult, LoginDTO login, CancellationToken ct);

        Task<RoutingSaveDTO?>                         GetRoutingHeader(int routingId, LoginDTO login, CancellationToken ct);
        Task<IEnumerable<RoutingVersionSaveDTO>>      GetRoutingVersions(int routingId, LoginDTO login, CancellationToken ct);
        Task<IEnumerable<RoutingVersionDetailSaveDTO>> GetRoutingVersionDetails(int routingVersionId, LoginDTO login, CancellationToken ct);
        Task<(IEnumerable<RoutingListItemDTO> Items, int TotalCount)> GetRoutingList(int firstNumber, int maxResult, LoginDTO login, CancellationToken ct);

        Task SaveRoutingHeader(RoutingSaveDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
        Task UpdateRoutingHeader(RoutingSaveDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
        Task SaveRoutingVersion(RoutingVersionSaveDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
        Task BulkSaveRoutingVersionDetails(IEnumerable<RoutingVersionDetailSaveDTO> details, LoginDTO login, DbTransaction tx);
        Task DeleteRoutingVersionDetails(int routingVersionId, LoginDTO login, DbTransaction tx, CancellationToken ct);
        Task SoftDeleteRouting(int routingId, LoginDTO login, DbTransaction tx, CancellationToken ct);
    }
}