private string getInterestsJson(LockedModeUser user)
{
InterestsModel model = new InterestsModel();
List <string> result = new List <string>();
foreach (var property in model.GetType().GetProperties())
{
if (user.GetType().GetProperty(property.Name).GetValue(user, null).ToString() == "1")
{
result.Add(property.Name);
}
}
if (result.Count == 0)
{
return("[]");
}
return("[\"" + string.Join <string>("\",\"", result) + "\"]");
}
public async Task <IActionResult> UpdateInterestsAsync(InterestsModel interests)
{
using var connection = new MySqlConnection(AppConfig.Constants.DbConnectionString);
using var command = new MySqlCommand("AddInterestsList", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddRange(new[]
{
new MySqlParameter("user_id", MyId),
new MySqlParameter("interests", string.Join(',', interests.Interests))
});
connection.Open();
await command.ExecuteNonQueryAsync();
return(ResponseModel.OK.ToResult());
}
