using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.ResponseStandard;
using SwDAL.DTO.SyncGroup;
using System.Data;
using System.Data.Common;

namespace SwDAL.CustomCode.SyncGroup;

public interface ISyncGroupDAL
{
    Task<SyncGroupDTO?>             GetById(int syncGroupId, LoginDTO loginDTO, CancellationToken ct);
    Task<IEnumerable<SyncTableDTO>> GetTables(int syncGroupId, LoginDTO loginDTO, CancellationToken ct);
    Task<bool>                      ExistsInClientDb(int syncGroupId, LoginDTO loginDTO);
    Task<string>                    GetSelectListSyncGroup(int first, int max, CriteriaDTO CriteriaDTO, LoginDTO loginDTO);

    Task<Result<string>> SaveSyncGroup(SyncGroupDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateSyncGroup(SyncGroupDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteSyncGroup(int syncGroupId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> InsertSyncTable(SyncTableDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteSyncTable(int syncTableId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteAllSyncTables(int syncGroupId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<SyncGroupDTO?> GetSyncGroupHeader(int syncGroupId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<SyncTableDTO>> GetSyncTables(int syncGroupId, LoginDTO login, CancellationToken ct);
}