/// <summary> /// 取得所有使用者清單列表 /// </summary> /// <returns></returns> public IEnumerable <Infrastructure.ValueObject.AuthMember> GetAllMemberList() { var db = _uow.DbContext; var result = new List <Infrastructure.ValueObject.AuthMember>(); //取得所有使用者清單 var sqlMemberList = db.Members.ToList(); foreach (var _item in sqlMemberList) { var resAuthMember = new Infrastructure.ValueObject.AuthMember(); resAuthMember.AccountId = _item.Id; resAuthMember.AccountName = _item.Name; resAuthMember.Account = _item.Account; result.Add(resAuthMember); } return(result); }
/// <summary> /// 取得學習圈成員 - 以使用者為主 [使用者內包角色] /// </summary> /// <param name="learningId"></param> /// <returns></returns> public IEnumerable <Infrastructure.ValueObject.AuthMember> GetMemberList(int learningId) { var result = new List <Infrastructure.ValueObject.AuthMember>(); var db = _uow.DbContext; var query = from lr in db.LearningRole join cmr in db.CircleMemberRoleplay on lr.Id equals cmr.RoleId join m in db.Members on cmr.MemberId equals m.Id where lr.LearningId.Equals(learningId) group m.Id by m into g select g; foreach (var _item in query) { var resMemberInfo = new Infrastructure.ValueObject.AuthMember(); resMemberInfo.Account = _item.Key.Account; resMemberInfo.AccountId = _item.Key.Id; resMemberInfo.AccountName = _item.Key.Name; resMemberInfo.Picture = _item.Key.Photo; result.Add(resMemberInfo); } return(result); }