public ActionResult Index() { _logger.Log("Home-Index"); var customDate = _customDateService.GetCustomDate(1); DashboardViewModel dashboardViewModel = new DashboardViewModel(); dashboardViewModel.NominationList = GetWinnersList(customDate.Month, customDate.Year, 1); string utiltyName = WebConfigurationManager.AppSettings["ProductName"]; var authorizationService = new Authorization(_commonDbService.GetCommonDataBaseContext()); var commonRoles = authorizationService.GetRoleForUtility(User.Identity.Name, utiltyName); dashboardViewModel.UserRoles = commonRoles; var typesOfAwards = _encourageDatabaseContext.Query <Award>().ToList(); var awardsList = new List <AwardViewModel>(); foreach (var award in typesOfAwards) { var awardDetails = new AwardViewModel { AwardId = award.Id, AwardTitle = award.Name, AwardCode = award.Code }; awardsList.Add(awardDetails); } dashboardViewModel.Awards = awardsList; dashboardViewModel.CustomDate = customDate; return(View("Dashboard", dashboardViewModel)); }
public void UnShortlistNomination(int nominationId) { var shortlistedNomination = _encourageDatabaseContext.Query <Shortlist>().SingleOrDefault(model => model.NominationId == nominationId); if (shortlistedNomination != null) { _encourageDatabaseContext.Delete <Shortlist>(shortlistedNomination); } }
public bool AddReviewer(int userId) { try { if (!_encourageDatabaseContext.Query <Reviewer>().Any(r => r.UserId == userId)) { _encourageDatabaseContext.Add <Reviewer>(new Reviewer { UserId = userId }); _encourageDatabaseContext.SaveChanges(); return(true); } } catch (Exception) { return(false); } return(false); }
// [CustomeAuthorize(AllowedRole = "User,Manager,Admin,Reviewer")] public ActionResult Index() { string utility = WebConfigurationManager.AppSettings["ProductName"]; var authorizationService = new Authorization(_commonDbService.GetCommonDataBaseContext()); Session["UserEmailAddress"] = User.Identity.Name; // var commonRoles = authorizationService.GetRoleForUtility(User.Identity.Name, utility); var commonRoles = new List <string>() { "Manager", "Admin" }; if ((commonRoles.Count > 0)) { HttpContext.Session["Role"] = commonRoles; } var winnersForLastMonth = _encourageDatabaseContext.Query <Shortlist>().Where(w => w.IsWinner == true && w.WinningDate.Value.Month == (DateTime.Now.Month) && w.WinningDate.Value.Year == DateTime.Now.Year).ToList(); var listOfWinners = new List <NominationListViewModel>(); foreach (var winner in winnersForLastMonth) { var winnerName = _nominationService.GetNomineeNameOfCurrentNomination(winner.NominationId); var awardMonthYear = _nominationService.GetAwardMonthAndYear(winner.NominationId); var awardName = _nominationService.GetAwardName(winner.NominationId); listOfWinners.Add(new NominationListViewModel() { DisplayName = winnerName, NominationTime = awardMonthYear, AwardName = awardName }); } return(View("Dashboard", listOfWinners)); }
public DateTime GetCustomDate(int awardId) { var data = _encourageDbcontext.Query <CustomDate>().FirstOrDefault(x => x.AwardId == awardId); var award = _encourageDbcontext.Query <Award>().FirstOrDefault(x => x.Id == awardId); var currentDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var somDate = currentDate.AddMonths(-1); var pinnacleDate = currentDate.AddMonths(-12); if (data != null) { if (award != null && data.IsApplicable) { var month = data.Month == null ? DateTime.Today.Month : (int)data.Month; var year = data.Year == null ? DateTime.Today.Year : (int)data.Year; return(new DateTime(year, month, 1)); } else if (award != null && !data.IsApplicable) { return(somDate); } } else if (award != null) { var awardFrequency = _encourageDbcontext.Query <FrequencyMaster>().FirstOrDefault(x => x.Id == award.FrequencyId); if (awardFrequency != null && awardFrequency.Code == FrequencyCode.MON.ToString()) { return(somDate); } if (awardFrequency != null && awardFrequency.Code == FrequencyCode.YEAR.ToString()) { return(pinnacleDate); } } return(currentDate); }
public ActionResult SavedNomination(int managerId = 0) { _logger.Log("Nomination-SavedNomination-GET"); var email = User.Identity.Name; _awardService.GetProjectsUnderCurrentUserAsManager(email); _awardService.GetDepartmentsUnderCurrentUserAsManager(email); var nominations = _nominationService.GetAllSubmittedAndSavedNominationsByCurrentUser(managerId); var savedNominations = new List <NominationListViewModel>(); foreach (var nomination in nominations) { var award = _encourageDatabaseContext.Query <Award>().FirstOrDefault(a => a.Id == nomination.AwardId); if (award == null) { continue; } var awardFrequencyCode = _nominationService.GetAwardFrequencyById(award.FrequencyId); var awardName = award.Code; var nominee = _commonDbContext.Query <User>().FirstOrDefault(u => u.ID == nomination.UserId); var nominationTime = nomination.NominationDate; if (nominationTime == null) { continue; } string nominationTimeToDisplay = CultureInfo.CurrentCulture.DateTimeFormat.GetAbbreviatedMonthName(nominationTime.Value.Month) + "-" + nominationTime.Value.Year; if (nominee != null) { var reviewNominationViewModel = new NominationListViewModel() { Intials = nominee.FirstName.Substring(0, 1) + "" + nominee.LastName.Substring(0, 1), AwardName = awardName, DisplayName = nominee.DisplayName, NominationTime = nominationTimeToDisplay, Id = nomination.Id, IsSubmitted = nomination.IsSubmitted, AwardFrequencyCode = awardFrequencyCode.Code, UserId = nominee.ID, EmployeeId = nominee.EmployeeID }; savedNominations.Add(reviewNominationViewModel); } } return(View(savedNominations)); }
public ActionResult ReviewFeedbackList() { _logger.Log("Review-ReviewFeedbackList-GET"); int awardType = 0; var shortListedNominations = new ShortlistedNominationViewModel(); var reviewFeedbackList = ReviewFeedbackList(true, awardType); var awards = _encourageDatabaseContext.Query <Award>().ToList(); foreach (var award in awards) { shortListedNominations.Awards.Add(new LockAwardViewModel { Id = award.Id, Code = award.Code, Name = award.Name }); } shortListedNominations.ReviewFeedbackList = reviewFeedbackList; return(View(shortListedNominations)); }
public IEnumerable <Review> GetReviewsForNomination(int nominationID) { var reviews = _encourageDatabaseContext.Query <Review>("ReviewerComments").Where(review => review.NominationId == nominationID && review.IsSubmited == true).ToList(); return(reviews); }
public EmailTemplate GetEmailTemplate(int templateId) { return(_encourageDatabaseContext.Query <EmailTemplate>().FirstOrDefault(t => t.Id == templateId)); }
public List <Nomination> GetAllNominations() { return(_encourageDatabaseContext.Query <Nomination>("ManagerComments").ToList()); }
public List <Shortlist> GetAllWinners() { return(_context.Query <Shortlist>().Where(x => x.IsWinner == true).ToList()); }
public IEnumerable <Award> GetAllAwards() { return(_encourageDbcontext.Query <Award>().ToList()); }