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);
}
