/// <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);
}
