public void AddRolesToUserForAUtility(UtilityUserRoleViewModel newUserRole) { var newUserRoles = new UtilityUserRoles(); foreach (var userId in newUserRole.UserId) { var userRole = _commonDBContext.Query <UtilityUserRoles>().FirstOrDefault(x => x.UserId == userId && x.UtilityId == newUserRole.UtilityId && x.RoleId == newUserRole.RoleId); if (userRole != null) { userRole.IsActive = true; _commonDBContext.Update(userRole); } else { newUserRoles.UtilityId = newUserRole.UtilityId; newUserRoles.RoleId = newUserRole.RoleId; newUserRoles.UserId = userId; newUserRoles.IsActive = true; _commonDBContext.Add(newUserRoles); } if (HttpContext.Current.Request.IsLocal) { ServicePointManager.ServerCertificateValidationCallback = delegate { return(true); }; } string url = ConfigurationManager.AppSettings["Addreviewer"] + userId; HttpClient client = new HttpClient(); client.BaseAddress = new Uri(url); var response = client.GetAsync(url).Result; } RemoveRolesOfUserFromUtility(newUserRole); }
public void AddRolesToUserForAUtility(UtilityUserRoleViewModel newUserRole) { var myNewUserRole = new UtilityUserRoles(); foreach (var item in newUserRole.UserId) { var userRole = _commonDBContext.Query <UtilityUserRoles>().Where(x => x.UserId == item && x.UtilityId == newUserRole.UtilityId).FirstOrDefault(); if (userRole != null) { _commonDBContext.Delete(userRole); } myNewUserRole.UtilityId = newUserRole.UtilityId; myNewUserRole.RoleId = newUserRole.RoleId; myNewUserRole.UserId = item; _commonDBContext.Add(myNewUserRole); } }
// [CustomeAuthorize(AllowedRole = "Reviewer")] public ActionResult AddExtensionCode(ExtensionSolution extensionSolution) { try { var userEmailAddress = User.Identity.Name; extensionSolution.CreationDate = System.DateTime.Now; extensionSolution.FrequentSearchedCount = 0; User user = new User(); user = _commonDataBaseContext.Query <User>().Where(u => u.EmailAddress == userEmailAddress).FirstOrDefault(); List <UtilityUserRoles> Reviewers = new List <UtilityUserRoles>(); Reviewers = _commonDataBaseContext.Query <UtilityUserRoles>().Where(u => u.UtilityId == 4 && u.RoleId == 371).ToList(); extensionSolution.UserDisplayName = user.DisplayName; extensionSolution.userid = user.ID; List <ExtensionSolution> ExtensionSolutionList = new List <ExtensionSolution>(); ExtensionSolutionList = _extensionCodeService.GetAllExtensionSolution(); var lastItem = ExtensionSolutionList.LastOrDefault(); UtilityUserRoles SelectedReviewer = new UtilityUserRoles(); for (int i = 0; i < Reviewers.Count(); i++) { if (i == Reviewers.Count - 1 || lastItem.reviewerid == 0) { SelectedReviewer = Reviewers[0]; break; } else { if (lastItem.reviewerid == Reviewers[i].UserId) { i = i + 1; SelectedReviewer = Reviewers[i]; break; } } } User reviewer = new User(); reviewer = _commonDataBaseContext.Query <User>().Where(u => u.ID == SelectedReviewer.UserId).FirstOrDefault(); extensionSolution.reviewerid = SelectedReviewer.UserId; _extensionCodeService.AddExtensionSolution(extensionSolution); var reviewerEmailAddresses = reviewer.EmailAddress; //var reviewerEmailAddresses = "*****@*****.**"; var subject = "Review Request for the Extension Code Method."; var userName = user.DisplayName; var codeType = "Extension Code"; var link = "https://reusable.azurewebsites.net/Extension/ReviewExtensionCodeList"; //_extensionCodeService.SendEmail(userName, reviewerEmailAddresses, subject, codeType,link); Task.Factory.StartNew(() => { _extensionCodeService.SendEmail(userName, reviewerEmailAddresses, subject, codeType, link); }); return(RedirectToAction("ShowMyExtensionCode")); } catch (DbUpdateException ex) { ViewBag.message = "Category Name already exists"; return(View(ex)); } catch (Exception e) { return(View(e)); } }