using GB5Shared.DTO.Framework.Login;
using SwDAL.DTO.ChangeRequest;
using SwDAL.DTO.DdlScript;
using SwDAL.Enums;

namespace SwDAL.CustomCode.ChangeRequest;

public interface IChangeRequestDAL
{
    Task<ChangeRequestDTO?> GetById(int changeRequestId, LoginDTO login, CancellationToken ct);
    Task<(IEnumerable<ChangeRequestListDTO> rows, int total)> GetList(ChangeRequestListCriteria criteria, int pageOffset, int pageSize, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<ChangeRequestListDTO>> GetSelectList(int firstNumber, int maxResult, LoginDTO login, CancellationToken ct);
    Task<int> Insert(ChangeRequestDTO dto, LoginDTO login, CancellationToken ct);
    Task Update(ChangeRequestDTO dto, LoginDTO login, CancellationToken ct);
    Task UpdateStatus(int changeRequestId, byte newStatus, byte expectedStatus, int performedById, string? comment, LoginDTO login, CancellationToken ct);
    Task AppendTimeline(int changeRequestId, CrTimelineEventType eventType, string? comment, int performedById, LoginDTO login, CancellationToken ct);
    Task Delete(int changeRequestId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DdlScriptDTO>> GetLinkedApprovedDdlScripts(int changeRequestId, LoginDTO login, CancellationToken ct);
    Task UpdateExecutionStatusAsync(int changeRequestId, byte newExecutionStatus, LoginDTO login, CancellationToken ct, int? queuedById = null);
    Task<IEnumerable<ChangeRequestDTO>> GetQueuedForExecutionAsync(LoginDTO login, CancellationToken ct);
}