public static void Main(string[] args)
{
string connectionString = "Server=localhost;Database=test;User ID=root;Password=;";
IDbConnection conn = new MySqlConnection(connectionString);
conn.Open();
sqlgg.all gen = new sqlgg.all(conn);
gen.drop_person.execute();
gen.drop_money.execute();
gen.create_person.execute();
gen.create_money.execute();
IDbCommand last_id = conn.CreateCommand();
last_id.CommandText = "SELECT LAST_INSERT_ID()";
last_id.Prepare();
gen.add_person.execute("John", "Black");
long john = (long)last_id.ExecuteScalar();
gen.add_person.execute("Ivan", "Petrov");
long ivan = (long)last_id.ExecuteScalar();
gen.add_person.execute("Sancho", "Alvares");
long sancho = (long)last_id.ExecuteScalar();
// add money relations
gen.add_money.execute(john, ivan, 200);
gen.add_money.execute(john, sancho, 100);
gen.add_money.execute(john, sancho, 250);
gen.add_money.execute(sancho, ivan, 300);
Console.WriteLine("Total transfers:");
foreach (var row in gen.calc_total.rows())
{
Console.WriteLine(row.fullname + " = " + row.total);
}
Console.WriteLine("Donors:");
gen.list_donors.execute("petrov", 100, delegate(string surname) { Console.WriteLine(surname); });
conn.Close();
conn = null;
}
public static void Main(string[] args)
{
string connectionString = "Server=localhost;Database=test;User ID=root;Password=;";
IDbConnection conn = new MySqlConnection(connectionString);
conn.Open();
sqlgg.all gen = new sqlgg.all(conn);
gen.drop_person.execute();
gen.drop_money.execute();
gen.create_person.execute();
gen.create_money.execute();
IDbCommand last_id = conn.CreateCommand();
last_id.CommandText = "SELECT LAST_INSERT_ID()";
last_id.Prepare();
gen.add_person.execute("John","Black");
long john = (long)last_id.ExecuteScalar();
gen.add_person.execute("Ivan","Petrov");
long ivan = (long)last_id.ExecuteScalar();
gen.add_person.execute("Sancho","Alvares");
long sancho = (long)last_id.ExecuteScalar();
// add money relations
gen.add_money.execute(john,ivan,200);
gen.add_money.execute(john,sancho,100);
gen.add_money.execute(john,sancho,250);
gen.add_money.execute(sancho,ivan,300);
Console.WriteLine("Total transfers:");
foreach (var row in gen.calc_total.rows())
{
Console.WriteLine(row.fullname + " = " + row.total);
}
Console.WriteLine("Donors:");
gen.list_donors.execute("petrov",100,delegate(string surname) { Console.WriteLine(surname); });
conn.Close();
conn = null;
}
