public IActionResult GetMyRoomees([FromRoute][Required] int roomId, [FromHeader][Required] string token)
{
if (!Authentication.IsTokenValid(token))
{
return(Problem("token is not valid"));
}
List <int> roomUserIds = new List <int>();
List <Dictionary <string, string> > roomUserPreferences = new List <Dictionary <string, string> >();
using (SqlConnection conn = new SqlConnection(Startup.ConnectionString)) {
conn.Open();
SqlCommand command = new SqlCommand(@"SELECT * FROM [RoomAssignment] WHERE (RoomId = @roomId) AND (StatusId = @statusId);", conn);
command.Parameters.AddWithValue("@roomId", roomId);
command.Parameters.AddWithValue("@statusId", 1);
using (SqlDataReader reader = command.ExecuteReader()) {
if (reader.HasRows)
{
while (reader.Read())
{
roomUserIds.Add(reader.GetInt32(1));
}
}
else
{
return(Problem("No roomees found"));
}
}
}
foreach (int userId in roomUserIds)
{
UserPreferences user = UserPreferences.FromUserId(userId);
if (user == null)
{
return(Problem("problem fetching roomees"));
}
Dictionary <string, string> userAndPrefs = new Dictionary <string, string>();
userAndPrefs.Add("userId", userId.ToString());
userAndPrefs.Add("userStatus", UserPreferences.FromUserId(userId).UserStatus);
roomUserPreferences.Add(userAndPrefs);
}
return(Ok(JsonConvert.SerializeObject(roomUserPreferences, Formatting.Indented)));
}