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