/// <summary> /// thêm matchType /// </summary> private void GroupUser_Add() { try { Group_User creGroup_User = new Group_User(); creGroup_User.Owner = Window.GetWindow(this); creGroup_User.ShowDialog(); if (creGroup_User.c_createOk == 1) { LoadData(); for (int i = 0; i < arrAllGroupUser.Count; i++) { GroupUserInfo ui = (GroupUserInfo)arrAllGroupUser[i]; if (ui.Id == c_IdInsert) { rowselect = i; c_IdInsert = 0; break; } } DataGridHelper.NVSFocus(dgrGroupUser, rowselect, 1); creGroup_User.c_createOk = 0; } } catch (Exception ex) { CommonData.log.Error(ex.ToString()); } }
public async Task <IActionResult> Edit(int id, [Bind("Id,GroupId,UserId")] Group_User group_User) { if (id != group_User.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(group_User); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Group_UserExists(group_User.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["GroupId"] = new SelectList(_context.Group, "GroupId", "GroupName", group_User.GroupId); ViewData["UserId"] = new SelectList(_context.Users, "Id", "UserName", group_User.UserId); return(View(group_User)); }
//Functions public Result <GroupServiceModel> Add(GroupServiceModel group, int userId) { var result = new Result <GroupServiceModel>(); //initialize transaction var transaction = _unitOfWork.BeginTransaction(); try { //No mapping. Because system properties shouldn't be null. var newGroup = new Group() { Name = group.Name, IsActive = true, MediaId = group.MediaId, CreatedOn = Application.CurrentDate, CreatedBy = userId, UpdatedOn = Application.CurrentDate, UpdatedBy = userId }; _unitOfWork.GroupRepository.Add(newGroup); _unitOfWork.Save(); var newGroupUser = new Group_User() { GroupId = newGroup.Id, UserId = userId, IsActive = true }; _unitOfWork.GroupUserRepository.Add(newGroupUser); _unitOfWork.Save(); //commit transaction transaction.commit(); //return mapped new group var mappedNewGroup = _mapper.Map <GroupServiceModel>(newGroup); result.IsSuccess = true; result.Data = mappedNewGroup; return(result); } catch (Exception ex) { //rollback transaction transaction.Rollback(); _logger.LogError(ex.InnerException.Message); result.IsSuccess = false; result.ErrorMessage = ErrorMessage.Add; return(result); } }
/// <summary> /// Created By : sangeee /// Created On : 07 Aug 2018 /// Description : Delete an User from a Group /// </summary> /// <param name="group_User"></param> /// <returns></returns> public bool DeleteUserFromGroup(Group_User group_User) { try { Group_User _resourceExistDb = _unitOfWork.Group_UserRepository.GetSingle(x => x.GroupId == group_User.GroupId && x.UserId == group_User.UserId); if (_resourceExistDb == null) { return(false); } _unitOfWork.Group_UserRepository.DeleteWhere(x => x.UserId == group_User.UserId && x.GroupId == group_User.GroupId); _unitOfWork.Commit(); return(true); } catch (Exception ex) { return(false); } }
public void SaveGroupUser([FromBody] List <Object> listUserGroup, string CodeGroup) { int a = listUserGroup.Count; string list = ";"; #region add user group for (int i = 0; i < a; i++) { UserProfile result = JsonConvert.DeserializeObject <UserProfile>(listUserGroup[i].ToString()); var dt = db.Group_User.Where(t => t.UserName == result.UserName && t.CodeGroup == CodeGroup).FirstOrDefault(); if (dt == null) { dt = new Group_User(); dt.FCode = System.Guid.NewGuid().ToString(); dt.FCreateTime = System.DateTime.Now; dt.FUpdateTime = System.DateTime.Now; dt.FUserCreate = RequestContext.Principal.Identity.Name; dt.CodeGroup = CodeGroup; dt.UserName = result.UserName; // dt.FBranchCode = result.FBranchCode; dt.FInUse = true; db.Group_User.Add(dt); db.SaveChanges(); } else { dt.FInUse = true; db.SaveChanges(); } list += result.UserName + ";"; } #endregion #region xóa những user tồn tại trong group nhưng không có trong list add group ở trên var User = db.Group_User.Where(t => t.CodeGroup == CodeGroup && t.FInUse == true).ToList(); //if (list != ";") //{ foreach (var it in User) { if (!list.Contains(";" + it.UserName + ";")) { it.FInUse = false; db.SaveChanges(); } } //} #endregion }
public void CreateGroup_User(string[] listUser, string groupName) { if (listUser != null) { string myUserId = Context.User.Identity.Name; // tạo group phải có mình trong đó string groupnameDefault = ""; string NameFirstsend = ""; foreach (var item in listUser) { groupnameDefault += item + "|"; NameFirstsend += item + "|"; } groupnameDefault += myUserId; Group group = new Group(); group.GroupName = string.IsNullOrWhiteSpace(groupName) ? groupnameDefault : groupName; group.GroupType = "G"; db.Groups.Add(group); foreach (var item in listUser) { Group_User userGroup = new Group_User(); userGroup.GroupId = group.GroupId; userGroup.UserOfGroup = db.UserLogins.FirstOrDefault(ul => ul.UserNameCopy == item).Id; db.Group_User.Add(userGroup); } Group_User myGroup = new Group_User(); myGroup.GroupId = group.GroupId; myGroup.UserOfGroup = db.UserLogins.FirstOrDefault(ul => ul.UserNameCopy == myUserId).Id; db.Group_User.Add(myGroup); try { db.SaveChanges(); } catch (Exception) { throw; } SendPrivateMessage(group.GroupId.ToString(), myUserId + " Đã thêm " + NameFirstsend + " vào nhóm "); } }
public async Task <IActionResult> Create([Bind("GroupId,UserId")] Group_User group_User) { var GroupId = group_User.GroupId; var check = from gu in _context.Group_User where gu.GroupId == group_User.GroupId && gu.UserId == group_User.UserId select gu; if (ModelState.IsValid && check.Count() == 0) { _context.Add(group_User); await _context.SaveChangesAsync(); return(RedirectToAction("User", "Groups", new { id = GroupId })); } return(RedirectToAction("User", "Groups", new { id = GroupId })); }
public void SaveGroupByUser(string CodeGroup, string user) { var check = db.Group_User.Where(t => t.UserName == user).ToList(); if (check.Any()) { db.Group_User.RemoveRange(check); db.SaveChanges(); } var model = JsonConvert.DeserializeObject <List <string> >(CodeGroup); var ListGroup = ";"; foreach (var item in model) { if (item != "") { var dt = db.Group_User.Where(t => t.UserName == user && t.CodeGroup == item).FirstOrDefault(); if (dt != null) { dt.FInUse = true; db.SaveChanges(); } else { dt = new Group_User(); dt.FCode = Guid.NewGuid().ToString(); dt.UserName = user; dt.CodeGroup = item; db.Group_User.Add(dt); db.SaveChanges(); } ListGroup += item + ";"; } } var DelGroup = db.Group_User.Where(t => t.UserName == user && t.CodeGroup != Commons.Constants.SUPPERADMIN).ToList(); foreach (var i in DelGroup) { if (!ListGroup.Contains(i.CodeGroup)) { i.FInUse = false; db.SaveChanges(); } } }
/// <summary> /// CreatedBy : sangeee /// CreatedOn : 07 Aug 2018 /// Description : Add new User to Group /// </summary> /// <param name="group_User"></param> /// <returns></returns> public bool AddUserToGroup(Group_User group_User) { try { Group_User _resourceExistDb = _unitOfWork.Group_UserRepository.GetSingle(x => x.GroupId == group_User.GroupId && x.UserId == group_User.UserId); if (_resourceExistDb == null) { _unitOfWork.Group_UserRepository.Add(group_User); } else { _unitOfWork.Group_UserRepository.Update(group_User); } _unitOfWork.Commit(); return(true); } catch (Exception ex) { return(false); } }
public IActionResult DeleteUserFromGroup([FromBody] Group_User group_User) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } bool status = GroupModel.DeleteUserFromGroup(group_User); if (status) { return(Ok()); } else { return(new NotFoundResult()); } } catch (Exception ex) { return(BadRequest(ex)); } }
private string getAllSalesMenIDs() { string salesMenIDs = ""; try { Group gp = new Group(); gp.Where.Active.Value = 1; gp.Where.Name.Value = "SalesMen"; gp.Query.Load(); if (gp.RowCount > 0) { Group_User gpUser = new Group_User(); gpUser.Where.Active.Value = 1; gpUser.Where.GroupID.Value = gp.ID; if (gpUser.Query.Load()) { if (gpUser.DefaultView != null && gpUser.DefaultView.Count > 0) { do { if (salesMenIDs == "") { salesMenIDs = "'" + gpUser.UserID + "'"; } else { salesMenIDs += ",'" + gpUser.UserID + "'"; } } while (gpUser.MoveNext()); } } } } catch (Exception ex) { //Logger.LogException(ex); } return(salesMenIDs); }
private string getUserGroup() { string groupName = ""; Group_User gpUser = new Group_User(); gpUser.Where.UserID.Value = UserID; gpUser.Where.Active.Value = true; gpUser.Query.AddOrderBy(Group_User.ColumnNames.GroupID, WhereParameter.Dir.ASC); gpUser.Query.Load(); if (gpUser.RowCount > 0) { gpUser.Rewind(); Group gp = new Group(); if (gp.LoadByPrimaryKey(gpUser.GroupID)) { if (gp.Active) { groupName = gp.Name.Trim(); } } } return(groupName); }
private string getMyTaskIDs() { string taskIDs = ""; Dictionary <long, bool> taskIDDict = new Dictionary <long, bool>(); TaskPermission taskPerm = new TaskPermission(); taskPerm.Where.UserGroupID.Value = UserID; taskPerm.Where.IsGroup.Value = false; if (taskPerm.Query.Load()) { if (taskPerm.DefaultView != null && taskPerm.DefaultView.Count > 0) { do { if (taskIDs == "") { if (!taskIDDict.ContainsKey(taskPerm.TaskID)) { taskIDDict.Add(taskPerm.TaskID, true); taskIDs = "'" + taskPerm.TaskID + "'"; } } else { if (!taskIDDict.ContainsKey(taskPerm.TaskID)) { taskIDDict.Add(taskPerm.TaskID, true); taskIDs += ",'" + taskPerm.TaskID + "'"; } } } while (taskPerm.MoveNext()); } } string gpIDs = ""; Group_User gpUser = new Group_User(); gpUser.Where.Active.Value = true; gpUser.Where.UserID.Value = UserID; if (gpUser.Query.Load()) { if (gpUser.DefaultView != null && gpUser.DefaultView.Count > 0) { do { if (gpIDs == "") { gpIDs = "'" + gpUser.GroupID + "'"; } else { gpIDs += ",'" + gpUser.GroupID + "'"; } } while (gpUser.MoveNext()); } } if (gpIDs != "") { TaskPermission gpTasks = new TaskPermission(); gpTasks.Where.UserGroupID.Value = gpIDs; gpTasks.Where.UserGroupID.Operator = WhereParameter.Operand.In; gpTasks.Where.IsGroup.Value = true; if (gpTasks.Query.Load()) { if (gpTasks.DefaultView != null && gpTasks.DefaultView.Count > 0) { do { if (taskIDs == "") { if (!taskIDDict.ContainsKey(gpTasks.TaskID)) { taskIDDict.Add(gpTasks.TaskID, true); taskIDs = "'" + gpTasks.TaskID + "'"; } } else { if (!taskIDDict.ContainsKey(gpTasks.TaskID)) { taskIDDict.Add(gpTasks.TaskID, true); taskIDs += ",'" + gpTasks.TaskID + "'"; } } } while (gpTasks.MoveNext()); } } } return(taskIDs); }