public async Task <UserResponseModel> GetUserById(int userId)
{
UserResponseModel user = null;
using (MySqlConnection conn = new MySqlConnection(_configuration["Database:ConnectionString"]))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_user_by_id", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("userId", userId);
using (var reader = await cmd.ExecuteReaderAsync())
{
user = UserServiceMapper.ToUser(reader);
}
}
return(user);
}
