public void UpdatePictureWall(string _id, string _description, DateTime _createTime, BitmapImage _image) { try { var db = App.myMidProject; using (var statement = db.Prepare("UPDATE PW SET Description = ?, CreateTime = ?, Image = ? WHERE Id = ?")) { statement.Bind(1, _description); statement.Bind(2, _createTime.ToString()); statement.Bind(3, _image.UriSource.ToString()); statement.Bind(4, _id); statement.Step(); } for (int x = 0; x < allPictureWalls.Count; x++) { if (allPictureWalls[x].id == _id) { selectedPictureWall = allPictureWalls[x]; allPictureWalls[x].createTime = _createTime; allPictureWalls[x].description = _description; allPictureWalls[x].image = _image; break; } } selectedPictureWall = null; } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
public void RemovePictureWall(string _id) { try { var db = App.myMidProject; using (var statement = db.Prepare("DELETE FROM PW WHERE Id = ?")) { statement.Bind(1, _id); statement.Step(); } for (int x = 0; x < allPictureWalls.Count; x++) { if (allPictureWalls[x].id == _id) { selectedPictureWall = allPictureWalls[x]; allPictureWalls.RemoveAt(x); break; } } selectedPictureWall = null; } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
public void loadAllItems() { var db = App.myMidProject; using (var statement = db.Prepare("SELECT Id, Description, CreateTime, Image FROM PW")) { while (SQLiteResult.ROW == statement.Step()) { if (statement.DataCount != 0) { var newitem = new Models.PictureWall((string)statement[0], (string)statement[1], (string)statement[3], (string)statement[2]); allPictureWalls.Add(newitem); } } } }
public void AddPictureWall(string _description, DateTime _createTime, BitmapImage _image) { var db = App.myMidProject; try { var tmp = new Models.PictureWall(_description, _image, _createTime); using (var statement = db.Prepare("INSERT INTO PW (Id, Description, CreateTime, Image) VALUES (?, ?, ?, ?)")) { statement.Bind(1, tmp.id); statement.Bind(2, tmp.description); statement.Bind(3, tmp.createTimeToString); statement.Bind(4, tmp.image.UriSource.ToString()); statement.Step(); } allPictureWalls.Add(tmp); } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }