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); //} }
public override IActionResult Delete(Guid id) { var CheckVac = _vacancy.GetAll().Where(x => x.ServicePackCategoryId.Equals(id)).FirstOrDefault(); if (CheckVac != null) { return(Json(BadRequest())); } return(base.Delete(id)); }
public override IActionResult Delete(Guid id) { var CheckSrf = _srf.GetAll().Where(x => x.AccountId.Equals(id)).FirstOrDefault(); var CheckVac = _vacancy.GetAll().Where(x => x.AccountNameId.Equals(id)).FirstOrDefault(); if (CheckSrf != null || CheckVac != null) { return(Json(BadRequest())); } return(base.Delete(id)); }
public override IActionResult Delete(Guid id) { var CheckSrf = _srf.GetAll().Where(x => x.DepartmentSubId.Equals(id)).FirstOrDefault(); var CheckVac = _vacancy.GetAll().Where(x => x.DepartmentSubId.Equals(id)).FirstOrDefault(); var CheckTimeSheet = _timeSheet.GetAll().Where(x => x.DepartmentSubId.Equals(id)).FirstOrDefault(); if (CheckSrf != null || CheckVac != null || CheckTimeSheet != null) { return(Json(BadRequest())); } return(base.Delete(id)); }
private int CountPieChartAppoverWP(int AccountId, int Id, ClaimsPrincipal User) { Expression <Func <VacancyList, object> >[] Includes = new Expression <Func <VacancyList, object> > [1]; Includes[0] = pack => pack.Vendor; int data = _vacancy.GetAll(Includes).Where(x => x.VendorId == AccountId && x.Status != SrfStatus.Terminate && x.EndDate > DateTime.Now && x.StatusThree == SrfApproveStatus.Approved).Count(); #region Approver if (User.IsInRole("Line Manager")) { return(_vacancy.GetAll(Includes).Where(x => x.VendorId == AccountId && x.Status != SrfStatus.Terminate && x.EndDate > DateTime.Now && x.ApproverOneId == Id && x.StatusThree == SrfApproveStatus.Approved).Count()); } if (User.IsInRole("Head Of Service Line")) { return(_vacancy.GetAll(Includes).Where(x => x.VendorId == AccountId && x.Status != SrfStatus.Terminate && x.EndDate > DateTime.Now && x.ApproverTwoId == Id && x.StatusThree == SrfApproveStatus.Approved).Count()); } #endregion return(data); }
public override IActionResult Create() { //var Srf = _userHelper.GetCurrentSrfByLogin(User); //var Candidate = _candidate.GetById(Srf.CandidateId); //var Vacancy = _vacancy.GetById(Candidate.VacancyId); //// Auto Fll Form SRF //ViewBag.CostCenterId = Vacancy.CostCodeId; //ViewBag.NetworkNumberId = Vacancy.NetworkId; var maxNumber = Service.GetAll().Select(x => x.TravelReqNo) .DefaultIfEmpty() .Max(); if (maxNumber.Equals(null)) { ViewBag.TravelReqNumber = 1; } else { ViewBag.TravelReqNumber = maxNumber + 1; } //ViewBag.CostCenter = _costCenter.GetAll().Where(x => x.Status == Status.Active).ToList(); ViewBag.ContractorName = _vacancy.GetAll().Where(x => x.VendorId == _userHelper.GetUser(User).UserProfile.Id && x.EndDate >= DateTime.Now && x.StatusThree == SrfApproveStatus.Approved && x.TerminateBy == null).ToList(); //ViewBag.NetworkNumber = _networkNumber.GetAll().Where(x=>x.IsClosed == false).ToList(); //ViewBag.ActivityCode = _activityCode.GetAll().ToList(); ViewBag.Schedule = from Schedule n in Enum.GetValues(typeof(Schedule)) select new { Id = (int)n, Name = Extension.GetEnumDescription(n) }; ViewBag.Departure = _city.GetAll().ToList(); ViewBag.Destination = _city.GetAll().ToList(); ViewBag.ProjectManager = _userHelper.GetByRoleName("Regional Project Manager").ToList(); ViewBag.LineManager = _userHelper.GetByRoleName("Line Manager").ToList(); return(base.Create()); }
public override IActionResult Create() { ViewBag.ContractorName = _vacancy.GetAll().Where(x => x.VendorId == _userHelper.GetUser(User).UserProfile.Id && x.EndDate.AddMonths(1) >= DateTime.Now && x.StatusThree == SrfApproveStatus.Approved && x.TerminateBy == null).ToList(); //var Srf = _userHelper.GetCurrentSrfByLogin(User); //var Candidate = _candidate.GetById(Srf.CandidateId); //var Vacancy = _vacancy.GetById(Candidate.VacancyId); //ViewBag.OrganizationUnit = _department.GetAll().ToList(); //ViewBag.CostCenter = _cost.GetAll().Where(x => x.Status == Status.Active). // ToList(); //ViewBag.AccountName = _account.GetAll().ToList(); //ViewBag.NetworkNumber = _network.GetAll().Where(x=>x.IsClosed == false).ToList(); //ViewBag.Project = _project.GetAll().ToList(); //ViewBag.Code = _code.GetAll().ToList(); //ViewBag.SubOperasional = _subOp.GetAll().ToList(); //ViewBag.City = _city.GetAll().ToList(); //ViewBag.Annual = Srf.AnnualLeave; // Auto Fll Form SRF //ViewBag.OrganizationUnitId = Vacancy.DepartmentId; //ViewBag.SubOrganizatonId = Vacancy.DepartmentSubId; //ViewBag.CostCenterId = Vacancy.CostCodeId; //ViewBag.AccountNameId = Vacancy.AccountNameId; //ViewBag.NetworkNumberId = Vacancy.NetworkId; // Start - Menampilkan Time Sheet //var jan1 = new DateTime(DateTime.Today.Year, 1, 1); //if(DateTime.Now.Month == 1) //{ // jan1 = new DateTime(DateTime.Today.Year - 1, 12, 1); //} //var firstWeek = jan1.AddDays(1 - (int)(jan1.DayOfWeek)); //var weeks = Enumerable.Range(0, 54).Select(i => new //{ weekStart = firstWeek.AddDays(i * 7) }) // .TakeWhile(x => x.weekStart.Year <= jan1.Year) // .Select(x => new { x.weekStart, weekFinish = x.weekStart.AddDays(6) }) // .SkipWhile(x => x.weekFinish < jan1.AddDays(1)) // .Select((x, i) => new // { x.weekStart, x.weekFinish, weekNum = i + 1 }); //if(DateTime.Now.Month == 1) //{ // weeks = Enumerable.Range(0, 54).Select(i => new // { weekStart = firstWeek.AddDays(i * 7) }) // .TakeWhile(x => x.weekStart.Year <= DateTime.Now.Year) // .Select(x => new { x.weekStart, weekFinish = x.weekStart.AddDays(6) }) // .SkipWhile(x => x.weekFinish < jan1.AddDays(1)) // .Select((x, i) => new // { x.weekStart, x.weekFinish, weekNum = i + 1 }); //} //DateTime Today = Convert.ToDateTime(DateTime.Now.Date.ToString()); //string SelectWeeks = ""; //List<WeeksList> WeekList = new List<WeeksList>(); //List<DateList> DateList = new List<DateList>(); //List<DateList> DateRecord = new List<DateList>(); //foreach (var X in weeks) //{ // DateTime CurrentDay = Today.Date; // if (Today.DayOfWeek != DayOfWeek.Sunday) // { // CurrentDay = Today.Date.AddDays(7); // } // if(DateTime.Now.Month == 1) // { // if (X.weekStart.Date <= CurrentDay.Date && X.weekFinish.Date <= CurrentDay.Date) // { // SelectWeeks = X.weekStart.ToString("dd MMM yyyy") + " - " + X.weekFinish.ToString("dd MMM yyyy"); // var Value = X.weekStart.ToString("yyyy-MM-dd") + ";" + X.weekFinish.ToString("yyyy-MM-dd") + ";" + X.weekNum; // WeekList.Add(new WeeksList { Weeks = Value, SelectDates = SelectWeeks }); // for (var dt = X.weekStart; dt <= X.weekFinish; dt = dt.AddDays(1)) // { // DateList.Add(new DateList { Weeks = X.weekNum, Date = dt, DateName = dt.DayOfWeek.ToString() }); // } // } // } // else // { // if (X.weekStart.Date <= CurrentDay.Date && X.weekFinish.Date <= CurrentDay.Date && X.weekFinish.Year == Today.Year) // { // SelectWeeks = X.weekStart.ToString("dd MMM yyyy") + " - " + X.weekFinish.ToString("dd MMM yyyy"); // var Value = X.weekStart.ToString("yyyy-MM-dd") + ";" + X.weekFinish.ToString("yyyy-MM-dd") + ";" + X.weekNum; // WeekList.Add(new WeeksList { Weeks = Value, SelectDates = SelectWeeks }); // for (var dt = X.weekStart; dt <= X.weekFinish; dt = dt.AddDays(1)) // { // DateList.Add(new DateList { Weeks = X.weekNum, Date = dt, DateName = dt.DayOfWeek.ToString() }); // } // } // } //} //foreach (var item in DateList) //{ // if (item.Weeks == WeekList.Count) // { // DateRecord.Add(new DateList { Weeks = item.Weeks, Date = item.Date, DateName = item.DateName }); // } //} //ViewBag.Weeks = JsonConvert.SerializeObject(WeekList); //ViewBag.Dates = JsonConvert.SerializeObject(DateList); //ViewBag.DatesArray = string.Join(",", DateRecord.Select(x => x.Date.ToString("yyyy-MM-dd")).ToArray()); ViewBag.HeadOfServiceLine = _userHelper.GetByRoleName("Head Of Service Line").ToList(); ViewBag.RegionalProjectManager = _userHelper.GetByRoleName("Regional Project Manager").ToList(); //ViewBag.Activity = _actiivity.GetAll().ToList(); //ViewBag.TimeSheetType = _timesheet.GetAll().ToList(); return(base.Create()); }