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