public static IEnumerable <UserGroupUser> Map(IRepository <eSuiteDbContext> repository, SqlDataReader dr) { var ret = new List <UserGroupUser>(); var userId = LookUpUser(repository, Convert.ToString(dr["U_Login_Id"])); var uguESmat = new UserGroupUser(); uguESmat.UserId = userId; uguESmat.ApplicationUserGroupId = LookUpApplicationUserGroup(repository, "eSmat", Convert.ToString(dr["UT_User_Type"])); if (uguESmat.UserId != default(int) && uguESmat.ApplicationUserGroupId != default(int)) { ret.Add(uguESmat); } var uguESuite = new UserGroupUser(); uguESuite.UserId = userId; uguESuite.ApplicationUserGroupId = LookUpApplicationUserGroup(repository, "eSuite", "User"); if (uguESuite.UserId != default(int) && uguESuite.ApplicationUserGroupId != default(int)) { ret.Add(uguESuite); } var uguEAction = new UserGroupUser(); uguEAction.UserId = userId; uguEAction.ApplicationUserGroupId = LookUpApplicationUserGroup(repository, "eAction", Convert.ToString(dr["UT_User_Type"]).Replace("SMAT Leader", "Action Leader")); if (uguEAction.UserId != default(int) && uguEAction.ApplicationUserGroupId != default(int)) { ret.Add(uguEAction); } return(ret); }
//Thêm người dùng vào nhóm public bool InsertUserToGroup(string pUserName, string pIdGroup) { try { dc = new DbSpaDataContext(); var query = from us in dc.UserGroupUsers where us.USERNAME == pUserName && us.IDGROUPUSER.Equals(pIdGroup) select us; if (query != null) { UserGroupUser us = new UserGroupUser(); us.USERNAME = pUserName; us.IDGROUPUSER = Convert.ToInt32(pIdGroup); us.STATUS = 1; dc.UserGroupUsers.InsertOnSubmit(us); dc.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
public void AddUserToGroup(UserAccount user, UserGroup group) { var userGroupUser = new UserGroupUser { Group = group, User = user, Permissions = 0 }; group.Users.Add(userGroupUser); Commit(); }
//Xóa người dùng khỏi nhóm public bool DeleteUserOutGroup(string pUserName, string pIdGroup) { try { dc = new DbSpaDataContext(); UserGroupUser user = dc.UserGroupUsers.Where(t => t.USERNAME == pUserName && t.IDGROUPUSER == Convert.ToInt32(pIdGroup)).FirstOrDefault(); dc.UserGroupUsers.DeleteOnSubmit(user); dc.SubmitChanges(); return(true); } catch { return(false); } }
public UserGroup CreateAndAddNewGroup(string name, UserAccount admin) { var userGroup = new UserGroup { Name = name }; var userGroupUser = new UserGroupUser { Group = userGroup, User = admin, Permissions = 1 }; userGroup.Users.Add(userGroupUser); Add(userGroup); Commit(); return(userGroup); }
// Test version until A/D available public void AddUserToGroup(string groupName, UserModel user) { var group = db.FindUserGroup(groupName); if (group == null) { group = new UserGroup { GroupName = groupName, Enabled = true }; db.InsertOrUpdateUserGroup(group); } var groupUser = db.FindUserGroupUser(group.Id, user.Id); if (groupUser == null) { groupUser = new UserGroupUser { UserGroup = group, User = db.FindUser(user.Id) }; db.InsertOrUpdateUserGroupUser(groupUser); } }
public static void AddTransaction(BizPortalSessionContext context, int functionId, int pageId, UserGroupUser uguTarget, User u, ref string message, ref int warningCount) { string functionName = ""; string lange = context.CurrentLanguage.Code; using (ITransaction tx = context.PersistenceSession.BeginTransaction()) { try { if (IsExisting(uguTarget.Group.GroupUsers, u, ref message)) { warningCount++; } if (warningCount == 0) { MaintenanceWorkflow fw = GetFunctionMaintenanceWorkflow(context.User, functionId); functionName = Messages.UserGroupUser.AddUserGroupUser.Format(lange, uguTarget.User.LoginName, uguTarget.Group.Title); if (fw.MemberFunction == null) { warningCount++; message = Messages.Genaral.IsNotMemberFunction.Format(context.CurrentLanguage.Code); } BizPortalFunction function = fw.MemberFunction.Function; AddMemberGroupUserTransaction transactionMember = new AddMemberGroupUserTransaction(context, fw, DateTime.Now, context.Member, uguTarget); transactionMember.Transit(context, fw, functionName, TransitionEventCode.SubmitEvent); transactionMember.Persist(context); tx.Commit(); message = String.Format("{0} <br/>", Messages.Genaral.TransactionSubmitedForPendingApproval.Format(lange, functionName)); context.Log(functionId, pageId, 0, ActionLog.BankAdminFunction.AddMemberGroupUser, functionName); } } catch (Exception ex) { tx.Rollback(); warningCount++; context.Log((int)functionId, pageId, 0, ActionLog.BankAdminFunction.AddMemberGroupUser , IBankException.LogMessageProgramError(ex, ExceptionMessages.AddTransactionUserGroupUserError_Role.Code + "-" + functionName + message)); message = ExceptionMessages.AddTransactionUserGroupUserError_Role.Message; } } }
public static void AddTransactionClient(BizPortalSessionContext context, Member member, int functionId, UserGroupUser uguTarget, User u, ref string message, ref int warningCount) { string functionName = ""; string lange = context.CurrentLanguage.Code; using (ITransaction tx = context.PersistenceSession.BeginTransaction()) { try { if (uguTarget.IsNotFinalized) { warningCount++; message = Messages.Genaral.TransactionApproved.Format(lange); } if (IsExisting(uguTarget.Group.GroupUsers, u, ref message)) { warningCount++; } if (warningCount == 0) { MaintenanceWorkflow fw = GetFunctionMaintenanceWorkflow(context.User, functionId); functionName = Messages.UserGroupUser.AddUserGroupUser.Format(lange, uguTarget.User.LoginName, uguTarget.Group.Title); if (fw.MemberFunction == null) { warningCount++; message = Messages.Genaral.IsNotMemberFunction.Format(context.CurrentLanguage.Code); } else { BizPortalFunction function = fw.MemberFunction.Function; AddMemberGroupUserTransaction transactionMember = new AddMemberGroupUserTransaction(context, fw, DateTime.Now, member, uguTarget); transactionMember.Transit(context, fw, functionName, TransitionEventCode.SubmitEvent); transactionMember.Persist(context); tx.Commit(); message = String.Format("- {0} {1} {2} <br/>", functionName, Messages.Genaral.Success.Format(lange), Messages.Genaral.PendingApproval.Format(lange)); context.Log(functionId, 0, 0, ActionLog.BankAdminFunction.AddMemberGroupUser, functionName); } } } catch (Exception) { tx.Rollback(); warningCount++; context.Log((int)functionId, 0, 0, ActionLog.BankAdminFunction.AddMemberGroupUser, functionName + message); //context.Log((int)functionId, 0, 0, Messages.UserGroupUser.AddUserGroupUser.Format(lange, "", ""), // functionName + message); } } }