public void GetUsersByGroup(int groupId, int entId = -1) { LoginIDs.Clear(); LoginIDs.Add(new SelectListItem { Value = "", Text = "" }); List <uas_User> users = null; using (var context = DataContext.getUasDbContext()) { if (groupId != -1) { List <int> userIdsForUserGroup = context.uas_GroupUserAppPermissions.Where(g => g.uas_Group.GroupID == groupId && g.StatusFlag == "A") .Select(g => g.UserID).ToList(); users = context.uas_User.Where(u => userIdsForUserGroup.Contains(u.UserID) && u.StatusFlag == "A").Select(u => u).ToList(); } else { if (entId == -1) { users = context.uas_User.Where(u => u.EnterpriseID == SessionHelper.LoginStatus.EnterpriseID && u.StatusFlag == "A").Select(u => u).ToList(); } else { users = context.uas_User.Where(u => u.EnterpriseID == entId && u.StatusFlag == "A").Select(u => u).ToList(); } } foreach (uas_User user in users) { LoginIDs.Add(new SelectListItem { Value = user.UserID.ToString(), Text = user.UserName }); } } }
public void GetUsers(int enterpriseId) { LoginIDs.Clear(); using (var context = DataContext.getUasDbContext()) { List <uas_User> users = context.uas_User.Where(u => u.StatusFlag == "A" && u.EnterpriseID == enterpriseId).Select(u => u).ToList(); LoginIDs.Add(new SelectListItem { Value = "", Text = "" }); foreach (uas_User user in users) { LoginIDs.Add(new SelectListItem { Value = user.UserID.ToString(), Text = user.UserName }); } } }