public async Task <IActionResult> UpdateRelationshipStatus(UpdateDropDownFieldModel dropDownField)
{
using var connection = new MySqlConnection(AppConfig.Constants.DbConnectionString);
using var command = connection.CreateCommand();
command.CommandText = BuildPatchDropDownListCommand("relationship_statuses", "status", "relationship_status", dropDownField.RelationshipStatus);
connection.Open();
await command.ExecuteNonQueryAsync();
return(ResponseModel.OK.ToResult());
}
public async Task <IActionResult> UpdateAttitudeToSmoking(UpdateDropDownFieldModel dropDownField)
{
using var connection = new MySqlConnection(AppConfig.Constants.DbConnectionString);
using var command = connection.CreateCommand();
command.CommandText = BuildPatchDropDownListCommand("attitudes", "attitude", "attitude_to_smoking", dropDownField.AttitudeToSmoking);
connection.Open();
await command.ExecuteNonQueryAsync();
return(ResponseModel.OK.ToResult());
}
public async Task <IActionResult> UpdateSexPreference(UpdateDropDownFieldModel dropDownField)
{
using var connection = new MySqlConnection(AppConfig.Constants.DbConnectionString);
using var command = connection.CreateCommand();
command.CommandText = BuildPatchDropDownListCommand("sexes", "sex", "sex_preference", dropDownField.SexPreference);
connection.Open();
await command.ExecuteNonQueryAsync();
return(ResponseModel.OK.ToResult());
}
