public string CadastroCartao(DadosCartao Cartao) { using (var connection = GetConnection()) { connection.Open(); string rpta = ""; try { command.Connection = connection; command.CommandText = "INSERT INTO tb_cartoes (id_bandeira, taxa_debito, taxa_credito) VALUES (@id_bandeira, @taxa_debito, @taxa_credito)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_bandeira", Cartao.Bandeira); command.Parameters.AddWithValue("@taxa_debito", Cartao.TaxaDebito); command.Parameters.AddWithValue("@taxa_credito", Cartao.TaxaCredito); //command.Parameters.AddWithValue("@id_pagamento", Cartao.IdPagamento); rpta = command.ExecuteNonQuery() == 1 ? "OK" : "Falha ao cadastrar cartao"; connection.Close(); } catch (Exception ex) { rpta = ex.Message + ex.StackTrace; } return(rpta); } }
public bool Valida(DadosCartao Cartao) { using (var connection = GetConnection()) { connection.Open(); try { command.Connection = connection; command.CommandText = "select * from tb_cartoes where id_bandeira = @id_bandeira"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_bandeira", Cartao.Bandeira); var result = command.ExecuteScalar(); if (result != null) { return(true); } } catch (Exception ex) { } return(false); } }
public string UpdateCartao(DadosCartao Cartao) { using (var connection = GetConnection()) { connection.Open(); string rpta = ""; try { command.Connection = connection; command.CommandText = "Update tb_cartoes SET taxa_debito=@taxa_debito, taxa_credito=@taxa_credito WHERE id_bandeira=@id_bandeira"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_bandeira", Cartao.Bandeira); command.Parameters.AddWithValue("@taxa_debito", Cartao.TaxaDebito); command.Parameters.AddWithValue("@taxa_credito", Cartao.TaxaCredito); //command.Parameters.AddWithValue("@id_pagamento", Cartao.IdPagamento); rpta = command.ExecuteNonQuery() == 1 ? "OK" : "Falha ao atualizar cartao"; } catch (Exception ex) { rpta = ex.Message + ex.StackTrace; } return(rpta); } }