private void _buttonEditFolder_Click(object sender, RoutedEventArgs e) { if (_listBoxFolders.SelectedItem == null) { return; } System.Windows.Forms.FolderBrowserDialog dialog = new System.Windows.Forms.FolderBrowserDialog(); if (dialog == null) { return; } DBObject.ImagePath imagePath = _listBoxFolders.SelectedItem as DBObject.ImagePath; ViewModel.ConfigurationViewModel configurationViewModel = DataContext as ViewModel.ConfigurationViewModel; int index = configurationViewModel.ImagePaths.IndexOf(imagePath); dialog.SelectedPath = imagePath.path; if (dialog.ShowDialog() != System.Windows.Forms.DialogResult.OK) { return; } imagePath.path = dialog.SelectedPath; configurationViewModel.UpdateImagePath(imagePath); configurationViewModel.ImagePaths.RemoveAt(index); configurationViewModel.ImagePaths.Insert(index, imagePath); }
public bool Exists(DBObject.ImagePath imagePath) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("SELECT * FROM "); stringBuilder.Append(UseTableNameFix ? "\"tblImages\"" : "tblImages"); stringBuilder.Append(" WHERE image_database_id="); stringBuilder.Append(imagePath.id); return(_database.Query <DBObject.ImagePath>(stringBuilder.ToString()).Count() > 0); }
public void Delete(DBObject.ImagePath imagePath) { _database.Delete("tblImagesDatabase", "id", imagePath); }
public void Insert(DBObject.ImagePath imagePath) { imagePath.id = System.Convert.ToInt64(_database.Insert("tblImagesDatabase", "id", imagePath)); }