/// <summary>
/// Executes a non-query with a single parameter.
/// </summary>
/// <param name="command">Non-query command.</param>
/// <param name="parameters">Parameters to be added.</param>
/// <param name="types">Database data type of parameters.</param>
/// <param name="values">Values for parameters.</param>
public static void ExecuteWithParameter(MySqlCommand command, MysqlParameter parameter)
{
AddParameter(command, parameter);
command.ExecuteNonQuery();
}
/// <summary>
/// Adds a single parameters to a command.
/// </summary>
/// <param name="command">Command to be parametrised.</param>
/// <param name="parameters">Parameters to be added.</param>
/// <param name="types">Database data type of parameters</param>
/// <param name="values">Values to be stored in parametrised command.</param>
public static void AddParameter(MySqlCommand command, MysqlParameter parameters)
{
var tempParameter = command.Parameters.Add(parameters.name, parameters.type);
tempParameter.Value = parameters.value;
}
