public PermissionByUserIdModelList SelectPermisionByUserId(UserRequestIdModel userId)
{
// userRepository ดึงข้อมูล role id, role name โดย ส่ง user id ไปหา ต้อง join กับ table role ด้วยนะ
RoleModel roldInfo = _userRepository.SelectRoleIdByUserId(userId);
RoleByIdModel roleByIdModel = new RoleByIdModel();
roleByIdModel.roleId = roldInfo.id;
// roleByIdModel.roleId = 1;
// roleRepository ดึงข้อมูล permision โดยส่ง role id
List <int> rolePermission = _rolesRepository.SelectRolePermissionByRoleId(roleByIdModel);
PermissionModelList permission = _rolesRepository.SelectPermissionAll();
PermissionByUserIdModelList result = new PermissionByUserIdModelList();
// result.role = "Admin";
result.role = roldInfo.role;
result.permissions = new List <PermissionModel>();
foreach (PermissionModel item in permission.Permissiontable)
{
result.permissions.Add(
new PermissionModel()
{
permissionId = item.permissionId, //PermisdionTbl
permissionName = item.permissionName, //PermisdionTbl
permissionCheck = rolePermission.IndexOf(item.permissionId) >= 0 ? true : false
}
);
}
return(result);
}
public PermissionModelList SelectPermissionAll()
{
var cs = "Server=localhost\\SQLEXPRESS;Database=HospitalDB;Trusted_Connection=True;";
using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database
con.Open();
string sql = "SELECT Id, Permission FROM PermissionTbl";
using var cmd = new SqlCommand(sql, con); //Using Class SqlCommand for query data
using SqlDataReader rdr = cmd.ExecuteReader();
PermissionModelList output = new PermissionModelList();
output.Permissiontable = new List <PermissionModel>();
while (rdr.Read())
{
output.Permissiontable.Add(
new PermissionModel()
{
permissionId = rdr.GetInt32(0),
permissionName = rdr.GetString(1),
permissionCheck = false
}
);
}
return(output);
}
public PermissionByIdModelList SelectPermissionsById(RoleByIdModel requestId)
{
List <int> rolePermission = _rolesRepository.SelectRolePermissionByRoleId(requestId);
PermissionModelList permission = _rolesRepository.SelectPermissionAll();
PermissionByIdModelList result = new PermissionByIdModelList();
result.PermissionIdList = new List <PermissionModel>();
foreach (PermissionModel item in permission.Permissiontable)
{
result.PermissionIdList.Add(
new PermissionModel()
{
permissionId = item.permissionId, //PermisdionTbl
permissionName = item.permissionName, //PermisdionTbl
permissionCheck = rolePermission.IndexOf(item.permissionId) >= 0 ? true : false
//Search PermissionId(PermissionTbl) on RolePermisdion(RolePermissionTbl)
}
);
}
return(result);
}
public PermissionModelList GetPermissionList()
{
PermissionModelList result = _rolesService.SelectPermissions();
return(result);
}
public PermissionModelList SelectPermissions()
{
PermissionModelList result = _rolesRepository.SelectPermissionAll();
return(result);
}
