public void RemoveFileFromMediaDatabase(string fName)
{
var mediaInfor = new MediaTable();
database.Execute("insert or replace into media values (?,?,?,?)",
new object[] { fName, null, 0, 1 });
}
public async Task MarkFileAdd(StorageFile file)
{
var mediaInfo = new MediaTable();
mediaInfo.CheckSum = await Checksum(file);
mediaInfo.ModifiedTime = await GetTimeLastModified(file);
mediaInfo.Dirty = 1;
mediaInfo.IsAdded = true;
mediaInfo.RelativePathName = file.Name;
database.InsertOrReplace(mediaInfo, typeof(MediaTable));
}
public void MarkFileRemoveIntoDatabase(string fName, long deckId, long?modifiedTime = null)
{
var mediaInfor = new MediaTable();
mediaInfor.RelativePathName = deckId.ToString() + DECK_NAME_SEPARATOR + fName;
mediaInfor.IsAdded = false;
mediaInfor.DeckId = deckId;
mediaInfor.Dirty = 1;
if (modifiedTime == null)
{
mediaInfor.ModifiedTime = DateTimeOffset.Now.ToUnixTimeSeconds();
}
else
{
mediaInfor.ModifiedTime = (long)modifiedTime;
}
database.InsertOrReplace(mediaInfor);
SetDatabaseModified();
}
public void MarkFileAddIntoDatabase(string fileName, long deckId, long?modifiedTime = null)
{
var mediaInfo = new MediaTable();
if (modifiedTime == null)
{
mediaInfo.ModifiedTime = DateTimeOffset.Now.ToUnixTimeSeconds();
}
else
{
mediaInfo.ModifiedTime = (long)modifiedTime;
}
mediaInfo.Dirty = 1;
mediaInfo.DeckId = deckId;
mediaInfo.IsAdded = true;
mediaInfo.RelativePathName = deckId.ToString() + DECK_NAME_SEPARATOR + fileName;
database.InsertOrReplace(mediaInfo, typeof(MediaTable));
SetDatabaseModified();
}
