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