public override void AddUsersToRoles(string[] usernames, string[] roleNames) { foreach (var username in usernames) { var user = Repository <User> .Get(c => c.Username == username); if (user == null) { continue; } foreach (var roleName in roleNames) { var role = Repository <Role> .Get(c => c.RoleName == roleName); if (role == null) { continue; } var userinRole = new UserInRole { RoleId = role.Id, UserId = user.Id }; Repository <UserInRole> .Create(userinRole); } } }
public async Task <IActionResult> PutUserInRole(int id, UserInRole userInRole) { if (id != userInRole.Id) { return(BadRequest()); } _context.Entry(userInRole).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserInRoleExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public int ApiCreateUser(User user, int RoleId, out string ErrorMsg) { int UserId = 0; ErrorMsg = string.Empty; using (var db = dbFactory.Open()) { using (var dbTrans = db.OpenTransaction()) { try { UserId = (int)db.Insert(user, true); if (UserId > 0) { UserInRole UserRole = new UserInRole() { UserId = UserId, RoleId = RoleId }; var UserRoleId = db.Insert(UserRole, true); dbTrans.Commit(); } } catch (Exception ex) { dbTrans.Rollback(); ErrorMsg = ex.Message; UserId = 0; } } } return(UserId); }
public async Task <RespondModel> UpdateAsync(Guid id, UserUpdateViewModel userUpdateViewModel) { var user = await _repository.FetchFirstAsync(x => x.Id == id); if (user == null) { return(new RespondModel() { StatusCode = System.Net.HttpStatusCode.NotFound, Message = "Can't find user" }); } else { var updateUser = userUpdateViewModel.GetUserFromModel(user); updateUser.UserInRoles = new List <UserInRole>(); foreach (var roleId in userUpdateViewModel.Roles) { var userInRole = new UserInRole() { AppUserId = updateUser.Id, AppRoleId = roleId }; updateUser.UserInRoles.Add(userInRole); } return(await _repository.UpdateAsync(updateUser)); } }
public async Task <Unit> Handle(RegisterUserCommand request, CancellationToken cancellationToken) { await UsernameIsAlreadyRegisteredValidation(request.Dto); await EmailIsAlreadyRegisteredValidation(request.Dto); await CompanyIsAlreadyRegisteredValidation(request.Dto); await RoleDoesNotExistValidation(request.Dto); byte[] passwordHash, passwordSalt; AuthHelper.CreatePasswordHash(request.Dto.UserInfo.Password, out passwordHash, out passwordSalt); // add user var user = new User { Username = request.Dto.UserInfo.Username, PasswordHash = passwordHash, PasswordSalt = passwordSalt, Member = new Member { FirstName = request.Dto.UserInfo.FirstName, LastName = request.Dto.UserInfo.LastName, Email = request.Dto.UserInfo.Email, PhotoUrl = request.Dto.UserInfo.PhotoUrl, } }; var company = await unitOfWork.Companies.GetByCompanyNameAsync(request.Dto.CompanyInfo.CompanyName); if (company != null) { user.Member.Company = company; } else { user.Member.Company = new Company { CompanyName = request.Dto.CompanyInfo.CompanyName, Description = request.Dto.CompanyInfo.Description, LogoUrl = request.Dto.CompanyInfo.LogoUrl, IsActive = true }; } await unitOfWork.Users.AddAsync(user); // add role var role = await unitOfWork.Roles.GetByRolenameAsync(request.Dto.UserInfo.Role); if (role != null) { var userRole = new UserInRole { UserId = user.UserId, RoleId = role.RoleId }; await unitOfWork.UserInRoles.AddAsync(userRole); } return(Unit.Value); }
public async Task <int> Add(UserInRole entity) { await _uow.UserInRoleRepository.Add(entity); _uow.Save(); return(entity.ID); }
private void AddUserToRole(User user, string roleName) { Role role = _roleRepository.GetAll().FirstOrDefault(roleEntity => roleEntity.Name == roleName); if (role == null) { Role tempRole = new Role() { Name = roleName }; _roleRepository.Add(tempRole); _roleRepository.Save(); role = tempRole; } UserInRole userInRole = new UserInRole() { RoleId = role.Id, UserId = user.Id }; _userInRoleRepository.Add(userInRole); _userInRoleRepository.Save(); }
public int Add(AppUser user) { //WebSecurity.CreateUserAndAccount(user.Name, "123456", new { Email = ((AppUserEx)user).Email }); MemberShip member = new MemberShip() { UserName = user.Name, CreateDate = DateTime.Now, IsConfirmed = true, Email = user.Email, PhoneNumber = user.PhoneNumber, PasswordSalt = CommOp.NewId(), }; member.Password = MyStateProvider.EncryptPassword("123456", member.PasswordSalt); foreach (string roleId in user.RoleIds) { UserInRole uir = new UserInRole { RoleId = roleId.ToInt(), }; member.UserInRoles.Add(uir); } using (var _context = new ModelContext()) { _context.Set <MemberShip>().Add(member); _context.SaveChanges(); } user.Id = member.UserId.ToString(); return(1); }
public IActionResponse <int> Insert(UserInRole model) { var currentDate = DateTime.Now.Date; var userInRole = _userInRole.FirstOrDefault(x => x.RoleId == model.RoleId && x.UserId == model.UserId && x.ExpireDateMi >= currentDate); if (userInRole.IsNotNull()) { return new ActionResponse <int> { Message = BusinessMessage.CanNotAddNewRoleDueToActiveRole } } ; model.ExpireDateMi = PersianDateTime.Parse(model.ExpireDateSh).ToDateTime(); _userInRole.Add(model); var result = _uow.SaveChanges(); return(new ActionResponse <int> { IsSuccessful = result.ToSaveChangeResult(), Message = result.ToSaveChangeMessageResult(BusinessMessage.Success, BusinessMessage.Error), Result = model.UserInRoleId }); }
private void addUserToRole(User user, string roleName) { var role = _roleRepository.GetSingleByRoleName(roleName); Guid roleId = role == null ? Guid.Empty : role.Id; if (role == null) { var newRole = new Role { Name = roleName, CreateTime = DateTime.Now, Status = 1 }; roleId = _roleRepository.Insert(newRole); } var userInRole = new UserInRole() { RoleId = roleId, UserId = user.Id, CreateTime = DateTime.Now, Status = 1 }; _userInRoleRepository.Insert(userInRole); }
private async Task CreateUser(RegisterAdminCommand request, byte[] passwordHash, byte[] passwordSalt) { var user = new User { Username = request.Dto.Username, PasswordHash = passwordHash, PasswordSalt = passwordSalt }; context.Users.Add(user); await context.SaveChangesAsync(); var userRole = new UserInRole { UserId = user.UserId, RoleId = request.Dto.RoleId.GetValueOrDefault() }; context.UserInRoles.Add(userRole); await context.SaveChangesAsync(); if (request.Dto.RoleId > 0) { var role = await context.Roles.FindAsync(request.Dto.RoleId); if (role.RoleName == "customer") { await CreateCustomerAccount(request, user); } else if (role.RoleName == "rider") { await CreateRiderAccount(request, user); } } }
public JsonResult Save([Bind(Include = "UserID,RoleID,IsActive,SetOn,SetBy")] UserInRole userInRole, bool isInsert) { if (ModelState.IsValid) { userInRole.SetBy = LoginInformation.UserID; userInRole.SetOn = DateTime.Now; IEnumerable <UserInRoleView> userInRoles = _unitOfWork.UserInRoleRepository.Get(userInRole.UserID, userInRole.RoleID); var userInRoleViews = userInRoles as UserInRoleView[] ?? userInRoles.ToArray(); if (!userInRoleViews.Any()) { if (isInsert) { _unitOfWork.UserInRoleRepository.InsertUserInRole(userInRole); } return(new JsonResult { Data = _unitOfWork.UserInRoleRepository.Get(userInRole.UserID, userInRole.RoleID) .FirstOrDefault() }); } if (userInRoleViews.Any() && !isInsert) { _unitOfWork.UserInRoleRepository.UpdateUserInRole(userInRole); } _unitOfWork.Save(); } return(new JsonResult { Data = _unitOfWork.UserInRoleRepository.Get(userInRole.UserID, userInRole.RoleID) .FirstOrDefault() }); }
public Task AddToRoleAsync(User user, string roleName) { Argument.ThrowIfNull(user, "user"); Argument.ThrowIfNullOrEmpty(roleName, "roleName"); using (var db = dbFactory.Open()) { Role role = db.Single <Role>(r => r.Name == roleName); if (role != null) { UserInRole userRole = new UserInRole() { UserId = user.Id, RoleId = role.Id }; user.UserRoles.Add(userRole); var result = db.Insert(userRole); return(Task.FromResult(result)); } else { Int64 result = -1; return(Task.FromResult(result)); } } }
public async Task <ActionResult <UserInRole> > PostUserInRole(UserInRole userInRole) { _context.userInRoles.Add(userInRole); await _context.SaveChangesAsync(); return(CreatedAtAction("GetUserInRole", new { id = userInRole.Id }, userInRole)); }
private void addUserToRole(User user, string roleName) { var role = _roleRepository.GetSingleByRoleName(roleName); if (role == null) { var tempRole = new Role() { Name = roleName }; _roleRepository.Add(tempRole); _roleRepository.Save(); role = tempRole; } var userInRole = new UserInRole() { RoleKey = role.Key, UserKey = user.Key }; _userInRoleRepository.Add(userInRole); _userInRoleRepository.Save(); }
public JsonResult Save([Bind(Include = "UserID,RoleID,IsActive,SetOn,SetBy")] UserInRoleView userInRoleView, bool isInsert) { var userInRole = new UserInRole { UserID = Convert.ToInt16(userInRoleView.UserID), RoleID = Convert.ToInt16(userInRoleView.RoleID), IsActive = userInRoleView.IsActive, SetOn = Convert.ToDateTime(DateTime.Now), SetBy = LoginInformation.UserID, }; if (!ModelState.IsValid) { return new JsonResult { Data = _unitOfWork.UserInRoleRepository.GetByID(userInRole.UserID).ToUserInRoleView() } } ; if (isInsert) { _unitOfWork.UserInRoleRepository.Insert(userInRole); } else { _unitOfWork.UserInRoleRepository.Update(userInRole); } _unitOfWork.Save(); return(new JsonResult { Data = _unitOfWork.UserInRoleRepository.Get(userInRole.UserID, userInRole.RoleID).FirstOrDefault().ToUserInRoleView() }); }
private void CreateUser(string email, string name, string password, bool isApproved, bool isLockedOut, bool createRoles) { var dataSource = DependencyInjector.Get <IMembershipDataSource>(); var securityService = DependencyInjector.Get <ISecurityManager>(); var mainGroupId = dataSource.Query <Group>().Where(g => g.Name.ToLower() == Resources.DefaultValues.MainGroupName.ToLower()).Select(a => a.Id).FirstOrDefault(); var user = new User(Guid.NewGuid(), email, name); user.PreferredCulture = StrixPlatform.DefaultCultureCode; var userSecurity = new UserSecurity(user.Id); userSecurity.Password = securityService.EncodePassword(password); userSecurity.Approved = isApproved; userSecurity.LockedOut = isLockedOut; dataSource.Save(userSecurity); var userSession = new UserSessionStorage(user.Id); dataSource.Save(userSession); dataSource.Save(user); if (createRoles) { var adminRole = dataSource.Query <GroupInRole>().First(g => g.Role.Name == PlatformConstants.ADMINROLE); var userInRole = new UserInRole(adminRole, user.Id); dataSource.Save(userInRole); } dataSource.SaveChanges(); }
public ActionResult DeleteUser(int id) { if (Session["UserId"] == null && Session["UserName"] == null) { return(RedirectToAction("Login", "UserView")); } try { if (ModelState.IsValid) { UserInRole objUserInRole = db.UserInRoles.Where(m => m.UserId == id).FirstOrDefault(); User objUser = db.Users.Where(m => m.UserId == id).FirstOrDefault(); Address objAddress = db.Addresses.Where(m => m.AddressId == objUser.AddressId).FirstOrDefault(); //To remove address of user from address table db.Addresses.Remove(objAddress); //To Remove User from User Table db.Users.Remove(objUser); // To remove User from UserInRole table. db.UserInRoles.Remove(objUserInRole); db.SaveChanges(); } return(RedirectToAction("GetAllUsers")); } catch (Exception ex) { throw ex; } }
public async Task <RespondModel> AddUserAsync(UserRegisterViewModel userRegisterViewModel) { var user = await _repository.FetchFirstAsync(x => x.Email == userRegisterViewModel.Email); if (user != null) { return(new RespondModel() { StatusCode = System.Net.HttpStatusCode.NotFound, Message = "User is exist" }); } else { var newUser = AutoMapper.Mapper.Map <AppUser>(userRegisterViewModel); if (userRegisterViewModel.Roles != null) { foreach (var roleId in userRegisterViewModel.Roles) { var userInRole = new UserInRole() { AppUserId = newUser.Id, AppRoleId = roleId }; if (newUser.UserInRoles == null) { newUser.UserInRoles = new List <UserInRole>(); } newUser.UserInRoles.Add(userInRole); } } return(await _repository.InsertAsync(newUser)); } }
public void DeleteUserToRoleMap(int usrId, int roleId) { UserInRole result = db.UserInRoles.First(uir => uir.UserID == usrId && uir.RoleID == roleId); db.UserInRoles.Remove(result); db.SaveChanges(); }
public void AddUsersToRoles(string[] usernames, string[] roleNames) { foreach (string rolename in roleNames) { if (!RoleExists(rolename)) { return; } } foreach (string username in usernames) { foreach (string rolename in roleNames) { if (IsUserInRole(username, rolename)) { return; } } } var lst = new UserInRole { userId = int.Parse(usernames[0]), roleId = int.Parse(roleNames[0]) }; _userInRole.Add(lst); }
public async Task <IActionResult> EditUserInRole(string roleId) { ViewBag.roleId = roleId; var role = await roleManager.FindByIdAsync(roleId); if (role == null) { ViewBag.ErrorMessage = $"Role with ID = {roleId} cannot be found!"; return(View("NotFound")); } var model = new List <UserInRole>(); foreach (var user in userManager.Users.ToList()) { var userInRole = new UserInRole { UserId = user.Id, UserName = user.UserName }; if (await userManager.IsInRoleAsync(user, role.Name)) { userInRole.IsSelected = true; } else { userInRole.IsSelected = false; } model.Add(userInRole); } return(View(model)); }
public virtual async Task <JsonResult> Add(UserInRole model) { if (!ModelState.IsValid) { return(Json(new { IsSuccessful = false, Message = ModelState.GetModelError() })); } var addRep = await _userInRoleSrv.Add(model); if (!addRep.IsSuccessful) { return(Json(addRep)); } var getRep = _userInRoleSrv.Get(model.UserId).ToList(); getRep.ForEach((x) => { x.Role.UserInRoles = null; }); return(Json(new Response <string> { IsSuccessful = true, Result = await ControllerExtension.RenderViewToStringAsync(this, "Partials/_List", getRep) })); }
public void Delete(UserInRole entity) { using (var conn = new SqlConnection(_connStr)) { conn.Open(); entity.CreateRepository(conn).Delete(entity); } }
public bool AddNewUser(CreateUserInfo newUserInfo) { VisDashboardDataDataContext db = new VisDashboardDataDataContext(); using (TransactionScope ts = new TransactionScope()) { try { // Lookup the role ID Role desiredRole = null; var query = from p in db.Roles where p.RoleName == newUserInfo.UserInRole select p; try { desiredRole = query.Single(); } catch (Exception) { MessageBox.Show("Could not process user role.", "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } // Try to add new user to database User newUser = new User { Username = newUserInfo.Username, Password = newUserInfo.Password }; UserInRole newUserInRole = new UserInRole { ApplicationName = "DashboardPermissionTool", RoleID = desiredRole.RoleID }; newUserInRole.User = newUser; db.UserInRoles.InsertOnSubmit(newUserInRole); db.SubmitChanges(); ts.Complete(); } catch (SqlException e) { if (e.Message.Contains("Violation of UNIQUE KEY constraint 'U_Username'. Cannot insert duplicate key in object 'dbo.User'")) { MessageBox.Show("This user already exists.", "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show("Database Error: " + e.Message, "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); } return(false); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } } return(true); }
/// <summary> /// initializing Acl tables, remove after using /// for using in Hillavas.BaseProject_MaterialPro.Data.Migrations.Configuration.cs /// just add "AclSeed.Init(context);" to seed method /// </summary> /// <param name="db">project context</param> public bool Init() { using (var bt = _db.Database.BeginTransaction()) { var rep = AddAdminUserAndRole(); if (!rep.Success) { return(false); } #region UserInRole var userInRole = new UserInRole() { UserId = rep.UserId, RoleId = rep.RoleId }; _db.Set <UserInRole>().Add(userInRole); if (_db.SaveChanges() == 0) { bt.Rollback(); return(false); } #endregion var actionsRep = AddActions(); if (!actionsRep.Success) { bt.Rollback(); return(false); } _db.Set <ActionInRole>().AddRange(actionsRep.actions.Select(x => new ActionInRole { RoleId = rep.RoleId, ActionId = x.ActionId, IsDefault = x.ActionName == "ProfileInfo" ? true : false })); var addStoreRole = AddStoreRole(); if (!addStoreRole.Success) { bt.Rollback(); return(false); } _db.Set <ActionInRole>().Add(new ActionInRole { RoleId = addStoreRole.RoleId, ActionId = actionsRep.actions[0].ActionId, IsDefault = true }); if (_db.SaveChanges() == 0) { bt.Rollback(); return(false); } bt.Commit(); return(true); } }
public ActionResult AddUser(User objuser) { try { objuser.IsSuperUser = false; objuser.IsActive = true; objuser.IsClosed = false; objuser.LoginFailedAttempts = 0; objuser.LastLoginDate = DateTime.UtcNow; string strHostName = Dns.GetHostName(); IPHostEntry ipEntry = Dns.GetHostEntry(strHostName); IPAddress[] addr = ipEntry.AddressList; objuser.LastLoginIP = addr[addr.Length - 1].ToString(); objuser.TotalLogins = 0; HttpRequest req = System.Web.HttpContext.Current.Request; objuser.PlateForm = req.Browser.Platform; // TODO: Add insert logic here db.Users.Add(objuser); db.SaveChanges(); long userID = objuser.ID; UserInRole userRole = new UserInRole(); userRole.IsActive = true; userRole.UserID = userID; userRole.UserRoleID = Convert.ToInt32(Request.Form["UserInRoles"]); userRole.EffectiveFromDate = DateTime.UtcNow; userRole.ExpiryDate = DateTime.UtcNow.AddMonths(6); db.UserInRoles.Add(userRole); db.SaveChanges(); //get pages according to role List <tblUserRolePage> LstPages = db.tblUserRolePages.Where(x => x.RoleId == userRole.UserRoleID).ToList(); foreach (var item in LstPages) { //ADD Pages according to RoleID and UserID tblUserPage objUserPage = new tblUserPage(); objUserPage.page_id = item.PageId; objUserPage.Role_id = userRole.UserRoleID; objUserPage.show_in_menu = true; objUserPage.user_id = Convert.ToInt32(userID); db.tblUserPages.Add(objUserPage); db.SaveChanges(); } return(Redirect("/user-list")); } catch (Exception ex) { string a = ex.ToString(); return(View()); } }
public BaseUserInRoleViewModel(UserInRole userInRole) : this() { if (userInRole != null) { Id = userInRole.Id; UserId = userInRole.UserId; RoleId = userInRole.RoleId; } }
public bool isUserInRole(int userID, int roleID) { UserInRole result = db.UserInRoles.FirstOrDefault(uir => uir.UserID == userID && uir.RoleID == roleID); if (result == null) { return(false); } return(true); }
public void DeleteUserFromRole(int usrID, int roleID) { UserInRole uir = db.UserInRoles.First(r => r.UserID == usrID && r.RoleID == roleID); if (uir != null) { db.UserInRoles.Remove(uir); db.SaveChanges(); } }
public IServiceResults<bool> AddRole(UserInRole model) { _userInRole.Add(model); var saveResult = _uow.SaveChanges(); return new ServiceResults<bool> { IsSuccessfull = saveResult.ToBool(), Message = saveResult.ToMessage(BusinessMessage.Error), Result = saveResult.ToBool() }; }
partial void InsertUserInRole(UserInRole instance);
partial void UpdateUserInRole(UserInRole instance);
partial void DeleteUserInRole(UserInRole instance);
private void attach_UserInRoles(UserInRole entity) { this.SendPropertyChanging(); entity.User = this; }
private void detach_UserInRoles(UserInRole entity) { this.SendPropertyChanging(); entity.User = null; }
private void CreateUser(string email, string name, string password, bool isApproved, bool isLockedOut, bool createRoles) { var dataSource = DependencyInjector.Get<IMembershipDataSource>(); var securityService = DependencyInjector.Get<ISecurityManager>(); var mainGroupId = dataSource.Query<Group>().Where(g => g.Name.ToLower() == Resources.DefaultValues.MainGroupName.ToLower()).Select(a => a.Id).FirstOrDefault(); var user = new User(Guid.NewGuid(), email, name); user.PreferredCulture = StrixPlatform.DefaultCultureCode; var userSecurity = new UserSecurity(user.Id); userSecurity.Password = securityService.EncodePassword(password); userSecurity.Approved = isApproved; userSecurity.LockedOut = isLockedOut; dataSource.Save(userSecurity); var userSession = new UserSessionStorage(user.Id); dataSource.Save(userSession); dataSource.Save(user); if (createRoles) { var adminRole = dataSource.Query<GroupInRole>().First(g => g.Role.Name == PlatformConstants.ADMINROLE); var userInRole = new UserInRole(adminRole, user.Id); dataSource.Save(userInRole); } dataSource.SaveChanges(); }
protected void RegisterBtn_Click(object sender, EventArgs e) { string Username = RegUsernameBox.Text; string Email = RegEmailBox.Text; string REmail = RegREmailBox.Text; string Password = RegPasswordBox.Text; string RPassword = RegRPasswordBox.Text; if (Email != REmail) { RegError.Text = "Email don't match"; } else if (Password != RPassword) { RegError.Text = "Password don't match"; } else { GaymerLINQDataContext db = new GaymerLINQDataContext(); //Sjekk om email eller username eksisterer var UsernameTest = (from a in db.Users where a.Username == Username select a).FirstOrDefault(); var EmailTest = (from a in db.Users where a.Mail == Email select a).FirstOrDefault(); if (UsernameTest == null && EmailTest == null) { //klar for registrering User use = new User(); use.Username = Username; use.Mail = Email; Random rand = new Random(); string salt = rand.Next().ToString(); byte[] bytee = System.Text.Encoding.Default.GetBytes(Password + salt); byte[] byteHash = new SHA1CryptoServiceProvider().ComputeHash(bytee); string hash = Convert.ToBase64String(byteHash); use.Salt = salt; use.Password = hash; UserInRole uir = new UserInRole(); uir.inRoleID = 2; use.UserInRoles.Add(uir); db.Users.InsertOnSubmit(use); db.UserInRoles.InsertOnSubmit(uir); try { db.SubmitChanges(); RegError.Text = "You are now registered"; Response.Redirect("/User/UserPage.aspx"); } catch { RegError.Text = "General database error"; } finally { db.Dispose(); } } else if (UsernameTest != null && EmailTest != null) { } else if (UsernameTest != null) { } else if (EmailTest != null) { } } }
public bool AddNewUser(CreateUserInfo newUserInfo) { VisDashboardDataDataContext db = new VisDashboardDataDataContext(); using (TransactionScope ts = new TransactionScope()) { try { // Lookup the role ID Role desiredRole = null; var query = from p in db.Roles where p.RoleName == newUserInfo.UserInRole select p; try { desiredRole = query.Single(); } catch (Exception) { MessageBox.Show("Could not process user role.", "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); return false; } // Try to add new user to database User newUser = new User { Username = newUserInfo.Username, Password = newUserInfo.Password }; UserInRole newUserInRole = new UserInRole { ApplicationName = "DashboardPermissionTool", RoleID = desiredRole.RoleID }; newUserInRole.User = newUser; db.UserInRoles.InsertOnSubmit(newUserInRole); db.SubmitChanges(); ts.Complete(); } catch (SqlException e) { if (e.Message.Contains("Violation of UNIQUE KEY constraint 'U_Username'. Cannot insert duplicate key in object 'dbo.User'")) { MessageBox.Show("This user already exists.", "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); } else { MessageBox.Show("Database Error: " + e.Message, "User Creation Failed", MessageBoxButton.OK, MessageBoxImage.Error); } return false; } catch (Exception e) { Console.WriteLine(e.Message); return false; } } return true; }
public void AddUserToRole(HsrOrderApp.BL.DomainModel.User user, HsrOrderApp.BL.DomainModel.Role role) { try { UserInRole dbUserInRole = db.UserInRoles.FirstOrDefault(ur => ur.RoleId == role.RoleId && ur.UserId == user.UserId); if (dbUserInRole != null) { // user already in role return; } dbUserInRole = new UserInRole(); dbUserInRole.Role = db.Roles.FirstOrDefault(r => r.RoleId == role.RoleId); dbUserInRole.User = db.Users.FirstOrDefault(u => u.UserId == user.UserId); db.UserInRoles.InsertOnSubmit(dbUserInRole); db.SubmitChanges(); } catch (ChangeConflictException ex) { if (ExceptionPolicy.HandleException(ex, "DA Policy")) throw; } }
/// <summary> /// 处理通过拖拽和双击往角色列表中为用户添加角色 /// </summary> /// <param name="sender"></param> private void AddRoleToUserInRoles(object sender) { var selrole = sender as Roles; UserInRole userRole = new UserInRole(); userRole.Roles = selrole; //判断拖动的角色是否和角色列表中的角色重复,若重复不能添加 SelCurrentUser.UserInRoles.Add(userRole); this.userInRoles.Items.MoveCurrentTo(userRole); }