using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Threading.Tasks; using HRM.BO; using HRM.BO.ess; using Microsoft.AspNetCore.Authorization; using static iTextSharp.text.pdf.AcroFields; using HRM.DA.Fund; using System.Data; using HRM.Report; using Ease.Core.DataAccess; using Ease.Core.Utility; namespace HRM.UI.Controllers.Ess { [Route("api/Ess")] [ApiController] [Authorize] public class EssController : ControllerBase { private readonly IProfileUpdateRequestService _profileUpdateRequestService; private readonly IInstitutionService _institutionService; private readonly ISearchEmployeeService _searchEmployeeService; private readonly IWebHostEnvironment _env; private readonly ICacheManager _cashManager; public EssController(IProfileUpdateRequestService profileUpdateRequestService, IInstitutionService institutionService, ISearchEmployeeService searchEmployeeService, IWebHostEnvironment env, ICacheManager cashManager) { this._profileUpdateRequestService = profileUpdateRequestService; _institutionService = institutionService; _searchEmployeeService = searchEmployeeService; _env = env; _cashManager = cashManager; } [HttpPost] [Route("savePUR")] public ActionResult SaveEmployee(ProfileUpdateRequest item) { int ans; CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); item.RequestEmpID = currentUser.EmployeeID.GetValueOrDefault(); try { if (item.NomineeNominationPurposeId != null) { int Percentage = _profileUpdateRequestService.GetNomineePercent(item.NomineeNominationPurposeId ?? 0, 1); if (Percentage + item.NomineePercent > 100) { return BadRequest("Percentage is exceed the limit"); } } if(item.PURequestType == EnumPURequestType.Education) { if(item.AcademicInstitute == "") { item.AcademicInstitute = _institutionService.Get(item.AcademicUniversityBoardID ?? 0).Name; } } ans = _profileUpdateRequestService.Save(item); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(ans); } [HttpPost] [Route("updateEmployee")] public ActionResult UpdateEmployee(ProfileUpdateRequest item) { try { CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); item.currentUserId = currentUser.UserID; item.CreatedBy = currentUser.UserID; if (item.NomineeNominationPurposeId != null) { int Percentage = _profileUpdateRequestService.GetNomineePercent(item.NomineeNominationPurposeId ?? 0, 1); if ((Percentage + item.NomineePercent) > 100) { return BadRequest("Percentage is exceed the limit"); } } ApproveRequest(item); ClearDashboardCache(item.RequestEmpID); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(); } [HttpPost] [Route("updateEmployeeRequestBulk")] public ActionResult UpdateEmployeeRequestBulk(List items) { try { CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); items.ForEach(x => { x.currentUserId = currentUser.UserID; ApproveRequest(x); }); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(); } [HttpPost] [Route("rejectEmployeeRequestBulk")] public ActionResult RejectEmployeeRequestBulk(List items) { try { CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); int currentUserId = currentUser.UserID; _profileUpdateRequestService.RejectEmployeeRequestBulk(items, currentUserId, DateTime.Now); items.ForEach(DiscardProfilePicture); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(); } [HttpGet("getAllPURByEmpId")] public ActionResult GetAllPURByEmpId() { List items = new List(); CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); int empId = currentUser.EmployeeID.GetValueOrDefault(); try { items = _profileUpdateRequestService.GetAllByEmpId(empId); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(items); } [HttpGet("getPURByEmpIdAndStatus/{status}")] public ActionResult GetPURByEmpIdAndStatus(EnumPURequestStatus status) { CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); int empId = currentUser.EmployeeID.GetValueOrDefault(); int ans; try { ans = _profileUpdateRequestService.GetPURCountEmpIdAndStatus(empId, status); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(ans); } [HttpGet("getAllPUR")] public ActionResult GetAllPUR() { List items = new List(); try { items = _profileUpdateRequestService.GetAll(); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(items); } [HttpPost] [Route("updateStatusToRejected")] public ActionResult UpdateStatusToRejected(ProfileUpdateRequest item) { try { CurrentUser currentUser = CurrentUser.GetCurrentUser(HttpContext.User); item.currentUserId = currentUser.UserID; _profileUpdateRequestService.UpdateStatusToRejected(item); DiscardProfilePicture(item); } catch (Exception ex) { return StatusCode(StatusCodes.Status500InternalServerError, ex.Message); } return Ok(); } /// /// Employee/getEmployeeForDashboard caches each employee's dashboard row (incl. /// profile-completion percent). Approving a request changes that data, so drop the /// entry and let the next dashboard load re-read it from the DB. /// private void ClearDashboardCache(int employeeId) { _cashManager.Remove(enumMemoryCashType.LandingPageEmployee, enumMemoryCashNature.EmployeeWise, employeeId); } /// /// Approves one request. Everything that touches the database — the request's own /// changes, its status, the profile percentage, the notification and, for a picture /// request, the photo row — goes in through a single service call, so it all commits /// together or not at all. The photo FILE is moved only after that call returns, /// because a file move cannot be rolled back with the transaction. /// private void ApproveRequest(ProfileUpdateRequest item) { string employeeNo; empFileupload approvedPicture = ReadSubmittedPicture(item, out employeeNo); _profileUpdateRequestService.UpdateEmployee(item, approvedPicture); if (approvedPicture != null) MoveApprovedPictureIntoPlace(employeeNo); } /// /// The picture an employee submitted, read out of the pending folder so it can be saved /// inside the approval's transaction. Returns null for anything that is not a picture /// request, and for picture requests raised before pictures moved to the folder — those /// still have their bytes in empFileuploadUpdateRequest and the service promotes them. /// /// It carries the original upload rather than the 100px thumbnail: this row is what the /// thumbnail is rebuilt from whenever the photo folder is empty (a fresh deploy, a new /// environment). /// /// referenceID is the employee id, which is what every photo reader asks for /// (GetuploadEmpFile(empId, empId, Profile_Picture)) and what the core-HR upload writes. /// The older approval path used 0 here, which no screen ever looked up. /// private empFileupload ReadSubmittedPicture(ProfileUpdateRequest item, out string employeeNo) { employeeNo = null; if (item == null || item.PURequestType != EnumPURequestType.Picture) return null; SearchEmployee employee = _searchEmployeeService.get(item.RequestEmpID); if (employee == null || string.IsNullOrWhiteSpace(employee.EmployeeNo)) return null; var pending = new EmployeePhotoService(_env).GetPending(employee.EmployeeNo); if (pending == null) return null; employeeNo = employee.EmployeeNo; string extension = Path.GetExtension(pending.Value.FileName); if (string.IsNullOrWhiteSpace(extension)) extension = ".jpg"; return new empFileupload { employeeID = item.RequestEmpID, referenceID = item.RequestEmpID, filetype = enumEmpFileUploadType.photo, FileFormat = EnumFileFormat.Picture, fileName = "Profile Picture" + extension, fileData = pending.Value.Bytes }; } /// /// Moves the approved picture from the pending folder into the one every read path /// serves from. Runs after the transaction has committed, so a failure here cannot undo /// the approval — and does not need to: the photo is already on the employee's record, /// and the next read of it rebuilds the thumbnail from there. /// private void MoveApprovedPictureIntoPlace(string employeeNo) { if (string.IsNullOrWhiteSpace(employeeNo)) return; var photoService = new EmployeePhotoService(_env); try { photoService.ApprovePending(employeeNo); } catch (Exception e) { ExceptionLog.Write(e); // Don't leave it sitting in the queue as though it were still awaiting approval. photoService.DeletePending(employeeNo); } } /// /// Discards a rejected profile picture so it is not left behind in the pending folder. /// private void DiscardProfilePicture(ProfileUpdateRequest item) { if (item == null || item.PURequestType != EnumPURequestType.Picture) return; SearchEmployee employee = _searchEmployeeService.get(item.RequestEmpID); if (employee == null || string.IsNullOrWhiteSpace(employee.EmployeeNo)) return; new EmployeePhotoService(_env).DeletePending(employee.EmployeeNo); } } }