// |==============================METODOS Y FUNCIONES==============================|
public int NuevaTransaccion(EntitieTransaccion transaccion)
{
ManagerDatabase.Instance.Execute("INSERT INTO Transacciones " +
"VALUES(" + transaccion.GetIdCuenta() + ", " + transaccion.GetIdTipoTransaccion() + ", " +
transaccion.GetMonto().ToString().Replace(",", ".") + ", '" + transaccion.GetFechaHora().ToString() + "')");
String signo = "";
if (transaccion.GetMonto() >= 0)
{
signo = "+";
}
ManagerDatabase.Instance.Execute("UPDATE Cuentas SET Balance = Balance " + signo + " " + transaccion.GetMonto().ToString().Replace(",", ".") + " " +
"WHERE ID_Cuenta = " + transaccion.GetIdCuenta());
ActualizarResumenHome();
return(Convert.ToInt32(ManagerDatabase.Instance.ExecuteQuery("SELECT MAX(ID_Transaccion) FROM Transacciones").Rows[0][0]));
}
public void RollBackTransaccion(int idTransaccion)
{
EntitieTransaccion transaccion = GetTransaccionById(idTransaccion);
ManagerDatabase.Instance.Execute("DELETE FROM Transacciones WHERE ID_Transaccion = " + transaccion.GetIdTransaccion());
String signo = "+";
String stringMonto = transaccion.GetMonto().ToString().Replace(",", ".");
if (stringMonto.Substring(0, 1) == "-")
{
stringMonto = stringMonto.Substring(1);
}
// Inversa
if (transaccion.GetMonto() >= 0)
{
signo = "-";
}
ManagerDatabase.Instance.Execute("UPDATE Cuentas SET Balance = Balance " + signo + " " + stringMonto + " " +
"WHERE ID_Cuenta = " + transaccion.GetIdCuenta());
ActualizarResumenHome();
}