public static void ReadProcessFileList(Dictionary <string, clsFileList> verifyFiles, Utils.FileStatus fileStatus)
{
WindART_SMIDataContext windARTDataContext = new WindART_SMIDataContext();
var processFilesCollection = from processFiles in windARTDataContext.ProcessFiles
where processFiles.FileStatus == (int)fileStatus
select processFiles;
foreach (var pf in processFilesCollection)
{
clsFileList fl = new clsFileList();
fl.FullFilePath = pf.Name;
fl.FileLocationId = (int)pf.FileLocationId;
if (pf.FileFormatId != null)
{
fl.FileFormatId = (int)pf.FileFormatId;
}
//fl.Encrypted = pf.Encrypted.Equals('Y'); // should be a bool
fl.ProcessFileId = pf.ProcessFileId;
if (pf.SiteId != null)
{
fl.SiteId = (int)pf.SiteId;
}
// never add the same file twice
if (!verifyFiles.Keys.Contains(fl.FullFilePath))
{
verifyFiles.Add(fl.FullFilePath, fl);
}
}
}
public static void CopyFilesToDocumentLibrary(clsFileList cfl, Utils.FileStatus status, string logProcessName)
{
Dictionary <string, clsFileList> importFiles = new Dictionary <string, clsFileList>();
importFiles.Add(cfl.FullFilePath, cfl);
CopyFilesToDocumentLibrary(importFiles, status, logProcessName);
}
//static string rootLocation = @"D:\";
public static void RecordFileDetailsInDB(clsFileList cfl, string logProcessName)
{
Dictionary <string, clsFileList> importFiles = new Dictionary <string, clsFileList>();
importFiles.Add(cfl.FullFilePath, cfl);
RecordFileDetailsInDB(importFiles, logProcessName);
}
public static Utils.FileStatus GetNextFileStatus(clsFileList cf)
{
if (cf.IsExcel())
{
return(Utils.FileStatus.ReadyForConvertion);
}
else if (cf.Encrypted)
{
return(Utils.FileStatus.ReadyForDecyption);
}
else
{
return(Utils.FileStatus.ReadyForImport);
}
}
public static void UpdateStatusInDB(clsFileList updateFile, FileStatus newStatus)
{
WindART_SMIDataContext windARTDataContext = new WindART_SMIDataContext();
var ProcessedFilesQuery = from processedFiles in windARTDataContext.ProcessFiles
where processedFiles.ProcessFileId == updateFile.ProcessFileId
select processedFiles;
// set db status
// there should be only one, but do a foreach anyway
foreach (ProcessFile pf in ProcessedFilesQuery)
{
pf.FileStatus = (int)newStatus;
}
windARTDataContext.SubmitChanges();
}
public static void DeleteMissingFileinDB(clsFileList updateFile)
{
WindART_SMIDataContext windARTDataContext = new WindART_SMIDataContext();
var ProcessedFilesQuery = from processedFiles in windARTDataContext.ProcessFiles
where processedFiles.ProcessFileId == updateFile.ProcessFileId
select processedFiles;
// set db status
// there should be only one, but do a foreach anyway
foreach (ProcessFile pf in ProcessedFilesQuery)
{
windARTDataContext.ProcessFiles.DeleteOnSubmit(pf);
}
windARTDataContext.SubmitChanges();
}
public static void ReadProcessFileList(Dictionary <string, clsFileList> verifyFiles, Utils.FileStatus fileStatus)
{
WindART_SMIDataContext windARTDataContext = new WindART_SMIDataContext();
var processFilesCollection = from processFiles in windARTDataContext.ProcessFiles
where processFiles.FileStatus == (int)fileStatus
select processFiles;
//Console.WriteLine("just before iterating results from processfile");
//Console.ReadLine();
foreach (var pf in processFilesCollection)
{
clsFileList fl = new clsFileList();
fl.FullFilePath = pf.Name;
//****comment out for production
// fl.FullFilePath = pf.Name.Replace(@"D:\", @"\\10.254.13.3\");
//***************************
fl.FileLocationId = (int)pf.FileLocationId;
if (pf.FileFormatId != null)
{
fl.FileFormatId = (int)pf.FileFormatId;
}
//fl.Encrypted = pf.Encrypted.Equals('Y'); // should be a bool
fl.ProcessFileId = pf.ProcessFileId;
if (pf.SiteId != null)
{
fl.SiteId = (int)pf.SiteId;
}
// never add the same file twice
if (!verifyFiles.Keys.Contains(fl.FullFilePath))
{
verifyFiles.Add(fl.FullFilePath, fl);
}
fl.FullFilePath = pf.Name.Replace(@"\\10.254.13.3\", @"D:\");
}
// Console.WriteLine("built list of files successfully");
//Console.ReadLine();
}
