using FrameworkDAL.DTO.MessageHubService.UpdateHandleStatus;
using FrameworkDAL.Query.MessageHubService.TemplateApproval;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;
using Microsoft.Extensions.Logging;
using System;
using System.Threading.Tasks;

namespace FrameworkDAL.CustomCode.MessageHubService.TemplateApproval
{
    /// <summary>
    /// Data Access Layer for Template Approval and Call Ticket Assignment operations.
    /// Handles Accept, Reject, and Forward actions on TCALL.
    /// Supports CallId-based approvals.
    /// </summary>
    public class TemplateApprovalDAL : ITemplateApprovalDAL
    {
        private readonly IQueryExecutor _queryExecutor;
        private readonly ILogger<TemplateApprovalDAL> _logger;

        public TemplateApprovalDAL(IQueryExecutor queryExecutor, ILogger<TemplateApprovalDAL> logger)
        {
            _queryExecutor = queryExecutor ?? throw new ArgumentNullException(nameof(queryExecutor));
            _logger = logger ?? throw new ArgumentNullException(nameof(logger));
        }

        /// <summary>
        /// Accepts a call approval ticket.
        /// Sets TCALL.STATUS = 1, ACTIONTAKEN = 'ACCEPT'.
        /// </summary>
        public async Task<int> AcceptTemplateApproval(TemplateApprovalDTO dto, LoginDTO loginDTO)
        {
            if (dto == null) throw new ArgumentNullException(nameof(dto));
            if (loginDTO == null) throw new ArgumentNullException(nameof(loginDTO));

            _logger.LogInformation("AcceptTemplateApproval called | CallId={CallId} | DTO={@DTO}", dto.TicketNumber, dto);

            try
            {
                var sql = TemplateApprovalQB.ACCEPT_TEMPLATE_APPROVAL;
                var result = await _queryExecutor.ExecuteAsync(loginDTO, sql, dto);
                _logger.LogInformation("AcceptTemplateApproval executed. Rows affected: {Result}", result);
                return result;
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error in AcceptTemplateApproval | CallId={CallId}", dto.TicketNumber);
                throw;
            }
        }

        /// <summary>
        /// Rejects a call approval ticket.
        /// Sets TCALL.STATUS = 2, ACTIONTAKEN = 'REJECT'.
        /// </summary>
        public async Task<int> RejectTemplateApproval(TemplateApprovalDTO dto, LoginDTO loginDTO)
        {
            if (dto == null) throw new ArgumentNullException(nameof(dto));
            if (loginDTO == null) throw new ArgumentNullException(nameof(loginDTO));

            _logger.LogInformation("RejectTemplateApproval called | CallId={CallId} | DTO={@DTO}", dto.TicketNumber, dto);

            try
            {
                var sql = TemplateApprovalQB.REJECT_TEMPLATE_APPROVAL;
                var result = await _queryExecutor.ExecuteAsync(loginDTO, sql, dto);
                _logger.LogInformation("RejectTemplateApproval executed. Rows affected: {Result}", result);
                return result;
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error in RejectTemplateApproval | CallId={CallId}", dto.TicketNumber);
                throw;
            }
        }

        /// <summary>
        /// Forwards a call approval ticket.
        /// Sets TCALL.STATUS = 3, ACTIONTAKEN = 'FORWARD', updates CUSTOMERREMARKS.
        /// </summary>
        public async Task<int> ForwardTemplate(TemplateApprovalDTO dto, LoginDTO loginDTO)
        {
            if (dto == null) throw new ArgumentNullException(nameof(dto));
            if (loginDTO == null) throw new ArgumentNullException(nameof(loginDTO));

            _logger.LogInformation("ForwardTemplate called | CallId={CallId} | Remarks={Remarks}", dto.TicketNumber, dto.Remarks);

            try
            {
                var sql = TemplateApprovalQB.FORWARD_TEMPLATE;
                var result = await _queryExecutor.ExecuteAsync(loginDTO, sql, dto);
                _logger.LogInformation("ForwardTemplate executed. Rows affected: {Result}", result);
                return result;
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error in ForwardTemplate | CallId={CallId}", dto.TicketNumber);
                throw;
            }
        }
    }
}