using Dapper;
using HashidsNet;
using Microsoft.AspNetCore.JsonPatch;
using MisIngredientesVue.Core.Exceptions;
using MisIngredientesVue.Core.Extensions;
using MisIngredientesVue.Core.Models;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Information;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;

namespace MisIngredientesVue.Core.Services
{
    public interface ISellersService
    {
        Task<FindResults<Seller>> GetSellers(int skip, int take, string sortBy, string sortOrder, string q);
        Task<MemoryStream> GetExcel(int offset, string sortBy, string sortOrder, string q);
        Task<Seller> InsertSeller(Seller seller);
        Task UpdateSeller(Seller seller);
        Task DeleteSellers(int[] ids);
        Task<Seller> GetSellerById(int id);
        Task<FindResults<SellerEarning>> GetSellerEarnings(int id, int skip, int take, string sortBy, string sortOrder, string q);

    }

    public class SellersService : ISellersService
    {
        private readonly IRepository _repository;

        public SellersService(IRepository repository)
        {
            _repository = repository;
        }

        public async Task DeleteSellers(int[] ids)
        {
            await _repository.DeleteManyByIds<Product, int>("TODO", -1, ids);
        }

        public async Task<MemoryStream> GetExcel(int offset, string sortBy, string sortOrder, string q)
        {
            var filterExpression = GetFilterExpression(q);
            return await _repository.GetExcel<Seller, int>("TODO", offset, filterExpression, sortBy, sortOrder);
        }

        public async Task<Seller> GetSellerById(int id)
        {
            return await _repository.FindOneById<Seller, int>("TODO", id);
        }

        public async Task<FindResults<SellerEarning>> GetSellerEarnings(int id, int skip, int take, string sortBy, string sortOrder, string q)
        {
            var filterExpression = GetEarningsFilterExpression(id, q);
            return await _repository.Find<SellerEarning, int>("TODO", filterExpression, skip, take, sortBy, sortOrder);
        }

        public async Task<FindResults<Seller>> GetSellers(int skip, int take, string sortBy, string sortOrder, string q)
        {
            var filterExpression = GetFilterExpression(q);
            return await _repository.Find<Seller, int>("TODO", filterExpression, skip, take, sortBy, sortOrder);
        }

        public async Task<Seller> InsertSeller(Seller seller)
        {
            var newSeller = await _repository.Insert<Seller, int>("TODO", null, seller, false);
            return newSeller;
        }

        public async Task UpdateSeller(Seller seller)
        {
            await _repository.Update<Seller, int>("TODO", 0, seller);
        }

        private Expression<Func<SellerEarning, bool>> GetEarningsFilterExpression(int sellerId, string q)
        {
            return x => x.SellerId == sellerId;
        }

        private Expression<Func<Seller, bool>> GetFilterExpression(string q)
        {
            return x => x.FirstName.Contains(q) || x.LastName.Contains(q) || x.Email.Contains(q);
        }
    }
}