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