public List<FileNames> GetFiles()
{
var user = User.FindByLoginId(System.Web.HttpContext.Current.User.Identity.Name);
var lstFiles = new List<FileNames>();
var dirInfo = new DirectoryInfo(HostingEnvironment.MapPath(_storageLocation));
int i = 0;
foreach (var item in dirInfo.GetFiles())
{
lstFiles.Add(new FileNames()
{
FileId = i + 1,
FileName = item.Name,
TimeStamp = item.CreationTime,
FilePath = dirInfo.FullName + @"\" + item.Name
});
i = i + 1;
}
using (var db = new FISDataMartEntities())
{
var unitFiles = db.UnitFiles.ToList();
foreach (var file in lstFiles)
{
var unitFileResult = unitFiles.FirstOrDefault(u => u.Filename.Equals(file.FileName));
if (unitFileResult != null)
{
file.CreatedBy = unitFileResult.CreatedBy;
file.Uploaded = unitFileResult.Uploaded;
file.UploadedBy = unitFileResult.UploadedBy;
file.SchoolCode = unitFileResult.SchoolCode;
}
}
}
return lstFiles;
}