public int DeleteRecentByGuid(Recent item) { lock (locker) { return database.Query<Recent>("DELETE FROM [RECENT] Where Name = '" + item.Name + "' and RelativePath = '" + item.RelativePath + "'").Count; } }
public int SaveItem(Recent item) { lock (locker) { if (item.Id != 0) { database.Update(item); return item.Id; } else { return database.Insert(item); } } }
private void UpdateRecentList(Recent recentItem) { try { var database = new RecentDatabase(); database.DeleteRecentByGuid(recentItem); database.SaveItem(recentItem); var lstRecentDocuments = database.GetItems(); while (RecentListHelper.RecentList.Any()) RecentListHelper.RecentList.RemoveAt(RecentListHelper.RecentList.Count - 1); foreach (var item in lstRecentDocuments.OrderByDescending(x => x.Id)) { RecentListHelper.RecentList.Add(item); } } catch (Exception ex) { Alert (ex.Message); } }
public TransformImageViewModel(Document selecteDocument) : base() { try { DocName = selecteDocument.Name; CurrentPickerPage = _currentPage.ToString(); Task.Run(() => RefreshImage(_currentPage, selecteDocument.Name, selecteDocument.RelativePath, true)); var recentItem = new Recent() { Ext = selecteDocument.Ext, Name = selecteDocument.Name, CreatedBy = selecteDocument.CreatedBy, CreatedDateTime = selecteDocument.CreatedDateTime, Size = selecteDocument.Size, ModifiedBy = selecteDocument.ModifiedBy, ModifiedDateTime = selecteDocument.ModifiedDateTime, LibraryGuid = selecteDocument.LibraryGuid, RelativePath = selecteDocument.RelativePath }; UpdateRecentList(recentItem); } catch (Exception ex) { Alert (ex.Message); } }