Notes

public async Task<ProjectionsExcelMasterModels> GetProjectionDetailsList(string startDate, string endDate)
{
ProjectionsExcelMasterModels projectionsExcelMasterModels = new();
try
{
List<ProjectionsFooterModel> projectionsFooterModelList = new();
CostosMasterModel costosMasterModel = new();
List<CostosExcelModel> costosExcelModelList = new();

DateTime.TryParseExact(startDate, AppConstants.DateFormat, CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime parsedStartDate);
DateTime.TryParseExact(endDate, AppConstants.DateFormat, CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime parsedEndDate);

var costosEmployeeDetails = await helperRepository.GetCandidatesRecordModelForCosts(startDate, endDate);
var companyCodesAsync = await helperRepository.GetCompanyCodesAsync();
var projectionIncomeExpensesHelperAsync = await GetProjectionIncomeExpensesHelperAsync(parsedStartDate, parsedEndDate);
var empForms = await helperRepository.GetDivisionCodesAsync();

if (parsedStartDate != DateTime.MinValue && parsedEndDate != DateTime.MinValue)
{
foreach (var item in costosEmployeeDetails.DistinctBy(x => new { x.CandidateId, x.SalaryStartId, x.SalaryRecId, x.EmpSalary }))
{
if (string.IsNullOrEmpty(item.SalaryEndDate) || (DateTime.TryParseExact(item.SalaryEndDate, AppConstants.SalaryEndDateFormat, CultureInfo.InvariantCulture, DateTimeStyles.None, out DateTime salaryEndDate) && salaryEndDate >= parsedStartDate))
{
if (item.EffectiveDate <= parsedEndDate && item.SalaryApproved == AppConstants.One)
{
if (item.CompanyId != InvoiceConstants.SMX && item.CompanyId != InvoiceConstants.SMXServicesConsultingInc && item.CompanyId != InvoiceConstants.SMXUSA && item.CompanyId != InvoiceConstants.SMXUSAFL && item.CompanyId != InvoiceConstants.InfolasticSMXSalesforce)
{
if (item.Division != "485791" && item.Division != "469942" && item.Division != "468692" && item.Division != "492341" && item.Division != "509597")
{
// Special logic for "EVERTEC Group, LLC"
if (item.Company == "EVERTEC Group, LLC")
{
// Split into two groups: ECSalaryDivisionCode and non-ECSalaryDivisionCode
var ecsSalaryDivisionConsultants = costosEmployeeDetails.Where(x => x.Company == "EVERTEC Group, LLC" && x.Status == AppConstants.ECSalaryDivisionCode).ToList();
var nonEcsSalaryDivisionConsultants = costosEmployeeDetails.Where(x => x.Company == "EVERTEC Group, LLC" && x.Status != AppConstants.ECSalaryDivisionCode).ToList();

// First record for ECSalaryDivisionCode consultants
if (ecsSalaryDivisionConsultants.Any())
{
var costosExcelModelECSalary = CreateProjectionExcelModel(item, parsedStartDate, parsedEndDate, empForms, companyCodesAsync, ecsSalaryDivisionConsultants);
costosExcelModelList.Add(costosExcelModelECSalary);
}

// Second record for non-ECSalaryDivisionCode consultants
if (nonEcsSalaryDivisionConsultants.Any())
{
var costosExcelModelNonECSalary = CreateProjectionExcelModel(item, parsedStartDate, parsedEndDate, empForms, companyCodesAsync, nonEcsSalaryDivisionConsultants);
costosExcelModelList.Add(costosExcelModelNonECSalary);
}
}
else
{
// For other companies, only one record
CostosExcelModel costosExcelModel = CreateProjectionExcelModel(item, parsedStartDate, parsedEndDate, empForms, companyCodesAsync);
costosExcelModelList.Add(costosExcelModel);
}
}
}
}
}
}

// Add the resulting CostosExcelModel list to the CostosMasterModel
costosMasterModel.CostosModelList = costosExcelModelList;

// Here you can add further logic to process the projection footer or totals if needed
projectionsExcelMasterModels.ProjectionsFooterModelList = projectionsFooterModelList;
}
}
catch (Exception ex)
{
Log.Error($"Error in GetProjectionDetailsList: {ex.Message}");
throw;
}

return projectionsExcelMasterModels;
}
public CostosExcelModel CreateProjectionExcelModel(CandidateModel item, DateTime parsedStartDate, DateTime parsedEndDate, List<EmpForm> empForms, List<CompanyCode> companyCodesAsync, List<CandidateModel> consultants = null)
{
var consultantList = consultants ?? new List<CandidateModel> { item };

// Process the logic here for generating the CostosExcelModel
CostosExcelModel costosExcelModel = new CostosExcelModel
{
CompanyId = item.CompanyId,
CandidateId = item.CandidateId,
StartDate = parsedStartDate,
EndDate = parsedEndDate,
// Add other necessary fields based on business logic
};

// If you need to process the consultant list:
foreach (var consultant in consultantList)
{
// Handle specific business logic for each consultant here
}

return costosExcelModel;
}