using System.Collections.Generic;
using System.Linq;
using _0_Framework.InfraStructure;
using Company.Domain.CrossJobAgg;
using CompanyManagment.App.Contracts.CrossJob;
using Microsoft.EntityFrameworkCore;

namespace CompanyManagment.EFCore.Repository;

public class CrossJobRepository : RepositoryBase<long, CrossJob>, ICrossJobRepository
{
    private readonly CompanyContext _context;

    public CrossJobRepository(CompanyContext context) : base(context)
    {
        _context = context;
    }

    public List<CrossJobViewModel> GetCrossJob(long idGuild)
    {
        return _context.CrossJobs.Where(x => x.CrossJobGuildId == idGuild).Include(c => c.CrossJobGuild)
            .Select(x => new CrossJobViewModel
            {
                Id = x.id,
                SalaryRatioOver = x.SalaryRatioOver,
                SalaryRatioUnder = x.SalaryRatioUnder,
                EquivalentRialOver = x.EquivalentRialOver,
                EquivalentRialUnder = x.EquivalentRialUnder,
                CrossJobGuildId = x.CrossJobGuildId,
                //parentRowId = x.ParentRowId,
                //jobId = x.JobId,
                //job =new App.Contracts.Job.JobViewModel{
                //   Id =  x.Job.id,
                //   JobName = x.Job.JobName
                //}
            }).ToList();
    }

    public long CreateBackId(CrossJob createCrossJob)
    {
        _context.Add(createCrossJob);
        _context.SaveChanges();
        return createCrossJob.id;
    }

    public EditCrossJob GetDetails(long id)
    {
        return _context.CrossJobs.Include(c => c.CrossJobGuild).Select(x => new EditCrossJob
            {
                Id = x.id,
                SalaryRatioOver = x.SalaryRatioOver,
                SalaryRatioUnder = x.SalaryRatioUnder,
                EquivalentRialOver = x.EquivalentRialOver,
                EquivalentRialUnder = x.EquivalentRialUnder,
                CrossJobGuildId = x.CrossJobGuildId,
                //parentRowId = x.ParentRowId,
                //jobId = x.JobId,
                //job = new App.Contracts.Job.JobViewModel
                //{
                //    Id = x.Job.id,
                //    JobName = x.Job.JobName
                //}
            })
            .FirstOrDefault(x => x.Id == id);
    }

    public List<CrossJobViewModel> Search(CrossJobSearchModel searchModel)
    {
        var query = _context.CrossJobs.Include(c => c.CrossJobGuild).Select(x => new CrossJobViewModel
        {
            Id = x.id,
            SalaryRatioOver = x.SalaryRatioOver,
            SalaryRatioUnder = x.SalaryRatioUnder,
            EquivalentRialOver = x.EquivalentRialOver,
            EquivalentRialUnder = x.EquivalentRialUnder,
            CrossJobGuildId = x.CrossJobGuildId,
            //parentRowId = x.ParentRowId,
            //jobId = x.JobId,
            //job = new App.Contracts.Job.JobViewModel
            //{
            //    Id = x.Job.id,
            //    JobName = x.Job.JobName
            //}
        });
        //if (!string.IsNullOrWhiteSpace(searchModel.Title))
        //    query = query.Where(x => x.Title.Contains(searchModel.Title));
        if (searchModel.CrossJobGuildId != 0)
            query = query.Where(x => x.CrossJobGuildId == searchModel.CrossJobGuildId);
        //if (searchModel.parentRowId != 0)
        //    query = query.Where(x => x.parentRowId == searchModel.parentRowId);
        //if (searchModel.jobId != 0)
        //    query = query.Where(x => x.jobId == searchModel.jobId);
        return query.OrderByDescending(x => x.Id).ToList();
    }
    public void Remove(long id)
    {
        var query = _context.CrossJobs.Where(x => x.id == id).FirstOrDefault();
        Remove(query);
    }
    public void RemoveRange(long id)
    {
        var query = _context.CrossJobs.Where(x => x.CrossJobGuildId == id);
        RemoveRange(query);
    }


}