add: implement AsghaeeAzarWorkshopsExcelGenerator and view model for generating Excel reports

CompanyManagement.Infrastructure.Excel/Checkout/AsghaeeAzarWorkshops/AsghaeeAzarWorkshopsExcelGenerator.cs

@@ -0,0 +1,154 @@
+using System.Drawing;
+using _0_Framework.Application;
+using OfficeOpenXml;
+using OfficeOpenXml.Style;
+
+namespace CompanyManagement.Infrastructure.Excel.Checkout.AsghaeeAzarWorkshops;
+
+public class AsghaeeAzarWorkshopsExcelGenerator
+{
+    public static Dictionary<string, string> Header { get; set; } = new()
+    {
+        { "FullName", "نام و نام خانوادگی" },
+        { "NationalCode", "کد ملی" },
+        { "FinalAmount", "مبلغ نهایی" }
+    };
+
+    public static byte[] Generate(List<AsghaeeAzarWorkshopsExcelViewModel> data)
+    {
+        ExcelPackage.License.SetNonCommercialOrganization("Gozareshgir Noncommercial organization");
+        using var package = new ExcelPackage();
+        var worksheet = package.Workbook.Worksheets.Add("Sheet1");
+
+        // Add index column header
+        var indexCell = worksheet.Cells[1, 1];
+        indexCell.Value = "ردیف";
+        ApplyHeaderStyle(indexCell);
+
+        // Add headers to worksheet
+        for (int i = 0; i < Header.Count; i++)
+        {
+            worksheet.Cells[1, i + 2].Value = Header.ElementAt(i).Value;
+            ApplyHeaderStyle(worksheet.Cells[1, i + 2]);
+        }
+
+        var dataRow = 2;
+        int finalAmountColumnIndex = -1;
+
+        foreach (var item in data)
+        {
+            var column = 2;
+            foreach (var header in Header)
+            {
+                var property = item.GetType().GetProperty(header.Key);
+                var value = property?.GetValue(item, null)?.ToString();
+
+                // Check if the property requires MoneyToDouble()
+                if (header.Key == "FinalAmount")
+                {
+                    worksheet.Cells[dataRow, column].Value = MoneyToDouble(value ?? "0");
+                    finalAmountColumnIndex = column;
+                }
+                else
+                {
+                    worksheet.Cells[dataRow, column].Value = value;
+                }
+
+                ApplyGeneralDataStyle(worksheet.Cells[dataRow, column]);
+                ApplySpecificStyle(worksheet.Cells[dataRow, column], header.Key);
+
+                column++;
+            }
+
+            // Add row number
+            var rowCounter = worksheet.Cells[dataRow, 1];
+            rowCounter.Value = dataRow - 1;
+            ApplyGeneralDataStyle(rowCounter);
+            ApplySpecificStyle(rowCounter, "RowNumber");
+
+            dataRow++;
+        }
+
+        worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
+        worksheet.PrinterSettings.PaperSize = ePaperSize.A4;
+        worksheet.PrinterSettings.Orientation = eOrientation.Portrait;
+        worksheet.PrinterSettings.FitToPage = true;
+        worksheet.PrinterSettings.FitToWidth = 1;
+        worksheet.PrinterSettings.FitToHeight = 0;
+        worksheet.PrinterSettings.Scale = 85;
+        worksheet.View.RightToLeft = true;
+
+        if (finalAmountColumnIndex != -1)
+        {
+            ApplyConditionalFormatting(worksheet, dataRow, finalAmountColumnIndex);
+        }
+
+        return package.GetAsByteArray();
+    }
+
+    private static double MoneyToDouble(string value)
+    {
+        if (string.IsNullOrEmpty(value))
+            return 0;
+
+        var min = value.Length > 1 ? value.Substring(0, 2) : "";
+        var result = min == "\u200e\u2212" ? value.MoneyToDouble() * -1 : value.MoneyToDouble();
+        return result;
+    }
+
+    private static void ApplyHeaderStyle(ExcelRange cell)
+    {
+        cell.Style.Font.Bold = true;
+        cell.Style.Fill.PatternType = ExcelFillStyle.Solid;
+        cell.Style.Fill.BackgroundColor.SetColor(Color.LightGray);
+        cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
+        cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
+        cell.Style.Border.BorderAround(ExcelBorderStyle.Thin);
+    }
+
+    private static void ApplyGeneralDataStyle(ExcelRange cell)
+    {
+        cell.Style.Border.BorderAround(ExcelBorderStyle.Thin);
+        cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
+        cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
+        cell.Style.Fill.PatternType = ExcelFillStyle.Solid;
+    }
+
+    private static void ApplySpecificStyle(ExcelRange cell, string columnKey)
+    {
+        switch (columnKey)
+        {
+            case "RowNumber":
+            case "FullName":
+            case "NationalCode":
+                cell.Style.Fill.BackgroundColor.SetColor(Color.LightYellow);
+                break;
+            case "FinalAmount":
+                cell.Style.Fill.BackgroundColor.SetColor(ColorTranslator.FromHtml("#A8BAFE")); // Light blue
+                cell.Style.Numberformat.Format = "#,##0";
+                break;
+        }
+    }
+
+    private static void ApplyConditionalFormatting(ExcelWorksheet worksheet, int dataRow, int finalAmountColumnIndex)
+    {
+        for (int rowIndex = 2; rowIndex < dataRow; rowIndex++)
+        {
+            var finalAmountValue = worksheet.Cells[rowIndex, finalAmountColumnIndex].Value;
+            if (finalAmountValue != null && double.TryParse(finalAmountValue.ToString(), out double amount))
+            {
+                if (amount < 0)
+                {
+                    var rowRange = worksheet.Cells[rowIndex, 1, rowIndex, worksheet.Dimension.End.Column];
+                    rowRange.Style.Fill.PatternType = ExcelFillStyle.Solid;
+                    rowRange.Style.Fill.BackgroundColor.SetColor(Color.Red);
+                    foreach (var cell in rowRange)
+                    {
+                        cell.Style.Font.Color.SetColor(Color.White);
+                    }
+                }
+            }
+        }
+    }
+}
+

CompanyManagement.Infrastructure.Excel/Checkout/AsghaeeAzarWorkshops/AsghaeeAzarWorkshopsExcelViewModel.cs

@@ -0,0 +1,8 @@
+namespace CompanyManagement.Infrastructure.Excel.Checkout.AsghaeeAzarWorkshops;
+
+public class AsghaeeAzarWorkshopsExcelViewModel
+{
+    public string FullName { get; set; }
+    public string NationalCode { get; set; }
+    public string FinalAmount { get; set; }
+}

ProgramManager/src/Application/GozareshgirProgramManager.Application/Modules/Projects/Commands/AutoUpdateDeployStatus/AutoUpdateDeployStatusCommand.cs

@@ -1,52 +0,0 @@
-using System.Linq;
-using GozareshgirProgramManager.Application._Common.Interfaces;
-using GozareshgirProgramManager.Application._Common.Models;
-using GozareshgirProgramManager.Domain.ProjectAgg.Entities;
-using GozareshgirProgramManager.Domain.ProjectAgg.Enums;
-using Microsoft.EntityFrameworkCore;
-
-namespace GozareshgirProgramManager.Application.Modules.Projects.Commands.AutoUpdateDeployStatus;
-
-public record AutoUpdateDeployStatusCommand : IBaseCommand;
-
-public class AutoUpdateDeployStatusCommandHandler : IBaseCommandHandler<AutoUpdateDeployStatusCommand>
-{
-    private readonly IProgramManagerDbContext _dbContext;
-
-    public AutoUpdateDeployStatusCommandHandler(IProgramManagerDbContext dbContext)
-    {
-        _dbContext = dbContext;
-    }
-
-    public async Task<OperationResult> Handle(AutoUpdateDeployStatusCommand request,
-        CancellationToken cancellationToken)
-    {
-        // Fetch all sections whose phase is still marked as not completed
-        var sections = await _dbContext.TaskSections
-            .Include(ts => ts.Task)
-            .ThenInclude(t => t.Phase)
-            .Where(ts => ts.Task.Phase.DeployStatus == ProjectDeployStatus.NotCompleted)
-            .ToListAsync(cancellationToken);
-
-        if (sections.Count == 0)
-            return OperationResult.Success();
-
-        var phasesToUpdate = sections
-            .GroupBy(ts => ts.Task.PhaseId)
-            .Where(g => g.All(s => s.Status == TaskSectionStatus.Completed))
-            .Select(g => g.First().Task.Phase)
-            .Distinct()
-            .ToList();
-
-        if (phasesToUpdate.Count == 0)
-            return OperationResult.Success();
-
-        foreach (var phase in phasesToUpdate)
-        {
-            phase.UpdateDeployStatus(ProjectDeployStatus.PendingDevDeploy);
-        }
-
-        await _dbContext.SaveChangesAsync(cancellationToken);
-        return OperationResult.Success();
-    }
-}

ProgramManager/src/Application/GozareshgirProgramManager.Application/Modules/Projects/Commands/ChangeDeployStatusProject/ChangeDeployeStatusProjectComand.cs

@@ -1,44 +0,0 @@
-using GozareshgirProgramManager.Application._Common.Interfaces;
-using GozareshgirProgramManager.Application._Common.Models;
-using GozareshgirProgramManager.Domain._Common;
-using GozareshgirProgramManager.Domain.ProjectAgg.Entities;
-using GozareshgirProgramManager.Domain.ProjectAgg.Repositories;
-
-namespace GozareshgirProgramManager.Application.Modules.Projects.Commands.ChangeDeployStatusProject;
-
-public record ChangeDeployStatusProjectCommand(Guid PhaseId, ProjectDeployStatus Status):IBaseCommand;
-
-public class ChangeDeployStatusProjectCommandHandler : IBaseCommandHandler<ChangeDeployStatusProjectCommand>
-{
-    private readonly IProjectRepository _projectRepository;
-    private readonly IProjectPhaseRepository _projectPhaseRepository;
-    private readonly IUnitOfWork _unitOfWork;
-
-    public ChangeDeployStatusProjectCommandHandler(IProjectRepository projectRepository, IUnitOfWork unitOfWork, IProjectPhaseRepository projectPhaseRepository)
-    {
-        _projectRepository = projectRepository;
-        _unitOfWork = unitOfWork;
-        _projectPhaseRepository = projectPhaseRepository;
-    }
-
-    public async Task<OperationResult> Handle(ChangeDeployStatusProjectCommand request, CancellationToken cancellationToken)
-    {
-        var project = await _projectPhaseRepository.GetByIdAsync(request.PhaseId, cancellationToken);
-        if (project == null)
-            return OperationResult.NotFound("بخش مورد نظر یافت نشد");
-
-        if (project.DeployStatus == ProjectDeployStatus.NotCompleted)
-        {
-            return OperationResult.Failure("وضعیت استقرار نمی‌تواند از حالت 'تایید نشده' تغییر کند.");
-        }
-
-        if (request.Status == ProjectDeployStatus.NotCompleted)
-        {
-            return OperationResult.Failure("وضعیت استقرار نمی‌تواند به حالت 'تایید نشده' تغییر کند.");
-        }
-        project.UpdateDeployStatus(request.Status);
-
-        await _unitOfWork.SaveChangesAsync(cancellationToken);
-        return OperationResult.Success();
-    }
-}

ProgramManager/src/Application/GozareshgirProgramManager.Application/Modules/Projects/Queries/ProjectDeployBoardDetail/ProjectDeployBoardDetailsQueryHandler.cs

@@ -1,113 +0,0 @@
-using System.Security.AccessControl;
-using GozareshgirProgramManager.Application._Common.Interfaces;
-using GozareshgirProgramManager.Application._Common.Models;
-using Microsoft.EntityFrameworkCore;
-
-namespace GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectDeployBoardDetail;
-
-public record ProjectDeployBoardDetailsResponse(
-    ProjectDeployBoardDetailPhaseItem Phase,
-    List<ProjectDeployBoardDetailTaskItem> Tasks);
-
-public record ProjectDeployBoardDetailPhaseItem(
-    string Name,
-    TimeSpan TotalTimeSpan,
-    TimeSpan DoneTimeSpan);
-
-public record ProjectDeployBoardDetailTaskItem(
-    string Name,
-    TimeSpan TotalTimeSpan,
-    TimeSpan DoneTimeSpan,
-    List<ProjectDeployBoardDetailItemSkill> Skills)
-    : ProjectDeployBoardDetailPhaseItem(Name, TotalTimeSpan, DoneTimeSpan);
-
-public record ProjectDeployBoardDetailItemSkill(string OriginalUserFullName, string SkillName, int TimePercentage);
-
-public record ProjectDeployBoardDetailsQuery(Guid PhaseId) : IBaseQuery<ProjectDeployBoardDetailsResponse>;
-
-public class
-    ProjectDeployBoardDetailsQueryHandler : IBaseQueryHandler<ProjectDeployBoardDetailsQuery,
-    ProjectDeployBoardDetailsResponse>
-{
-    private readonly IProgramManagerDbContext _dbContext;
-
-    public ProjectDeployBoardDetailsQueryHandler(IProgramManagerDbContext dbContext)
-    {
-        _dbContext = dbContext;
-    }
-
-    public async Task<OperationResult<ProjectDeployBoardDetailsResponse>> Handle(ProjectDeployBoardDetailsQuery request,
-        CancellationToken cancellationToken)
-    {
-        var phase = await _dbContext.ProjectPhases
-            .Include(x => x.Tasks)
-            .ThenInclude(x => x.Sections)
-            .ThenInclude(x => x.Activities)
-            .Include(x => x.Tasks)
-            .ThenInclude(x => x.Sections)
-            .ThenInclude(x => x.AdditionalTimes)
-            .Include(x => x.Tasks)
-            .ThenInclude(x => x.Sections)
-            .ThenInclude(x => x.Skill)
-            .FirstOrDefaultAsync(x => x.Id == request.PhaseId, cancellationToken);
-
-        if (phase == null)
-            return OperationResult<ProjectDeployBoardDetailsResponse>.NotFound("بخش اصلی مورد نظر یافت نشد");
-
-        var userIds = phase.Tasks
-            .SelectMany(t => t.Sections)
-            .Select(s => s.OriginalAssignedUserId)
-            .Distinct()
-            .ToList();
-
-        var usersDict = await _dbContext.Users
-            .Where(x => userIds.Contains(x.Id))
-            .ToDictionaryAsync(x => x.Id, x => x.FullName, cancellationToken);
-
-        var tasksRes = phase.Tasks.Select(t =>
-        {
-            var totalTime = t.Sections.Select(s => s.FinalEstimatedHours)
-                .Aggregate(TimeSpan.Zero, (sum, next) => sum.Add(next));
-
-            var doneTime = t.Sections.Aggregate(TimeSpan.Zero,
-                (sum, next) => sum.Add(next.GetTotalTimeSpent()));
-            var skills = t.Sections
-                .Select(s =>
-                {
-                    var originalUserFullName = usersDict.GetValueOrDefault(s.OriginalAssignedUserId,
-                        "کاربر ناشناس");
-
-                    var skillName = s.Skill?.Name ?? "بدون مهارت";
-
-                    var totalTimeSpent = s.GetTotalTimeSpent();
-                    
-                    var timePercentage = s.FinalEstimatedHours.Ticks > 0
-                        ? (int)((totalTimeSpent.Ticks / (double)s.FinalEstimatedHours.Ticks) * 100)
-                        : 0;
-                    
-                    return new ProjectDeployBoardDetailItemSkill(
-                        originalUserFullName,
-                        skillName,
-                        timePercentage);
-                }).ToList();
-
-            return new ProjectDeployBoardDetailTaskItem(
-                t.Name,
-                totalTime,
-                doneTime,
-                skills);
-        }).ToList();
-
-        var totalTimeSpan = tasksRes.Aggregate(TimeSpan.Zero,
-            (sum, next) => sum.Add(next.TotalTimeSpan));
-
-        var doneTimeSpan = tasksRes.Aggregate(TimeSpan.Zero,
-            (sum, next) => sum.Add(next.DoneTimeSpan));
-
-        var phaseRes = new ProjectDeployBoardDetailPhaseItem(phase.Name, totalTimeSpan, doneTimeSpan);
-
-        var res = new ProjectDeployBoardDetailsResponse(phaseRes, tasksRes);
-
-        return OperationResult<ProjectDeployBoardDetailsResponse>.Success(res);
-    }
-}

ProgramManager/src/Application/GozareshgirProgramManager.Application/Modules/Projects/Queries/ProjectDeployBoardDetail/ProjectDeployBoardDetailsQueryValidator.cs

@@ -1,11 +0,0 @@
-using FluentValidation;
-
-namespace GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectDeployBoardDetail;
-
-public class ProjectDeployBoardDetailsQueryValidator:AbstractValidator<ProjectDeployBoardDetailsQuery>
-{
-    public ProjectDeployBoardDetailsQueryValidator()
-    {
-        RuleFor(x=>x.PhaseId).NotNull().WithMessage("شناسه بخش اصلی نمی‌تواند خالی باشد");
-    }
-}

ProgramManager/src/Application/GozareshgirProgramManager.Application/Modules/Projects/Queries/ProjectDeployBoardList/ProjectDeployBoardListQueryHandler.cs

@@ -10,14 +10,12 @@ namespace GozareshgirProgramManager.Application.Modules.Projects.Queries.Project
 
 public record ProjectDeployBoardListItem()
 {
-    public Guid Id { get; set; }
     public string ProjectName { get; set; }
     public string PhaseName { get; set; }
     public int TotalTasks { get; set; }
     public int DoneTasks { get; set; }
     public TimeSpan TotalTimeSpan { get; set; }
     public TimeSpan DoneTimeSpan { get; set; }
-    public ProjectDeployStatus DeployStatus { get; set; }
 }
 public record GetProjectsDeployBoardListResponse(List<ProjectDeployBoardListItem> Items);
 
@@ -45,28 +43,23 @@ public class ProjectDeployBoardListQueryHandler:IBaseQueryHandler<GetProjectDepl
         }
 
         var query =await _dbContext.TaskSections
-            .Include(x=>x.Activities)
             .Include(x=>x.Task)
             .ThenInclude(x => x.Phase)
             .ThenInclude(x => x.Project)
             .AsNoTracking()
             .Where(x => x.Status == TaskSectionStatus.Completed
                         || x.Status == TaskSectionStatus.PendingForCompletion 
-                        || (x.Task.Phase.DeployStatus != ProjectDeployStatus.NotCompleted 
-                            && x.InitialEstimatedHours>TimeSpan.Zero))
+                        || x.Task.Phase.DeployStatus != ProjectDeployStatus.NoTCompleted)
             .GroupBy(x=>x.Task.PhaseId).ToListAsync(cancellationToken: cancellationToken);
         
         var list = query.Select(g => new ProjectDeployBoardListItem
         {
-            Id = g.Key,
             ProjectName = g.First().Task.Phase.Project.Name,
             PhaseName = g.First().Task.Phase.Name,
             TotalTasks = g.Select(x => x.TaskId).Distinct().Count(),
-            DoneTasks = g.Where(x => x.Status == TaskSectionStatus.Completed)
-                .Select(x => x.TaskId).Distinct().Count(),
-            TotalTimeSpan = TimeSpan.FromTicks(g.Sum(x => x.InitialEstimatedHours.Ticks)),
-            DoneTimeSpan = TimeSpan.FromTicks(g.Sum(x=>x.GetTotalTimeSpent().Ticks)),
-            DeployStatus = g.First().Task.Phase.DeployStatus
+            DoneTasks = g.Where(x => x.Status == TaskSectionStatus.Completed).Select(x => x.TaskId).Distinct().Count(),
+            TotalTimeSpan = TimeSpan.FromHours(g.Sum(x => x.InitialEstimatedHours.TotalHours)),
+            DoneTimeSpan = TimeSpan.FromHours(g.Where(x => x.Status == TaskSectionStatus.Completed).Sum(x => x.InitialEstimatedHours.TotalHours))
         }).ToList();
         var response = new GetProjectsDeployBoardListResponse(list);
         return OperationResult<GetProjectsDeployBoardListResponse>.Success(response);

ProgramManager/src/Domain/GozareshgirProgramManager.Domain/ProjectAgg/Entities/ProjectPhase.cs

@@ -23,7 +23,7 @@ public class ProjectPhase : ProjectHierarchyNode
         ProjectId = projectId;
         _tasks = new List<ProjectTask>();
         _phaseSections = new List<PhaseSection>();
-        DeployStatus = ProjectDeployStatus.NotCompleted;
+        DeployStatus = ProjectDeployStatus.NoTCompleted;
         AddDomainEvent(new PhaseCreatedEvent(Id, projectId, name));
     }
     
@@ -211,16 +211,12 @@ public class ProjectPhase : ProjectHierarchyNode
     public void UpdateDeployStatus(ProjectDeployStatus status)
     {
         DeployStatus = status;
-        if (status == ProjectDeployStatus.Deployed)
-        {
-            IsArchived = true;
-        }
     }
 }
 
 public enum ProjectDeployStatus
 {
-    NotCompleted,
+    NoTCompleted,
     PendingDevDeploy,
     DevDeployed,
     PendingDeploy,

ProgramManager/src/Domain/GozareshgirProgramManager.Domain/ProjectAgg/Repositories/ITaskSectionActivityRepository.cs

@@ -5,6 +5,7 @@ namespace GozareshgirProgramManager.Domain.ProjectAgg.Repositories;
 
 public interface ITaskSectionActivityRepository:IRepository<Guid,TaskSectionActivity>
 {
+    Task<TaskSectionActivity?> GetByIdAsync(Guid id);
     Task<List<TaskSectionActivity>> GetBySectionIdAsync(Guid sectionId);
     Task<List<TaskSectionActivity>> GetByUserIdAsync(long userId);
     Task<List<TaskSectionActivity>> GetActiveByUserAsync(long userId);

ProgramManager/src/Domain/GozareshgirProgramManager.Domain/_Common/IRepository.cs

@@ -5,7 +5,7 @@ namespace GozareshgirProgramManager.Domain._Common;
 public interface IRepository<TKey, T> where  T:class
 {
     T Get(TKey id);
-    Task<T?> GetByIdAsync(TKey id, CancellationToken cancellationToken = default);
+    Task<T?> GetByIdAsync(TKey id);
     List<T> Get();
     IQueryable<T> GetQueryable();
     void Create(T entity);

ProgramManager/src/Infrastructure/GozareshgirProgramManager.Infrastructure/Persistence/_Common/RepositoryBase.cs

@@ -43,9 +43,9 @@ public class RepositoryBase<TKey, T> : IRepository<TKey, T> where T : class
         return _context.Find<T>(id);
     }
 
-    public async Task<T?> GetByIdAsync(TKey id, CancellationToken cancellationToken = default)
+    public async Task<T?> GetByIdAsync(TKey id)
     {
-        return await _context.Set<T>().FindAsync([id], cancellationToken);
+        return await _context.Set<T>().FindAsync(id);
     }
 
     public List<T> Get()

ServiceHost/Areas/Admin/Controllers/ProgramManager/ProjectController.cs

@@ -2,8 +2,6 @@
 using GozareshgirProgramManager.Application._Common.Models;
 using GozareshgirProgramManager.Application.Modules.Projects.Commands.AssignProject;
 using GozareshgirProgramManager.Application.Modules.Projects.Commands.AutoStopOverTimeTaskSections;
-using GozareshgirProgramManager.Application.Modules.Projects.Commands.AutoUpdateDeployStatus;
-using GozareshgirProgramManager.Application.Modules.Projects.Commands.ChangeDeployStatusProject;
 using GozareshgirProgramManager.Application.Modules.Projects.Commands.ChangeStatusSection;
 using GozareshgirProgramManager.Application.Modules.Projects.Commands.CreateProject;
 using GozareshgirProgramManager.Application.Modules.Projects.Commands.DeleteProject;
@@ -14,7 +12,6 @@ using GozareshgirProgramManager.Application.Modules.Projects.Queries.GetProjectA
 using GozareshgirProgramManager.Application.Modules.Projects.Queries.GetProjectsList;
 using GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectBoardDetail;
 using GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectBoardList;
-using GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectDeployBoardDetail;
 using GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectDeployBoardList;
 using GozareshgirProgramManager.Application.Modules.Projects.Queries.ProjectSetTimeDetails;
 using MediatR;
@@ -26,75 +23,70 @@ namespace ServiceHost.Areas.Admin.Controllers.ProgramManager;
 public class ProjectController : ProgramManagerBaseController
 {
     private readonly IMediator _mediator;
-
+    
     public ProjectController(IMediator mediator)
     {
         _mediator = mediator;
     }
 
     [HttpGet]
-    public async Task<ActionResult<OperationResult<GetProjectsListResponse>>> Get(
-        [FromQuery] GetProjectsListQuery query)
+    public async Task<ActionResult<OperationResult<GetProjectsListResponse>>> Get([FromQuery]GetProjectsListQuery query)
     {
-        var res = await _mediator.Send(query);
+        var res=await _mediator.Send(query);
         return res;
     }
-
+    
     [HttpPost]
     public async Task<ActionResult<OperationResult>> Create([FromBody] CreateProjectCommand command)
     {
-        var res = await _mediator.Send(command);
+        var res=await _mediator.Send(command);
         return res;
     }
-
+    
     [HttpPut]
     public async Task<ActionResult<OperationResult>> Edit([FromBody] EditProjectCommand command)
     {
-        var res = await _mediator.Send(command);
+        var res=await _mediator.Send(command);
         return res;
     }
-
+    
     [HttpDelete]
     public async Task<ActionResult<OperationResult>> Delete([FromQuery] DeleteProjectCommand command)
     {
-        var res = await _mediator.Send(command);
+        var res=await _mediator.Send(command);
         return res;
     }
-
+    
     [HttpGet("assign")]
-    public async Task<ActionResult<OperationResult<GetProjectAssignDetailsResponse>>> GetAssignableProjects(
-        GetProjectAssignDetailsQuery query)
+    public async Task<ActionResult<OperationResult<GetProjectAssignDetailsResponse>>> GetAssignableProjects(GetProjectAssignDetailsQuery query)
     {
-        var res = await _mediator.Send(query);
+        var res=await _mediator.Send(query);
         return res;
     }
-
+    
     [HttpPost("assign")]
     public async Task<ActionResult<OperationResult>> Assign(AssignProjectCommand command)
     {
-        var res = await _mediator.Send(command);
+        var res=await _mediator.Send(command);
         return res;
     }
-
     [HttpGet("set-time")]
-    public async Task<ActionResult<OperationResult<ProjectSetTimeResponse>>> GetSetTimeProjectDetails(
-        ProjectSetTimeDetailsQuery query)
+    public async Task<ActionResult<OperationResult<ProjectSetTimeResponse>>> GetSetTimeProjectDetails(ProjectSetTimeDetailsQuery query)
     {
-        var res = await _mediator.Send(query);
+        var  res=await _mediator.Send(query);
         return res;
     }
-
     [HttpPost("set-time")]
     public async Task<ActionResult<OperationResult>> SetTimeProject(SetTimeProjectCommand command)
     {
-        var res = await _mediator.Send(command);
+        var  res=await _mediator.Send(command);
         return res;
     }
 
     [HttpPost("change-status")]
     public async Task<ActionResult<OperationResult>> ChangeStatus(ChangeStatusSectionCommand command)
     {
-        var res = await _mediator.Send(command);
+        var res = await  _mediator.Send(command);
         return res;
     }
 
@@ -106,16 +98,14 @@ public class ProjectController : ProgramManagerBaseController
     }
 
     [HttpGet("board")]
-    public async Task<ActionResult<OperationResult<List<ProjectBoardListResponse>>>> GetProjectBoard(
-        [FromQuery] ProjectBoardListQuery query)
+    public async Task<ActionResult<OperationResult<List<ProjectBoardListResponse>>>> GetProjectBoard([FromQuery] ProjectBoardListQuery query)
     {
         // اجرای Command برای متوقف کردن تسک‌های overtime قبل از نمایش
         await _mediator.Send(new AutoStopOverTimeTaskSectionsCommand());
-
+        
         var res = await _mediator.Send(query);
         return res;
     }
-
     [HttpGet("board/details")]
     public async Task<ActionResult<OperationResult<ProjectBoardDetailResponse>>> GetProjectBoardDetails(Guid id)
     {
@@ -127,24 +117,7 @@ public class ProjectController : ProgramManagerBaseController
     [HttpGet("deploy-board")]
     public async Task<ActionResult<OperationResult<GetProjectsDeployBoardListResponse>>> GetProjectDeployBoard()
     {
-        // قبل از دریافت دیتا، وضعیت دیپلوی را بر اساس تکمیل شدن تمام سکشن‌ها به‌روزرسانی می‌کنیم
-        await _mediator.Send(new AutoUpdateDeployStatusCommand());
         var request = new GetProjectDeployBoardListQuery();
         return await _mediator.Send(request);
     }
-
-    [HttpGet("deploy-board/details")]
-    public async Task<ActionResult<OperationResult<ProjectDeployBoardDetailsResponse>>> GetProjectDeployBoardDetails(Guid id)
-    {
-        var query = new ProjectDeployBoardDetailsQuery(id);
-        var res = await _mediator.Send(query);
-        return res;
-    }
-
-    [HttpPost("deploy-board/change-status")]
-    public async Task<ActionResult<OperationResult>> ChangeDeployStatus(ChangeDeployStatusProjectCommand command)
-    {
-        var res = await _mediator.Send(command);
-        return res;
-    }
 }

ServiceHost/Areas/AdminNew/Pages/Company/AndroidApk/Index.cshtml.cs

@@ -14,6 +14,7 @@ using Company.Domain.PaymentTransactionAgg;
 using Company.Domain.RewardAgg;
 using Company.Domain.RollCallAgg.DomainService;
 using CompanyManagement.Infrastructure.Excel.WorkshopsRollCall;
+using CompanyManagement.Infrastructure.Excel.Checkout.AsghaeeAzarWorkshops;
 using CompanyManagment.App.Contracts.AndroidApkVersion;
 using CompanyManagment.App.Contracts.InstitutionContract;
 using CompanyManagment.App.Contracts.PaymentTransaction;
@@ -152,7 +153,10 @@ namespace ServiceHost.Areas.AdminNew.Pages.Company.AndroidApk
         {
             //await UpdateInstitutionContract();
             //await UpdateFaceEmbeddingNames();
-            await SetInstitutionContractSigningType();
+            //await SetInstitutionContractSigningType();
+            var data = OnGetExportAsghaeeAzarWorkshops();
+            return File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
+                "AsghaeeAzarWorkshops.xlsx");
             ViewData["message"] = "تومام یک";
             return Page();
         }
@@ -1111,6 +1115,28 @@ namespace ServiceHost.Areas.AdminNew.Pages.Company.AndroidApk
         }
 
         #endregion
+
+        #region Excel
+
+        /// <summary>
+        /// خروجی اکسل آقایی آذر ورکشاپ
+        /// </summary>
+        /// <returns></returns>
+        private byte[] OnGetExportAsghaeeAzarWorkshops()
+        {
+            var data = _context.CheckoutSet
+                .Where(x => x.WorkshopId == 768 && x.Month =="آذر"  && x.Year =="1404")
+                .Select(x => new AsghaeeAzarWorkshopsExcelViewModel()
+                {
+                    FinalAmount = x.TotalPayment.ToMoney(),
+                    FullName = x.EmployeeFullName,
+                    NationalCode = x.NationalCode
+                }).ToList();
+
+            return AsghaeeAzarWorkshopsExcelGenerator.Generate(data);
+        }
+
+        #endregion
     }
 
     public class IndexModel2 : PageModel