/// <summary> /// get all phan quyen tai khoan /// </summary> /// <returns> /// userID: mã user /// UserName: tên user /// MaPhanQuyen: mã phân quyền /// PhanQuyen: tên phân quyền /// TrangThai: trạng thái tài khoản /// </returns> public List <crudPhanQuyen> GetPhanQuyenTaiKhoan() { try { var lst = from usr in _db.TaiKhoanQuanLies join pq in _db.PhanQuyens on usr.MaPhanQuyen equals pq.RoleID select new { usr.UsrID, usr.UserName, pq.RoleID, pq.TenPhanQuyen, usr.TrangThai }; var result = new List <crudPhanQuyen>(); foreach (var i in lst) { var item = new crudPhanQuyen() { userID = i.UsrID, UserName = i.UserName, MaPhanQuyen = i.RoleID, PhanQuyen = i.TenPhanQuyen, TrangThai = (bool)i.TrangThai }; result.Add(item); } return(result); } catch (Exception e) { bs_EventLog.EventLog("Connection", "bs - GetPhanQuyenTaiKhoan", "NghiaBui", e.Message, e.StackTrace); } return(null); }
/// <summary> /// Get phân quyền tài khoản id theo id /// </summary> /// <param name="roleID"></param> /// <returns></returns> public crudPhanQuyen GetPhanQuyenTKTheoID(int roleID = 0) { try { var obj = (from usr in _db.TaiKhoanQuanLies join pq in _db.PhanQuyens on usr.MaPhanQuyen equals pq.RoleID select new { usr.UsrID, usr.UserName, pq.RoleID, pq.TenPhanQuyen, usr.TrangThai }).FirstOrDefault(); var result = new crudPhanQuyen() { userID = obj.UsrID, UserName = obj.UserName, MaPhanQuyen = obj.RoleID, PhanQuyen = obj.TenPhanQuyen, TrangThai = (bool)obj.TrangThai }; return(result); } catch (Exception e) { bs_EventLog.EventLog("Connection", "Role", "NghiaBui", e.Message, e.StackTrace); } return(null); }