private void frmErga_Single_DragDrop(object sender, DragEventArgs e) { if (e.Data.GetDataPresent(DataFormats.FileDrop)) { string[] filePaths = (string[])(e.Data.GetData(DataFormats.FileDrop)); foreach (string fileLoc in filePaths) { // Code to read the contents of the text file if (File.Exists(fileLoc)) { using (TextReader tr = new StreamReader(fileLoc)) { tblFileDap newDap = new tblFileDap(); long fldFileId = newDap.InsertFile(fileLoc, 1, DateTime.Now); tblProjectFileDap newProjectFileDap = new tblProjectFileDap(); tblProjectFile ProjectFile = new tblProjectFile(); ProjectFile.fldFileID = fldFileId; ProjectFile.fldProjectID = _tblProject.fldProjectID; newProjectFileDap.Insert(ProjectFile); List<vwvwProjectFile> listOfFiles = new List<vwvwProjectFile>(); vwvwProjectFileDap ProjectFileDap = new vwvwProjectFileDap(); listOfFiles = ProjectFileDap.GetProjectFiles(_tblProject.fldProjectID); bsFiles.DataSource = listOfFiles; } } } } }
private void gdDocs_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e) { MessageBox.Show(e.Cell.Row.Cells["fldFileID"].Value.ToString()); long fldFileID = (long)e.Cell.Row.Cells["fldFileID"].Value; tblFileDap FileDap = new tblFileDap(); tblFile file = FileDap.GetByfldFileID(fldFileID); string filename = Path.GetFileName( file.fldFileName); filename = Path.Combine(globals.tempPath, filename); FileDap.RetrieveFile((long)e.Cell.Row.Cells["fldFileID"].Value, filename); }
public tblFile GettblFileByfldFileID(Int64 fldFileID) { using (var dap = new tblFileDap(this)) { return dap.GetByfldFileID(fldFileID); } }