public List <File> GetFilesByFolderID(Int64 FolderID)
{
List <File> result = new List <File>();
using (SPKTDataContext dc = conn.GetContext())
{
IEnumerable <File> files1 = (from f in dc.Files
where f.DefaultFolderID == FolderID &&
dc.IsFlagged(5, f.FileID) != true
select f);
IEnumerable <File> files2 = (from f in dc.Files
join ff in dc.FolderFiles on f.FileID equals ff.FileID
where ff.FolderID == FolderID &&
dc.IsFlagged(5, f.FileID) != true
select f);
IEnumerable <File> files3 = files1.Union(files2);
result = files3.ToList();
foreach (File file in result)
{
var fileType = dc.FileTypes.Where(ft => ft.FileTypeID == file.FileTypeID).FirstOrDefault();
file.Extension = fileType.Name;
}
}
return(result);
}
