/// <summary> /// 取得非管理員角色 /// </summary> /// <param name="learningId"></param> /// <returns></returns> public Infrastructure.BusinessObject.LearningRole GetLearningNormalRoleList(int learningId) { var result = new Infrastructure.BusinessObject.LearningRole(); result.RoleInfo = new List <Infrastructure.Entity.LearningRole>(); var db = _uow.DbContext; var query = from lr in db.LearningRole join lc in db.LearningCircle on lr.LearningId equals lc.Id where lc.Id.Equals(learningId) && !(lr.IsAdminRole.Equals(true) && lr.Enable.Equals(true)) select lr; foreach (var _item in query) { //取得角色 var resCourseRole = db.LearningRole.Find(_item.Id); if (resCourseRole != null) { //取得某個學習圈的角色 if (resCourseRole.LearningId.Equals(learningId)) { result.RoleInfo.Add(resCourseRole); } } } return(result); }
/// <summary> /// 取得某個使用者在某個學習圈的角色 /// </summary> /// <param name="memberId">要查詢的使用者代碼</param> /// <param name="learningId">學習圈代碼</param> /// <returns></returns> public Infrastructure.BusinessObject.LearningRole GetLearningMemberRole(int memberId, int learningId) { var result = new Infrastructure.BusinessObject.LearningRole(); result.RoleInfo = new List <Infrastructure.Entity.LearningRole>(); var db = _uow.DbContext; var sqlSectionRole = db.CircleMemberRoleplay.Where(t => t.MemberId.Equals(memberId)); foreach (var _resitem in sqlSectionRole) { //取得角色 var resCourseRole = db.LearningRole.Find(_resitem.RoleId); if (resCourseRole != null) { //取得某個學習圈的角色 if (resCourseRole.LearningId.Equals(learningId)) { resCourseRole.Enable = _resitem.Enable; result.RoleInfo.Add(resCourseRole); } } } return(result); }