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