private List <User> ReadUsers(IDataReader reader)
{
var result = new List <User>();
var houseDA = new HouseDataAdapter();
var roleDA = new RoleDataAdapter();
while (reader.Read())
{
var user = new User
{
Id = reader["Id"].ToString(),
Email = reader["Email"]?.ToString() ?? "",
Phone = reader["Phone"]?.ToString() ?? "",
Password = reader["Password"].ToString(),
Username = reader["Username"].ToString(),
Role = new Role
{
Id = reader["RoleId"].ToString(),
},
Status = reader["Status"]?.ToString() ?? "",
House = new House
{
Id = reader["HouseId"].ToString()
}
};
if (reader["HouseId"] != null && !string.IsNullOrEmpty(reader["HouseId"].ToString()))
{
user.House = houseDA.GetById(user.House.Id);
}
user.Role = roleDA.GetById(user.Role.Id);
result.Add(user);
}
return(result);
}
private List <RoleObjectPermission> Read(IDataReader reader)
{
var list = new List <RoleObjectPermission>();
var roleDA = new RoleDataAdapter();
while (reader.Read())
{
var item = new RoleObjectPermission
{
Id = reader["Id"].ToString(),
Role = new Role
{
Id = reader["RoleId"].ToString()
},
ObjectType = reader["ObjectType"].ToString(),
ObjectId = reader["ObjectId"]?.ToString(),
Permission = (PermissionEnum)Convert.ToInt32(reader["Permission"])
};
item.Role = roleDA.GetById(item.Role.Id);
list.Add(item);
}
return(list);
}
