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()); }