public void SelectWinner(int nominationId, string winningComment, string hrAdminsFeedback, int adminId) { var shortlistedNomination = _encourageDatabaseContext.Query <Shortlist>().SingleOrDefault(model => model.NominationId == nominationId); var currentNomination = shortlistedNomination != null?_encourageDatabaseContext.Query <Nomination>().FirstOrDefault(x => x.Id == shortlistedNomination.NominationId) : _encourageDatabaseContext .Query <Nomination>().FirstOrDefault(x => x.Id == nominationId); if (currentNomination != null) { var customDate = _customDateService.GetCustomDate(currentNomination.AwardId); if (shortlistedNomination != null) { shortlistedNomination.IsWinner = true; shortlistedNomination.WinningDate = customDate.Date; shortlistedNomination.WinningComment = winningComment; shortlistedNomination.HrAdminsFeedback = hrAdminsFeedback; shortlistedNomination.AdminId = adminId; _encourageDatabaseContext.Update <Shortlist>(shortlistedNomination); } else { var winner = new Shortlist() { IsWinner = true, NominationId = nominationId, //WinningDate = DateTime.Now.Date, WinningDate = customDate.Date, WinningComment = winningComment, HrAdminsFeedback = hrAdminsFeedback, AdminId = adminId }; _encourageDatabaseContext.Add <Shortlist>(winner); } } }
public ActionResult SaveFinalScore(ConsolidatedNominationsViewModel consolidatedNominationsViewModel) { try { foreach (var nomination in consolidatedNominationsViewModel.Nominations) { foreach (var finalComment in nomination.ManagerComments) { var commentDb = _encourageDatabaseContext.Query <ManagerComment>().FirstOrDefault(mc => mc.NominationId == finalComment.NominationId && mc.CriteriaId == finalComment.CriteriaId); if (commentDb != null) { commentDb.AdminComment = finalComment.AdminComment; commentDb.FinalScore = finalComment.FinalScore; _encourageDatabaseContext.Update(commentDb); } } } } catch (Exception e) { _logger.Log("Review-SaveFinalScore-POST-" + e.Message); throw; } return(Json(true)); }
public bool SetCustomDate(int awardId, int month, int year, bool isApplicable) { var customDatesForAward = _encourageDbcontext.Query <CustomDate>().FirstOrDefault(x => x.AwardId == awardId); if (customDatesForAward != null) { if (month > 0) { customDatesForAward.Month = month; customDatesForAward.Year = year; customDatesForAward.IsApplicable = isApplicable; _encourageDbcontext.Update(customDatesForAward); return(true); } else if (year > 0) { customDatesForAward.Year = year; customDatesForAward.IsApplicable = isApplicable; _encourageDbcontext.Update(customDatesForAward); return(true); } } if (month > 0) { _encourageDbcontext.Add(new CustomDate { AwardId = awardId, Month = month, Year = year, IsApplicable = isApplicable }); return(true); } else if (year > 0) { _encourageDbcontext.Add(new CustomDate { AwardId = awardId, Month = DateTime.Today.Month, Year = year, IsApplicable = isApplicable }); return(true); } return(false); }
public string UpdateEmailTemplate(int templateId, string updatedTemplate) { var toBeUpdatedTemplate = _encourageDatabaseContext.Query <EmailTemplate>().FirstOrDefault(t => t.Id == templateId); if (toBeUpdatedTemplate != null) { toBeUpdatedTemplate.Template = updatedTemplate; var returnedValue = _encourageDatabaseContext.Update(toBeUpdatedTemplate); if (returnedValue == 0) { return("Error"); } } return("Success"); }
public void UpdateReview(Review model) { _encourageDatabaseContext.Update(model); }
public void UpdateNomination(Nomination model) { _encourageDatabaseContext.Update <Nomination>(model); }