882 lines
40 KiB
C#
882 lines
40 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Diagnostics;
|
||
using System.Linq;
|
||
using System.Threading.Tasks;
|
||
using _0_Framework.Application;
|
||
using Company.Domain.ContarctingPartyAgg;
|
||
using Company.Domain.EmployeeAgg;
|
||
using Company.Domain.empolyerAgg;
|
||
using Company.Domain.InstitutionContractAgg;
|
||
using Company.Domain.LeftWorkAgg;
|
||
using Company.Domain.RepresentativeAgg;
|
||
using Company.Domain.WorkshopAgg;
|
||
using CompanyManagment.App.Contracts.FinancialStatment;
|
||
using CompanyManagment.App.Contracts.InstitutionContract;
|
||
using CompanyManagment.App.Contracts.Workshop;
|
||
using CompanyManagment.EFCore.Migrations;
|
||
using PersianTools.Core;
|
||
using ConnectedPersonnelViewModel = CompanyManagment.App.Contracts.Workshop.ConnectedPersonnelViewModel;
|
||
|
||
namespace CompanyManagment.Application;
|
||
|
||
public class InstitutionContractApplication : IInstitutionContractApplication
|
||
{
|
||
private readonly IInstitutionContractRepository _institutionContractRepository;
|
||
private readonly IPersonalContractingPartyRepository _contractingPartyRepository;
|
||
private readonly IRepresentativeRepository _representativeRepository;
|
||
private readonly IFinancialStatmentApplication _financialStatmentApplication;
|
||
private readonly IEmployerRepository _employerRepository;
|
||
private readonly IWorkshopRepository _workshopRepository;
|
||
private readonly ILeftWorkRepository _leftWorkRepository;
|
||
private readonly IWorkshopApplication _workshopApplication;
|
||
|
||
|
||
public InstitutionContractApplication(IInstitutionContractRepository institutionContractRepository, IPersonalContractingPartyRepository contractingPartyRepository, IRepresentativeRepository representativeRepository, IEmployerRepository employerRepository, IWorkshopRepository workshopRepository, ILeftWorkRepository leftWorkRepository, IFinancialStatmentApplication financialStatmentApplication, IWorkshopApplication workshopApplication)
|
||
{
|
||
_institutionContractRepository = institutionContractRepository;
|
||
_contractingPartyRepository = contractingPartyRepository;
|
||
_representativeRepository = representativeRepository;
|
||
_employerRepository = employerRepository;
|
||
_workshopRepository = workshopRepository;
|
||
_leftWorkRepository = leftWorkRepository;
|
||
_financialStatmentApplication = financialStatmentApplication;
|
||
_workshopApplication = workshopApplication;
|
||
}
|
||
|
||
public OperationResult Create(CreateInstitutionContract command)
|
||
{
|
||
|
||
string contractingPartyName = String.Empty;
|
||
bool dateMessages = false;
|
||
string dateMaessageResult = String.Empty;
|
||
var opration = new OperationResult();
|
||
if (_institutionContractRepository.Exists(x =>
|
||
x.ContractingPartyId == command.ContractingPartyId && x.RepresentativeId == command.RepresentativeId && x.TypeOfContract == command.TypeOfContract))
|
||
return opration.Failed("برای این معرف و طرف حساب قبلا قرارداد ایجاد شده است، شما میتوانید از تمدید استفاده کنید");
|
||
|
||
if (string.IsNullOrWhiteSpace(command.ContractDateFa))
|
||
{
|
||
dateMaessageResult = "تاریخ قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractStartFa))
|
||
{
|
||
dateMaessageResult += "تاریخ شروع قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractEndFa))
|
||
{
|
||
dateMaessageResult += "تاریخ پایان قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
|
||
if (dateMessages)
|
||
return opration.Failed(dateMaessageResult);
|
||
|
||
if (command.RepresentativeId < 1 && command.ContractingPartyId > 1)
|
||
{
|
||
return opration.Failed("معرف را انتخاب کنید");
|
||
}
|
||
else if (command.ContractingPartyId < 1 && command.RepresentativeId > 1)
|
||
{
|
||
return opration.Failed("طرف حساب را انتخاب کنید");
|
||
|
||
}
|
||
else if (command.ContractingPartyId < 1 && command.RepresentativeId < 1)
|
||
{
|
||
return opration.Failed("معرف و طرف حساب را انتخاب کنید");
|
||
}
|
||
|
||
var syear = command.ContractStartFa.Substring(0, 4);
|
||
var smonth = command.ContractStartFa.Substring(5, 2);
|
||
var sday = command.ContractStartFa.Substring(8, 2);
|
||
var contractingParty = _contractingPartyRepository.GetDetails(command.ContractingPartyId);
|
||
//شماره قرارداد
|
||
var contractNo = $"{syear}{smonth}{sday}/{contractingParty.ArchiveCode}/0";
|
||
|
||
///////////////////////
|
||
if (command.ContactInformationList.Count == 0)
|
||
return opration.Failed("ورود شماره تماس برای ارسال پیامک الزامیست");
|
||
var accountContact = command.ContactInformationList.Where(x =>
|
||
x.SendSmsString == "true" && x.Position == "طرف قرارداد" && x.PhoneType == "شماره همراه" && !string.IsNullOrWhiteSpace(x.PhoneNumber)).ToList();
|
||
if(accountContact.Count == 0)
|
||
return opration.Failed("ورود شماره همراه با سمت طرف قرارداد برای ساخت حساب کاربری الزامیست");
|
||
var accountContactCount = command.ContactInformationList.Where(x => x.PhoneType == "شماره همراه" && x.Position == "طرف قرارداد").ToList();
|
||
if (accountContactCount.Count > 1)
|
||
return opration.Failed("فقط یکی از شماره تلفن ها میتواند سمت طرف قرارداد داشته باشد");
|
||
|
||
contractingPartyName = contractingParty.LName;
|
||
//نام معرف
|
||
var representative = _representativeRepository.GetDetails(command.RepresentativeId).FullName;
|
||
|
||
var contractStartGr = command.ContractStartFa.ToGeorgianDateTime();
|
||
var contractEndGr = command.ContractEndFa.ToGeorgianDateTime();
|
||
|
||
var contractDateGr = command.ContractDateFa.ToGeorgianDateTime();
|
||
|
||
if (command.Address != null && command.State == null)
|
||
{
|
||
|
||
return opration.Failed("لطفا استان و شهر را انتخاب کنید");
|
||
}
|
||
|
||
if ((command.Address != null && command.State != null) && command.City == "شهرستان")
|
||
{
|
||
|
||
return opration.Failed("لطفا شهر را انتخاب کنید");
|
||
}
|
||
|
||
if (command.Address == null && command.State != null)
|
||
{
|
||
|
||
return opration.Failed("لطفا آدرس را وارد کنید");
|
||
}
|
||
|
||
if (string.IsNullOrWhiteSpace(command.OfficialCompany))
|
||
return opration.Failed("رسمی یا غیر رسمی بودن پرداخت را مشخص کنید");
|
||
if(command.OfficialCompany == "Official" && string.IsNullOrWhiteSpace(command.HasValueAddedTax))
|
||
return opration.Failed("وضعیت ارزش افزوده را مشخص کنید");
|
||
if (string.IsNullOrWhiteSpace(command.TypeOfContract))
|
||
return opration.Failed("عنوان قرارداد را انتخاب کنید");
|
||
|
||
if (string.IsNullOrWhiteSpace(command.ContractAmountString))
|
||
command.ContractAmountString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.DailyCompenseationString))
|
||
command.DailyCompenseationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.ObligationString))
|
||
command.ObligationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.TotalAmountString))
|
||
command.TotalAmountString = "0";
|
||
command.ValueAddedTax = string.IsNullOrWhiteSpace(command.ValueAddedTaxStr) ? 0 : command.ValueAddedTaxStr.MoneyToDouble();
|
||
var contractAmount = command.ContractAmountString.ToDoubleMoney();
|
||
command.ContractAmount = Convert.ToDouble(contractAmount);
|
||
var DailyCompenseation = command.DailyCompenseationString.ToDoubleMoney();
|
||
command.DailyCompenseation = Convert.ToDouble(DailyCompenseation);
|
||
var Obligation = command.ObligationString.ToDoubleMoney();
|
||
command.Obligation = Convert.ToDouble(Obligation);
|
||
var TotalAmount = command.TotalAmountString.ToDoubleMoney();
|
||
command.TotalAmount = Convert.ToDouble(TotalAmount);
|
||
//var hasValueAddedTax = "false";
|
||
//double valueAddedTax = 0;
|
||
//if (command.HasValueAddedTax == "true")
|
||
//{
|
||
// hasValueAddedTax = "true";
|
||
// valueAddedTax = command.ContractAmount * 0.1;
|
||
// command.ContractAmount += valueAddedTax;
|
||
//}
|
||
|
||
var createContract = new InstitutionContract(contractNo, command.RepresentativeId, representative,
|
||
command.ContractingPartyId,
|
||
contractingPartyName, contractDateGr, command.ContractDateFa, command.State, command.City,
|
||
command.Address, contractStartGr,
|
||
command.ContractStartFa, contractEndGr, command.ContractEndFa, command.ContractAmount,
|
||
command.DailyCompenseation, command.Obligation,
|
||
command.TotalAmount, 0,command.WorkshopManualCount,command.EmployeeManualCount,command.Description, command.OfficialCompany, command.TypeOfContract,command.HasValueAddedTax,command.ValueAddedTax);
|
||
|
||
_institutionContractRepository.Create(createContract);
|
||
_institutionContractRepository.SaveChanges();
|
||
return opration.Succcedded(createContract.id);
|
||
}
|
||
|
||
public OperationResult Extension(CreateInstitutionContract command)
|
||
{
|
||
|
||
bool dateMessages = false;
|
||
string dateMaessageResult = String.Empty;
|
||
var opration = new OperationResult();
|
||
|
||
command.ExtensionNo += 1;
|
||
if (_institutionContractRepository.Exists(x =>
|
||
x.ExtensionNo == command.ExtensionNo && x.ContractingPartyId == command.ContractingPartyId && x.TypeOfContract == command.TypeOfContract))
|
||
return opration.Failed("برای این قرارداد قبلا تمدید ایجاد شده است");
|
||
|
||
|
||
if (string.IsNullOrWhiteSpace(command.ContractDateFa))
|
||
{
|
||
dateMaessageResult = "تاریخ قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractStartFa))
|
||
{
|
||
dateMaessageResult += "تاریخ شروع قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractEndFa))
|
||
{
|
||
dateMaessageResult += "تاریخ پایان قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
|
||
if (dateMessages)
|
||
return opration.Failed(dateMaessageResult);
|
||
|
||
var firstContract = _institutionContractRepository.GetFirstContract(command.ContractingPartyId, command.TypeOfContract);
|
||
|
||
var syear = firstContract.ContractStartFa.Substring(0, 4);
|
||
var smonth = firstContract.ContractStartFa.Substring(5, 2);
|
||
var sday = firstContract.ContractStartFa.Substring(8, 2);
|
||
var contractingParty = _contractingPartyRepository.GetDetails(command.ContractingPartyId);
|
||
//شماره قرارداد
|
||
var contractNo = $"{syear}{smonth}{sday}/{contractingParty.ArchiveCode}/{command.ExtensionNo}";
|
||
|
||
|
||
var contractStartGr = command.ContractStartFa.ToGeorgianDateTime();
|
||
var contractEndGr = command.ContractEndFa.ToGeorgianDateTime();
|
||
|
||
var contractDateGr = command.ContractDateFa.ToGeorgianDateTime();
|
||
if (_institutionContractRepository.Exists(x =>
|
||
((contractStartGr >= x.ContractStartGr && contractStartGr <= x.ContractEndGr)||(contractEndGr >= x.ContractStartGr && contractEndGr <= x.ContractEndGr)) && x.TypeOfContract == command.TypeOfContract && x.ContractingPartyId == command.ContractingPartyId))
|
||
return opration.Failed("تاریخ شروع و پایان وارد شده با قرارداد دیگری تداخل دارد");
|
||
if (command.Address != null && command.State == null)
|
||
{
|
||
|
||
return opration.Failed("لطفا استان و شهر را انتخاب کنید");
|
||
}
|
||
|
||
if ((command.Address != null && command.State != null) && command.City == "شهرستان")
|
||
{
|
||
|
||
return opration.Failed("لطفا شهر را انتخاب کنید");
|
||
}
|
||
|
||
if (command.Address == null && command.State != null)
|
||
{
|
||
|
||
return opration.Failed("لطفا آدرس را وارد کنید");
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.OfficialCompany))
|
||
return opration.Failed("رسمی یا غیر رسمی بودن پرداخت را مشخص کنید");
|
||
if (command.OfficialCompany == "Official" && string.IsNullOrWhiteSpace(command.HasValueAddedTax))
|
||
return opration.Failed("وضعیت ارزش افزوده را مشخص کنید");
|
||
if (string.IsNullOrWhiteSpace(command.TypeOfContract))
|
||
return opration.Failed("عنوان قرارداد را انتخاب کنید");
|
||
if (string.IsNullOrWhiteSpace(command.ContractAmountString))
|
||
command.ContractAmountString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.DailyCompenseationString))
|
||
command.DailyCompenseationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.ObligationString))
|
||
command.ObligationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.TotalAmountString))
|
||
command.TotalAmountString = "0";
|
||
command.ValueAddedTax = string.IsNullOrWhiteSpace(command.ValueAddedTaxStr) ? 0 : command.ValueAddedTaxStr.MoneyToDouble();
|
||
var contractAmount = command.ContractAmountString.ToDoubleMoney();
|
||
command.ContractAmount = Convert.ToDouble(contractAmount);
|
||
var DailyCompenseation = command.DailyCompenseationString.ToDoubleMoney();
|
||
command.DailyCompenseation = Convert.ToDouble(DailyCompenseation);
|
||
var Obligation = command.ObligationString.ToDoubleMoney();
|
||
command.Obligation = Convert.ToDouble(Obligation);
|
||
var TotalAmount = command.TotalAmountString.ToDoubleMoney();
|
||
command.TotalAmount = Convert.ToDouble(TotalAmount);
|
||
var createContract = new InstitutionContract(contractNo, command.RepresentativeId, command.RepresentativeName,
|
||
command.ContractingPartyId,
|
||
command.ContractingPartyName, contractDateGr, command.ContractDateFa, command.State, command.City,
|
||
command.Address, contractStartGr,
|
||
command.ContractStartFa, contractEndGr, command.ContractEndFa, command.ContractAmount,
|
||
command.DailyCompenseation, command.Obligation,
|
||
command.TotalAmount, command.ExtensionNo, command.WorkshopManualCount, command.EmployeeManualCount, command.Description,command.OfficialCompany, command.TypeOfContract, command.HasValueAddedTax, command.ValueAddedTax);
|
||
|
||
_institutionContractRepository.Create(createContract);
|
||
_institutionContractRepository.SaveChanges();
|
||
|
||
|
||
return opration.Succcedded(createContract.id);
|
||
}
|
||
|
||
public OperationResult Edit(EditInstitutionContract command)
|
||
{
|
||
bool dateMessages = false;
|
||
string dateMaessageResult = String.Empty;
|
||
var opration = new OperationResult();
|
||
var ContractEdit = _institutionContractRepository.Get(command.Id);
|
||
if (ContractEdit == null)
|
||
opration.Failed("رکورد مورد نظر وجود ندارد");
|
||
|
||
var contractStartGr = command.ContractStartFa.ToGeorgianDateTime();
|
||
var contractEndGr = command.ContractEndFa.ToGeorgianDateTime();
|
||
|
||
var contractDateGr = command.ContractDateFa.ToGeorgianDateTime();
|
||
|
||
if (_institutionContractRepository.Exists(x =>
|
||
x.ContractingPartyId == ContractEdit.ContractingPartyId && ((contractStartGr >= x.ContractStartGr && contractStartGr <= x.ContractEndGr) || (contractEndGr >= x.ContractStartGr && contractEndGr <= x.ContractEndGr)) && x.id != command.Id && x.TypeOfContract == command.TypeOfContract))
|
||
return opration.Failed("در بازه تاریخ وارد شده قرارداد دیگری وجود دارد");
|
||
//if (_institutionContractRepository.Exists(x =>
|
||
// x.ContractingPartyId == ContractEdit.ContractingPartyId && (x.ContractStartGr <= contractDateGr || x.ContractDateGr <= contractDateGr) && x.id != command.Id))
|
||
// return opration.Failed("تاریخ عقد قرارداد با قرارداد دیگری تداخل دارد");
|
||
if (string.IsNullOrWhiteSpace(command.ContractDateFa))
|
||
{
|
||
dateMaessageResult = "تاریخ قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractStartFa))
|
||
{
|
||
dateMaessageResult += "تاریخ شروع قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
if (string.IsNullOrWhiteSpace(command.ContractEndFa))
|
||
{
|
||
dateMaessageResult += "تاریخ پایان قراراداد اجباری است. ";
|
||
dateMessages = true;
|
||
}
|
||
|
||
if (dateMessages)
|
||
return opration.Failed(dateMaessageResult);
|
||
if (command.Address != null && command.State == null)
|
||
{
|
||
|
||
return opration.Failed("لطفا استان و شهر را انتخاب کنید");
|
||
}
|
||
|
||
if ((command.Address != null && command.State != null) && command.City == "شهرستان")
|
||
{
|
||
|
||
return opration.Failed("لطفا شهر را انتخاب کنید");
|
||
}
|
||
|
||
if (command.Address == null && command.State != null)
|
||
{
|
||
|
||
return opration.Failed("لطفا آدرس را وارد کنید");
|
||
}
|
||
|
||
if (string.IsNullOrWhiteSpace(command.OfficialCompany))
|
||
return opration.Failed("رسمی یا غیر رسمی بودن پرداخت را مشخص کنید");
|
||
if (command.OfficialCompany == "Official" && string.IsNullOrWhiteSpace(command.HasValueAddedTax))
|
||
return opration.Failed("وضعیت ارزش افزوده را مشخص کنید");
|
||
if (string.IsNullOrWhiteSpace(command.TypeOfContract))
|
||
return opration.Failed("عنوان قرارداد را انتخاب کنید");
|
||
|
||
if (string.IsNullOrWhiteSpace(command.ContractAmountString))
|
||
command.ContractAmountString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.DailyCompenseationString))
|
||
command.DailyCompenseationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.ObligationString))
|
||
command.ObligationString = "0";
|
||
if (string.IsNullOrWhiteSpace(command.TotalAmountString))
|
||
command.TotalAmountString = "0";
|
||
|
||
command.ValueAddedTax = command.ValueAddedTaxStr.MoneyToDouble();
|
||
var contractAmount = command.ContractAmountString.ToDoubleMoney();
|
||
command.ContractAmount = Convert.ToDouble(contractAmount);
|
||
var DailyCompenseation = command.DailyCompenseationString.ToDoubleMoney();
|
||
command.DailyCompenseation = Convert.ToDouble(DailyCompenseation);
|
||
var Obligation = command.ObligationString.ToDoubleMoney();
|
||
command.Obligation = Convert.ToDouble(Obligation);
|
||
var TotalAmount = command.TotalAmountString.ToDoubleMoney();
|
||
command.TotalAmount = Convert.ToDouble(TotalAmount);
|
||
|
||
ContractEdit.Edit(contractDateGr, command.ContractDateFa,command.State,command.City,command.Address,contractStartGr,
|
||
command.ContractStartFa,contractEndGr,command.ContractEndFa,command.ContractAmount,command.DailyCompenseation,
|
||
command.Obligation,command.TotalAmount,command.WorkshopManualCount, command.EmployeeManualCount,command.Description,command.OfficialCompany, command.TypeOfContract, command.ValueAddedTax, command.HasValueAddedTax);
|
||
_institutionContractRepository.SaveChanges();
|
||
return opration.Succcedded(command.Id);
|
||
|
||
}
|
||
|
||
public EditInstitutionContract GetDetails(long id)
|
||
{
|
||
return _institutionContractRepository.GetDetails(id);
|
||
}
|
||
|
||
public List<InstitutionContractViewModel> Search(InstitutionContractSearchModel searchModel)
|
||
{
|
||
|
||
var query = _institutionContractRepository.Search(searchModel);
|
||
var join = new List<InstitutionContractViewModel>();
|
||
|
||
var now = DateTime.Now;
|
||
var nowFa = now.ToFarsi();
|
||
|
||
var endFa = nowFa.FindeEndOfMonth();
|
||
var endThisMontGr = endFa.ToGeorgianDateTime();
|
||
//var watch = System.Diagnostics.Stopwatch.StartNew();
|
||
|
||
|
||
var newResult = query.Select(x => new InstitutionContractViewModel
|
||
{
|
||
Id = x.Id,
|
||
ContractNo = x.ContractNo,
|
||
ContractStartGr = x.ContractStartGr,
|
||
ContractStartFa = x.ContractStartFa,
|
||
ContractEndGr = x.ContractEndGr,
|
||
ContractEndFa = x.ContractEndFa,
|
||
//RepresentativeId = x.RepresentativeId,
|
||
RepresentativeName = x.RepresentativeName,
|
||
//ContractingPartyName = _contractingPartyRepository.GetDetails(x.ContractingPartyId).LName,
|
||
//IsContractingPartyBlock = _contractingPartyRepository.GetDetails(x.ContractingPartyId).IsBlock,
|
||
//BlockTimes = _contractingPartyRepository.GetDetails(x.ContractingPartyId).BlockTimes,
|
||
ContractingPartyId = x.ContractingPartyId,
|
||
EmployerViewModels = _employerRepository.GetEmployerByContracrtingPartyID(x.ContractingPartyId),
|
||
EmployerNo = _employerRepository.GetEmployerByContracrtingPartyID(x.ContractingPartyId).FirstOrDefault(xn => xn.ContractingPartyID == x.ContractingPartyId)?.EmployerNo,
|
||
EmployerName = _employerRepository.GetEmployerByContracrtingPartyID(x.ContractingPartyId).FirstOrDefault(xn => xn.ContractingPartyID == x.ContractingPartyId)?.FullName,
|
||
//EmployerId = _employerRepository.GetEmployerByContracrtingPartyID(x.ContractingPartyId).FirstOrDefault(xn => xn.ContractingPartyID == x.ContractingPartyId)?.Id == null ? 0 :
|
||
// _employerRepository.GetEmployerByContracrtingPartyID(x.ContractingPartyId).FirstOrDefault(xn => xn.ContractingPartyID == x.ContractingPartyId)!.Id,
|
||
ContractAmount = x.ContractAmount,
|
||
TotalAmount = x.TotalAmount,
|
||
SearchAmount = x.SearchAmount,
|
||
IsActiveString = x.IsActiveString,
|
||
OfficialCompany = x.OfficialCompany,
|
||
Signature = x.Signature,
|
||
ExpireColor = ExpCheckColor(now, x.ContractEndGr, endThisMontGr, x.ContractAmount, x.IsActiveString),
|
||
BalanceDouble = TotalBalance(x.ContractingPartyId).TotalBalanceDbl,
|
||
BalanceStr = TotalBalance(x.ContractingPartyId).TotalBalanceStr,
|
||
//WorkshopViewModels = WorkShopDetailsAndEmployeeCount(x.ContractingPartyId).WorkshopViewModels,
|
||
//WorkshopCount = WorkShopDetailsAndEmployeeCount(x.ContractingPartyId).WorkshopCount,
|
||
//EmployeeCount = WorkShopDetailsAndEmployeeCount(x.ContractingPartyId).EmployeeCount,
|
||
//ArchiveCode = WorkShopDetailsAndEmployeeCount(x.ContractingPartyId).ArchiveCode,
|
||
TypeOfContract = x.TypeOfContract
|
||
|
||
}).ToList();
|
||
//Console.WriteLine("efTime : " + watch.Elapsed);
|
||
|
||
//var watchw = System.Diagnostics.Stopwatch.StartNew();
|
||
foreach (var item in newResult)
|
||
{
|
||
//string totalBalanceStr = "0";
|
||
//double totalBalance = 0;
|
||
//var firstGetStatement = _financialStatmentApplication.GetDetailsByContractingPartyId(item.ContractingPartyId);
|
||
//var allTransactions = firstGetStatement.FinancialTransactionViewModels;
|
||
//if (allTransactions != null)
|
||
//{
|
||
// allTransactions = allTransactions.OrderBy(x => x.TdateGr).ToList();
|
||
// var debt = allTransactions.Sum(x => x.Deptor);
|
||
// var credit = allTransactions.Sum(x => x.Creditor);
|
||
// totalBalance = debt - credit;
|
||
// totalBalanceStr = totalBalance.ToMoney();
|
||
//}
|
||
var contractingParty = _contractingPartyRepository.GetDetails(item.ContractingPartyId);
|
||
if (contractingParty != null)
|
||
{
|
||
item.ContractingPartyName = contractingParty.LName;
|
||
item.IsContractingPartyBlock = contractingParty.IsBlock;
|
||
item.BlockTimes = contractingParty.BlockTimes;
|
||
}
|
||
|
||
|
||
var employer = _employerRepository.GetEmployerByContracrtingPartyID(item.ContractingPartyId);
|
||
item.EmployerViewModels = employer;
|
||
item.EmployerName = employer.FirstOrDefault(x => x.ContractingPartyID == item.ContractingPartyId)?.FullName;
|
||
var id = employer.FirstOrDefault(x => x.ContractingPartyID == item.ContractingPartyId)?.Id;
|
||
item.EmployerNo = employer.FirstOrDefault(x => x.ContractingPartyID == item.ContractingPartyId)?.EmployerNo;
|
||
if (id != null) item.EmployerId = (long)id;
|
||
|
||
var emplId = item.EmployerViewModels.Select(x => x.Id).ToList();
|
||
|
||
item.WorkshopViewModels = _workshopRepository.GetWorkshopsByEmployerId(emplId);
|
||
var workshopIds = item.WorkshopViewModels.Select(x => x.Id).ToList();
|
||
var left = 0;
|
||
item.WorkshopCount = Convert.ToString(item.WorkshopViewModels.Count);
|
||
//var joinPersonelList = new List<ConnectedPersonnelViewModel>();
|
||
int pCount = 0;
|
||
foreach (var workshopId in workshopIds)
|
||
{
|
||
//var reslt = _workshopApplication.GetConnectedPersonnels(workshopId);
|
||
//var noBlock = reslt.Where(x => x.Black == false).ToList();
|
||
//joinPersonelList.AddRange(noBlock);
|
||
var p = _workshopApplication.PersonnelCount(workshopId);
|
||
pCount += p;
|
||
|
||
}
|
||
//var joinlistWithoutDuplicat = joinPersonelList.GroupBy(x => x.PersonName).Select(x => x.First()).ToList();
|
||
//left = joinlistWithoutDuplicat.Count();
|
||
// var left= _leftWorkRepository.GetLeftPersonelByWorkshopId(workshopIds).Count();
|
||
|
||
item.EmployeeCount = Convert.ToString(pCount);
|
||
//if (item.ContractEndGr < now)
|
||
// item.ExpireColor = "black";
|
||
//if (item.ContractEndGr >= now && item.ContractEndGr <= endThisMontGr)
|
||
// item.ExpireColor = "red";
|
||
//if (item.ContractAmount == "0")
|
||
// item.ExpireColor = "purple";
|
||
int archiveCode = 0;
|
||
if (item.WorkshopViewModels.Count > 0)
|
||
{
|
||
var workshop = item.WorkshopViewModels.OrderBy(x => x.Id)?.ToList();
|
||
|
||
var arc = workshop.Select(x => new ArchiveCodConvertoint
|
||
{
|
||
ArchiveCodeInt = x.ArchiveCode.Substring(0, 1) == "b" ? 10000000 : x.ArchiveCode.ConvertToInt(),
|
||
}).OrderBy(x=>x.ArchiveCodeInt).ToList();
|
||
var minArchiveCode = arc.Min(x=>x.ArchiveCodeInt);
|
||
archiveCode = minArchiveCode == 10000000 ? 0 : minArchiveCode;
|
||
}
|
||
|
||
var result = new InstitutionContractViewModel()
|
||
{
|
||
Id = item.Id,
|
||
ContractNo = item.ContractNo,
|
||
ContractStartGr = item.ContractStartGr,
|
||
ContractStartFa = item.ContractStartFa,
|
||
ContractEndGr = item.ContractEndGr,
|
||
ContractEndFa = item.ContractEndFa,
|
||
RepresentativeName = item.RepresentativeName,
|
||
ContractingPartyName = item.ContractingPartyName,
|
||
ContractingPartyId = item.ContractingPartyId,
|
||
EmployerNo = item.EmployerNo,
|
||
ContractAmount = item.ContractAmount,
|
||
EmployerName = item.EmployerName,
|
||
EmployerViewModels = item.EmployerViewModels,
|
||
IsActiveString = item.IsActiveString,
|
||
WorkshopCount = item.WorkshopCount,
|
||
WorkshopViewModels = item.WorkshopViewModels,
|
||
EmployeeCount = item.EmployeeCount,
|
||
ExpireColor = item.ExpireColor,
|
||
SearchAmount = item.SearchAmount,
|
||
BalanceDouble = item.BalanceDouble,
|
||
BalanceStr = item.BalanceStr,
|
||
Signature = item.Signature,
|
||
ArchiveCode = archiveCode,
|
||
TypeOfContract = item.TypeOfContract,
|
||
IsContractingPartyBlock = item.IsContractingPartyBlock,
|
||
BlockTimes = item.BlockTimes,
|
||
};
|
||
join.Add(result);
|
||
}
|
||
|
||
//Console.WriteLine("forEchTime : " + watchw.Elapsed);
|
||
var findeByFilter = new List<InstitutionContractViewModel>();
|
||
if (searchModel.WorkshopId != 0)
|
||
{
|
||
|
||
foreach (var item in join)
|
||
{
|
||
var check = item.WorkshopViewModels.Where(x => x.Id == searchModel.WorkshopId).ToList();
|
||
if(check.Count >0)
|
||
findeByFilter.Add(item);
|
||
}
|
||
|
||
join = findeByFilter;
|
||
}
|
||
|
||
var findeByFilter2 = new List<InstitutionContractViewModel>();
|
||
if (searchModel.EmployerId != 0)
|
||
{
|
||
|
||
foreach (var item in join)
|
||
{
|
||
var check = item.EmployerViewModels.Where(x => x.Id == searchModel.EmployerId).ToList();
|
||
if (check.Count > 0)
|
||
findeByFilter2.Add(item);
|
||
|
||
|
||
}
|
||
|
||
join = findeByFilter2;
|
||
}
|
||
|
||
|
||
join = join.OrderBy(x => x.WorkshopCount != "0" && string.IsNullOrWhiteSpace(x.ExpireColor))
|
||
.ThenBy(x => x.WorkshopCount == "0" && string.IsNullOrWhiteSpace(x.ExpireColor))
|
||
.ThenBy(x=>x.ExpireColor=="red")
|
||
.ThenBy(x => x.ExpireColor == "purple")
|
||
.ThenBy(x=>x.ExpireColor=="black").ToList();
|
||
|
||
return join;
|
||
}
|
||
|
||
public List<InstitutionContractViewModel> NewSearch(InstitutionContractSearchModel searchModel)
|
||
{
|
||
return _institutionContractRepository.NewSearch(searchModel);
|
||
}
|
||
|
||
public string ExpCheckColor(DateTime now, DateTime ContractEndGr, DateTime endThisMontGr, string ContractAmount, string isActiveString)
|
||
{
|
||
string result = "";
|
||
|
||
if (ContractEndGr < now)
|
||
result = "black";
|
||
if (ContractEndGr >= now && ContractEndGr <= endThisMontGr)
|
||
result = "red";
|
||
if (ContractAmount == "0")
|
||
result = "purple";
|
||
if (isActiveString == "blue")
|
||
result = "blue";
|
||
return result;
|
||
}
|
||
|
||
public TotalbalancViewModel TotalBalance(long contractingPartyId)
|
||
{
|
||
var result = new TotalbalancViewModel();
|
||
|
||
var firstGetStatement = _financialStatmentApplication.GetDetailsByContractingPartyId(contractingPartyId);
|
||
var allTransactions = firstGetStatement.FinancialTransactionViewModels;
|
||
if (allTransactions != null)
|
||
{
|
||
allTransactions = allTransactions.OrderBy(x => x.TdateGr).ToList();
|
||
var debt = allTransactions.Sum(x => x.Deptor);
|
||
var credit = allTransactions.Sum(x => x.Creditor);
|
||
result.TotalBalanceDbl = debt - credit;
|
||
result.TotalBalanceStr = result.TotalBalanceDbl.ToMoney();
|
||
}
|
||
return result;
|
||
}
|
||
|
||
public WorkshopsAndEmployeeViewModel WorkShopDetailsAndEmployeeCount(long contractingPartyId)
|
||
{
|
||
var result = new WorkshopsAndEmployeeViewModel();
|
||
|
||
var emplId = _employerRepository.GetEmployerByContracrtingPartyID(contractingPartyId).Select(x => x.Id).ToList(); ;
|
||
result.WorkshopViewModels = _workshopRepository.GetWorkshopsByEmployerId(emplId);
|
||
var workshopIds = result.WorkshopViewModels.Select(x => x.Id).ToList();
|
||
var left = 0;
|
||
result.WorkshopCount= Convert.ToString(workshopIds.Count);
|
||
var joinPersonelList = new List<ConnectedPersonnelViewModel>();
|
||
foreach (var workshopId in workshopIds)
|
||
{
|
||
//var reslt = _workshopApplication.GetConnectedPersonnels(workshopId);
|
||
//var noBlock = reslt.Where(x => x.Black == false).ToList();
|
||
//joinPersonelList.AddRange(noBlock);
|
||
var pCount = _workshopApplication.PersonnelCount(workshopId);
|
||
result.EmployeeCount = Convert.ToString(pCount);
|
||
|
||
}
|
||
//var joinlistWithoutDuplicat = joinPersonelList.GroupBy(x => x.PersonName).Select(x => x.First()).ToList();
|
||
//left = joinlistWithoutDuplicat.Count();
|
||
//result.EmployeeCount = Convert.ToString(left);
|
||
|
||
|
||
result.ArchiveCode = 0;
|
||
if (workshopIds.Count > 0)
|
||
{
|
||
var workshop = result.WorkshopViewModels.OrderBy(x => x.Id)?.ToList();
|
||
|
||
var arc = workshop.Select(x => new ArchiveCodConvertoint
|
||
{
|
||
ArchiveCodeInt = x.ArchiveCode.Substring(0, 1) == "b" ? 10000000 : x.ArchiveCode.ConvertToInt(),
|
||
}).OrderBy(x => x.ArchiveCodeInt).ToList();
|
||
var minArchiveCode = arc.Min(x => x.ArchiveCodeInt);
|
||
result.ArchiveCode = minArchiveCode == 10000000 ? 0 : minArchiveCode;
|
||
}
|
||
|
||
return result;
|
||
}
|
||
|
||
public List<InstitutionContractViewModel> PrintAll(List<long> id)
|
||
{
|
||
throw new NotImplementedException();
|
||
}
|
||
|
||
public InstitutionContractViewModel PrintOne(long id)
|
||
{
|
||
var get = _institutionContractRepository.GetDetails(id);
|
||
var employer = _employerRepository.GetEmployerByContracrtingPartyID(get.ContractingPartyId);
|
||
var employerViewModels = employer;
|
||
var emplId = employerViewModels.Select(x => x.Id).ToList();
|
||
var workshops = _workshopRepository.GetWorkshopsByEmployerId(emplId);
|
||
var res = new InstitutionContractViewModel()
|
||
{
|
||
Id = get.Id,
|
||
ContractNo = get.ContractNo,
|
||
|
||
ContractStartFa = get.ContractStartFa,
|
||
|
||
ContractEndFa = get.ContractEndFa,
|
||
|
||
ContractingPartyName = get.ContractingPartyName,
|
||
|
||
ContractingPartyId = get.ContractingPartyId,
|
||
ContractDateFa = get.ContractDateFa,
|
||
State = get.State,
|
||
City = get.City,
|
||
Address = get.Address,
|
||
Description = get.Description,
|
||
HasValueAddedTax = get.HasValueAddedTax,
|
||
ValueAddedTax = get.ValueAddedTax,
|
||
ContractAmount = get.ContractAmountString,
|
||
DailyCompenseation = get.DailyCompenseationString,
|
||
Obligation = get.ObligationString,
|
||
TotalAmount = get.TotalAmountString,
|
||
WorkshopViewModels = workshops
|
||
|
||
};
|
||
return res;
|
||
}
|
||
|
||
|
||
public OperationResult Active(long id)
|
||
{
|
||
|
||
var opration = new OperationResult();
|
||
var contract = _institutionContractRepository.Get(id);
|
||
if (contract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
contract.Active();
|
||
|
||
_institutionContractRepository.SaveChanges();
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public OperationResult DeActive(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var contract = _institutionContractRepository.Get(id);
|
||
if (contract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
contract.DeActive();
|
||
|
||
|
||
_institutionContractRepository.SaveChanges();
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public OperationResult DeActiveBlue(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var institutionContract = _institutionContractRepository.Get(id);
|
||
if (institutionContract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
institutionContract.DeActiveBlue();
|
||
_institutionContractRepository.SaveChanges();
|
||
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public OperationResult DeActiveAllConnections(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var institutionContract = _institutionContractRepository.Get(id);
|
||
if (institutionContract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
|
||
var contractingParty = _contractingPartyRepository.Get(institutionContract.ContractingPartyId);
|
||
if (contractingParty != null)
|
||
{
|
||
contractingParty.DeActive();
|
||
_contractingPartyRepository.SaveChanges();
|
||
var employers =
|
||
_employerRepository.GetEmployerByContracrtingPartyID(institutionContract.ContractingPartyId);
|
||
//var employersIdList = employers.Select(x => x.Id).ToList();
|
||
//var workshops = _workshopApplication.GetWorkshopsByEmployerId(employersIdList);
|
||
//foreach (var workshop in workshops)
|
||
//{
|
||
// var res = _workshopApplication.DeActive(workshop.Id);
|
||
//}
|
||
foreach (var employer in employers)
|
||
{
|
||
var res = _employerRepository.DeActiveAll(employer.Id);
|
||
}
|
||
}
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public OperationResult ReActiveAllConnections(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var institutionContract = _institutionContractRepository.Get(id);
|
||
if (institutionContract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
|
||
var contractingParty = _contractingPartyRepository.Get(institutionContract.ContractingPartyId);
|
||
if (contractingParty != null)
|
||
{
|
||
contractingParty.Active();
|
||
_contractingPartyRepository.SaveChanges();
|
||
var employers =
|
||
_employerRepository.GetEmployerByContracrtingPartyID(institutionContract.ContractingPartyId);
|
||
//var employersIdList = employers.Select(x => x.Id).ToList();
|
||
//var workshops = _workshopApplication.GetWorkshopsByEmployerId(employersIdList);
|
||
//foreach (var workshop in workshops)
|
||
//{
|
||
// var res = _workshopApplication.DeActive(workshop.Id);
|
||
//}
|
||
foreach (var employer in employers)
|
||
{
|
||
var res = _employerRepository.ActiveAll(employer.Id);
|
||
}
|
||
}
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public void ReActiveAllAfterCreateNew(long contractingPartyId)
|
||
{
|
||
var contractingParty = _contractingPartyRepository.Get(contractingPartyId);
|
||
if (contractingParty != null)
|
||
{
|
||
if (contractingParty.IsActiveString == "false")
|
||
{
|
||
contractingParty.Active();
|
||
_contractingPartyRepository.SaveChanges();
|
||
}
|
||
|
||
var employers =
|
||
_employerRepository.GetEmployerByContracrtingPartyID(contractingPartyId);
|
||
|
||
foreach (var employer in employers)
|
||
{
|
||
var res = _employerRepository.ActiveAll(employer.Id);
|
||
}
|
||
}
|
||
}
|
||
|
||
|
||
public void RemoveContract(long id)
|
||
{
|
||
_institutionContractRepository.RemoveContract(id);
|
||
|
||
}
|
||
|
||
|
||
public OperationResult Sign(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var contract = _institutionContractRepository.Get(id);
|
||
if (contract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
contract.Sign();
|
||
|
||
|
||
_institutionContractRepository.SaveChanges();
|
||
opration.IsSuccedded = true;
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public OperationResult UnSign(long id)
|
||
{
|
||
var opration = new OperationResult();
|
||
var contract = _institutionContractRepository.Get(id);
|
||
if (contract == null)
|
||
return opration.Failed("رکورد مورد نظر یافت نشد");
|
||
|
||
contract.UnSign();
|
||
|
||
|
||
_institutionContractRepository.SaveChanges();
|
||
opration.IsSuccedded = true;
|
||
return opration.Succcedded();
|
||
}
|
||
|
||
public void CreateContractingPartyAccount(long contractingPartyid, long accountId)
|
||
{
|
||
_institutionContractRepository.CreateContractingPartyAccount(contractingPartyid,accountId);
|
||
}
|
||
|
||
public double GetcontractAmount(int countPerson)
|
||
{
|
||
return _institutionContractRepository.GetcontractAmount(countPerson);
|
||
}
|
||
}
|
||
|
||
|
||
#region CustomViewModels
|
||
|
||
public class TotalbalancViewModel
|
||
{
|
||
public string TotalBalanceStr { get; set; } = "0";
|
||
public double TotalBalanceDbl { get; set; } = 0;
|
||
}
|
||
|
||
public class WorkshopsAndEmployeeViewModel
|
||
{
|
||
public List<WorkshopViewModel> WorkshopViewModels { get; set; }
|
||
public string WorkshopCount { get; set; }
|
||
public string EmployeeCount { get; set;}
|
||
public int ArchiveCode { get; set; }
|
||
}
|
||
|
||
#endregion |