public void AddMomentItem(Models.MomentModelItems x) { this.allItems.Insert(0, x); using (var conn = MomentDatabase.GetDbConnection()) { var Database = conn.Table <Models.MomentModelItems>(); conn.Insert(x); } NotifyPropertyChanged(); }
public void Clear() { this.allItems.Clear(); using (var conn = MomentDatabase.GetDbConnection()) { var Database = conn.Table <Models.MomentModelItems>(); foreach (var item in Database) { conn.Delete(item); } } }
public MomentViewModes() { using (var conn = MomentDatabase.GetDbConnection()) { var allDB = conn.Table <MomentModelItems>(); foreach (var item in allDB) { this.allItems.Add(new MomentModelItems() { id = item.id, User = item.User, Details = item.Details, Image = item.Image, BmpImage = new BitmapImage(new Uri("ms-appx://Midnight/" + item.Image)) }); } } }
public void AddMomentItem(string detail, string img) { Models.MomentModelItems theNew = new Models.MomentModelItems() { Details = detail, Image = img, BmpImage = new BitmapImage(new Uri("ms-appx://Midnight/" + img)) }; this.allItems.Insert(0, theNew); using (var conn = MomentDatabase.GetDbConnection()) { var Database = conn.Table <Models.MomentModelItems>(); conn.Insert(theNew); } NotifyPropertyChanged(); }
public MomentViewModes() { using (var conn = MomentDatabase.GetDbConnection()) { var allDB = conn.Table <MomentModelItems>(); int size = allDB.ToArray().Length; for (int i = size - 1; i >= 0; --i) { var item = allDB.ElementAt(i); this.allItems.Add(new MomentModelItems() { id = item.id, Details = item.Details, Image = item.Image, BmpImage = new BitmapImage(new Uri("ms-appx://Midnight/" + item.Image)) }); } } }