// GET: Departements/Details/5 public async Task <IActionResult> Details(int?id) { if (id == null) { return(NotFound()); } var departements = iDepatementService.GetById(id.GetValueOrDefault()); if (departements == null) { return(NotFound()); } return(View(departements)); }
public override IActionResult Details(Guid id) { var networkNumber = Service.GetById(id); ViewBag.Departements = departement.GetById(networkNumber.DepartmentId); ViewBag.Project = projects.GetById(networkNumber.ProjectId); ViewBag.LineManagers = _userHelper.GetUserProfile(networkNumber.LineManagerId); ViewBag.ProjectManagers = _userHelper.GetUserProfile(networkNumber.ProjectManagerId); ViewBag.AccountNames = accountName.GetById(networkNumber.AccountNameId); return(base.Details(id)); }
// GET: /<controller>/ public IActionResult Index() { var user = _userHelper.GetUser(User); var roles = _userManager .GetRolesAsync(user) .Result .ToList(); if (User.IsInRole("Contractor")) { var srf = _userHelper.GetCurrentSrfByLogin(User); var ContractorInfo = _candidate.GetById(srf.CandidateId); var Vacancy = _vacancy.GetById(ContractorInfo.VacancyId); ViewBag.Srf = srf; ViewBag.ContractorInfo = ContractorInfo; ViewBag.Departement = _department.GetById(srf.DepartmentId); ViewBag.DepartmentSub = _departmentSub.GetById(srf.DepartmentSubId); ViewBag.LineManager = _userHelper.GetUserProfile(srf.ApproveOneId.Value); ViewBag.ProjectManager = _userHelper.GetUserProfile(srf.ProjectManagerId); ViewBag.SSOW = _ssow.GetById(Vacancy.ServicePackId); if (ContractorInfo.HomeBaseId.HasValue) { ViewBag.HomeBase = _city.GetById(ContractorInfo.HomeBaseId).Name; } else { ViewBag.HomeBase = "-"; } } else { ViewBag.Srf = null; ViewBag.ContractorInfo = null; ViewBag.Departement = null; ViewBag.DepartmentSub = null; ViewBag.LineManager = null; } ViewBag.ModelForm = _mapper.Map <UpdateProfileForm>(user); ViewBag.CurretRoles = roles; return(View(_mapper.Map <ApplicationUserViewModel>(user))); }
public override IActionResult Edit(string id, RecoveryForm model) { if (ModelState.IsValid) { var User = _userHelper.GetUser(id); if (User != null) { // Insert Vacancy var NewVacancy = new VacancyList(); NewVacancy.AccountNameId = model.AccountNameId; NewVacancy.ApproverOneId = model.ApproverOneId; NewVacancy.ApproverTwoId = model.SourcingId; NewVacancy.CostCodeId = model.CostCodeId; NewVacancy.CreatedAt = DateTime.Now; NewVacancy.DepartmentId = model.DepartmentId; NewVacancy.DepartmentSubId = model.DepartmentSubId; NewVacancy.JobStageId = model.JobStageId; NewVacancy.JoinDate = model.JoinDate; NewVacancy.NetworkId = model.NetworkId; NewVacancy.NoarmalRate = model.NoarmalRate; NewVacancy.OtLevel = model.OtLevel; NewVacancy.RequestBy = _userHelper.GetUserProfile(model.ApproverOneId); NewVacancy.PackageTypeId = model.PackageTypeId; NewVacancy.ServicePackCategoryId = model.ServicePackCategoryId; NewVacancy.ServicePackId = model.ServicePackId; //NewVacancy.Status = VacanStatusFive.Done; NewVacancy.VacancyStatus = ApproverStatus.Completed; NewVacancy.isHrms = model.isHrms; NewVacancy.isLaptop = model.isLaptop == 1 ? true : false; NewVacancy.isManager = model.isManager; NewVacancy.isUsim = model.isUsim; NewVacancy.StatusOne = SrfApproveStatus.Approved; NewVacancy.StatusTwo = SrfApproveStatus.Approved; NewVacancy.StatusThree = SrfApproveStatus.Approved; NewVacancy.StatusFourth = SrfApproveStatus.Approved; _vacancy.Add(NewVacancy); if (NewVacancy.Id != null) { // Insert Candidate var UserProfile = _profileService.GetByUserId(id); var GetCandidate = _candidate.GetAll().Where(x => x.AccountId == UserProfile.Id).FirstOrDefault(); if (GetCandidate == null) { var Candidate = new CandidateInfo(); Candidate.Account = UserProfile; Candidate.Address = UserProfile.Address; Candidate.AgencyId = model.AgencyId; Candidate.AgencyType = AgencyType.Agency; Candidate.ApproveOneDate = DateTime.Now; Candidate.ApproveOneStatus = ApproverStatus.Selected; Candidate.ApproveTwoeDate = DateTime.Now; Candidate.CreatedAt = DateTime.Now; Candidate.Email = User.Email; Candidate.Gender = UserProfile.Gender.Value; Candidate.HomePhoneNumber = UserProfile.HomePhoneNumber; Candidate.IdNumber = UserProfile.IdNumber; Candidate.IsCandidate = false; Candidate.IsContractor = true; Candidate.IsUser = true; Candidate.Martial = Martial.M1; Candidate.MobilePhoneNumber = UserProfile.MobilePhoneNumber; Candidate.Name = UserProfile.Name; Candidate.Nationality = "Indonesia"; Candidate.NickName = UserProfile.Name; Candidate.PlaceOfBirth = UserProfile.Birthplace; Candidate.DateOfBirth = UserProfile.Birthdate.Value; Candidate.RequestBy = _userHelper.GetUserProfile(model.AgencyId); Candidate.ApproveTwoStatus = ApproverStatus.Completed; Candidate.Vacancy = NewVacancy; GetCandidate = _candidate.Add(Candidate); } if (GetCandidate != null) { var Department = _department.GetById(model.DepartmentId); var Network = _network.GetById(model.NetworkId); // Insert SRF SrfRequest NewSrf = new SrfRequest(); NewSrf.CreatedAt = DateTime.Now; NewSrf.Number = "0000"; NewSrf.Type = SrfType.New; NewSrf.ApproveStatusOne = SrfApproveStatus.Approved; NewSrf.ApproveStatusTwo = SrfApproveStatus.Approved; NewSrf.ApproveStatusThree = SrfApproveStatus.Approved; NewSrf.ApproveStatusFour = SrfApproveStatus.Approved; NewSrf.ApproveStatusFive = SrfApproveStatus.Approved; NewSrf.ApproveStatusSix = SrfApproveStatus.Approved; NewSrf.RequestBy = _userHelper.GetUserProfile(model.ApproverOneId).Name; NewSrf.SrfBegin = model.SrfBegin; NewSrf.SrfEnd = model.SrfEnd; NewSrf.ServiceLevel = model.OtLevel; NewSrf.isWorkstation = model.isLaptop == 1 ? true : false; NewSrf.isCommunication = model.isUsim; NewSrf.IsHrms = model.isHrms; NewSrf.IsOps = Department.OperateOrNon == 1 ? true : false; NewSrf.IsManager = false; NewSrf.RateType = Domain.Models.Enum.RateType.Normal; NewSrf.IsExtended = false; NewSrf.IsLocked = false; NewSrf.Status = Domain.Models.Enum.SrfStatus.Done; NewSrf.SpectValue = 0; NewSrf.IsActive = false; NewSrf.ServicePackId = model.ServicePackId; NewSrf.NetworkId = model.NetworkId; NewSrf.CostCenterId = model.CostCodeId; NewSrf.LineManagerId = model.ApproverOneId; NewSrf.ActivityCode = _activity.GetAll().OrderBy(x => Guid.NewGuid()).FirstOrDefault(); NewSrf.DepartmentId = model.DepartmentId; NewSrf.DepartmentSubId = model.DepartmentSubId; NewSrf.ProjectManagerId = Network.ProjectManagerId; NewSrf.ApproveOneId = model.ApproverOneId; NewSrf.ApproveTwoId = model.ApproveTwoId; NewSrf.ApproveThreeId = model.ApproveThreeId; NewSrf.ApproveFourId = model.ApproveFourId; NewSrf.ApproveSixId = model.ApproveSixId; NewSrf.Candidate = GetCandidate; NewSrf.AccountId = model.AccountNameId; NewSrf.IsLocked = false; NewSrf.IsActive = true; var AnnualLeave = MonthDistance(model.SrfBegin, model.SrfEnd); NewSrf.AnnualLeave = AnnualLeave; Service.Add(NewSrf); if (NewSrf.Id != null) { TempData["Success"] = true; } } } } } return(RedirectToAction("Index")); }
public IActionResult Add(Guid id) { try { var srf = Service.GetById(id); var Candidate = _candidate.GetById(srf.CandidateId); var Vacancy = _vacancy.GetById(Candidate.VacancyId); var CurrentSSO = _ssow.GetById(Vacancy.ServicePackId); var Departement = _department.GetById(Vacancy.DepartmentId); ViewBag.Candidate = Candidate; ViewBag.Vacancy = Vacancy; ViewBag.Departement = Departement; ViewBag.SSOW = CurrentSSO; ViewBag.SCategory = _ssowCategory.GetById(CurrentSSO.ServicePackCategoryId); ViewBag.JobsStage = _jobStage.GetById(Vacancy.JobStageId); ViewBag.ListDepartement = _department.GetAll().ToList(); if (Departement.OperateOrNon == 1) { ViewBag.HeadOperation = _userHelper.GetByRoleName("Head Of Operation").ToList(); } else { ViewBag.HeadOperation = _userHelper.GetByRoleName("Head Of Non Operation").ToList(); } ViewBag.ListServiceLine = _userHelper.GetByRoleName("Head Of Service Line").ToList(); ViewBag.ListServiceCordinator = _userHelper.GetByRoleName("Service Coordinator").ToList(); ViewBag.ListHeadOperation = _userHelper.GetByRoleName("Head Of Operation").ToList(); ViewBag.ListHeadNonOperation = _userHelper.GetByRoleName("Head Of Non Operation").ToList(); ViewBag.ListHeadSourcing = _userHelper.GetByRoleName("Head Of Sourcing").ToList(); ViewBag.ListAccount = _account.GetAll().ToList(); ViewBag.ListSubDepartment = _departmentSub.GetAll().Where(x => x.DepartmentId.Equals(srf.DepartmentId)).ToList(); ViewBag.ListCostCenter = _costCenter.GetAll().Where(x => x.DepartmentId.Equals(srf.DepartmentId)).ToList(); ViewBag.ListNetwork = _network.GetAll().Where(x => x.DepartmentId.Equals(srf.DepartmentId)).ToList(); //ViewBag.ListSSOW = _ssow.GetAll().Where(x => x.Type.Equals(CurrentSSO.Type)).ToList(); ViewBag.PackageType = _packageType.GetAll().ToList(); ViewBag.ServicePackCategory = _ssowCategory.GetAll().ToList(); ViewBag.BasicServiceLevel = new List <int>(new int[] { 0, 20, 30, 40 }).Select(x => new { Id = x, Name = x.ToString() }); Dictionary <string, bool> ws = new Dictionary <string, bool>(); ws.Add("No", false); ws.Add("Yes", true); Dictionary <string, bool> com = new Dictionary <string, bool>(); com.Add("No USIM", false); com.Add("USIM", true); ViewBag.WorkstationService = ws.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); ViewBag.CommunicationService = com.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); var ProfileId = _userHelper.GetLoginUser(User).Id; ViewBag.ProfileId = ProfileId; if (srf != null) { var Model = new EscalationModelForm(); Model.Srf = Mapper.Map <SrfRequestModelForm>(srf); Model.SrfId = id; return(View(Model)); } } catch (Exception e) { return(Content(e.ToString())); } return(NoContent()); }
public override IActionResult Edit(Guid id) { try { var item = Service.GetById(id); var Vacancy = _vacancy.GetById(_candidate.GetById(item.CandidateId).VacancyId); var Departement = _department.GetById(item.DepartmentId); var PackageType = _packageType.GetById(Vacancy.PackageTypeId); ViewBag.PriceType = PackageType.Name; ViewBag.Vacancy = Vacancy; ViewBag.Candidate = _candidate.GetById(item.CandidateId); ViewBag.Departement = _department.GetById(item.DepartmentId); ViewBag.SSOW = _ssow.GetById(item.ServicePackId); ViewBag.SCategory = _ssowCategory.GetById(_ssow.GetById(item.ServicePackId).ServicePackCategoryId); ViewBag.JobsStage = _jobStage.GetById(Vacancy.JobStageId); ViewBag.ListDepartement = _department.GetAll().ToList(); if (Departement.OperateOrNon == 1) { ViewBag.HeadOperation = _userHelper.GetByRoleName("Head Of Operation").ToList(); } else { ViewBag.HeadOperation = _userHelper.GetByRoleName("Head Of Non Operation").ToList(); } ViewBag.isOperation = Departement.OperateOrNon; ViewBag.ListServiceLine = _userHelper.GetByRoleName("Head Of Service Line").ToList(); ViewBag.ListServiceCordinator = _userHelper.GetByRoleName("Service Coordinator").ToList(); ViewBag.ListAccount = _account.GetAll().ToList(); ViewBag.ListSubDepartment = _departmentSub.GetAll().Where(x => x.DepartmentId.Equals(item.DepartmentId)).ToList(); ViewBag.ListCostCenter = _costCenter.GetAll().Where(x => x.DepartmentId.Equals(item.DepartmentId)).ToList(); ViewBag.ListNetwork = _network.GetAll().Where(x => x.DepartmentId.Equals(item.DepartmentId) && x.IsClosed == false).ToList(); ViewBag.Id = id; ViewBag.isOperation = Departement.OperateOrNon; ViewBag.txtOperaion = (Departement.OperateOrNon == 1) ? "Operational" : "Non Operational"; ViewBag.FormDisable = 1; ViewBag.SrfNumber = Service.GenerateNumnber(); ViewBag.NowYear = DateTime.Now.Year.ToString("yy"); // Aditional Dictionary<string, int> ws = new Dictionary<string, int>(); ws.Add("No", 0); ws.Add("Yes", 1); Dictionary<string, bool> com = new Dictionary<string, bool>(); com.Add("No USIM", false); com.Add("USIM", true); Dictionary<string, bool> sign = new Dictionary<string, bool>(); sign.Add("Non-HRMS", false); sign.Add("HRMS", true); Dictionary<string, bool> manager = new Dictionary<string, bool>(); manager.Add("Manager", true); manager.Add("Non Manager", false); ViewBag.PackageType = _packageType.GetAll().ToList(); ViewBag.ServicePackCategory = _ssowCategory.GetAll().ToList(); ViewBag.ServicePack = _ssow.GetAll().Where(x => x.Type == (PackageTypes)Enum.Parse(typeof(PackageTypes), PackageType.Name)).ToList(); ViewBag.BasicServiceLevel = new List<int>(new int[] { 0, 20, 30, 40 }).Select(x => new { Id = x, Name = x.ToString() }); ViewBag.WorkstationService = ws.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); ViewBag.CommunicationService = com.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); ViewBag.Signum = sign.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); ViewBag.IsManager = manager.Select(x => new { Id = x.Value, Name = x.Key.ToString() }).ToList(); ViewBag.Jobstage = _jobStage.GetAll().Where(x => !string.IsNullOrEmpty(x.Description)).ToList(); ViewBag.ListAgency = _userHelper.GetByRoleName("HR Agency").ToList(); ViewBag.ListActivity = _activity.GetAll().ToList(); ViewBag.ListExtended = Service.GetAll().Where(x => x.CandidateId.Equals(item.CandidateId) && x.SrfEnd >= item.SrfBegin).ToList(); ViewBag.ListLineManager = _userHelper.GetByRoleName("Line Manager").ToList(); ViewBag.ListHeadOfSourcing = _userHelper.GetByRoleName("Head Of Sourcing").ToList(); ViewBag.ListSrfStatus = new List<SrfApproveStatus>(new SrfApproveStatus[] { SrfApproveStatus.Waiting, SrfApproveStatus.Approved }).Select(x => new { Id = x, Name = x.ToString() }); ViewBag.ListTypeSRF = new List<SrfType>(new SrfType[] { SrfType.New, SrfType.Extension }).Select(x => new { Id = x, Name = x.ToString() }); ViewBag.LisStatusSrf = new List<SrfStatus>(new SrfStatus[] { SrfStatus.Done,SrfStatus.Terminate,SrfStatus.Blacklist }).Select(x => new { Id = x, Name = x.ToString() }); var Model = Mapper.Map<SrfRequestModelForm>(item); Model.FormVacancy = Mapper.Map<VacancyListFormModel>(Vacancy); if(item.Status == SrfStatus.Waiting) { Model.Status = SrfStatus.Done; } var CandidateInfo = _candidate.GetById(item.CandidateId); if(CandidateInfo!=null) { Model.AgencyId = CandidateInfo.AgencyId.Value; } var Esc = _escalation.GetAll().Where(x => x.SrfId.Equals(id)).FirstOrDefault(); if(Esc==null) { ViewBag.IsEscalation = false; } else { ViewBag.IsEscalation = true; } return View(Model); } catch (Exception e) { return Content(e.ToString()); } }
public IActionResult Approval(string CandidateId, bool ApprovalStatus, string ApprovalNotes = null) { var Candidate = Service.GetById(Guid.Parse(CandidateId)); var callbackUrl = Url.Action("Details", "Vacancy", new { area = "Admin", id = Candidate.VacancyId }, _hostConfiguration.Protocol, _hostConfiguration.Name); if (ApprovalStatus == true) { if (User.IsInRole("Line Manager") && User.IsInRole("Sourcing")) { Candidate.ApproveOneStatus = ApproverStatus.Selected; Candidate.ApproveOneDate = DateTime.Now; Candidate.ApproveOneNotes = ApprovalNotes; Candidate.ApproveTwoStatus = ApproverStatus.Completed; Candidate.ApproveTwoeDate = DateTime.Now; Candidate.ApproveTwoNotes = ApprovalNotes; // Update Another Candidate var Temp = Service.GetAll().Where(x => x.VacancyId.Equals(Candidate.VacancyId) && x.Id != Candidate.Id).ToList(); foreach (var row in Temp) { var c = Service.GetById(row.Id); c.ApproveTwoStatus = ApproverStatus.Shortlist; Service.Update(c); } } else if (User.IsInRole("Line Manager")) { Candidate.ApproveOneStatus = ApproverStatus.Selected; Candidate.ApproveOneDate = DateTime.Now; Candidate.ApproveOneNotes = ApprovalNotes; Service.Update(Candidate); // Send Notif To Sourcing var Vacancy = _vacancy.GetById(Candidate.VacancyId); var Sourcing = _user.GetById(Vacancy.ApproverTwoId); var SrcUser = _userService.GetById(Sourcing.ApplicationUserId); _notif.Send( User, // User From "Job vacancy CV is approved by " + _userHelper.GetLoginUser(User).Name, // Subject Sourcing.Name, // User target name SrcUser.Email, // User target email callbackUrl, // Link CallBack "New Job vacancy CV is approved by " + _userHelper.GetLoginUser(User).Name, // Email content or descriptions ApprovalNotes, // Description NotificationInboxStatus.Approval, // Notif Status Activities.Vacant // Activity Status ); } else if (User.IsInRole("Sourcing")) { Candidate.ApproveTwoStatus = ApproverStatus.Completed; Candidate.ApproveTwoeDate = DateTime.Now; Candidate.ApproveTwoNotes = ApprovalNotes; Service.Update(Candidate); // Update Another Candidate var Temp = Service.GetAll().Where(x => x.VacancyId.Equals(Candidate.VacancyId) && x.Id != Candidate.Id).ToList(); foreach (var row in Temp) { var c = Service.GetById(row.Id); c.ApproveTwoStatus = ApproverStatus.Shortlist; Service.Update(c); } } TempData["Approved"] = "OK"; } else { // Send Correction To Agency var Up = _userHelper.GetUserProfile(Candidate.AgencyId.Value); var AppUser = _userHelper.GetUser(Up.ApplicationUserId); _notif.Send( User, // User From "Correction CV", // Subject Up.Name, // User target name Up.Email, // User target email callbackUrl, // Link CallBack "Rejected CV", // Email content or descriptions ApprovalNotes, // Description NotificationInboxStatus.Reject, // Notif Status Activities.Vacant // Activity Status ); Candidate.ApproveOneStatus = ApproverStatus.Shortlist; Candidate.ApproveTwoStatus = ApproverStatus.Shortlist; Candidate.ApproveOneDate = DateTime.Now; Candidate.ApproveOneNotes = ApprovalNotes; Service.Update(Candidate); } var Success = Service.GetAll().Where(x => x.ApproveTwoStatus == ApproverStatus.Completed && x.VacancyId.Equals(Candidate.VacancyId)).FirstOrDefault(); if (Success != null) { var vc = _vacancy.GetById(Candidate.VacancyId); vc.VacancyStatus = ApproverStatus.Completed; _vacancy.Update(vc); var Dp = _department.GetById(vc.DepartmentId); var Network = _network.GetById(vc.NetworkId); // SEND TO SRF var LineManager = _user.GetById(vc.ApproverOneId); SrfRequest Srf = new SrfRequest { Type = SrfType.New, ApproveOneBy = vc.ApproverOne, CandidateId = Candidate.Id, CreatedAt = DateTime.Now, RequestBy = _userHelper.GetLoginUser(User).Name, ServicePackId = vc.ServicePackId, ServiceLevel = vc.OtLevel, isWorkstation = vc.isLaptop, isCommunication = vc.isUsim, NetworkId = vc.NetworkId, IsManager = vc.isManager, DepartmentId = vc.DepartmentId, DepartmentSubId = vc.DepartmentSubId, CostCenterId = vc.CostCodeId, IsHrms = vc.isHrms, IsOps = Dp.OperateOrNon == 1 ? true : false, LineManagerId = LineManager.Id, Status = SrfStatus.Waiting, AccountId = Network.AccountNameId, ApproveStatusOne = SrfApproveStatus.Waiting, // Line Manager ApproveStatusTwo = SrfApproveStatus.Waiting, // Head Of Service Line ApproveStatusThree = SrfApproveStatus.Waiting, // Head Of Operation ApproveStatusFour = SrfApproveStatus.Waiting, // Head Of Non Operation ApproveStatusFive = SrfApproveStatus.Waiting, // Head Of Sourcing ApproveStatusSix = SrfApproveStatus.Waiting, // Service Cordinator ProjectManagerId = Network.ProjectManagerId, SrfBegin = null, SrfEnd = null, IsActive = false, IsLocked = false, AnnualLeave = 0 }; _srf.Add(Srf); // Send Notif To Line Manager var LmUser = _userService.GetById(LineManager.ApplicationUserId); _notif.Send( User, // User From "Job vacancy CV is approved by " + _userHelper.GetLoginUser(User).Name, // Subject LineManager.Name, // User target name LmUser.Email, // User target email callbackUrl, // Link CallBack "Job vacancy CV is approved by " + _userHelper.GetLoginUser(User).Name, // Email content or descriptions ApprovalNotes, // Description NotificationInboxStatus.Request, // Notif Status Activities.SRF // Activity Status ); TempData["Approved"] = "OK"; } else { var Selected = Service.GetAll().Where(x => x.ApproveOneStatus == ApproverStatus.Selected && x.VacancyId.Equals(Candidate.VacancyId)).Count(); var vc = _vacancy.GetById(Candidate.VacancyId); if (Selected > 0) { vc.VacancyStatus = ApproverStatus.Selected; } else { TempData["Rejected"] = "OK"; vc.VacancyStatus = ApproverStatus.Rejected; } _vacancy.Update(vc); } return(RedirectToAction("Details", "Vacancy", new { id = Candidate.VacancyId })); }
public Departement GetByIdDepartement(int id) { return(_deptService.GetById(id)); }
public string CurrentTemplate() { string sWebRootFolder = _environment.WebRootPath; string sFileName = @"report/TRCP_TEMPLATE.xlsx"; string URL = string.Format("{0}://{1}/{2}", Request.Scheme, Request.Host, sFileName); FileInfo file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); if (file.Exists) { file.Delete(); file = new FileInfo(Path.Combine(sWebRootFolder, sFileName)); } using (ExcelPackage package = new ExcelPackage(file)) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1"); int i = 0; int index = 1; worksheet.Cells[index, i += 1].Value = "Organization / Sub Organization"; worksheet.Cells[index, i += 1].Value = "TRCP Approved"; worksheet.Cells[index, i += 1].Value = "TRCP Forecast"; worksheet.Cells[index, i += 1].Value = "Date SRF"; for (int i_temp = 1; i_temp <= i; i_temp++) { worksheet.Cells[index, i_temp].Style.Font.Bold = true; worksheet.Cells[index, i_temp].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; worksheet.Cells[index, i_temp].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(79, 129, 189)); worksheet.Cells[index, i_temp].Style.Font.Color.SetColor(System.Drawing.Color.White); } index += 1; var Data = Service.GetAll().ToList(); if (Data != null) { foreach (var row in Data) { if (row.DepartmentId.HasValue && row.DepartmentSubId == null) { var Temp = _dept.GetById(row.DepartmentId); worksheet.Cells[index, 1].Value = Temp.Name; } else { var Temp = _deptSub.GetById(row.DepartmentSubId); worksheet.Cells[index, 1].Value = Temp.SubName; } worksheet.Cells[index, 2].Value = row.Approved; worksheet.Cells[index, 3].Value = row.Forecast; if (row.DateSrf.HasValue) { worksheet.Cells[index, 4].Value = row.DateSrf.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture); } else { worksheet.Cells[index, 4].Value = ""; } index++; } } worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns(); package.Save(); } return(URL); }
public IActionResult GetOptionFormSrf(string id) { var Dept = _department.GetById(Guid.Parse(id)); Dictionary <string, object> Data = new Dictionary <string, object>(); String DepartmentSub = "<option disabled selected>-- Select Sub Organizational Unit --</option>"; var ListDepartmentSub = _departmentSub.GetAll().Where(x => x.DepartmentId.Equals(Guid.Parse(id))).ToList(); foreach (var row in ListDepartmentSub) { if (ListDepartmentSub.Count == 1) { DepartmentSub += "<option value='" + row.Id + "' selected>" + row.SubName + "</option>"; } else { DepartmentSub += "<option value='" + row.Id + "'>" + row.SubName + "</option>"; } } DepartmentSub += "<option></option>"; String CostCenter = "<option disabled selected>-- Select Cost Center --</option>"; var ListCostCenter = _costCenter.GetAll().Where(x => x.DepartmentId.Equals(Guid.Parse(id))).ToList(); foreach (var row in ListCostCenter) { if (ListCostCenter.Count == 1) { CostCenter += "<option value='" + row.Id + "' selected>" + row.DisplayName + "</option>"; } else { CostCenter += "<option value='" + row.Id + "'>" + row.DisplayName + "</option>"; } } CostCenter += "<option></option>"; String NetworkNumber = "<option disabled selected>-- - Select Network Number -- --</option>"; var ListNetworkNumber = _networkNumber.GetAll().Where(x => x.DepartmentId.Equals(Guid.Parse(id))).ToList(); foreach (var row in ListNetworkNumber) { if (ListNetworkNumber.Count == 1) { NetworkNumber += "<option value='" + row.Id + "' selected>" + row.DisplayName + "</option>"; } else { NetworkNumber += "<option value='" + row.Id + "'>" + row.DisplayName + "</option>"; } } NetworkNumber += "<option></option>"; Data.Add("DepartementSub", DepartmentSub); Data.Add("CostCenter", CostCenter); Data.Add("NetworkNumber", NetworkNumber); if (Dept.OperateOrNon == 1) { Data.Add("IsOperation", true); } else { Data.Add("IsOperation", false); } return(Ok(Data)); }