public void UpdateMemorandum(string _id, string _content, DateTime _createTime) { try { var db = App.myMidProject; using (var statement = db.Prepare("UPDATE Mem SET Content = ?, CreateTime = ? WHERE Id = ?")) { statement.Bind(1, _content); statement.Bind(2, _createTime.ToString()); statement.Bind(3, _id); statement.Step(); } for (int x = 0; x < allMemorandums.Count; x++) { if (allMemorandums[x].id == _id) { selectedMemorandum = allMemorandums[x]; allMemorandums[x].content = _content; allMemorandums[x].createTime = _createTime; allMemorandums[x].createTimeToString = _createTime.ToString(); break; } } selectedMemorandum = null; } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
public void RemoveMemorandum(string _id) { try { var db = App.myMidProject; using (var statement = db.Prepare("DELETE FROM Mem WHERE Id = ?")) { statement.Bind(1, _id); statement.Step(); } for (int x = 0; x < allMemorandums.Count; x++) { if (allMemorandums[x].id == _id) { selectedMemorandum = allMemorandums[x]; allMemorandums.RemoveAt(x); break; } } selectedMemorandum = null; } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
public void loadALLMemToMemorandun() { var db = App.myMidProject; using (var statement = db.Prepare("SELECT Id, Content, CreateTime FROM Mem")) { while (SQLiteResult.ROW == statement.Step()) { if (statement.DataCount != 0) { var newitem = new Models.Memorandum((string)statement[0], (string)statement[1], (string)statement[2]); allMemorandums.Add(newitem); } } } }
public void AddMemorandum(string _content, DateTime _createTime) { var db = App.myMidProject; try { var tmp = new Models.Memorandum(_content, _createTime); using (var statement = db.Prepare("INSERT INTO Mem (Id, Content, CreateTime) VALUES (?, ?, ?)")) { statement.Bind(1, tmp.id); statement.Bind(2, tmp.content); statement.Bind(3, tmp.createTimeToString); statement.Step(); } allMemorandums.Add(tmp); } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }