| public static GraphLinkInsert ( string tableName, string eventName, string graphFileName, bool dbconOpened ) : int | ||
| tableName | string | |
| eventName | string | |
| graphFileName | string | |
| dbconOpened | bool | |
| Результат | int | |
public static void AddGraphLinksRj()
{
using (SqliteTransaction tr = dbcon.BeginTransaction())
{
using (SqliteCommand dbcmdTr = dbcon.CreateCommand())
{
dbcmdTr.Transaction = tr;
SqliteEvent.GraphLinkInsert(Constants.JumpRjTable, "RJ(j)", "jump_rj.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpRjTable, "RJ(t)", "jump_rj.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpRjTable, "RJ(unlimited)", "jump_rj_in.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpRjTable, "triple jump", "jump_rj.png", true, dbcmdTr);
}
tr.Commit();
}
}
public static void AddGraphLinksRunSimple()
{
using (SqliteTransaction tr = dbcon.BeginTransaction())
{
using (SqliteCommand dbcmdTr = dbcon.CreateCommand())
{
dbcmdTr.Transaction = tr;
SqliteEvent.GraphLinkInsert(Constants.RunTable, "20m", "run_simple.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "100m", "run_simple.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "200m", "run_simple.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "400m", "run_simple.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "1000m", "run_simple.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "2000m", "run_simple.png", true, dbcmdTr);
}
tr.Commit();
}
}
public static void AddGraphLinksRunSimpleAgility()
{
using (SqliteTransaction tr = dbcon.BeginTransaction())
{
using (SqliteCommand dbcmdTr = dbcon.CreateCommand())
{
dbcmdTr.Transaction = tr;
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Agility-20Yard", "agility_20yard.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Agility-505", "agility_505.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Agility-Illinois", "agility_illinois.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Agility-Shuttle-Run", "agility_shuttle.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Agility-ZigZag", "agility_zigzag.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Margaria", "margaria.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunTable, "Gesell-DBT", "gesell_dbt.png", true, dbcmdTr);
}
tr.Commit();
}
}
public static void AddGraphLinksRunInterval()
{
using (SqliteTransaction tr = dbcon.BeginTransaction())
{
using (SqliteCommand dbcmdTr = dbcon.CreateCommand())
{
dbcmdTr.Transaction = tr;
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "byLaps", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "byTime", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "unlimited", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "20m10times", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "7m30seconds", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "20m endurance", "run_interval.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "MTGUG", "mtgug.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.RunIntervalTable, "Agility-3L3R", "agility_3l3r.png", true, dbcmdTr);
}
tr.Commit();
}
}
//put the graph links on the db
//don't put the full description because if the user changes language, description will be in old lang
//description will be on src/jumpType
public static void AddGraphLinks()
{
using (SqliteTransaction tr = dbcon.BeginTransaction())
{
using (SqliteCommand dbcmdTr = dbcon.CreateCommand())
{
dbcmdTr.Transaction = tr;
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "Free", "jump_free.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "SJ", "jump_sj.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "SJl", "jump_sj_l.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "CMJ", "jump_cmj.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "CMJl", "jump_cmj_l.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "ABK", "jump_abk.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "ABKl", "jump_abk_l.png", true, dbcmdTr);
//SqliteEvent.GraphLinkInsert (Constants.JumpTable, "Max", "jump_max.png", true, dbcmdTr); //we already have "Free"
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "Rocket", "jump_rocket.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "DJa", "jump_dj_a.png", true, dbcmdTr);
SqliteEvent.GraphLinkInsert(Constants.JumpTable, "DJna", "jump_dj.png", true, dbcmdTr);
}
tr.Commit();
}
}
