private void OnFileChanged(object sender, FileSystemEventArgs e) { try { EnableRaisingEvents = false; var changedFile = new MediaFileInfo(e.FullPath); _conn.ExecuteUpdate( $"update files set hash = '{changedFile.Md5}' where path = '{changedFile.FullName}';" ); OnRenderRequested(EventArgs.Empty); } finally { EnableRaisingEvents = true; } }
private void OnFileCreated(object sender, FileSystemEventArgs e) { try { EnableRaisingEvents = false; var createdFile = new MediaFileInfo(e.FullPath); _conn.ExecuteUpdate("execute procedure addFile(" + $"'{createdFile.Name}'," + $"'{createdFile.FullName}'," + $"'{createdFile.Md5}');"); _conn.ExecuteUpdate($"execute procedure bindTagToFile('new', '{createdFile.FullName}')"); OnRenderRequested(EventArgs.Empty); } finally { EnableRaisingEvents = true; } }