Example #1
0
        private void Activation()
        {
            var AllSrf        = _srf.GetAll().ToList();
            var AllUser       = _userProfile.GetAll().ToList();
            var AllVacancy    = _vacancy.GetAll().ToList();
            var AllCandidate  = _candidate.GetAll().ToList();
            var AllEscalation = _escalation.GetAll().ToList();
            var GetLastSrf    = _srf.GetAll().OrderByDescending(x => x.CreatedAt).GroupBy(x => x.CandidateId).Select(x => x.Key).ToArray();
            var SrfCandidate  = _srf.GetAll().Where(x => GetLastSrf.Contains(x.CandidateId)).ToArray();

            foreach (var srf in SrfCandidate)
            {
                // Set Active Srf To User
                var _temp = _srf.GetById(srf.Id);
                _temp.IsActive = true;


                // Set Terminate
                if (!string.IsNullOrEmpty(srf.TeriminateNote))
                {
                    var Candidate = _candidate.GetById(srf.CandidateId);
                    if (Candidate.Account != null)
                    {
                        var pro = _userProfile.GetById(Candidate.AccountId);
                        pro.IsBlacklist = false;
                        pro.IsTerminate = true;
                        _userProfile.Update(pro);
                    }
                    _temp.Status = SrfStatus.Terminate;
                }

                _srf.Update(_temp);
            }



            // Generate SRF NUMBER
            //foreach (var row in AllSrf)
            //{
            //    String SrfNumber = null;
            //    if (string.IsNullOrEmpty(row.Number))
            //    {
            //        SrfNumber = "0000";
            //    }
            //    else
            //    {
            //        if (row.Number.Length > 4)
            //        {
            //            SrfNumber = row.Number.Substring(0, 4);
            //        }
            //        else
            //        {
            //            SrfNumber = row.Number;
            //        }
            //    }
            //    var _temp = _srf.GetById(row.Id);
            //    _temp.Number = SrfNumber;
            //    _srf.Update(_temp);
            //}
        }
Example #2
0
        public void SetActive(Guid SrfId, Guid CandidateId, int UserProfileId)
        {
            var Candidate    = _contractor.GetAll().Where(x => x.Id.Equals(CandidateId) && x.AccountId.Equals(UserProfileId)).FirstOrDefault();
            var CandidateSrf = _repository.GetAll().Where(x => x.CandidateId.Equals(Candidate.Id)).ToList();

            var ApproveGeneral  = _repository.GetSingle(SrfId);
            var ApproveEscalasi = _escalation.GetAll().Where(x => x.SrfId.Equals(SrfId)).FirstOrDefault();

            if (CandidateSrf != null)
            {
                foreach (var srf in CandidateSrf)
                {
                    var Temp = _repository.GetSingle(srf.Id);
                    Temp.IsActive = false;
                    Temp.IsLocked = true;
                    _repository.Update(Temp);
                }

                if (ApproveGeneral != null || ApproveEscalasi != null)
                {
                    var Srf = _repository.GetSingle(SrfId);
                    Srf.IsActive = true;
                    Srf.IsLocked = false;
                    _repository.Update(Srf);
                }
            }
        }
        public override IActionResult Edit(Guid id)
        {
            try
            {
                var srf         = Service.GetById(id);
                var item        = _escalation.GetAll().Where(x => x.SrfId.Equals(id)).FirstOrDefault();
                var Candidate   = _candidate.GetById(srf.CandidateId);
                var Vacancy     = _vacancy.GetById(Candidate.VacancyId);
                var CurrentSSO  = _ssow.GetById(srf.ServicePackId);
                var Departement = _department.GetById(srf.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();
                ViewBag.EscalationId         = item.Id;
                ViewBag.ServiceCode          = _ssow.GetById(item.ServicePackId).Code;
                ViewBag.SrfNumber            = srf.Number;

                var PreofileId = _userHelper.GetUser(User).UserProfile.Id;
                ViewBag.PreofileId     = PreofileId;
                ViewBag.LineManagerId  = srf.ApproveOneId;
                ViewBag.ServiceLineId  = srf.ApproveTwoId;
                ViewBag.HeadOpId       = srf.ApproveThreeId;
                ViewBag.HeadNonId      = srf.ApproveFourId;
                ViewBag.HeadOfSourceId = srf.ApproveFourId;
                ViewBag.ServiceCoordId = srf.ApproveSixId;

                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();

                if (srf != null)
                {
                    var Model = Mapper.Map <EscalationModelForm>(item);
                    Model.Srf   = Mapper.Map <SrfRequestModelForm>(srf);
                    Model.SrfId = id;
                    string typeName = CurrentSSO.Type.ToString();
                    Guid   packageTypeId, servicePackCategoryId;
                    if (Guid.TryParse(item.CustomField1, out packageTypeId))
                    {
                        Model.PackageTypeId = packageTypeId;
                    }
                    if (Guid.TryParse(item.CustomField2, out servicePackCategoryId))
                    {
                        Model.ServicePackCategoryId = servicePackCategoryId;
                    }
                    if (!string.IsNullOrEmpty(item.Files))
                    {
                        var attachments = (JsonConvert.DeserializeObject <List <string> >(item.Files)
                                           ?? new List <string>());
                        Model.Files = string.Join("|", attachments.ToArray()) + "|";
                    }
                    else
                    {
                        Model.Files = null;
                    }
                    return(View(Model));
                }
            }
            catch (Exception e)
            {
                return(Content(e.ToString()));
            }

            return(NotFound());
        }
Example #4
0
        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());
            }
        }
Example #5
0
        public override IActionResult Index()
        {
            var      PreofileId     = _userHelper.GetUser(User).UserProfile.Id;
            string   sWebRootFolder = _env.WebRootPath;
            string   sFileName      = @"report/ContractorData.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 = "ID";
                worksheet.Cells[index, i += 1].Value = "Type";
                worksheet.Cells[index, i += 1].Value = "Contractor Name";
                worksheet.Cells[index, i += 1].Value = "SRF Number";
                worksheet.Cells[index, i += 1].Value = "Email";
                worksheet.Cells[index, i += 1].Value = "Position";
                worksheet.Cells[index, i += 1].Value = "Contractor Start";
                worksheet.Cells[index, i += 1].Value = "Contractor End";
                worksheet.Cells[index, i += 1].Value = "Status";
                worksheet.Cells[index, i += 1].Value = "Rate";
                worksheet.Cells[index, i += 1].Value = "Organization Unit";
                worksheet.Cells[index, i += 1].Value = "Sub Organization Unit";
                worksheet.Cells[index, i += 1].Value = "Line Manager";
                worksheet.Cells[index, i += 1].Value = "Project Manager";
                worksheet.Cells[index, i += 1].Value = "Supplier";
                worksheet.Cells[index, i += 1].Value = "Terminate Note";
                worksheet.Cells[index, i += 1].Value = "Blacklist Note";
                worksheet.Cells[index, i += 1].Value = "Date";
                worksheet.Cells[index, i += 1].Value = "Signum";

                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;
                Expression <Func <SrfRequest, object> >[] Includes = new Expression <Func <SrfRequest, object> > [11];
                Includes[0]  = pack => pack.Candidate;
                Includes[1]  = pack => pack.Candidate.Account;
                Includes[2]  = pack => pack.ServicePack;
                Includes[3]  = pack => pack.ServicePack.ServicePackCategory;
                Includes[4]  = pack => pack.Departement;
                Includes[5]  = pack => pack.DepartementSub;
                Includes[6]  = pack => pack.ApproveOneBy;
                Includes[7]  = pack => pack.NetworkNumber;
                Includes[8]  = pack => pack.NetworkNumber.ProjectManager;
                Includes[9]  = pack => pack.Candidate.Agency;
                Includes[10] = pack => pack.Candidate.Vacancy.PackageType;

                var Data = (List <SrfRequest>)null;

                #region Approver
                if (User.IsInRole("Line Manager"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveOneId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }
                else if (User.IsInRole("Head Of Service Line"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveTwoId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }

                else if (User.IsInRole("Head Of Operation"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveThreeId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }

                else if (User.IsInRole("Head Of Non Operation"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveFourId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }

                else if (User.IsInRole("Head Of Sourcing"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveFiveId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }
                else if (User.IsInRole("Service Coordinator"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.ApproveSixId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }

                else if (User.IsInRole("HR Agency"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.Candidate.AgencyId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }

                else if (User.IsInRole("Sourcing"))
                {
                    Data = Service.GetAll(Includes).Where(x => x.Candidate.Vacancy.ApproverTwoId == PreofileId && x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }
                else
                {
                    Data = Service.GetAll(Includes).Where(x => x.IsLocked == false && x.Candidate.IsUser == true && x.IsActive == true).ToList();
                }
                #endregion `

                if (Data != null)
                {
                    foreach (var row in Data)
                    {
                        int j = 0;
                        worksheet.Cells[index, j += 1].Value = !string.IsNullOrWhiteSpace(row.Number) ? row.Number : "-";
                        worksheet.Cells[index, j += 1].Value = row.Candidate.Vacancy.PackageType == null ? "-" : row.Candidate.Vacancy.PackageType.Name;
                        worksheet.Cells[index, j += 1].Value = row.Candidate.Account == null ? "-" : row.Candidate.Name;
                        worksheet.Cells[index, j += 1].Value = !string.IsNullOrWhiteSpace(row.Number) ? "e-EID/KI-" + row.CreatedAt.Value.ToString("yy", CultureInfo.InvariantCulture) + ":SRF: " + row.Number + " UEN" : "-";
                        worksheet.Cells[index, j += 1].Value = row.Candidate.Account == null ? "-" : row.Candidate.Email;
                        worksheet.Cells[index, j += 1].Value = row.ServicePack.ServicePackCategory == null ? "-" : row.ServicePack.ServicePackCategory.Name;
                        worksheet.Cells[index, j += 1].Value = row.SrfBegin.Value.ToString("dd MMMM yyyy", CultureInfo.InvariantCulture);
                        worksheet.Cells[index, j += 1].Value = row.SrfEnd.Value.ToString("dd MMMM yyyy", CultureInfo.InvariantCulture);

                        if (row.Status == SrfStatus.Terminate || row.Status == SrfStatus.Blacklist)
                        {
                            if (row.Status == SrfStatus.Terminate)
                            {
                                worksheet.Cells[index, j += 1].Value = "Terminate";
                            }
                            else
                            {
                                worksheet.Cells[index, j += 1].Value = "Blacklist";
                            }
                        }
                        else
                        {
                            worksheet.Cells[index, j += 1].Value = "Active";
                        }

                        var Escalation = _escalation.GetAll().Where(x => x.SrfId.Equals(row.Id)).ToList();
                        if (Escalation.Any())
                        {
                            worksheet.Cells[index, j += 1].Value = "Special Rate";
                        }
                        else
                        {
                            worksheet.Cells[index, j += 1].Value = "Normal Rate";
                        }

                        worksheet.Cells[index, j += 1].Value = row.Departement == null ? "-" : row.Departement.Name;
                        worksheet.Cells[index, j += 1].Value = row.DepartementSub == null ? "-" : row.DepartementSub.SubName;
                        worksheet.Cells[index, j += 1].Value = row.ApproveOneBy == null ? "-" : row.ApproveOneBy.Name;
                        worksheet.Cells[index, j += 1].Value = row.NetworkNumber.ProjectManager == null ? "-" : row.NetworkNumber.ProjectManager.Name;
                        worksheet.Cells[index, j += 1].Value = row.Candidate.Agency == null ? "-" : row.Candidate.Agency.Name;
                        worksheet.Cells[index, j += 1].Value = row.TeriminateNote;
                        worksheet.Cells[index, j += 1].Value = row.TeriminateNote;
                        worksheet.Cells[index, j += 1].Value = row.CreatedAt.Value.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                        worksheet.Cells[index, j += 1].Value = row.Candidate.Account == null ? "-" : row.Candidate.Account.AhId;
                        index++;
                    }
                }
                worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
                package.Save();
            }
            return(Redirect(URL));
        }