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