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