/// <summary> /// Get access group base on user inside it from DB /// </summary> /// <returns>one group access object</returns> public static GroupAccess GetAccessGroupByUser(string userId) { GroupAccess groupAccesses = null; DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessUQuery("Q", "", userId); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["groupAccessId"].ToString(); groupAccesses = GroupAccess.GetAccessGroupById(Id); } return(groupAccesses); } catch (Exception ex) { return(groupAccesses); } }
/// <summary> /// Get user inside access group /// </summary> /// <param name="groupId">ID of access group id include user</param> /// <returns>List of user insider access group</returns> public static List <Users> LoadUsersByACGroup(string groupId) { List <Users> users = new List <Users>(); DataTable dt = null; try { ServiceReference1.WSACUSoapClient client = new ServiceReference1.WSACUSoapClient(); DataSet ds = client.GroupAccessUQuery("Q", groupId, ""); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string Id = dr["userId"].ToString(); Users u = Users.LoadUsersById(Id); users.Add(u); } return(users); } catch (Exception ex) { return(null); } }