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