using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using _0_Framework.Application;
using Company.Domain.File1;
using Company.Domain.ProceedingSession;
using CompanyManagment.App.Contracts.Board;
using CompanyManagment.App.Contracts.Employee;
using CompanyManagment.App.Contracts.Employer;
using CompanyManagment.App.Contracts.Evidence;
using CompanyManagment.App.Contracts.File1;
using CompanyManagment.App.Contracts.MasterPenaltyTitle;
using CompanyManagment.App.Contracts.MasterPetition;
using CompanyManagment.App.Contracts.MasterWorkHistory;
using CompanyManagment.App.Contracts.PenaltyTitle;
using CompanyManagment.App.Contracts.Petition;
using CompanyManagment.App.Contracts.ProceedingSession;
using CompanyManagment.App.Contracts.WorkHistory;

namespace CompanyManagment.Application;

public class FileApplication : IFileApplication
{
    private readonly IFileRepository _fileRepository;
    private readonly IBoardApplication _boardApplication;
    private readonly IPetitionApplication _petitionApplication;
    private readonly IProceedingSessionRepository _proceedingSessionRepository;
    private readonly IMasterPetitionApplication _masterPetitionApplication;
    private readonly IEvidenceApplication _evidenceApplication;
    private readonly IWorkHistoryApplication _workHistoryApplication;
    private readonly IPenaltyTitleApplication _penaltyTitleApplication;
    private readonly IMasterWorkHistoryApplication _masterWorkHistoryApplication;
    private readonly IMasterPenaltyTitleApplication _masterPenaltyTitleApplication;
    private readonly IEmployeeApplication _employeeApplication;
    private readonly IEmployerApplication _employerApplication;


    public FileApplication
    (
        IFileRepository fileRepository,
        IBoardApplication boardApplication,
        IPetitionApplication petitionApplication,
        IProceedingSessionRepository proceedingSessionRepository,
        IMasterPetitionApplication masterPetitionApplication,
        IEvidenceApplication evidenceApplication,
        IWorkHistoryApplication workHistoryApplication,
        IPenaltyTitleApplication penaltyTitleApplication,
        IMasterWorkHistoryApplication masterWorkHistoryApplication,
        IMasterPenaltyTitleApplication masterPenaltyTitleApplication,
        IEmployeeApplication employeeApplication,
        IEmployerApplication employerApplication)
    {
        _fileRepository = fileRepository;
        _boardApplication = boardApplication;
        _petitionApplication = petitionApplication;
        _proceedingSessionRepository = proceedingSessionRepository;
        _masterPetitionApplication = masterPetitionApplication;
        _evidenceApplication = evidenceApplication;
        _workHistoryApplication = workHistoryApplication;
        _penaltyTitleApplication = penaltyTitleApplication;
        _masterWorkHistoryApplication = masterWorkHistoryApplication;
        _masterPenaltyTitleApplication = masterPenaltyTitleApplication;
        _employeeApplication = employeeApplication;
        _employerApplication = employerApplication;
    }

    public OperationResult Create(CreateFile command)
    {
        var operation = new OperationResult();
        var clientVisitDate = new DateTime();

        clientVisitDate = command.ClientVisitDate.ToGeorgianDateTime();

        //TODO if
        if(_fileRepository.Exists(x=>x.ArchiveNo == command.ArchiveNo))
            return operation.Failed("شماره بایگانی تکراری است");

        var file = new Company.Domain.File1.File1(command.ArchiveNo, clientVisitDate, command.ProceederReference,
            command.Reqester, command.Summoned, command.Client, command.FileClass, command.HasMandate,
            command.Description);
        _fileRepository.Create(file);
        _fileRepository.SaveChanges();

        return operation.Succcedded();
    }

    public OperationResult Edit(EditFile command)
    {
        var operation = new OperationResult();
        var file = _fileRepository.Get(command.Id);
        var clientVisitDate = new DateTime();

        if (command.ClientVisitDate != null)
        {
                
            clientVisitDate = command.ClientVisitDate.ToGeorgianDateTime();
        }
        else
        {
            clientVisitDate = file.ClientVisitDate;
        }


        //TODO
        //if(_BoardRepository.Exists(x=>x.Branch == command.Branch))
        //    operation.Failed("fail message")

        file.Edit(command.ArchiveNo, clientVisitDate, command.ProceederReference,
            command.Reqester, command.Summoned, command.Client, command.FileClass, command.HasMandate,
            command.Description, command.Status);
        _fileRepository.SaveChanges();

        return operation.Succcedded();
    }

    public EditFile GetDetails(long id)
    {
        var file = _fileRepository.GetDetails(id);

        file.ClientFullName = GetFileClientFullName(file.Id);
        file.OppositePersonFullName = GetFileOppositePersonFullName(file.Id);

        return file;
    }

    public List<FileViewModel> Search(FileSearchModel searchModel)
    {
        if (searchModel.UserId_RequesterOrSummoned != null)
        {
            var splitedString = searchModel.UserId_RequesterOrSummoned.Split("-");

            searchModel.UserId = int.Parse(splitedString[0]);
            searchModel.Client = int.Parse(splitedString[1]);
        }

        return _fileRepository.Search(searchModel);
    }

    public FileViewModel GetLastArchiveNumber(FileSearchModel searchModel)
    {
        var model = Search(searchModel);

        return model.Count != 0 ? model.OrderByDescending(x => x.ArchiveNo).FirstOrDefault() : new FileViewModel { ArchiveNo = 0 };
    }
    public long FindLastArchiveNumber()
    {
        return _fileRepository.FindLastArchiveNumber();
    }

    public string GetEmployeeFullNameById(long id)
    {
        return _fileRepository.GetEmployeeFullNameById(id);
    }

    public string GetEmployerFullNameById(long id)
    {
        return _fileRepository.GetEmployerFullNameById(id);
    }

    public List<EmployeeViewModel> GetAllEmploees(bool filter = true)
    {
        var employees = _fileRepository.GetAllEmploees();

        if (!filter)
            return employees;

        var allEmployees = new List<EmployeeViewModel>(employees);
        var files = _fileRepository.Search(new FileSearchModel());
        var filesUsers = files.Select(x => new { Id = x.Reqester }).ToList();
        filesUsers.AddRange(files.Select(x => new { Id = x.Summoned }).ToList());

        foreach(var employee in allEmployees)
        {
            if(filesUsers.Where(x => x.Id == employee.Id).FirstOrDefault() == null)
                employees.Remove(employee);
        }

        return employees;
    }

    public List<EmployerViewModel> GetAllEmployers(bool filter = true)
    {
        var employers = _fileRepository.GetAllEmployers();

        if (!filter)
            return employers;

        var allEmployers = new List<EmployerViewModel>(employers);
        var files = _fileRepository.Search(new FileSearchModel());
        var filesUsers = files.Select(x => new { Id = x.Reqester }).ToList();
        filesUsers.AddRange(files.Select(x => new { Id = x.Summoned }).ToList());

        foreach (var employer in allEmployers)
        {
            if (filesUsers.Where(x => x.Id == employer.Id).FirstOrDefault() == null)
                employers.Remove(employer);
        }

        return employers;
    }

    public FileViewModel GetFileDetails(FileViewModel file)
    {
        var viewModel = new FileViewModel();
        var searchModel = new FileSearchModel();

        searchModel.diagnosisProceedingSession.Status = 0;
        searchModel.disputeResolutionProceedingSession.Status = 0; 


        //if (searchModel.diagnosisBoard == null)
        //    searchModel.diagnosisBoard = new BoardSearchModel();

        //if (searchModel.diagnosisProceedingSession == null)
        //    searchModel.diagnosisProceedingSession = new ProceedingSessionSearchModel();

        //if (searchModel.disputeResolutionBoard == null)
        //    searchModel.disputeResolutionBoard = new BoardSearchModel();

        //if (searchModel.disputeResolutionProceedingSession == null)
        //    searchModel.disputeResolutionProceedingSession =
        //        new ProceedingSessionSearchModel();

        viewModel = file;

        searchModel.diagnosisBoard.File_Id = file.Id;
        searchModel.diagnosisBoard.BoardType_Id = 1;
        var diagnosisBoard =
            _boardApplication.Search(searchModel.diagnosisBoard).FirstOrDefault()
            ?? new EditBoard();

        searchModel.diagnosisProceedingSession.Board_Id = diagnosisBoard.Id;
        var diagnosisProceedingSessionList = _proceedingSessionRepository.Search(
            searchModel.diagnosisProceedingSession
        );

        //var diagnosisPsListCount = _proceedingSessionRepository.Search(searchModel.diagnosisProceedingSession).Count();
        var diagnosisPsListCount = diagnosisProceedingSessionList.Count();
        var firstDiagnosisProceedingSession = new EditProceedingSession();
        var lastDiagnosisProceedingSession = new EditProceedingSession();
        if (diagnosisProceedingSessionList.Count != 0)
        {
            if (diagnosisProceedingSessionList.Count == 1)
                firstDiagnosisProceedingSession = diagnosisProceedingSessionList.First();
            else
            {
                firstDiagnosisProceedingSession = diagnosisProceedingSessionList.First();
                lastDiagnosisProceedingSession = diagnosisProceedingSessionList.Last();
            }
        }

        var diagnosisPetition =
            _petitionApplication.GetDetails(file.Id, 1) ?? new EditPetition();

        searchModel.disputeResolutionBoard.File_Id = file.Id;
        searchModel.disputeResolutionBoard.BoardType_Id = 2;
        var disputeResolutionBoard =
            _boardApplication.Search(searchModel.disputeResolutionBoard).FirstOrDefault()
            ?? new EditBoard();

        searchModel.disputeResolutionProceedingSession.Board_Id = disputeResolutionBoard.Id;
        var disputeResolutionProceedingSessionList = _proceedingSessionRepository.Search(
            searchModel.disputeResolutionProceedingSession
        );

        var disputeResolutionPsListCount = disputeResolutionProceedingSessionList.Count();
        var firstDisputeResolutionProceedingSession = new EditProceedingSession();
        var lastDisputeResolutionProceedingSession = new EditProceedingSession();
        if (disputeResolutionProceedingSessionList.Count != 0)
        {
            if (disputeResolutionProceedingSessionList.Count == 1)
                firstDisputeResolutionProceedingSession = disputeResolutionProceedingSessionList.First();
            else
            {
                firstDisputeResolutionProceedingSession =
                    disputeResolutionProceedingSessionList.First();
                lastDisputeResolutionProceedingSession =
                    disputeResolutionProceedingSessionList.Last();
            }
        }

        var disputeResolutionPetition =
            _petitionApplication.GetDetails(file.Id, 2) ?? new EditPetition();

        viewModel.DiagnosisBoard = diagnosisBoard;
        viewModel.DiagnosisPsCount =
            firstDiagnosisProceedingSession.Id == lastDiagnosisProceedingSession.Id
                ? diagnosisPsListCount
                : diagnosisPsListCount - 1;
        viewModel.FirstDiagnosisPS = firstDiagnosisProceedingSession;
        viewModel.LastDiagnosisPS = lastDiagnosisProceedingSession;
        viewModel.DiagnosisPetition = diagnosisPetition;

        viewModel.DisputeResolutionBoard = disputeResolutionBoard;
        viewModel.DisputeResolutionPsCount =
            firstDisputeResolutionProceedingSession.Id
            == lastDisputeResolutionProceedingSession.Id
                ? disputeResolutionPsListCount
                : disputeResolutionPsListCount - 1;
        viewModel.FirstDisputeResolutionPS = firstDisputeResolutionProceedingSession;
        viewModel.LastDisputeResolutionPS = lastDisputeResolutionProceedingSession;
        viewModel.DisputeResolutionPetition = disputeResolutionPetition;

        var masterPetitions = _masterPetitionApplication.Search(new MasterPetitionSearchModel { File_Id = file.Id }).ToList();
        viewModel.DiagnosisMasterPetitionId = masterPetitions.Where(x => x.BoardType_Id == 1).FirstOrDefault() != null
            ? masterPetitions.Where(x => x.BoardType_Id == 1).FirstOrDefault().Id
            : 0;
        viewModel.DisputeResolutionMasterPetitionId = masterPetitions.Where(x => x.BoardType_Id == 2).FirstOrDefault() != null
            ? masterPetitions.Where(x => x.BoardType_Id == 2).FirstOrDefault().Id
            : 0;

        var evidences = _evidenceApplication.Search(new EvidenceSearchModel { File_Id = file.Id }).ToList();
        viewModel.DiagnosisEvidenceId = evidences.Where(x => x.BoardType_Id == 1).FirstOrDefault() != null
            ? evidences.Where(x => x.BoardType_Id == 1).FirstOrDefault().Id
            : 0;
        viewModel.DisputeResolutionEvidenceId = evidences.Where(x => x.BoardType_Id == 2).FirstOrDefault() != null
            ? evidences.Where(x => x.BoardType_Id == 2).FirstOrDefault().Id
            : 0;

        viewModel.ClientFullName = GetFileClientFullName(viewModel.Id);
        viewModel.OppositePersonFullName = GetFileOppositePersonFullName(viewModel.Id);

        if(file.Client == 1)
        {
            viewModel.EmployeeDetail = _employeeApplication.GetDetails(file.Reqester);
        }
        else
        {
            viewModel.EmployerDetail = _employerApplication.GetDetails(file.Summoned);
        }

        return viewModel;
    }

    public bool FilterFileDetails(FileViewModel tempViewModel, FileSearchModel fileSearchModel)
    {
        if (fileSearchModel == null)
            return true;

        if (fileSearchModel.ArchiveNo != null && !CheckValue(tempViewModel.ArchiveNo.ToString(), fileSearchModel.ArchiveNo))
            return false;

        if (fileSearchModel.FileClass != null && !CheckValue(tempViewModel.FileClass, fileSearchModel.FileClass))
            return false;

        if (fileSearchModel.UserId != 0 && !(fileSearchModel.UserId == tempViewModel.Summoned || fileSearchModel.UserId == tempViewModel.Reqester))
            return false;

        if (fileSearchModel.diagnosisBoard.Branch != null && !CheckValue(tempViewModel.DiagnosisBoard.Branch, fileSearchModel.diagnosisBoard.Branch))
            return false;

        if (!string.IsNullOrEmpty(fileSearchModel.diagnosisBoard.BoardChairman))
        {
            if (tempViewModel.DiagnosisBoard.BoardChairman == null)
                return false;

            if (!tempViewModel.DiagnosisBoard.BoardChairman.Contains(fileSearchModel.diagnosisBoard.BoardChairman))
                return false;
        }

        if (fileSearchModel.disputeResolutionBoard.Branch != null && !CheckValue(tempViewModel.DisputeResolutionBoard.Branch, fileSearchModel.disputeResolutionBoard.Branch))
            return false;
            
        if (!string.IsNullOrEmpty(fileSearchModel.disputeResolutionBoard.BoardChairman))
        {
            if(tempViewModel.DisputeResolutionBoard.BoardChairman == null)
                return false;

            if (!tempViewModel.DisputeResolutionBoard.BoardChairman.Contains(fileSearchModel.disputeResolutionBoard.BoardChairman))
                return false;
        }

        if (fileSearchModel.diagnosisProceedingSession.FromDate != null)
        {
            if (tempViewModel.FirstDiagnosisPS.Date == null)
                return false;
            if (tempViewModel.FirstDiagnosisPS.Date.ToGeorgianDateTime() < fileSearchModel.diagnosisProceedingSession.FromDate.ToGeorgianDateTime())
                return false;
        }

        if (fileSearchModel.disputeResolutionProceedingSession.FromDate != null)
        {
            if (tempViewModel.FirstDisputeResolutionPS.Date == null)
                return false;
            if (tempViewModel.FirstDisputeResolutionPS.Date.ToGeorgianDateTime() < fileSearchModel.disputeResolutionProceedingSession.FromDate.ToGeorgianDateTime())
                return false;
        }

        if (fileSearchModel.diagnosisProceedingSession.ToDate != null)
        {
            if (tempViewModel.LastDiagnosisPS.Date == null)
                return false;
            if (fileSearchModel.diagnosisProceedingSession.ToDate.ToGeorgianDateTime() < tempViewModel.LastDiagnosisPS.Date.ToGeorgianDateTime())
                return false;
        }

        if (fileSearchModel.disputeResolutionProceedingSession.ToDate != null)
        {
            if (tempViewModel.LastDisputeResolutionPS.Date == null)
                return false;
            if (fileSearchModel.disputeResolutionProceedingSession.ToDate.ToGeorgianDateTime() < tempViewModel.LastDisputeResolutionPS.Date.ToGeorgianDateTime())
                return false;
        }

        return true;
    }

    public FileSummary GetFileSummary(long id)
    {
        var summary = new FileSummary();

        summary.File = GetDetails(id);

        if(summary.File.Client == FileEnums.CLIENT_IS_REQUESTER)
        {
            summary.File.ClientFullName = GetEmployeeFullNameById(summary.File.Reqester);
            summary.File.OppositePersonFullName = GetEmployerFullNameById(summary.File.Summoned);
        }
        else
        {
            summary.File.ClientFullName = GetEmployerFullNameById(summary.File.Summoned);
            summary.File.OppositePersonFullName = GetEmployeeFullNameById(summary.File.Reqester);
        }

        summary.DiagnosisMasterPetition = _masterPetitionApplication.GetDetails(id, 1) ?? new EditMasterPetition();
        var masterPetitionId = summary.DiagnosisMasterPetition != null ? summary.DiagnosisMasterPetition.Id : 0;
        summary.DiagnosisMasterPetition.CreateMasterPenaltyTitle = _masterPenaltyTitleApplication.Search(masterPetitionId);
        summary.DiagnosisMasterPetition.CreateMasterWorkHistory = _masterWorkHistoryApplication.Search(masterPetitionId);

        summary.File.createDiagnosisBoard = _boardApplication.GetDetails(id, 1) ?? new EditBoard();

        if (summary.File.createDiagnosisBoard.Id == 0)
            summary.File.createDiagnosisPS = new List<EditProceedingSession>();

        else
            summary.File.createDiagnosisPS = _proceedingSessionRepository.Search(new ProceedingSessionSearchModel { Board_Id = summary.File.createDiagnosisBoard.Id });

        summary.File.createDiagnosisPetition = _petitionApplication.GetDetails(id, 1) ?? new EditPetition();
        var petitionId = summary.File.createDiagnosisPetition != null ? summary.File.createDiagnosisPetition.Id : 0;
        summary.File.createDiagnosisPetition.CreatePenaltyTitle = _penaltyTitleApplication.Search(petitionId);
        summary.File.createDiagnosisPetition.CreateWorkHistory = _workHistoryApplication.Search(petitionId);
        summary.File.createDiagnosisPetition.TotalPaidAmounts = summary.File.createDiagnosisPetition.CreatePenaltyTitle.Sum(x => x.PaidAmount != null ? Int32.Parse(x.PaidAmount.Replace(",", "")) : 0).ToString();


        summary.DisputeResolutionMasterPetition = _masterPetitionApplication.GetDetails(id, 2) ?? new EditMasterPetition();
        masterPetitionId = summary.DisputeResolutionMasterPetition != null ? summary.DisputeResolutionMasterPetition.Id : 0;
        summary.DisputeResolutionMasterPetition.CreateMasterPenaltyTitle = _masterPenaltyTitleApplication.Search(masterPetitionId);
        summary.DisputeResolutionMasterPetition.CreateMasterWorkHistory = _masterWorkHistoryApplication.Search(masterPetitionId);

        summary.File.createDisputeResolutionBoard = _boardApplication.GetDetails(id, 2) ?? new EditBoard();

        if (summary.File.createDisputeResolutionBoard.Id == 0)
            summary.File.createDisputeResolutionPS = new List<EditProceedingSession>();

        else
            summary.File.createDisputeResolutionPS = _proceedingSessionRepository.Search(new ProceedingSessionSearchModel { Board_Id = summary.File.createDisputeResolutionBoard.Id });

        summary.File.createDisputeResolutionPetition = _petitionApplication.GetDetails(id, 2) ?? new EditPetition();
        petitionId = summary.File.createDisputeResolutionPetition != null ? summary.File.createDisputeResolutionPetition.Id : 0;
        summary.File.createDisputeResolutionPetition.CreatePenaltyTitle = _penaltyTitleApplication.Search(summary.File.createDisputeResolutionPetition != null ? summary.File.createDisputeResolutionPetition.Id : 0);
        summary.File.createDisputeResolutionPetition.CreateWorkHistory = _workHistoryApplication.Search(summary.File.createDisputeResolutionPetition != null ? summary.File.createDisputeResolutionPetition.Id : 0);
        summary.File.createDisputeResolutionPetition.TotalPaidAmounts = summary.File.createDisputeResolutionPetition.CreatePenaltyTitle.Sum(x => x.PaidAmount != null ? Int32.Parse(x.PaidAmount.Replace(",", "")) : 0).ToString();

        return summary;
    }

    private string GetFileClientFullName(long fileId)
    {
        var file = _fileRepository.GetDetails(fileId);
        var clientFullName = "";

        if (file.Client == 1)
            clientFullName = GetEmployeeFullNameById(file.Reqester);

        else
            clientFullName = GetEmployerFullNameById(file.Summoned);
             

        return clientFullName;
    }
        
    private string GetFileOppositePersonFullName(long fileId)
    {
        var file = _fileRepository.GetDetails(fileId);
        var oppositePersonFullName = "";

        if (file.Client == 1)
            oppositePersonFullName = GetEmployerFullNameById(file.Summoned);

        else
            oppositePersonFullName = GetEmployeeFullNameById(file.Reqester);


        return oppositePersonFullName;
    }

    private bool CheckValue(string viewModel, string searchModel)
    {
        if (!string.IsNullOrEmpty(viewModel) && viewModel.Contains(searchModel))
            return true;

        return false;
    }

    public FileViewModel GetFileDetailsByBoardId(long boardId)
    {
        var board = _boardApplication.GetDetails(boardId);

        var file = Search(new FileSearchModel { Id = board.File_Id }).FirstOrDefault();

        return GetFileDetails(file);

        //return file;
    }

    #region Mahan
    public async Task<List<FileExcelViewModel>> GetExcelDetails()
    {
        return await _fileRepository.GetExcelDetails();
    }
    public async Task<List<FileListViewModel>> GetList(GetFileSearchModel searchModel)
    {
        return await _fileRepository.GetList(searchModel);
    }

    public async Task<List<string>> GetAllArchiveNo()
    {
        return await _fileRepository.GetAllArchiveNo();
    }

    public async Task<List<string>> GetAllClassFiles()
    {
        return await _fileRepository.GetAllClassFiles();
    }

    public async Task<List<EmployeeSelectListViewModel>> GetClientAndLitigation()
    {
        return await _fileRepository.GetClientAndLitigation();
    }

    public async Task<EditEmployee> GetClientDetails(long fileId)
    {
        return await _fileRepository.GetClientDetails(fileId);
    }

    #endregion
}