private int GetSavedSearchArtifactID(int jobArtifactID) { int result = -1; try { string sql = string.Format(Database.Resources.CheckForJobSS, JobArtifactID.ToString()); var dbResult = WorkspaceDBConnection.ExecuteSqlStatementAsScalar(sql); if (dbResult != null) { result = (int)dbResult; } } catch (Exception) { throw; } return(result); }
private void UpdateStatusInQueue(int status) { string sql = null; try { sql = string.Format(Database.Resources.UpdateCasesQueue, status.ToString(), ArtifactID.ToString(), JobArtifactID.ToString()); EDDSDBConnection.ExecuteNonQuerySQLStatement(sql); } catch (Exception ex) { throw; } }
private void RemoveFromQueue() { string sql = null; try { sql = string.Format(Database.Resources.RemoveFromCasesQueue, ArtifactID.ToString(), JobArtifactID.ToString()); EDDSDBConnection.ExecuteNonQuerySQLStatement(sql); } catch (Exception ex) { throw; } }
private bool ValidateFileType(int jobArtifactID) { bool result = false; try { var fileTypeCode = GetFileTypeCode(); if (fileTypeCode != null) { string sql = string.Format(Database.Resources.CheckForFileType, fileTypeCode, JobArtifactID.ToString()); var dbResult = WorkspaceDBConnection.ExecuteSqlStatementAsScalar(sql); result = (int)dbResult > 0; } } catch (Exception ex) { throw ex; } return(result); }
private void RetrieveDocuments() { string sql = null; try { sql = string.Format(Database.Resources.RetrieveDocuments, ArtifactID.ToString(), JobArtifactID.ToString()); // Check for save search if (ValidateSavedSearh(JobArtifactID)) { var ssArtifactId = GetSavedSearchArtifactID(JobArtifactID); FilterBySavedSearch(ssArtifactId); sql = string.Concat(sql, " ", Database.Resources.SavedSearchFilter); } // Check for File type selection if (ValidateFileType(JobArtifactID)) { var fileTypeCode = GetFileTypeCode(); sql = string.Concat(sql, " ", string.Format(Database.Resources.FileTypeFilter, fileTypeCode, JobArtifactID)); } DocumentResult = WorkspaceDBConnection.ExecuteSqlStatementAsDataTable(sql, 300); //Reader = WorkspaceDBConnection.ExecuteSQLStatementAsReader(sql, 300); } catch (Exception ex) { throw; } }
private void CheckDocumentQueue() { string sql = null; object result = null; try { DocumentsQueued = false; sql = string.Format(Database.Resources.DoQueueRecordsExist, ArtifactID.ToString(), JobArtifactID.ToString()); result = EDDSDBConnection.ExecuteSqlStatementAsScalar(sql); if ((result != null)) { if (!System.DBNull.Value.Equals(result)) { DocumentsQueued = true; } } } catch (Exception ex) { throw; } }