private void filtro_Click(object sender, EventArgs e) { GenData gd = new GenData(); if (gd.converter(data1.Text) <= gd.converter(data2.Text)) { transazioni_table.Rows.Clear(); Data d = new Data(); MySqlCommand commandDatabase = new MySqlCommand("SELECT * FROM `Transazioni` WHERE ID_Conto='" + id + "' AND Data >= '" + gd.converter(data1.Text) + "' AND Data <= " + gd.converter(data2.Text) + "", d.databaseConnection); commandDatabase.CommandTimeout = 60; d.databaseConnection.Open(); MySqlDataReader r = commandDatabase.ExecuteReader(); int counter = 0; if (r.HasRows) { while (r.Read()) { if (r.GetString(7) == "1") { transazioni_table.Rows.Add(r.GetString(3), r.GetString(4), conv(r.GetString(5)), r.GetString(6)); transazioni_table.Rows[counter].DefaultCellStyle.BackColor = Color.Red; counter++; } else { transazioni_table.Rows.Add(r.GetString(3), r.GetString(4), conv(r.GetString(5)), r.GetString(6)); transazioni_table.Rows[counter].DefaultCellStyle.BackColor = Color.Green; counter++; } } } transazioni_table.RowCount = counter; } else { MessageBox.Show("La prima data deve essere minore o uguale della seconda", "Errore", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void build_conto_Click(object sender, EventArgs e) { Data d = new Data(); GenData gd = new GenData(); int cp = Convert.ToInt32(d.cdb("SELECT COUNT(*) FROM Conti WHERE Nome_Conto = '" + comboBox1.Text + "'")); d.databaseConnection.Close(); if (cp == 0) { int spese = 0; if (comboBox1.Text == "Young") { spese = 12; } else { spese = 24; } d.db("INSERT INTO Conti(ID_Conto, ID_Utente, IBAN, Nome_Conto, Tipologia, Saldo, Spese) VALUES('" + gd.IDC() + "', '" + Login.UUID + "', '" + gd.IBAN() + "', '" + lbl_nc.Text + "', '" + comboBox1.Text + "', '0', '" + spese + "')"); this.Close(); Banca b = new Banca(); b.Show(); } }