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