private void AddOrderDetail(SQLiteTransaction trans, int id, int orderId, string article)
{
SQLiteCommand cmd = _Connection.CreateCommand("insert into OrderDetails (Id, OrderId, Article) values (@Id, @OrderId, @Article)");
cmd.Transaction = trans;
cmd.Parameters.Add("@Id", DbType.Int32).Value = id;
cmd.Parameters.Add("@OrderId", DbType.Int32).Value = orderId;
cmd.Parameters.Add("@Article", DbType.String).Value = article;
cmd.ExecuteNonQuery();
}
public SQLiteCommand()
{
_CommandText = String.Empty;
_UpdatedRowSource = UpdateRowSource.Both;
_Timeout = 30;
_ServingDataReader = false;
_Transaction = null;
_Parameters = new SQLiteParameterCollection();
_Statements = new SQLiteStatementCollection();
}
private void AddOrder(SQLiteTransaction trans, int id, int items, string customer, double amount)
{
SQLiteCommand cmd = _Connection.CreateCommand("insert into Orders (Id, Items, Customer, Amount) values (@Id, @Items, @Customer, @Amount)");
cmd.Transaction = trans;
cmd.Parameters.Add("@Id", DbType.Int32).Value = id;
cmd.Parameters.Add("@Items", DbType.Int32).Value = items;
cmd.Parameters.Add("@Customer", DbType.String).Value = customer;
cmd.Parameters.Add("@Amount", DbType.Single).Value = amount;
cmd.ExecuteNonQuery();
}