public static Insert ( bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string type, double distance, double time, string description, int simulated, bool initialSpeed ) : int | ||
dbconOpened | bool | |
tableName | string | |
uniqueID | string | |
personID | int | |
sessionID | int | |
type | string | |
distance | double | |
time | double | |
description | string | |
simulated | int | |
initialSpeed | bool | |
return | int |
protected override void write() { LogB.Information(string.Format("TIME: {0}", time.ToString())); /* * string myStringPush = Catalog.GetString("Last run") + ": " + RunnerName + " " + * type + " " + Catalog.GetString("time") + ": " + Util.TrimDecimals( time.ToString(), pDN ) + * " " + Catalog.GetString("speed") + ": " + Util.TrimDecimals ( (distance/time).ToString(), pDN ); */ if (simulated) { feedbackMessage = Catalog.GetString(Constants.SimulatedMessage); } else { feedbackMessage = ""; } needShowFeedbackMessage = true; string description = ""; if (type == "Margaria") { // P = W * 9.8 * D / t // W: person weight // D: distance between 3d and 9th stair double weight = SqlitePersonSession.SelectAttribute(false, personID, sessionID, Constants.Weight); double distanceMeters = distance / 1000; description = "P = " + Util.TrimDecimals((weight * 9.8 * distanceMeters / time).ToString(), pDN) + " (Watts)"; } else if (type == "Gesell-DBT") { description = "0"; } string table = Constants.RunTable; uniqueID = SqliteRun.Insert(false, table, "NULL", personID, sessionID, type, distance, time, description, Util.BoolToNegativeInt(simulated), !startIn //initialSpeed true if not startIn ); //define the created object eventDone = new Run(uniqueID, personID, sessionID, type, distance, time, description, Util.BoolToNegativeInt(simulated), !startIn); //event will be raised, and managed in chronojump.cs fakeButtonFinished.Click(); //app1.PrepareRunSimpleGraph(time, distance/time); PrepareEventGraphRunSimpleObject = new PrepareEventGraphRunSimple(time, distance / time, sessionID, personID, table, type); needUpdateGraphType = eventType.RUN; needUpdateGraph = true; needEndEvent = true; //used for hiding some buttons on eventWindow }
public override int InsertAtDB(bool dbconOpened, string tableName) { return(SqliteRun.Insert(dbconOpened, tableName, uniqueID.ToString(), personID, sessionID, type, distance, time, description, simulated, initialSpeed)); }