public static GraphLinkInsert ( string tableName, string eventName, string graphFileName, bool dbconOpened ) : int | ||
tableName | string | |
eventName | string | |
graphFileName | string | |
dbconOpened | bool | |
return | 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(); } }