public static double getClientBalance(Int32 clientA)
{
double balance = 0;
SqlConnection con = Connection.addConnection();
if (con != null)
{
SqlCommand cmd = new SqlCommand(String.Format("SELECT CONVERT(float, SUM(saldo)) FROM transaccion WHERE idCliente = {0};", clientA), con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
balance = reader.GetDouble(0);
}
}
con.Close();
return(balance);
}
public static List <Client> getClientsByCountry(String country)
{
List <Client> list = new List <Client>();
SqlConnection con = Connection.addConnection();
if (con != null)
{
SqlCommand cmd = new SqlCommand(String.Format("SELECT * FROM cliente WHERE pais = '{0}'", country), con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
list.Add(new Client(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3)));
}
}
return(list);
}
public int saveTransaction(Int32 clientA)
{
if (this.balance > getClientBalance(clientA))
{
MessageBox.Show("No se pudo crear la transacción debido a que el saldo es insuficiente.");
return(0);
}
int res = 0;
SqlConnection con = Connection.addConnection();
if (con != null)
{
SqlCommand cmd = new SqlCommand(String.Format("INSERT INTO transaccion VALUES((SELECT TOP 1 idTran + 1 FROM transaccion ORDER BY idTran DESC), {0}, {1}); INSERT INTO transaccion VALUES((SELECT TOP 1 idTran + 1 FROM transaccion ORDER BY idTran DESC), {2}, {3});", this.balance, this.idClient, this.balance * -1, clientA), con);
res = cmd.ExecuteNonQuery();
}
con.Close();
return(res);
}