protected override ScannedFiles GetFromSQLDb(byte processType)
{
FilesYetToProcessTableAdapter filesYetToProcessTableAdapter = new FilesYetToProcessTableAdapter();
ScannedFile scannedfile = new ScannedFile();
ScannedFiles scannedfiles = new ScannedFiles();
ApplicationSettings appSettings = new ApplicationSettings();
filesYetToProcessTableAdapter.Connection.ConnectionString = appSettings.getDbConnectionString();
dsFFC.FilesYetToProcessDataTable filesYetToProcess = filesYetToProcessTableAdapter.GetData(processType);
foreach (dsFFC.FilesYetToProcessRow file in filesYetToProcess.Rows)
{
scannedfile = new ScannedFile();
scannedfile.FileId = file.fileId;
scannedfile.Filename = file.fileName;
scannedfile.Filepath = file.filePath;
scannedfile.LastWriteTime = file.lastWriteTime;
scannedfile.LastAccessTime = file.lastAccessedDate;
scannedfile.Filesize = file.fileSize;
scannedfile.doUpdateRequireOnRescan = true;
scannedfile.performedAction = processType == 1 ? enums.ActionToPerform.FileForNextIteration : enums.ActionToPerform.FileFailedToDelete;
scannedfiles.Add(scannedfile);
}
return(scannedfiles);
}
public int Update(ScannedFile file, byte processType, string comments)
{
FilesYetToProcessTableAdapter filesYetToProcessTableAdapter = new FilesYetToProcessTableAdapter();
ApplicationSettings appSettings = new ApplicationSettings();
filesYetToProcessTableAdapter.Connection.ConnectionString = appSettings.getDbConnectionString();
return(filesYetToProcessTableAdapter.updateFileWhichWasYetToProcess(comments, processType, file.Filename, file.Filepath, file.FileId));
}
protected override void SaveToSQLDb(ScannedFile file, byte processType)
{
FilesYetToProcessTableAdapter filesYetToProcessTableAdapter = new FilesYetToProcessTableAdapter();
ApplicationSettings appSettings = new ApplicationSettings();
filesYetToProcessTableAdapter.Connection.ConnectionString = appSettings.getDbConnectionString();
if (!file.doUpdateRequireOnRescan)
{
filesYetToProcessTableAdapter.Insert(file.Filename, file.Filepath, DateTime.Now, String.Empty, "SYSTEM", processType, file.LastAccessTime, file.LastWriteTime, file.Filesize);
}
else
{
//only when failed to delete. this could be file no longer exists in directory.
if (processType == 2)
{
string comments = "No action taken, this could be file no longer exists in directory or inaccessible.";
this.Update(file, 3, comments);
}
}
}
