using Common;
using Common.Constant;
using Common.Http;
using Common.Logic;
using Esim.Apis.Singleton;
using Database.Database;
using log4net;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;

namespace Esim.Apis.Business
{
    public class ContentBusinessImpl : IContentBusiness
    {
        private static readonly log4net.ILog log = log4net.LogManager.GetLogger(
            typeof(ContentBusinessImpl)
        );

        private ModelContext dbContext;
        IConfiguration configuration;

        public ContentBusinessImpl(ModelContext _dbContext, IConfiguration _configuration)
        {
            dbContext = _dbContext;
            configuration = _configuration;
        }

        public async Task<IActionResult> BannerLoad(HttpRequest httpRequest, BannerLoadReq request)
        {
            var url = httpRequest.Path;
            var json = JsonConvert.SerializeObject(request);
            log.Debug("URL: " + url + " => Request: " + json);
            try
            {
                string lang = CommonLogic.GetLanguage(httpRequest, request.lang);
                int pageNumber = request.pageNumber < 0 ? 0 : request.pageNumber;
                int pageSize = request.pageSize <= 0 ? 10 : request.pageSize;

                var query = dbContext.Banners
                    .Where(b => b.Status == true)
                    .Where(b => b.StartDate == null || b.StartDate <= DateTime.Now)
                    .Where(b => b.EndDate == null || b.EndDate >= DateTime.Now);

                if (!string.IsNullOrEmpty(request.position))
                {
                    query = query.Where(b => b.Position == request.position);
                }

                int totalCount = query.Count();
                int totalPages = (int)Math.Ceiling((double)totalCount / pageSize);

                var banners = query
                    .OrderBy(b => b.DisplayOrder)
                    .ThenByDescending(b => b.CreatedDate)
                    .Skip(pageNumber * pageSize)
                    .Take(pageSize)
                    .Select(b => new
                    {
                        b.Id,
                        title = lang == "en"
                            ? (b.TitleEn ?? b.Title)
                            : (b.TitleLo ?? b.Title),
                        subtitle = lang == "en"
                            ? (b.SubtitleEn ?? b.Subtitle)
                            : (b.SubtitleLo ?? b.Subtitle),
                        b.ImageUrl,
                        b.ImageMobileUrl,
                        b.LinkUrl,
                        b.LinkTarget,
                        b.Position,
                        b.DisplayOrder
                    })
                    .ToList();

                return DotnetLib.Http.HttpResponse.BuildResponse(
                    log, url, json,
                    CommonErrorCode.Success,
                    ConfigManager.Instance.GetConfigWebValue("LOAD_SUCCESS", lang),
                    new { items = banners, pagination = new { pageNumber, pageSize, totalCount, totalPages } }
                );
            }
            catch (Exception ex)
            {
                log.Error("Exception: ", ex);
            }
            return DotnetLib.Http.HttpResponse.BuildResponse(
                log, url, json,
                CommonErrorCode.SystemError,
                ConfigManager.Instance.GetConfigWebValue("SYSTEM_FAILURE"),
                new { }
            );
        }

        public async Task<IActionResult> CustomerReviewLoad(HttpRequest httpRequest, CustomerReviewLoadReq request)
        {
            var url = httpRequest.Path;
            var json = JsonConvert.SerializeObject(request);
            log.Debug("URL: " + url + " => Request: " + json);
            try
            {
                string lang = CommonLogic.GetLanguage(httpRequest, request.lang);
                int pageNumber = request.pageNumber < 0 ? 0 : request.pageNumber;
                int pageSize = request.pageSize <= 0 ? 10 : request.pageSize;

                var query = dbContext.CustomerReviews
                    .Where(r => r.Status == true);

                if (request.isFeatured.HasValue && request.isFeatured.Value)
                {
                    query = query.Where(r => r.IsFeatured == true);
                }

                int totalCount = query.Count();
                int totalPages = (int)Math.Ceiling((double)totalCount / pageSize);

                var reviews = query
                    .OrderBy(r => r.DisplayOrder)
                    .ThenByDescending(r => r.CreatedDate)
                    .Skip(pageNumber * pageSize)
                    .Take(pageSize)
                    .Select(r => new
                    {
                        r.Id,
                        r.CustomerName,
                        r.AvatarUrl,
                        r.Rating,
                        reviewContent = lang == "en"
                            ? (r.ReviewContentEn ?? r.ReviewContent)
                            : (r.ReviewContentLo ?? r.ReviewContent),
                        destination = lang == "en"
                            ? (r.DestinationEn ?? r.Destination)
                            : (r.DestinationLo ?? r.Destination),
                        r.IsFeatured,
                        r.CreatedDate
                    })
                    .ToList();

                return DotnetLib.Http.HttpResponse.BuildResponse(
                    log, url, json,
                    CommonErrorCode.Success,
                    ConfigManager.Instance.GetConfigWebValue("LOAD_SUCCESS", lang),
                    new { items = reviews, pagination = new { pageNumber, pageSize, totalCount, totalPages } }
                );
            }
            catch (Exception ex)
            {
                log.Error("Exception: ", ex);
            }
            return DotnetLib.Http.HttpResponse.BuildResponse(
                log, url, json,
                CommonErrorCode.SystemError,
                ConfigManager.Instance.GetConfigWebValue("SYSTEM_FAILURE"),
                new { }
            );
        }

        public async Task<IActionResult> CustomerReviewCreate(HttpRequest httpRequest, CustomerReviewCreateReq request)
        {
            var url = httpRequest.Path;
            var json = JsonConvert.SerializeObject(request);
            log.Debug("URL: " + url + " => Request: " + json);
            try
            {
                string lang = CommonLogic.GetLanguage(httpRequest, request.lang);

                // Validate required fields
                if (string.IsNullOrEmpty(request.customerName) || string.IsNullOrEmpty(request.reviewContent))
                {
                    return DotnetLib.Http.HttpResponse.BuildResponse(
                        log, url, json,
                        CommonErrorCode.RequiredFieldMissing,
                        ConfigManager.Instance.GetConfigWebValue("REQUIRED_FIELD_MISSING", lang),
                        new { }
                    );
                }

                // Create new review (pending approval)
                var review = new CustomerReview
                {
                    CustomerName = request.customerName,
                    ReviewContent = request.reviewContent,
                    Destination = request.destination,
                    Rating = request.rating > 0,
                    Status = false, // Pending approval
                    IsFeatured = false,
                    CreatedDate = DateTime.Now
                };

                dbContext.CustomerReviews.Add(review);
                await dbContext.SaveChangesAsync();

                return DotnetLib.Http.HttpResponse.BuildResponse(
                    log, url, json,
                    CommonErrorCode.Success,
                    ConfigManager.Instance.GetConfigWebValue("REVIEW_SUBMITTED", lang),
                    new { reviewId = review.Id }
                );
            }
            catch (Exception ex)
            {
                log.Error("Exception: ", ex);
            }
            return DotnetLib.Http.HttpResponse.BuildResponse(
                log, url, json,
                CommonErrorCode.SystemError,
                ConfigManager.Instance.GetConfigWebValue("SYSTEM_FAILURE"),
                new { }
            );
        }

        public async Task<IActionResult> FaqCategoryLoad(HttpRequest httpRequest, FaqCategoryLoadReq request)
        {
            var url = httpRequest.Path;
            var json = JsonConvert.SerializeObject(request);
            log.Debug("URL: " + url + " => Request: " + json);
            try
            {
                string lang = CommonLogic.GetLanguage(httpRequest, request.lang);
                int pageNumber = request.pageNumber < 0 ? 0 : request.pageNumber;
                int pageSize = request.pageSize <= 0 ? 10 : request.pageSize;

                var query = dbContext.FaqCategories
                    .Where(c => c.Status == true);

                int totalCount = query.Count();
                int totalPages = (int)Math.Ceiling((double)totalCount / pageSize);

                var categories = query
                    .OrderBy(c => c.DisplayOrder)
                    .ThenBy(c => c.Id)
                    .Skip(pageNumber * pageSize)
                    .Take(pageSize)
                    .Select(c => new
                    {
                        c.Id,
                        categoryName = lang == "en"
                            ? (c.CategoryNameEn ?? c.CategoryName)
                            : (c.CategoryNameLo ?? c.CategoryName),
                        c.CategorySlug,
                        description = lang == "en"
                            ? (c.DescriptionEn ?? c.Description)
                            : (c.DescriptionLo ?? c.Description),
                        c.IconUrl,
                        c.DisplayOrder
                    })
                    .ToList();

                return DotnetLib.Http.HttpResponse.BuildResponse(
                    log, url, json,
                    CommonErrorCode.Success,
                    ConfigManager.Instance.GetConfigWebValue("LOAD_SUCCESS", lang),
                    new { items = categories, pagination = new { pageNumber, pageSize, totalCount, totalPages } }
                );
            }
            catch (Exception ex)
            {
                log.Error("Exception: ", ex);
            }
            return DotnetLib.Http.HttpResponse.BuildResponse(
                log, url, json,
                CommonErrorCode.SystemError,
                ConfigManager.Instance.GetConfigWebValue("SYSTEM_FAILURE"),
                new { }
            );
        }

        public async Task<IActionResult> FaqLoad(HttpRequest httpRequest, FaqLoadReq request)
        {
            var url = httpRequest.Path;
            var json = JsonConvert.SerializeObject(request);
            log.Debug("URL: " + url + " => Request: " + json);
            try
            {
                string lang = CommonLogic.GetLanguage(httpRequest, request.lang);
                int pageNumber = request.pageNumber < 0 ? 0 : request.pageNumber;
                int pageSize = request.pageSize <= 0 ? 10 : request.pageSize;

                var query = dbContext.Faqs
                    .Where(f => f.Status == true);

                if (request.categoryId.HasValue)
                {
                    query = query.Where(f => f.CategoryId == request.categoryId);
                }

                if (request.isFeatured.HasValue && request.isFeatured.Value)
                {
                    query = query.Where(f => f.IsFeatured == true);
                }

                int totalCount = query.Count();
                int totalPages = (int)Math.Ceiling((double)totalCount / pageSize);

                var faqs = query
                    .OrderBy(f => f.DisplayOrder)
                    .ThenByDescending(f => f.ViewCount)
                    .Skip(pageNumber * pageSize)
                    .Take(pageSize)
                    .Select(f => new
                    {
                        f.Id,
                        question = lang == "en"
                            ? (f.QuestionEn ?? f.Question)
                            : (f.QuestionLo ?? f.Question),
                        answer = lang == "en"
                            ? (f.AnswerEn ?? f.Answer)
                            : (f.AnswerLo ?? f.Answer),
                        f.CategoryId,
                        f.ViewCount,
                        f.IsFeatured
                    })
                    .ToList();

                return DotnetLib.Http.HttpResponse.BuildResponse(
                    log, url, json,
                    CommonErrorCode.Success,
                    ConfigManager.Instance.GetConfigWebValue("LOAD_SUCCESS", lang),
                    new { items = faqs, pagination = new { pageNumber, pageSize, totalCount, totalPages } }
                );
            }
            catch (Exception ex)
            {
                log.Error("Exception: ", ex);
            }
            return DotnetLib.Http.HttpResponse.BuildResponse(
                log, url, json,
                CommonErrorCode.SystemError,
                ConfigManager.Instance.GetConfigWebValue("SYSTEM_FAILURE"),
                new { }
            );
        }

    }
}