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