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