public static void unsetActivityData(ActivityDataRecord rec)
{
if (!opened || rec.id == 0)
{
return;
}
string sql = String.Format("DELETE FROM activitiesData WHERE rowid={0}", rec.id);
Save(sql);
activitiesData.Remove(rec);
}
public ActivityUpdate(int id, int y, int m, int d)
{
InitializeComponent();
data = id == 0 ? new ActivityRecord() : Model.activities[id];
note = Model.activitiesData.Find(ad => ad.activityId == id && ad.y == y && ad.m == m && ad.d == d);
if (note == null)
{
note = new ActivityDataRecord();
note.d = d;
note.m = m;
note.y = y;
note.activityId = id;
}
}
public void SaveActivity(ActivityRecord rec, bool noteOn, ActivityDataRecord note)
{
if (rec.id == 0)
{
rec.y = year; rec.m = month; rec.d = day;
Model.insertActivity(rec);
}
else
{
Model.updateActivity(rec);
}
if (noteOn)
{
Model.setActivityData(note);
}
else
{
Model.unsetActivityData(note);
}
ShowDayLog(day);
}
public static void setActivityData(ActivityDataRecord rec)
{
if (!opened)
{
return;
}
string sql;
if (rec.id == 0)
{
sql = String.Format("INSERT INTO activitiesData (activityId,d,m,y,memo) VALUES ({0},{1},{2},{3},'{4}')",
rec.activityId, rec.d, rec.m, rec.y, s(rec.memo));
rec.id = Insert(sql);
activitiesData.Add(rec);
}
else
{
sql = String.Format("UPDATE activitiesData SET memo='{0}' WHERE id={1}", s(rec.memo), rec.id);
Save(sql);
var index = activitiesData.FindIndex(i => i.id == rec.id);
activitiesData[index].memo = rec.memo;
}
}
public static void loadActivitiesData()
{
activitiesData.Clear();
if (!opened)
{
return;
}
string sql = "SELECT rowid,activityId, d,m,y, memo FROM activitiesData";
var cmd = new SQLiteCommand(sql, db);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var item = new ActivityDataRecord();
item.id = Convert.ToInt32(reader["rowid"]);
item.activityId = Convert.ToInt32(reader["activityId"]);
item.d = Convert.ToInt32(reader["d"]);
item.m = Convert.ToInt32(reader["m"]);
item.y = Convert.ToInt32(reader["y"]);
item.memo = reader["memo"].ToString();
activitiesData.Add(item);
}
}
