public List<TaxaDeEntrega> listaTaxaPorPesquisa(String s) { List<TaxaDeEntrega> pesquisa = new List<TaxaDeEntrega>(); s= "%" + s + "%"; MySqlConnection conn = Database.GetInstance().GetConnection(); if (conn.State != System.Data.ConnectionState.Open) conn.Open(); string qry = "Select nomeBairro, distancia, preco from taxas where nomeBairro like @S or distancia like @S order by distancia, nomeBairro"; MySqlCommand comm = new MySqlCommand(qry, conn); comm.Parameters.AddWithValue("@S", s); MySqlDataReader dr = comm.ExecuteReader(); //precisamos coocar as inf obtias no objeto while (dr.Read()) { TaxaDeEntrega taxa = new TaxaDeEntrega(); taxa.Bairro = dr.GetString(0); taxa.Distancia = dr.GetString(1); taxa.Preco = dr.GetFloat(2); pesquisa.Add(taxa); } dr.Close(); conn.Close(); return pesquisa; }
public List<TaxaDeEntrega> listaTudo() { List<TaxaDeEntrega> lista = new List<TaxaDeEntrega>(); MySqlConnection conn = Database.GetInstance().GetConnection(); if (conn.State != System.Data.ConnectionState.Open) conn.Open(); string qry = "Select nomeBairro, distancia, preco from taxas order by distancia, nomeBairro"; MySqlCommand comm = new MySqlCommand(qry, conn); MySqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { TaxaDeEntrega taxa = new TaxaDeEntrega(); taxa.Bairro = dr.GetString(0); taxa.Distancia = dr.GetString(1); taxa.Preco = dr.GetFloat(2); lista.Add(taxa); } dr.Close(); conn.Close(); return lista; }
private TaxaDeEntrega getDTO() { TaxaDeEntrega taxa = new TaxaDeEntrega(); taxa.Distancia = txtDistancia.Text; taxa.Bairro = txtBairro.Text; taxa.Preco = float.Parse(txtPrecoTaxa.Text); return(taxa); }
private void btnInsereTaxa_Click(object sender, EventArgs e) { TaxaDeEntrega taxa = new TaxaDeEntrega(); taxa = getDTO(); taxaDeEntregaDAO.Insere(taxa); txtBairro.Text = ""; txtDistancia.Text = ""; txtPrecoTaxa.Text = ""; SetInvisible(); AtualizaDataGrid(); }
public void Insere(TaxaDeEntrega taxa) { Database dbDelivery = Database.GetInstance(); string qry = "insert into taxas(nomeBairro, distancia, preco) values (@Nome, @dist, @preco)"; MySqlCommand comm = new MySqlCommand(qry); //seta parâmetros comm.Parameters.AddWithValue("@Nome", taxa.Bairro); comm.Parameters.AddWithValue("@dist", taxa.Distancia); comm.Parameters.AddWithValue("@preco", taxa.Preco); dbDelivery.ExecuteSQL(comm); }
private void setDTO(TaxaDeEntrega taxa) { txtDistancia.Text = taxa.Distancia; txtBairro.Text = taxa.Bairro; txtPrecoTaxa.Text = taxa.Preco.ToString("C"); }