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