public void Execute()
{
var applicantsProvider = new JobApplicationProvider();
var reviewerProvider = new ReviewerProvider();
var configs = AppConfigsProvider.EscalationConfigs;
Reviewer reviewer = null;
var unhandledApplicants = applicantsProvider
.GetList(a => a.ReviewStatus == Models.ReviewStatus.Assigned &&
a.RemindCount >= configs.RemindTheshold);
if (unhandledApplicants.Count() == 0)
{
return;
}
foreach (var applicant in unhandledApplicants)
{
if (applicant.ReviewerId.HasValue)
{
reviewer = reviewerProvider.Get(applicant.ReviewerId.Value);
}
var email = new TimeOutApplicationEscalationEmail()
{
JobApplication = applicant,
Reviewer = reviewer,
EscalationTo = configs.ReportToEmails,
};
BackgroundEmailService.Create().Send(email);
_logger.InfoFormat("Reviewing for applicant {0} has been escalated as reviewer {1} did not finish his review after {2} of reminds", applicant.Id, reviewer.Id, applicant.RemindCount);
}
}
private void AssignToReviewer(Models.JobApplication applicant)
{
if (applicant == null || applicant.ReviewStatus != ReviewStatus.New)
{
return;
}
var applicantService = new JobApplicationProvider();
var positionTypeService = new JobPositionTypeProvider();
var reviewerService = new ReviewerProvider();
var ghDataStore = GreenHouseDataStore.Instance;
var job = ghDataStore.GetJobById(applicant.JobId);
if (job == null || job.Status != JobStates.Open)
{
applicant.ReviewStatus = ReviewStatus.JobClosed;
applicantService.Update(applicant);
_logger.InfoFormat("Applicant {0} is closed because it's job ({1}) is either deleted or not opened", applicant.Id, job?.Id);
return;
}
if (applicant.Source == ApplicantSources.Referral && AppConfigsProvider.ReferralsHandlingConfigs.IsEnabled)
{
applicant.ReviewStatus = ReviewStatus.HandledAsReferral;
applicantService.Update(applicant);
SendEmailForReferral(applicant, job);
_logger.InfoFormat("Applicant {0} of job {1} has been handled as a referral", applicant.Id, job.Id);
return;
}
var positionTypeStr = job.GetCustomFieldValue(JobCustomFields.PositionType);
var positionType = positionTypeService.GetList(p => p.Name == positionTypeStr).FirstOrDefault();
if (positionType == null)
{
_logger.WarnFormat("Position Type '{0}' is not available.", positionTypeStr);
return;
}
var selectedReviewer = GetNextReviewer(positionType);
if (selectedReviewer == null)
{
_logger.WarnFormat("Can not get any reviewers for the applicant {0}. It's either because there is no reviewers configured for this position type or all reviewers all not in working hours.", applicant.Id);
return;
}
selectedReviewer.RecentAssignedAt = DateTime.UtcNow;
selectedReviewer.AssignedCount++;
applicant.ReviewerId = selectedReviewer.Id;
applicant.ReviewStatus = ReviewStatus.Assigned;
applicant.AssignedToReviewerAt = DateTime.UtcNow;
applicantService.Update(applicant);
reviewerService.Update(selectedReviewer);
_logger.InfoFormat("Applicant {0} has been assigned to reviewer {1}", applicant.Id, selectedReviewer.Id);
SendAssignmentEmail(selectedReviewer, applicant, job);
}
public ActionResult Edit(int id)
{
var service = new ReviewerProvider();
var reviewer = service.Get(id);
if (reviewer == null)
{
return(new HttpStatusCodeResult(System.Net.HttpStatusCode.NotFound));
}
return(View(reviewer));
}
public ActionResult Index(string order)
{
var jobApplicantService = new JobApplicationProvider();
var reviewerResourceServuce = new ReviewerProvider();
var results = jobApplicantService.GetList().OrderByDescending(m => m.AppliedAt)
.Select(applicant => new ApplicantViewModel()
{
Applicant = applicant,
Reviewer = applicant.ReviewerId.HasValue ? reviewerResourceServuce.Get(applicant.ReviewerId.Value) : null
});
return(View(results));
}
public ActionResult Create(Reviewer reviewer)
{
Random random = new Random();
if (ModelState.IsValid)
{
var provider = new ReviewerProvider();
reviewer.Id = provider.GetNextId();
provider.Add(reviewer);
return(RedirectToAction("Index"));
}
return(View(reviewer));
}
public ActionResult SyncData()
{
var count = 0;
var reviewerProvider = new ReviewerProvider();
var message = new MessageViewModel();
var usersGreenhouse = greenHouseAPI.GetUsers();
if (usersGreenhouse == null || usersGreenhouse.Count == 0)
{
message.Type = MessageType.Error;
message.Title = "Not Found";
message.Content = "There're not data found vie GreenHouse API ";
TempData["Message"] = message;
return(RedirectToAction("Index"));
}
foreach (var user in usersGreenhouse)
{
var reviewer = reviewerProvider.Get(int.Parse(user.Id));
if (reviewer != null)
{
continue;
}
reviewer = new Reviewer()
{
Id = int.Parse(user.Id),
Name = user.Name,
Email = string.Join(";", user.Emails),
};
reviewerProvider.Add(reviewer);
count++;
}
if (count == 0)
{
message.Type = MessageType.Info;
message.Title = "Finished";
message.Content = string.Format("No more updates found...", count);
}
else
{
message.Type = MessageType.Success;
message.Title = "Success";
message.Content = string.Format("Added new {0} reviewer(s)...", count);
}
TempData["Message"] = message;
return(RedirectToAction("Index"));
}
public void TestMethod1()
{
var reviewerProvider = new ReviewerProvider();
var workingDays = new DayOfWeek[] { DayOfWeek.Monday, DayOfWeek.Tuesday, DayOfWeek.Wednesday, DayOfWeek.Thursday, DayOfWeek.Friday, DayOfWeek.Saturday, DayOfWeek.Sunday };
var fromTime = new TimeSpan(0, 0, 0);
var toTime = new TimeSpan(24, 0, 0);
var allReviwers = reviewerProvider.GetList();
foreach (var rvr in allReviwers)
{
var isInWorkingHours = rvr.IsInWorkingHours(fromTime, toTime, workingDays);
Console.WriteLine("{0}: {1}", rvr.Name, isInWorkingHours);
}
}
public void Execute()
{
var applicantsProvider = new JobApplicationProvider();
var commonConfigs = AppConfigsProvider.CommonConfigs;
var remindConfigs = AppConfigsProvider.RemindReviewersConfigs;
var reviewerProvider = new ReviewerProvider();
//var greenHouseApi = DiContainers.Global.Resolve<IWebApiClient>();
var applicants = GetTimeOutApplicants();
var ghStore = GreenHouseDataStore.Instance;
if (applicants.Count() == 0)
{
return;
}
Reviewer reviewer = null;
foreach (var applicant in applicants)
{
if (applicant.ReviewerId.HasValue)
{
reviewer = reviewerProvider.Get(applicant.ReviewerId.Value);
}
if (reviewer == null)
{
applicant.ReviewStatus = ReviewStatus.Error;
applicantsProvider.Update(applicant);
continue;
}
if (!reviewer.IsInWorkingHours(commonConfigs.StartTimeOfDay, commonConfigs.EndTimeOfDay, commonConfigs.EnabledDays))
{
_logger.InfoFormat("Don't remind reviewer {0} ({1} because he's not in working hour", reviewer.Id, reviewer.Name);
continue;
}
applicant.RemindCount++;
applicant.RecentRemindAt = DateTime.UtcNow;
applicantsProvider.Update(applicant);
var email = new RemindReviewApplicationEmail()
{
JobApplication = applicant,
Reviewer = reviewer,
Job = ghStore.GetJobById(applicant.JobId)
};
BackgroundEmailService.Create().Send(email);
}
}
public ActionResult Delete(Reviewer reviewer)
{
var service = new ReviewerProvider();
service.Delete(reviewer.Id);
var message = new MessageViewModel()
{
Type = MessageType.Warning,
Title = "Deleted",
Content = string.Format("A reviewer has been deleted...", reviewer.Name, reviewer.Email),
};
TempData["Message"] = message;
return(RedirectToAction("Index"));
}
public ActionResult Edit(Reviewer reviewer)
{
if (ModelState.IsValid)
{
var service = new ReviewerProvider();
service.Update(reviewer);
var message = new MessageViewModel()
{
Type = MessageType.Success,
Title = "Success",
Content = string.Format("Reviewer {0} ({1}) has been updated...", reviewer.Name, reviewer.Email),
};
TempData["Message"] = message;
return(RedirectToAction("Index"));
}
return(View(reviewer));
}
public Reviewer GetNextReviewer(JobPositionType positionType)
{
var reviewerService = new ReviewerProvider();
var commonConfigs = AppConfigsProvider.CommonConfigs;
if (positionType == null || string.IsNullOrEmpty(positionType.Interviewers))
{
return(null);
}
var reviewers = positionType.Interviewers.Split(new char[] { ';', ',' }, StringSplitOptions.RemoveEmptyEntries)
.Select(email => email.ToLower().Trim())
.Select(email => reviewerService.GetByEmail(email))
.Where(rvr => rvr != null && rvr.IsInWorkingHours(commonConfigs.StartTimeOfDay, commonConfigs.EndTimeOfDay, commonConfigs.EnabledDays))
.Distinct();
return(reviewers.OrderBy(rvr => rvr.RecentAssignedAt ?? DateTime.MinValue)
.FirstOrDefault());
}
public ActionResult Index()
{
var reviewers = new ReviewerProvider();
var jobApplicants = new JobApplicationProvider();
var avgDurations = jobApplicants.GetList()
.GroupBy(rvw => rvw.ReviewerId)
.Select(g => new
{
g.Key,
AvgDuration =
g.Average(
x =>
((x.RejectedOrAcceptedAt ?? DateTime.UtcNow) - x.AssignedToReviewerAt).HasValue
? Math.Max(
((x.RejectedOrAcceptedAt ?? DateTime.UtcNow) - x.AssignedToReviewerAt).Value
.TotalSeconds / 3600, 0)
: 0)
});
//var results = reviewers.GetList()
// .Join(avgDurations, rvw => rvw.Id, ad => ad.Key, (rvw, ad) => new ReviewerViewModel { Reviewer = rvw, AvgTime = ad.AvgDuration });
var results = reviewers.GetList()
.GroupJoin(avgDurations,
rvw => rvw.Id,
ad => ad.Key,
(rvw, ms) => new { rvw, ms = ms.DefaultIfEmpty() })
.SelectMany(
z => z.ms.Select(ad => new { rvw = z.rvw, ad }))
.Select(x => new ReviewerViewModel()
{
Reviewer = x.rvw,
AvgTime = x.ad == null? 0 : Math.Round(x.ad.AvgDuration, 2)
});
return(View(results.ToList()));
}
public ActionResult Create()
{
var provider = new ReviewerProvider();
return(View(new Reviewer()));
}
public ActionResult Get()
{
var service = new ReviewerProvider();
return(Json(service.GetList(), JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int id)
{
var service = new ReviewerProvider();
return(View(service.Get(id)));
}
private void ProcUpdate(JobApplication applicant)
{
var applicantsProvider = new JobApplicationProvider();
var reviewerProvider = new ReviewerProvider();
var ghStore = GreenHouseDataStore.Instance;
Reviewer reviewer = null;
if (applicant == null || applicant.Id == 0)
{
return;
}
var apiJobApplication = ghStore.GetApplicationById(applicant.Id.ToString());
var appliedJob = ghStore.GetJobById(applicant.JobId);
if (applicant.ReviewerId.HasValue)
{
reviewer = reviewerProvider.Get(applicant.ReviewerId.Value);
}
//applicant deleted
if (apiJobApplication == null || apiJobApplication.Id == 0)
{
applicant.ReviewStatus = Models.ReviewStatus.Deleted;
applicantsProvider.Update(applicant);
_logger.WarnFormat("Applicant {0} has been deleted from Greenhosue", applicant.Id);
return;
}
if (apiJobApplication.CurrentStage == null)
{
applicant.ReviewStatus = ReviewStatus.Error;
applicantsProvider.Update(applicant);
_logger.WarnFormat("Cant not resolve current stage for applicant {0}", applicant.Id);
return;
}
//applicant accepted and moved to another stage
if (apiJobApplication.CurrentStage.Name != ApplicationStages.ApplicationReviewCV)
{
applicant.ReviewStatus = ReviewStatus.Accepted;
applicant.RejectedOrAcceptedAt = apiJobApplication.AcceptedAt;
applicantsProvider.Update(applicant);
if (reviewer != null)
{
reviewer.AdvanceCount++;
reviewerProvider.Update(reviewer);
}
_logger.WarnFormat("Applicant {0} has been accepted and moved to next stage by reviewer {1}", applicant.Id, reviewer != null ? reviewer.Id : 0);
}
//applicant is still at CV / Review stage and was rejected
if (apiJobApplication.CurrentStage.Name == ApplicationStages.ApplicationReviewCV &&
apiJobApplication.RejectedAt.HasValue)
{
applicant.ReviewStatus = ReviewStatus.Rejected;
applicant.RejectAt = apiJobApplication.RejectedAt.Value;
applicant.RejectedOrAcceptedAt = apiJobApplication.RejectedAt.Value;
applicant.RejectionReason = apiJobApplication.RejectionReason;
applicantsProvider.Update(applicant);
if (reviewer != null)
{
reviewer.RejectCount++;
reviewerProvider.Update(reviewer);
}
_logger.WarnFormat("Applicant {0} has been rejected by reviewer {1}", applicant.Id, reviewer?.Id ?? 0);
}
//Applied job was removed or closed
if (appliedJob == null || appliedJob.Status != JobStates.Open)
{
applicant.ReviewStatus = ReviewStatus.JobClosed;
applicantsProvider.Update(applicant);
_logger.WarnFormat("Applicant {0} has been closed because its job {1} is either deleted or closed", applicant.Id, applicant.JobId);
}
}
