private void execute_transaction_Click(object sender, EventArgs e) { Data d = new Data(); GenData gd = new GenData(); int Type = 0; if (tipo.Text != "") { if (tipo.Text == "Prelievo") { Type = 1; } else { Type = 0; } } string data = Convert.ToString(gd.converter(DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString())); string ora; if (DateTime.Now.Hour.ToString().Length < 2) { ora = "0" + DateTime.Now.Hour.ToString(); } else { ora = DateTime.Now.Hour.ToString(); } if (DateTime.Now.Minute.ToString().Length < 2) { ora += ":0" + DateTime.Now.Minute.ToString(); } else { ora += ":" + DateTime.Now.Minute.ToString(); } if (Type == 1) { double conto = Convert.ToDouble(d.fetch("SELECT * FROM Conti WHERE ID_Conto = '" + id + "'", 6)); d.databaseConnection.Close(); double ponte = conto - (Convert.ToDouble(value_text.Text) + d.getContoCom(id)); d.db("UPDATE Conti SET Saldo = '" + ponte + "' WHERE ID_Conto = '" + id + "'"); d.db("INSERT INTO Transazioni(ID_Conto, ID_Transazione, Ammontare, Causale, Data, Ora, Type) VALUES('" + id + "', '" + gd.IDT() + "', '" + (Convert.ToInt32(value_text.Text) + d.getContoCom(id)) + "', '" + causale_txt.Text + "', '" + data + "', '" + ora + "', '" + Type + "')"); } else { double conto = Convert.ToDouble(d.fetch("SELECT * FROM Conti WHERE ID_Conto = '" + id + "'", 6)); d.databaseConnection.Close(); double ponte = conto + (Convert.ToDouble(value_text.Text) - d.getContoCom(id)); d.db("UPDATE Conti SET Saldo = '" + ponte + "' WHERE ID_Conto = '" + id + "'"); d.db("INSERT INTO Transazioni(ID_Conto, ID_Transazione, Ammontare, Causale, Data, Ora, Type) VALUES('" + id + "', '" + gd.IDT() + "', '" + (Convert.ToInt32(value_text.Text) - d.getContoCom(id)) + "', '" + causale_txt.Text + "', '" + data + "', '" + ora + "', '" + Type + "')"); } MessageBox.Show("Transazione Completata con successo"); this.Close(); ViewConto v = new ViewConto(id); v.Show(); }
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); } }