public static void DeleteActivityFrame(DateTime timeStamp) { using (SQLiteConnection connection = new SQLiteConnection(TempDBCS)) { ActivityFrame frame = connection.Table <ActivityFrame>().Where(af => af.TimeStamp.Equals(timeStamp)).FirstOrDefault(); if (frame != null) { connection.Delete(frame); } } }
public static void UpdateActivityFrame(DateTime timeStamp, int intensity, int steps, byte mode, byte runs) { using (SQLiteConnection connection = new SQLiteConnection(TempDBCS)) { ActivityFrame frame = connection.Table <ActivityFrame>().Where(af => af.TimeStamp.Equals(timeStamp)).FirstOrDefault(); frame.Intensity = intensity; frame.Steps = steps; frame.Mode = mode; frame.Runs = runs; connection.Update(frame); } }
public static bool AddActivityFrame(DateTime timeStamp, int intensity, int steps, byte mode, byte runs) { using (SQLiteConnection connection = new SQLiteConnection(TempDBCS)) { ActivityFrame af = new ActivityFrame() { TimeStamp = timeStamp, Intensity = intensity, Steps = steps, Mode = mode, Runs = runs }; int ret = connection.InsertOrReplace(af); } return(true); }