/// <summary>
/// Registra o cartão de crédito informado na transação
/// </summary>
/// <param name="creditCard"></param>
public void Inserir(CreditCard creditCard)
{
using (var bd = new BDEngine())
{
sql.Clear();
sql.Append(@"
INSERT INTO CreditCard(card_number, card_holder_name, cvv, exp_date)
VALUES ('{0}', '{1}', {2}, '{3}')
");
bd.ExecuteNonQuery(string.Format(sql.ToString(),
creditCard.card_number,
creditCard.card_holder_name,
creditCard.cvv,
creditCard.exp_date));
}
}
/// <summary>
/// Insere histórico
/// </summary>
/// <param name="history"></param>
public void Inserir(History history)
{
using (var bd = new BDEngine())
{
sql.Clear();
sql.Append(@"
INSERT INTO History(card_number, client_id, value, order_id)
VALUES('{0}', '{1}', {2}, '{3}')
");
bd.ExecuteNonQuery(string.Format(sql.ToString(),
history.card_number,
history.client_id,
history.value,
history.order_id));
}
}
/// <summary>
/// Insere um item ao carrinho
/// </summary>
/// <param name="cart"></param>
public void Inserir(Cart cart)
{
using (var bd = new BDEngine())
{
sql.Clear();
sql.Append(@"
INSERT INTO Cart(cart_id, client_id, product_id, date, time)
VALUES('{0}', '{1}', '{2}', '{3}', '{4}')
");
bd.ExecuteNonQuery(string.Format(sql.ToString(),
cart.cart_id,
cart.client_id,
cart.product_id,
cart.date,
cart.time));
}
}
/// <summary>
/// Insere uma nova transação de compra
/// </summary>
/// <param name="transaction"></param>
/// <param name="orderId"></param>
public void Inserir(Transaction transaction)
{
using (var bd = new BDEngine())
{
sql.Clear();
sql.Append(@"
INSERT INTO Orders(client_id, cart_id, client_name, total_to_pay, credit_card, order_id, date)
VALUES('{0}', '{1}', '{2}', {3}, '{4}', '{5}', '{6}')
");
bd.ExecuteNonQuery(string.Format(sql.ToString(),
transaction.client_id,
transaction.cart_id,
transaction.client_name,
transaction.total_to_pay,
transaction.credit_card,
transaction.order_id,
transaction.date
));
}
}
/// <summary>
/// Insere um novo produto
/// </summary>
/// <param name="product"></param>
public void Inserir(Product product)
{
using (var bd = new BDEngine())
{
sql.Clear();
sql.Append(@"
INSERT INTO Product(product_id, artist, year, album, price, store, thumb, date)
VALUES('{0}', '{1}', {2}, '{3}', {4}, '{5}', '{6}', '{7}')
");
bd.ExecuteNonQuery(string.Format(sql.ToString(),
product.product_id,
product.artist,
product.year,
product.album,
product.price,
product.store,
product.thumb,
product.date));
}
}
