public async Task <IActionResult> Edit(int id, [Bind("Id,UserId,RoleId")] User_Role user_Role) { if (id != user_Role.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(user_Role); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!User_RoleExists(user_Role.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["RoleId"] = new SelectList(_context.Roles, "Id", "Id", user_Role.RoleId); ViewData["UserId"] = new SelectList(_context.Users, "Id", "Id", user_Role.UserId); return(View(user_Role)); }
public HttpMessage <User> Register(RegisterUser register) { return(TryCatchResponse(() => { if (register == null || string.IsNullOrEmpty(register.Email)) { throw new Exception("Неверные параметры регистрации."); } List <User> users = GetUsers(register.Email); if (users != null && users.Count > 0) { throw new Exception("Пользователь уже зарегистрирован."); } User user = InsertUser(new User() { Email = register.Email }); User_Role user_role = InsertUserRole(new User_Role() { User = user.Id, Role = 2 }); User_Sec user_sec = SetPassword(user, user.Email, null, "Регистрация в Auto Parts Site"); return CreateResponseOk(user); })); }
public IHttpActionResult PutUser_Role(int id, User_Role user_Role) { db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user_Role.User_Role_ID) { return(BadRequest()); } db.Entry(user_Role).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!User_RoleExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IActionResult> Post(User_Role user_Role) { if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = "Invalid Model State"; return(BadRequest(objHelper)); } try { //if (user_RoleRepository.IsDuplicate(user_Role)) //{ // objHelper.Status = StatusCodes.Status200OK; // objHelper.Message = "Data already available"; // return Ok(objHelper); //} await user_RoleRepository.Insert(user_Role); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; objHelper.Data = user_Role; return(Ok(objHelper)); } catch { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = "Get Unsuccessful"; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public Account_c(string acc, string pwd) { Lib.DataUtility du = new Lib.DataUtility(); DataTable dt = du.getDataTableByText("select * from account_c where account = @acc", "acc", acc); if (dt.Rows.Count != 1) { isValid = false; loginstatus = LoginStatus.Logout; } if (dt.Rows.Count == 1) { if (dt.Rows[0]["password"].ToString() == pwd) { isValid = true; account = acc; password = pwd; role_code = dt.Rows[0]["role_code"].ToString(); name = dt.Rows[0]["name"].ToString(); id = dt.Rows[0]["id"].ToString(); unit_code = dt.Rows[0]["unit_code"].ToString(); rank_code = dt.Rows[0]["rank_code"].ToString(); tel = dt.Rows[0]["tel"].ToString(); cell = dt.Rows[0]["cellphone"].ToString(); mail = dt.Rows[0]["mail"].ToString(); ip = dt.Rows[0]["ip"].ToString(); pwdChange = dt.Rows[0]["pwdChange"].ToString(); status = dt.Rows[0]["status"].ToString(); byAcc = dt.Rows[0]["byAcc"].ToString(); loginstatus = LoginStatus.Login; string roleCode = dt.Rows[0]["role_code"].ToString(); switch (roleCode) { case "1": role = User_Role.Administrator; break; case "2": role = User_Role.AccountManager; break; case "3": role = User_Role.CenterSupervisor; break; case "4": role = User_Role.CenterOfficer; break; default: break; } } else { isValid = false; loginstatus = LoginStatus.Logout; } } }
public HttpResponseMessage Register(string token, [FromBody] UserRegistration user) { try { if (!hasAuthorizedRole(con, token)) { return(Request.CreateResponse(HttpStatusCode.Forbidden)); } var salt = MembershipProvider.CreateNewSalt(); var hash = MembershipProvider.GenerateHash(user.PasswordClear, salt); var userId = con.OnboardUser(user.Username, hash, Convert.ToBase64String(salt), user.ClientID, user.LastName, user.FirstName, user.DOB, user.Email, user.UserTypeID, user.DivisionID); var role = new User_Role { Role_ID = user.RoleID, UserID = userId, DateCreated = DateTime.Now, isActive = true }; con.User_Roles.InsertOnSubmit(role); con.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK, userId)); } catch (Exception e) { ExceptionLog.LogException(e); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public IHttpActionResult PostDep_Teacher(User user, Guid id) { //1.先添加该教师到用户表 db.User.Add(user); //2.添加角色信息 Guid TeacherRoleID = db.Role.FirstOrDefault(u => u.RoleName == "教师").RoleID; User_Role UR = new User_Role(); UR.RoleID = TeacherRoleID; UR.UserID = user.UserID; db.User_Role.Add(UR); //将这个教师添加到软件学院 Dep_Teacher dep_Teacher = new Dep_Teacher(); dep_Teacher.Dep_ID = id; dep_Teacher.Dep_Name = db.Department.FirstOrDefault(u => u.DepID == id).DepName; dep_Teacher.Teacher_ID = user.UserID; dep_Teacher.Teacher_Name = user.UserName; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Dep_Teacher.Add(dep_Teacher); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = dep_Teacher.ID }, dep_Teacher)); }
public Role GetUserRole(Entities objectContext, User user) { Tools.CheckObjectContext(objectContext); if (user == null) { throw new ArgumentNullException("user"); } if (user.isAdmin == true) { throw new InvalidOperationException("user is admin"); } user.User_Roles.Load(); User_Role userRole = user.User_Roles.FirstOrDefault(ur => ur.active == true); if (userRole == null) { throw new ArgumentNullException("user doesnt have role set."); } userRole.RoleReference.Load(); Role role = userRole.Role; return(role); }
public async Task <IActionResult> AddUserAndRoleAsync(UserAndRoleDto model) { try { //获取到用户信息 IEnumerable <R_UserInfo> r_UserInfos = await dbContext.r_UserInfoRepository.GetAllInfoAsync(); //根据名称查找到这一条数据 R_UserInfo user = r_UserInfos.ToList().Where(s => s.UserName.Equals(model.User_Name)).FirstOrDefault(); if (user == null) { throw new Exception("没有找到这一条信息"); } User_Role m = new User_Role() { RoleID = model.RoleId, UserID = user.UserID }; dbContext.user_RoleRepository.CreateInfo(m); if (await dbContext.user_RoleRepository.SaveAsync()) { return(Ok(1)); } _logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddHHmmssfff")}同时添加用户和角色信息"); return(Ok("添加失败")); } catch (Exception ex) { throw new Exception(ex.Message); } }
public async Task <IActionResult> UpdateUserAndRoleAsync(User_Role user_Role) { try { //判断传过来的数据是否存在 if (await dbContext.user_RoleRepository.IsExistAsync(user_Role.ConnectionID)) { //找到这条数据 User_Role user = await dbContext.user_RoleRepository.GetFirstInfo(user_Role.ConnectionID); //修改数据 dbContext.user_RoleRepository.UpdateInfo(user); if (await dbContext.user_RoleRepository.SaveAsync()) { return(Ok(1)); } } _logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddHHmmssfff")}修改用户和角色信息"); //如果不存在返回错误信息 return(NotFound()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool AddUserRole(string userIds, string roleIds) { try { using (IDbContextBase context = DbContextFactory.GetDbContext()) { string[] arrUserId = userIds.Split(','); string[] arrRoleId = roleIds.Split(','); User_Role userRole = null; for (int i = 0; i < arrUserId.Length; i++) { for (int j = 0; j < arrRoleId.Length; j++) { userRole = new User_Role(); userRole.Id = Guid.NewGuid(); userRole.RoleId = new Guid(arrRoleId[j]); userRole.UserId = new Guid(arrUserId[i]); context.Insert <User_Role>(userRole, false); } } return(context.SaveChanges()); } } catch { throw; } }
/// <summary> /// 通过用户ID获取用户的角色信息 /// </summary> /// <param name="id">用ID</param> /// <returns>角色string</returns> public IHttpActionResult GetUserRole(Guid id) { //获取用户对应的角色编号 User_Role UR = db.User_Role.FirstOrDefault(u => u.UserID == id); //如果该用户没有角色 if (UR == null) { return(NotFound()); } else { //如果有角色,先获取角色ID Guid URI = UR.RoleID; //通过角色ID获取角色名称 Role R = db.Role.FirstOrDefault(u => u.RoleID == URI); if (R == null) { return(NotFound()); } else { return(Ok(R.RoleName)); } } }
/// <summary> /// Create a new User_Role object. /// </summary> /// <param name="id">Initial value of ID.</param> /// <param name="active">Initial value of active.</param> public static User_Role CreateUser_Role(long id, bool active) { User_Role user_Role = new User_Role(); user_Role.ID = id; user_Role.active = active; return(user_Role); }
public ActionResult DeleteConfirmed(int id) { User_Role user_Role = db.User_Role.Find(id); db.User_Role.Remove(user_Role); db.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// 创建UserRole信息 /// </summary> public static int InsertUserRole(User_Role entity) { DataCommand cmd = new DataCommand("InsertUserRole"); cmd.SetParameter <User_Role>(entity); int result = cmd.ExecuteScalar <int>(); return(result); }
public async Task <IActionResult> UserToRole(int userId, int roleId, string key) { if (key != "zhanghaodong138") //这就不写那些复杂的了,(配置文件,在加密解密,偷懒了) { return(Ok(new { code = 1, msg = "密钥不正确!" })); } var userrole = await _repositoryWrapper.User_RoleRepository.GetUser_RoleByUserIdAsync(userId); if (userrole == null) { User_Role user_Role = new User_Role(); var user = await _repositoryWrapper.UserRepository.GetByIdAsync(userId); if (user == null) { return(NotFound()); } user_Role.UserId = user.Id; user_Role.UserEmail = user.NickName; var role = await _context.Roles.FindAsync(roleId); if (role == null) { return(NotFound()); } user_Role.RoleId = role.Id; user_Role.RoleName = role.Name; await _repositoryWrapper.User_RoleRepository.AddAsync(user_Role); await _repositoryWrapper.User_RoleRepository.SaveAsync(); return(Ok(new { code = 0, msg = "角色分配成功!" })); } var user2 = await _repositoryWrapper.UserRepository.GetByIdAsync(userId); if (user2 == null) { return(NotFound()); } userrole.UserId = user2.Id; userrole.UserEmail = user2.NickName; var role2 = await _context.Roles.FindAsync(roleId); if (role2 == null) { return(NotFound()); } userrole.RoleId = role2.Id; userrole.RoleName = role2.Name; await _repositoryWrapper.User_RoleRepository.UpdateAsync(userrole); await _repositoryWrapper.User_RoleRepository.SaveAsync(); return(Ok(new { code = 0, msg = "角色分配成功!" })); }
public ActionResult AggRole(string usrname) { User_Role UserRol = new User_Role(); UserRol.UserName = usrname; ViewBag.Roles = new SelectList(getRoles(), "RolName", "RolName"); return(View(UserRol)); }
public ActionResult Edit([Bind(Include = "UserRole_ID,UserRole_Description")] User_Role user_Role) { if (ModelState.IsValid) { db.Entry(user_Role).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_Role)); }
public void RefreshGroups() { DBEntities context = COREobject.i.Context; string groupADServer = WebConfigurationManager.AppSettings[$"Persona_AdGroupServer"]; NexusLdapService ldap = new NexusLdapService(); ldap.UseServer(groupADServer); // get ADgroup_User from AD List <ADgroup_User> rightsLdap = new List <ADgroup_User>(); foreach (ADgroup group in context.ADgroups.ToList()) { // For ADGroup with added RoleForApplication remove UserRoles if (!string.IsNullOrEmpty(group.RoleForApplication)) { foreach (User_Role userRole in context.Users_Roles.ToList()) { if (userRole.ApplicationId == group.ApplicationId && userRole.RoleName == group.RoleForApplication) { context.Users_Roles.Remove(userRole); } } } var ADapps = ldap.GetGroups(group.Name); if (ADapps.Count() == 0) { continue; } foreach (JToken ADapp in ADapps) // should be only 1 { foreach (JToken member in ADapp["member"]) { // save user with groups User user = AuthAD.getUserAndHisGroupsFromAD(identify: (string)member).Item1; // Add UserRole according to ADGroup if (!string.IsNullOrEmpty(group.RoleForApplication)) { User_Role newUserRole = new User_Role(); newUserRole.UserId = user.Id; newUserRole.RoleName = group.RoleForApplication; newUserRole.ApplicationId = group.ApplicationId ?? 0; newUserRole.ApplicationName = context.Applications.Find(group.ApplicationId ?? 0).Name; context.Users_Roles.Add(newUserRole); } } } } context.SaveChanges(); }
public IHttpActionResult GetUser_Role(Guid id) { User_Role user_Role = db.User_Role.First(u => u.UserID == id); if (user_Role == null) { return(NotFound()); } return(Ok(user_Role)); }
/// <summary> /// 修改 /// </summary> /// <param name="id"></param> /// <param name="entity"></param> /// <returns></returns> public async Task <bool> PutEntityAsync(string id, User_Role entity) { if (!IsExists(id)) { return(false); } _context.Attach(entity); _context.Update(entity); return(await _context.SaveChangesAsync() > 0); }
private void Setup() { foreach (City item in DictionaryMocks.cityMock) { City newCity = (City)item.Clone(); newCity.Id = null; listCity.Add(newCity); } for (int i = 0; i < listCity.Count; i++) { int id = (int)dictionaryStorage.CityAddOrUpdate(listCity[i]).Result; listCity[i].Id = id; } foreach (Role item in DictionaryMocks.roleMocks) { Role newRole = (Role)item.Clone(); newRole.Id = null; listRole.Add(newRole); } for (int i = 0; i < listRole.Count; i++) { int id = (int)dictionaryStorage.RoleAddOrUpdate(listRole[i]).Result; listRole[i].Id = id; } foreach (User item in UserMock.listUsers) { User newUser = (User)item.Clone(); newUser.CityId = (int)listCity[0].Id; newUser.Id = null; listUser.Add(newUser); } for (int i = 0; i < listUser.Count; i++) { int id = (int)userStorage.UserAddOrUpdate(listUser[i]).Result; listUser[i].Id = id; } foreach (User_Role item in User_RoleMock.user_RoleMocks) { User_Role newUser_Role = (User_Role)item.Clone(); newUser_Role.Id = null; listUser_role.Add(newUser_Role); } for (int i = 0; i < listUser_role.Count; i++) { listUser_role[i].RoleId = (int)listRole[i].Id; listUser_role[i].UserId = (int)listUser[i].Id; int id = (int)userStorage.User_RoleAdd(listUser_role[i]).Result; listUser_role[i].Id = id; } }
public ActionResult Edit(User_Role userrole) { var ur = DB.User_Role.Find(userrole.User_ID); ur.User_ID = userrole.User_ID; ur.Login = userrole.Login + "@fpt.edu.vn"; ur.Role = ur.Role; ur.isActive = userrole.isActive; DB.SaveChanges(); return(RedirectToAction("ListAll"));; }
public ActionResult Create([Bind(Include = "UserRole_ID,UserRole_Description")] User_Role user_Role) { if (ModelState.IsValid) { db.User_Role.Add(user_Role); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_Role)); }
public ActionResult Index(User_Role user_Role, FormCollection form) { User_Role model = new User_Role(); model.Role_id = Convert.ToInt16(form["Rol"]); model.User_id = Convert.ToInt16(form["usr"]); model.Table_id = Convert.ToInt16(form["table"]); db.User_Role.Add(model); db.SaveChanges(); return(View()); }
public async Task <IActionResult> OnPostAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); if (ModelState.IsValid) { // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, set lockoutOnFailure: true var result = await _signInManager.PasswordSignInAsync(Input.Email, Input.Password, Input.RememberMe, lockoutOnFailure : false); var users = from m in _userManager.Users where m.Email.Equals(Input.Email) select m.User_Role; if (result.Succeeded) { _logger.LogInformation("User logged in."); //the first page foe user role once logging in foreach (string User_Role in users) { if (String.IsNullOrEmpty(User_Role)) { return(RedirectToAction("Index", "Home")); } else if (User_Role.Equals("Customer")) { return(RedirectToAction("Index", "Orders")); } else if (User_Role.Equals("Driver")) { return(RedirectToAction("Index", "Driver")); } } } if (result.RequiresTwoFactor) { return(RedirectToPage("./LoginWith2fa", new { ReturnUrl = returnUrl, RememberMe = Input.RememberMe })); } if (result.IsLockedOut) { _logger.LogWarning("User account locked out."); return(RedirectToPage("./Lockout")); } else { ModelState.AddModelError(string.Empty, "Invalid login attempt."); return(Page()); } } // If we got this far, something failed, redisplay form return(Page()); }
public async Task <User_Role> Get(int id) { try { User_Role lstUser_Role = adbContext.user_role.AsEnumerable <User_Role>().Where(w => w.Id == id).ToList().SingleOrDefault(); return(await Task.FromResult(lstUser_Role)); } catch (Exception ex) { throw ex; } }
public ActionResult Edit([Bind(Include = "User_ID,Role_ID,Login,isActive")] User_Role user_Role) { if (ModelState.IsValid) { user_Role.Login = user_Role.Login + "@fpt.edu.vn"; db.Entry(user_Role).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Role_ID = new SelectList(db.Roles, "Role_ID", "Role_Name", user_Role.Role_ID); return(View(user_Role)); }
public IHttpActionResult GetUser_Role(int id) { db.Configuration.ProxyCreationEnabled = false; User_Role user_Role = db.User_Role.Find(id); if (user_Role == null) { return(NotFound()); } return(Ok(user_Role)); }
public async Task Update(User_Role entity) { try { adbContext.user_role.Update(entity); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
protected void gvSearchUser_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow drv = ((GridViewRow)(((LinkButton)(e.CommandSource)).Parent.Parent)); //此得出的值是表示那行被选中的索引值 int userid = Convert.ToInt32(gvSearchUser.DataKeys[drv.RowIndex].Value); //此获取的值为GridView中绑定数据库中的主键值 String roleid = (String)ViewState["roleid"]; User_Role ur = new User_Role(); ur.UserKey = userid; ur.RoleKey = Convert.ToInt32(roleid); if (e.CommandName == "Add") { BLL.admin.role.RoleManagement.insertRoleUser(ur); databind(); lbMessage.Text = "添加成员成功!"; } }
public static bool insertRoleUser(User_Role ur) { using (DataClassesEduDataContext dc = new DataClassesEduDataContext()) { dc.User_Role.InsertOnSubmit(ur); dc.SubmitChanges(); return true; } }