public async Task Create(int warId, ContestantRequest c)
{
using (var connection = await CreateOpenConnection())
using (var command = CreateInsertCommand(warId, connection, c))
{
await command.ExecuteScalarAsync();
}
}
private static bool IsTheSame(Contestant contestant, ContestantRequest request)
{
return(ContainsAllElementsOf(contestant.Definition, request.Definition) && ContainsAllElementsOf(request.Definition, contestant.Definition));
}
private static SqlCommand CreateInsertCommand(int warId, SqlConnection connection, ContestantRequest request)
{
var command = connection.CreateCommand();
command.CommandText = "INSERT INTO [dbo].[Contestants] ([Id], [WarId], [Definition]) VALUES (NEWID(), @WarId, @Definition);";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@WarId", warId);
AddDefinitionParameter(command, request.Definition);
return(command);
}
