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