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