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