public static bool MultiInsertAuto(List <SaleItem> saleItem)
{
for (int i = 0; i < saleItem.Count; i++)
{
if (!ValidatorSaleItemMessage(saleItem[i]))
{
return(false);
}
}
string ArrayProdutoCodigoBarras = "{";
string ArrayQuantidade = "{";
for (int i = 0; i < saleItem.Count; i++)
{
ArrayProdutoCodigoBarras += saleItem[i].ProdutoCodigoBarras;
ArrayQuantidade += saleItem[i].Quantidade.ToString();
int temp = i + 1;
if (temp < saleItem.Count)
{
ArrayProdutoCodigoBarras += ",";
ArrayQuantidade += ",";
}
}
ArrayProdutoCodigoBarras += "}";
ArrayQuantidade += "}";
string cmd = string.Format("select * from inserir_item_venda_multi('{0}','{1}','{2}')",
saleItem[0].VendaID, ArrayProdutoCodigoBarras, ArrayQuantidade);
return(GenericDAO.genericBool(cmd));
}
public static bool Alter(SaleItem saleItem)
{
if (!ValidatorSaleItemMessage(saleItem))
{
return(false);
}
else
{
string cmd = string.Format("select * from inserir_item_venda('{0}','{1}')",
saleItem.ID, saleItem.Quantidade);
return(GenericDAO.genericBool(cmd));
}
}
public static bool Alter(Customer customer)
{
if (!ValidatorCustomerMessage(customer))
{
return(false);
}
string cmd = string.Format("select * from alterar_pessoa('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
customer.CPF, customer.Name, customer.Gender, customer.CellPhone, customer.Phone, customer.Address.Street, customer.Address.Number,
customer.Address.Complement, customer.Address.District, customer.Address.City, customer.Address.State);
return(GenericDAO.genericBool(cmd));
}
public static bool Alter(User user)
{
if (!ValidatorUserMessage(user))
{
return(false);
}
else
{
string cmd = string.Format("select * from alterar_usuario('{0}','{1}','{2}'')",
user.Login, user.Senha, user.Nome);
return(GenericDAO.genericBool(cmd));
}
}
public static bool Alter(Sale sale)
{
if (!ValidatorSaleMessage(sale))
{
return(false);
}
else
{
string cmd = string.Format("select * from alterar_venda('{0}','{1}','{2}','{3}','{4}')",
sale.ID, sale.Customer.CPF, sale.Date, sale.TotalMoney, sale.TotalCard);
return(GenericDAO.genericBool(cmd));
}
}
public static bool Alter(Product product)
{
if (!ValidatorProductMessage(product))
{
return(false);
}
else
{
string cmd = string.Format("select * from alterar_produto('{0}','{1}','{2}','{3}','{4}','{5}')",
product.Code, product.Name, product.Amount, product.Unity, product.CostPrice.ToString("N", CultureInfo.CreateSpecificCulture("en-US"))
, product.SalePrice.ToString("N", CultureInfo.CreateSpecificCulture("en-US")));
return(GenericDAO.genericBool(cmd));
}
}
public static bool Insert(BillPayment billPayment)
{
if (!ValidatorBillPaymentMessage(billPayment))
{
return(false);
}
else
{
string cmd = string.Format("select * from inserir_pagamento_conta('{0}','{1}','{2}','{3}')",
billPayment.Customer.CPF, billPayment.PaymentDate,
billPayment.Money.ToString("N", CultureInfo.CreateSpecificCulture("en-US")),
billPayment.Card.ToString("N", CultureInfo.CreateSpecificCulture("en-US")));
return(GenericDAO.genericBool(cmd));
}
}
public static bool MultiInsertManual(List <SaleItem> saleItem)
{
for (int i = 0; i < saleItem.Count; i++)
{
if (!ValidatorSaleItemMessage(saleItem[i]))
{
return(false);
}
else
{
string cmd = string.Format("select * from inserir_item_venda('{0}','{1}','{2}')",
saleItem[i].VendaID, saleItem[i].ProdutoCodigoBarras, saleItem[i].Quantidade);
GenericDAO.genericBool(cmd);
}
}
return(true);
}
public static bool Delete(string id)
{
string cmd = string.Format("select * from excluir_item_venda('{0}')", id);
return(GenericDAO.genericBool(cmd));
}
public static bool Delete(string barCode)
{
string cmd = string.Format("select * from excluir_produto('{0}')", barCode);
return(GenericDAO.genericBool(cmd));
}
public static bool Delete(string cpf)
{
string cmd = string.Format("select * from excluir_cliente('{0}')", cpf);
return(GenericDAO.genericBool(cmd));
}
public static bool Delete(string login)
{
string cmd = string.Format("select * from excluir_usuario('{0}')", login);
return(GenericDAO.genericBool(cmd));
}
public static bool Insert(BillItem billItem)
{
if (!ValidatorSaleMessage(billItem.Sale))
{
return(false);
}
DataTable dt = new DataTable();
try
{
using (DAO.PgsqlConnection = new NpgsqlConnection(DAO.ConnString))
{
//Abra a conexão com o PgSQL
DAO.PgsqlConnection.Open();
string inserirVendaCMD = string.Format("select * from inserir_venda('{0}','{1}','{2}','{3}')",
billItem.Sale.Customer.CPF, billItem.Sale.Date,
billItem.Sale.TotalMoney.ToString("N", CultureInfo.CreateSpecificCulture("en-US")),
billItem.Sale.TotalCard.ToString("N", CultureInfo.CreateSpecificCulture("en-US")));
using (NpgsqlDataAdapter Adpt = new NpgsqlDataAdapter(inserirVendaCMD, DAO.PgsqlConnection))
{
Adpt.Fill(dt);
}
if (dt.Rows.Count > 0)
{
billItem.Sale.ID = dt.Rows[0]["inserir_venda"].ToString(); // Captura ID da venda
for (int i = 0; i < billItem.Sale.SaleItem_.Count; i++)
{
billItem.Sale.SaleItem_[i].VendaID = billItem.Sale.ID;
}
SalelItemDAO.MultiInsertAuto(billItem.Sale.SaleItem_);
string inserirItemContaCMD = string.Format("select * from inserir_item_conta('{0}','{1}','{2}')",
billItem.Sale.ID, billItem.Sale.Customer.CPF,
billItem.Total.ToString("N", CultureInfo.CreateSpecificCulture("en-US")));
return(GenericDAO.genericBool(inserirItemContaCMD));
}
}
}
catch (NpgsqlException ex)
{
MessageBox.Show("Erro: " + ex.Message + ".\nPor Favor contate o suporte.", "Erro de Banco de Dados",
MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
catch (Exception ex)
{
MessageBox.Show("Erro: " + ex.Message + ".\nPor Favor contate o suporte.", "Erro de Sofware",
MessageBoxButton.OK, MessageBoxImage.Error);
return(false);
}
finally
{
DAO.PgsqlConnection.Close();
}
return(false);
}