public static void AddFile(File file) { DataClassesDataContext db = new DataClassesDataContext(); file.id = GetNextId(); db.Files.InsertOnSubmit(file); db.SubmitChanges(); }
public static void UpdateFile(File file) { DataClassesDataContext db = new DataClassesDataContext(); db.Files.Where(u => u.id == file.id) .ToList() .ForEach(f => { f.name = file.name; f.type = file.type; f.is_public = file.is_public; }); db.SubmitChanges(); }
private void btnUpdate_Click(object sender, RoutedEventArgs e) { if ((Data.File)listFiles.SelectedItem == null) { MessageBox.Show("You have to selecta File"); } try { Data.File currentFile = (Data.File)listFiles.SelectedItem; String newText = txtFileContent.Text; Data.Database.updateFileContent(currentFile, newText); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnUpload_Click(object sender, RoutedEventArgs e) { try { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.Filter = "Text | *.txt"; bool?result = dlg.ShowDialog(); if (result == true) { string path = dlg.FileName; string filename = dlg.SafeFileName; string content = System.IO.File.ReadAllText(path); Data.File newFile = new Data.File(filename, content); Data.Database.InsertFile(newFile); } } catch (Exception ex) { } }
partial void DeleteFile(File instance);
partial void UpdateFile(File instance);
partial void InsertFile(File instance);
private void listFiles_SelectionChanged(object sender, SelectionChangedEventArgs e) { Data.File currentFile = (Data.File)listFiles.SelectedItem; txtFileContent.Text = currentFile.fileContent; }