using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;
using GB5Shared.Resource.GB5Solution;
using GB5Shared.Resource.Response;
using GB5Shared.Validation;
using MMDAL.DTO.PartyTaxType;
using MMDAL.DTO.Terms;
using MMDAL.Query.TermsSet;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.CustomCode.TermsSet
{
    public class TermsSetDAL : ITermsSetDAL
    {
        private readonly IQueryExecutor _QueryExecutor;
        private readonly IValidation _Validation;


        public TermsSetDAL(IQueryExecutor QueryExecutor, IValidation Validation)
        {
            _QueryExecutor = QueryExecutor;
            _Validation = Validation;
        }
        public  async Task<string> GetSelectListTermsSet(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO)
        {
            try
            {
                string SQL = TermsSetQB.GET_SELECTLIST_TERMSSET;
                string name = GetCriteriaStringValue(CriteriaDTO, "Name", "");
                var parameters = new
                {
                    name = name


                };

                IEnumerable<TermsSetPicklistDTO> result = await _QueryExecutor.QueryAsync<TermsSetPicklistDTO>(LoginDTO, SQL, parameters);
                return JsonConvert.SerializeObject(result);

            }
            catch (Exception ex)
            {
                throw new Exception(MMResource.SelectListFailed, ex);
            }
        }
        private string GetCriteriaStringValue(CriteriaDTO criteriaDTO, string fieldName, string defaultValue)
        {
            try
            {
                var attr = criteriaDTO?.SectionCriteriaList?
                    .SelectMany(s => s.AttributesCriteriaList)
                    .FirstOrDefault(a => a.FieldName == fieldName);

                if (attr?.FieldValue is System.Text.Json.JsonElement je)
                    return je.ValueKind == System.Text.Json.JsonValueKind.String
                           ? je.GetString() ?? defaultValue
                           : defaultValue;

                return attr != null ? Convert.ToString(attr.FieldValue) ?? defaultValue : defaultValue;
            }
            catch { return defaultValue; }
        }
    }
}