public void Add(Election t)
{
IDbCommand command = _connector.CreateCommand();
command.CommandText = "INSERT INTO [Verkiezing] ([Naam], [AantalZetels]) VALUES (@name, @seats);";
command.AddParameterWithValue("name", t.Name);
command.AddParameterWithValue("seats", t.Seats);
_connector.ExecuteNonQuery(command);
}
public void Add(Party t)
{
IDbCommand command = _connector.CreateCommand();
command.CommandText = "INSERT INTO [Partij] ([Naam], [Lijsttrekker], [AantalLeden]) VALUES (@name, @partyleader, @members);";
command.AddParameterWithValue("name", t.Name);
command.AddParameterWithValue("primeminister", t.PartyLeader);
command.AddParameterWithValue("members", t.AmountOfMembers);
_connector.ExecuteNonQuery(command);
}
public void Add(Results t)
{
IDbCommand command = _connector.CreateCommand();
command.CommandText = "INSERT INTO [Uitslag] ([VerkiezingID], [Naam], [TotaalStemmen]) VALUES (@electionid, @name, @votes);";
command.AddParameterWithValue("electionid", 1);
command.AddParameterWithValue("name", t.Name);
command.AddParameterWithValue("votes", t.TotalVotes);
_connector.ExecuteNonQuery(command);
}
public void Add(Coalition t)
{
IDbCommand command = _connector.CreateCommand();
command.CommandText = "INSERT INTO [Coalitie] ([Naam], [Premier], [Zetels]) VALUES (@name, @primeminister, @seats);";
command.AddParameterWithValue("name", t.Name);
command.AddParameterWithValue("primeminister", t.PrimeMinister);
command.AddParameterWithValue("seats", t.Seats);
_connector.ExecuteNonQuery(command);
}
/// <summary>
/// Creates a database command and populates the parameter values.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="commandType">Type of the command.</param>
/// <param name="parameters">The parameter type instance.</param>
/// <param name="ignoreProperties">A list with properties to ignore.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, TParameters parameters, params string[] ignoreProperties)
{
var command = connector.CreateCommand(commandText);
PopulateCommandParameters(connector, command, parameters, ignoreProperties);
return(command);
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandBatch"/> class.
/// </summary>
/// <param name="connector">The database connector.</param>
public CommandBatch(IDatabaseConnector connector)
{
this.Connector = connector;
this.FormatProvider = connector.GetCommandFormatProvider();
this.Command = connector.CreateCommand();
this.Steps = new List <ICommandBatchStep>();
}
/// <summary>
/// Initializes a new instance of the <see cref="CommandBatch"/> class.
/// </summary>
/// <param name="connector">The database connector.</param>
public CommandBatch(IDatabaseConnector connector)
{
this.Connector = connector;
this.FormatProvider = connector.GetCommandFormatProvider();
this.Command = connector.CreateCommand();
this.Steps = new List <ICommandBatchStep>();
this.ParameterRegex = new Regex($"{this.Connector.GetCommandFormatProvider().GetParameterName(string.Empty)}[a-zA-Z][a-zA-Z0-9_]*", RegexOptions.Compiled | RegexOptions.Multiline);
}
/// <summary>
/// Creates a database command.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand(this IDatabaseConnector connector, string commandText)
{
var command = connector.CreateCommand();
command.CommandText = commandText;
return(command);
}
/// <summary>
/// Executes a database command as scalar.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The database command.</param>
/// <param name="action">A callback action to process the scalar value.</param>
public static T ExecuteScalar <T>(this IDatabaseConnector connector, string commandText, Func <object, T> action)
{
connector.OpenMySqlConnectionWhenClose();
using (var command = connector.CreateCommand(commandText))
{
return(action(command.ExecuteScalar()));
}
}
/// <summary>
/// Executes a database command as scalar.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The database command.</param>
/// <param name="action">A callback action to process the scalar value.</param>
public static void ExecuteScalar(this IDatabaseConnector connector, string commandText, Action <object> action)
{
connector.OpenMySqlConnectionWhenClose();
using (var command = connector.CreateCommand(commandText))
{
action(command.ExecuteScalar());
}
}
/// <summary>
/// Executes a database command as non query.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
public static void ExecuteNonQuery(this IDatabaseConnector connector, string commandText)
{
connector.OpenMySqlConnectionWhenClose();
using (var command = connector.CreateCommand(commandText))
{
command.ExecuteNonQuery();
}
}
/// <summary>
/// Executes a database command as scalar.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The database command.</param>
/// <param name="action">A callback action to process the scalar value.</param>
public static async Task <T> ExecuteScalarAsync <T>(this IDatabaseConnector connector, string commandText, Func <object, Task <T> > action)
{
await connector.OpenMySqlConnectionWhenCloseAsync();
using (var command = connector.CreateCommand(commandText))
{
return(await action(await command.ExecuteScalarAsync()));
}
}
/// <summary>
/// Executes a database command as scalar.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The database command.</param>
/// <param name="action">A callback action to process the scalar value.</param>
public static async Task ExecuteScalarAsync(this IDatabaseConnector connector, string commandText, Action <object> action)
{
await connector.OpenMySqlConnectionWhenCloseAsync();
using (var command = connector.CreateCommand(commandText))
{
action(await command.ExecuteScalarAsync());
}
}
/// <summary>
/// Initializes a new instance of the <see cref="CustomQuery{TResultType}"/> class.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="query">The query.</param>
/// <param name="descriptor">The custom type descriptor.</param>
public CustomQuery(IDatabaseConnector connector, string query, ICustomTypeDescriptor descriptor)
{
this.Connector = connector;
this.Descriptor = descriptor;
this.CommandText = query;
this.Command = connector.CreateCommand();
this.Command.CommandText = query;
this.Mapper = new DatabaseReaderMapper <TResultType>(connector, descriptor);
}
/// <summary>
/// Executes a database command as non query.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="action">A callback action to process the affected rows quantity.</param>
public static async Task ExecuteNonQueryAsync(this IDatabaseConnector connector, string commandText, Func <int, Task> action)
{
await connector.OpenMySqlConnectionWhenCloseAsync();
using (var command = connector.CreateCommand(commandText))
{
await action(await command.ExecuteNonQueryAsync());
}
}
/// <summary>
/// Creates a database command.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The databaseconnector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="commandType">Type of the command.</param>
/// <param name="descriptor">A routine type descriptor for the parameters.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, IRoutineTypeDescriptor descriptor)
{
var command = connector.CreateCommand(commandText);
command.CommandType = CommandType.StoredProcedure;
PopulateCommandParameters(connector, command, descriptor, default(TParameters), null);
return(command);
}
/// <summary>
/// Executes a database command as data reader.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="action">A callback action to process the database reader.</param>
public static async Task <T> ExecuteReaderAsync <T>(this IDatabaseConnector connector, string commandText, Func <IDatabaseReader, T> action)
{
await connector.OpenMySqlConnectionWhenCloseAsync();
using (var command = connector.CreateCommand(commandText))
{
using (var reader = await command.ExecuteReaderAsync())
{
return(action(reader));
}
}
}
/// <summary>
/// Executes a database command as data reader.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="action">A callback action to process the database reader.</param>
public static async Task ExecuteReaderAsync(this IDatabaseConnector connector, string commandText, Action <IDatabaseReader> action)
{
await connector.OpenMySqlConnectionWhenCloseAsync();
using (var command = connector.CreateCommand(commandText))
{
using (var reader = await command.ExecuteReaderAsync())
{
action(reader);
}
}
}
/// <summary>
/// Executes a database command as data reader.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="action">A callback action to process the database reader.</param>
public static void ExecuteReader(this IDatabaseConnector connector, string commandText, Action <IDatabaseReader> action)
{
connector.OpenMySqlConnectionWhenClose();
using (var command = connector.CreateCommand(commandText))
{
using (var reader = command.ExecuteReader())
{
action(reader);
}
}
}
/// <summary>
/// Executes a database command as data reader.
/// </summary>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="action">A callback action to process the database reader.</param>
public static T ExecuteReader <T>(this IDatabaseConnector connector, string commandText, Func <IDatabaseReader, T> action)
{
connector.OpenMySqlConnectionWhenClose();
using (var command = connector.CreateCommand(commandText))
{
using (var reader = command.ExecuteReader())
{
return(action(reader));
}
}
}
/// <summary>
/// Creates a database command.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="descriptor">The routine type descriptor.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, IRoutineTypeDescriptor descriptor)
{
return(connector.CreateCommand <TParameters>(commandText, CommandType.StoredProcedure, descriptor));
}
public void AddCardToDeck(Deck deck, Card card)
{
IDbCommand command = connector.CreateCommand();
command.CommandText = "INSERT INTO deckList (deckID, cardID) VALUES (@deck, @card);";
command.AddParameterWithValue("deck", deck.GetID());
command.AddParameterWithValue("card", card.GetID());
connector.ExecuteNonQuery(command);
}
/// <summary>
/// Creates a database command and populates the parameter values.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="commandType">Type of the command.</param>
/// <param name="parameters">The parameter type instance.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, CommandType commandType, TParameters parameters)
{
return(connector.CreateCommand(commandText, parameters, null));
}
/// <summary>
/// Creates a database command and populates the parameter values.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The database connector.</param>
/// <param name="commandText">The command text.</param>
/// <param name="parameters">The parameter type instance.</param>
/// <param name="ignoreProperties">A list with properties to ignore.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText, TParameters parameters, params string[] ignoreProperties)
{
return(connector.CreateCommand(commandText, CommandType.Text, parameters, ignoreProperties));
}
/// <summary>
/// Creates a database command.
/// </summary>
/// <typeparam name="TParameters">The type of a class containing the parameters.</typeparam>
/// <param name="connector">The databaseconnector.</param>
/// <param name="commandText">The command text.</param>
/// <returns>A database command.</returns>
public static IDatabaseCommand CreateCommand <TParameters>(this IDatabaseConnector connector, string commandText)
{
return(connector.CreateCommand(commandText, CommandType.Text, default(TParameters), null));
}
