using FrameworkDAL.CustomCode.GBPeriod;
using FrameworkDAL.DTO.GBPeriod;
using GB5Shared.DTO.Framework.AutoNumber;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.GenerateAutoNumber;
using GB5Shared.Resource.Framework;
using GB5Shared.Resource.Response;
using GB5Shared.Validation;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Threading.Tasks;

namespace FrameworkBLL.GBPeriod
{
    public class GBPeriodBLL : IGBPeriodBLL
    {
        private readonly IGBPeriodDAL _gbPeriodDAL;
        private readonly AutoNumber _AutoNumber;
        private readonly IValidation _Validation;


        public GBPeriodBLL(IGBPeriodDAL gbPeriodDAL, AutoNumber AutoNumber, IValidation Validation)
        {
            _gbPeriodDAL = gbPeriodDAL;
            _AutoNumber = AutoNumber;
            _Validation = Validation;
        }

        public async Task<string> GetGBPeriod(int gbPeriodId, LoginDTO loginDTO)
        {
            try
            {
                return await _gbPeriodDAL.GetGBPeriod(gbPeriodId, loginDTO);
            }
            catch (Exception)
            {
                throw;
            }
        }
        /// <summary>
        /// Inserts a new GBPeriod record or updates an existing one.
        /// Applies business rules such as auto-number assignment for new records.
        /// </summary>
        /// <param name="GBPeriodDTO">The GBPeriod data to save or update.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A message string indicating success and the GBPeriod ID.</returns>
        public async Task<string> SaveGBPeriod(GBPeriodDTO GBPeriodDTO, LoginDTO LoginDTO)
        {
            if (GBPeriodDTO == null) throw new ArgumentNullException(nameof(GBPeriodDTO));
            AutoNumberDTO? autoNumberDTO = null;
            try
            {
                await _Validation.NotEmpty(GBPeriodDTO.GBPeriodCode, nameof(GBPeriodDTO.GBPeriodCode));
                await _Validation.NotEmpty(GBPeriodDTO.GBPeriodName, nameof(GBPeriodDTO.GBPeriodName));
                GBPeriodDTO.GBPeriodModifiedById = LoginDTO.UserId;
                GBPeriodDTO.GBPeriodModifiedOn = DateTime.UtcNow;

                int initialId = GBPeriodDTO.GBPeriodId;
                int count = 1 + initialId;

                if (initialId == 0)
                {
                    AutoNumberDTO AutoNumberDTO = await _AutoNumber.GetNumberAsync(count, "GBPeriod", LoginDTO);
                    GBPeriodDTO.GBPeriodId = AutoNumberDTO.StartNumber;
                    GBPeriodDTO.GBPeriodCreatedById = LoginDTO.UserId;
                    GBPeriodDTO.GBPeriodCreatedOn = DateTime.UtcNow;

                    await _gbPeriodDAL.SaveGBPeriod(GBPeriodDTO, LoginDTO);
                    return $"{SuccessResponse.SaveSuccessMessage} {GBPeriodDTO.GBPeriodId}";
                }
                else
                {
                    await _gbPeriodDAL.UpdateGBPeriod(GBPeriodDTO, LoginDTO);
                    return $"{SuccessResponse.UpdateSuccessMessage} {GBPeriodDTO.GBPeriodId}";
                }
            }
            catch (ValidationException vex)
            {
                throw new Exception(vex.Message);
            }
            catch (Exception)
            {
                if (autoNumberDTO != null && GBPeriodDTO.GBPeriodId > 0)
                    await _AutoNumber.RollbackAutoNumber("GBPeriod", GBPeriodDTO.GBPeriodId, LoginDTO);

                throw;
            }
        }
        /// <summary>
        /// Deletes a GBPeriod record by its unique identifier.
        /// </summary>
        /// <param name="GBPeriodId">The ID of the GBPeriod to delete.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A message string indicating success or failure of the delete operation.</returns>
        public async Task<string> DeleteGBPeriod(int GBPeriodId, LoginDTO LoginDTO)
        {
            try
            {
                return await _gbPeriodDAL.DeleteGBPeriod(GBPeriodId, LoginDTO);
            }
            catch (Exception)
            {
                throw;
            }
        }
        /// <summary>
        /// Retrieves a paginated list of GBPeriod records based on specified filter criteria.
        /// Can optionally return the total count of records instead of the list.
        /// </summary>
        /// <param name="firstNumber">The starting index of records to fetch (for pagination).</param>
        /// <param name="maxResult">The maximum number of records to fetch.</param>
        /// <param name="criteriaDTO">Filter criteria for selecting GBPeriod records.</param>
        /// <param name="loginDTO">The current user's login details.</param>
        /// <param name="isCount">If true, returns the total count of matching records instead of the list.</param>
        /// <returns>A JSON string representing either the list of GBPeriod records or the total count.</returns>
        public async Task<string> GetSelectListGBPeriod(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO, bool isCount = false)
        {
            try
            {
                return await _gbPeriodDAL.GetSelectListGBPeriod(firstNumber, maxResult, criteriaDTO, loginDTO, isCount);
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// Retrieves a paginated list of GBPeriodDetail records (sub-periods) across all GBPeriods.
        /// Can optionally return the total count of records instead of the list.
        /// </summary>
        /// <param name="firstNumber">The starting index of records to fetch (for pagination).</param>
        /// <param name="maxResult">The maximum number of records to fetch.</param>
        /// <param name="criteriaDTO">Filter criteria for selecting GBPeriodDetail records.</param>
        /// <param name="loginDTO">The current user's login details.</param>
        /// <param name="isCount">If true, returns the total count of matching records instead of the list.</param>
        /// <returns>A JSON string representing either the list of GBPeriodDetail records or the total count.</returns>
        public async Task<string> GetSelectListGBPeriodDetail(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO, bool isCount = false)
        {
            try
            {
                return await _gbPeriodDAL.GetSelectListGBPeriodDetail(firstNumber, maxResult, criteriaDTO, loginDTO, isCount);
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// Retrieves the full GBPeriod/GBPeriodDetail picklist (no paging) filtered by the supplied criteria.
        /// Mirrors the GB4 Gb4PeriodPicklist behavior used by legacy period-selection pickers.
        /// </summary>
        /// <param name="criteriaDTO">Filter criteria (e.g. PeriodType, SubPeriodName, PeiodFromDate, PeiodToDate).</param>
        /// <param name="loginDTO">The current user's login details.</param>
        /// <returns>A JSON string representing the list of matching GBPeriodDetail picklist records.</returns>
        public async Task<string> Gb4PeriodPicklist(CriteriaDTO criteriaDTO, LoginDTO loginDTO)
        {
            try
            {
                return await _gbPeriodDAL.Gb4PeriodPicklist(criteriaDTO, loginDTO);
            }
            catch (Exception)
            {
                throw;
            }
        }

    }
}