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); }