public ActionResult Create(int groupId, string username) { if (ModelState.IsValid) { string queryString = "SELECT dbo.AspNetUsers.Id " + "FROM dbo.AspNetUsers " + "WHERE dbo.AspNetUsers.UserName='******'"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); AspNetGroupUser gu = new AspNetGroupUser { GroupId = groupId, UserId = reader.GetString(0) }; db.AspNetGroupUsers.Add(gu); db.SaveChanges(); reader.Close(); } } return(RedirectToAction("../Groups/Index")); }
// GET: AspNetGroupUsers/Delete/5 public ActionResult Delete(int?id, string username) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } /*if (username == null) * { * return new HttpStatusCodeResult(HttpStatusCode.BadRequest); * }*/ string uid; string queryString = "SELECT dbo.AspNetUsers.Id " + "FROM dbo.AspNetUsers " + "WHERE dbo.AspNetUsers.UserName='******'"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); uid = reader.GetString(0); reader.Close(); } AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(id, uid); if (aspNetGroupUser == null) { return(HttpNotFound("The id is " + id + " and the uid is " + uid)); } return(View(aspNetGroupUser)); }
public ActionResult Edit([Bind(Include = "GroupId,UserId")] AspNetGroupUser aspNetGroupUser) { if (ModelState.IsValid) { db.Entry(aspNetGroupUser).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetGroupUser)); }
public void AddUserToDefaultGroup(string userId, string createdBy) { var defaultGroup = _entities.AspNetGroups.FirstOrDefault(x => x.Code.ToLower() == "staffs" && x.Deleted == false && x.Active == true); if (defaultGroup != null) { //Add a record in table aspNetGroupUsers AspNetGroupUser groupUser = new AspNetGroupUser(); groupUser.UserId = userId; groupUser.GroupId = defaultGroup.Id; try { _groupUsersRepository.Add(groupUser); } catch { return; } try { _applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetGroupUser", userId + '-' + defaultGroup.Id, "", "", groupUser, "", System.Web.HttpContext.Current.Request.UserHostAddress, createdBy); } catch { } try { //Add all Roles of defaultGroup from table aspNetGroupRoles to table aspNetUserRoles IEnumerable <AspNetGroupRole> listRoleOfGroup = _aspNetGroupRolesRepository.GetAll().Where(n => n.GroupId == defaultGroup.Id); if (listRoleOfGroup.Count() > 0) { foreach (var item in listRoleOfGroup) { AspNetUserRole itemUserRole = new AspNetUserRole(); itemUserRole.UserId = userId; itemUserRole.RoleId = item.RoleId; itemUserRole.Grant = true; _aspNetUserRolesRepository.Add(itemUserRole); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetUserRole", userId + '-' + item.RoleId, "", "", itemUserRole, "", System.Web.HttpContext.Current.Request.UserHostAddress, createdBy); } catch { } } } } catch { } } }
// GET: AspNetGroupUsers/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(id); if (aspNetGroupUser == null) { return(HttpNotFound()); } return(View(aspNetGroupUser)); }
public BaseResponse <AspNetGroupUser> AddGroupForUser(ComplexGroupUser model) { var response = new BaseResponse <AspNetGroupUser>(); AspNetGroupUser groupUser = new AspNetGroupUser(); AspNetUserRole userRole; try { groupUser.UserId = model.UserId; groupUser.GroupId = model.GroupId; response.Value = _groupUsersRepository.Add(groupUser); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetGroupUser", response.Value.UserId + '-' + response.Value.GroupId, "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } IEnumerable <AspNetGroupRole> listRoleOfGroup = _aspNetGroupRolesRepository.GetAll().Where(n => n.GroupId == model.GroupId); if (listRoleOfGroup.Count() > 0) { foreach (var item in listRoleOfGroup) { IEnumerable <AspNetUserRole> listUserRole = _aspNetUserRolesRepository.GetAll().Where(n => n.RoleId == item.RoleId && n.UserId == model.UserId); if (listUserRole.Count() == 0) { userRole = new AspNetUserRole(); userRole.RoleId = item.RoleId; userRole.UserId = model.UserId; userRole.Grant = true; AddUserRole(userRole); try { _applicationLoggingRepository.Log("EVENT", "CREATE", "AspNetUserRole", userRole.UserId + '-' + userRole.RoleId, "", "", model, "", System.Web.HttpContext.Current.Request.UserHostAddress, model.CreatedBy); } catch { } } } } } catch (Exception ex) { response.IsSuccess = false; response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace; } return(response); }
public ActionResult DeleteConfirmed(int groupId, string username) { string userId; string queryString = "SELECT dbo.AspNetUsers.Id " + "FROM dbo.AspNetUsers " + "WHERE dbo.AspNetUsers.UserName='******'"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); reader.Read(); userId = reader.GetString(0); reader.Close(); } AspNetGroupUser aspNetGroupUser = db.AspNetGroupUsers.Find(groupId, userId); db.AspNetGroupUsers.Remove(aspNetGroupUser); db.SaveChanges(); return(RedirectToAction("../Groups/Index")); }
public ActionResult Create([Bind(Include = "GroupId,UserId,GroupName,StatusMessage")] AspNetGroup aspNetGroup) { if (ModelState.IsValid) { aspNetGroup.UserId = User.Identity.GetUserId(); db.AspNetGroups.Add(aspNetGroup); db.SaveChanges(); AspNetGroupUser gu = new AspNetGroupUser { GroupId = aspNetGroup.GroupId, UserId = User.Identity.GetUserId(), }; db.AspNetGroupUsers.Add(gu); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetGroup)); }