//public IEnumerable<DocumentModel> SimplePassthroughQueryDocumentWithPath(string filename, string subject)
//{
// List<DocumentModel> documentModels = new List<DocumentModel>();
// QueryResult queryResult;
// try
// {
// string queryString = "select dm_document.r_object_id, dm_document.subject, dm_document.a_content_type,dm_document.object_name,dm_format.dos_extension from dm_document,dm_format where dm_document.a_content_type = dm_format.name";
// if ((!String.IsNullOrEmpty(filename)) && (!String.IsNullOrEmpty(subject)))
// {
// queryString = queryString + " and upper(object_name) like '%" + filename.ToUpper() + "%' and upper(subject) like '%" + subject.ToUpper() + "%'";
// }
// if ((!String.IsNullOrEmpty(filename)) && (String.IsNullOrEmpty(subject)))
// {
// queryString = queryString + " and upper(object_name) like '%" + filename.ToUpper() + "%'";
// }
// if ((String.IsNullOrEmpty(filename)) && (!String.IsNullOrEmpty(subject)))
// {
// queryString = queryString + " and upper(subject) like '%" + subject.ToUpper() + "%'";
// }
// int startingIndex = 0;
// int maxResults = 60;
// int maxResultsPerSource = 20;
// PassthroughQuery q = new PassthroughQuery();
// q.QueryString = queryString;
// q.AddRepository(DefaultRepository);
// QueryExecution queryExec = new QueryExecution(startingIndex,
// maxResults,
// maxResultsPerSource);
// queryExec.CacheStrategyType = CacheStrategyType.NO_CACHE_STRATEGY;
// queryResult = searchService.Execute(q, queryExec, null);
// QueryStatus queryStatus = queryResult.QueryStatus;
// RepositoryStatusInfo repStatusInfo = queryStatus.RepositoryStatusInfos[0];
// if (repStatusInfo.Status == Status.FAILURE)
// {
// // Console.WriteLine(repStatusInfo.ErrorTrace);
// documentModels.Add(new DocumentModel() { ObjectId = "0", ObjectName = repStatusInfo.ErrorMessage, Subject = repStatusInfo.ErrorTrace });
// }
// //Console.WriteLine("Query returned result successfully.");
// DataPackage dp = queryResult.DataPackage;
// //Console.WriteLine("DataPackage contains " + dp.DataObjects.Count + " objects.");
// foreach (DataObject dObj in dp.DataObjects)
// {
// PropertySet docProperties = dObj.Properties;
// String objectId = dObj.Identity.GetValueAsString();
// String docName = docProperties.Get("object_name").GetValueAsString();
// String Extension = docProperties.Get("dos_extension").GetValueAsString();
// string repName = dObj.Identity.RepositoryName;
// string docsubject = docProperties.Get("subject").GetValueAsString();
// //Console.WriteLine("RepositoryName: " + repName + " ,Document: " + objectId + " ,Name:" + docName + " ,Subject:" + docsubject);
// documentModels.Add(new DocumentModel() { ObjectId = objectId, ObjectName = docName+"."+Extension , Subject = docsubject });
// }
// }
// catch (Exception ex)
// {
// documentModels.Add(new DocumentModel() { ObjectId = "1", ObjectName = "SampleFile.txt", Subject = "This is a Sample" });
// }
// return documentModels;
//}
public void SimpleStructuredQuery(String docName)
{
String repoName = DefaultRepository;
Console.WriteLine("Called SimpleStructuredQuery - " + DefaultRepository);
PropertyProfile propertyProfile = new PropertyProfile();
propertyProfile.FilterMode = PropertyFilterMode.IMPLIED;
OperationOptions operationOptions = new OperationOptions();
operationOptions.Profiles.Add(propertyProfile);
// Create query
StructuredQuery q = new StructuredQuery();
q.AddRepository(repoName);
q.ObjectType = "dm_document";
q.IsIncludeHidden = true;
q.IsDatabaseSearch = true;
ExpressionSet expressionSet = new ExpressionSet();
expressionSet.AddExpression(new PropertyExpression("object_name",
Condition.CONTAINS,
docName));
q.RootExpressionSet = expressionSet;
// Execute Query
int startingIndex = 0;
int maxResults = 60;
int maxResultsPerSource = 20;
QueryExecution queryExec = new QueryExecution(startingIndex,
maxResults,
maxResultsPerSource);
QueryResult queryResult = searchService.Execute(q, queryExec, operationOptions);
QueryStatus queryStatus = queryResult.QueryStatus;
RepositoryStatusInfo repStatusInfo = queryStatus.RepositoryStatusInfos[0];
if (repStatusInfo.Status == Status.FAILURE)
{
Console.WriteLine(repStatusInfo.ErrorTrace);
throw new Exception("Query failed to return result.");
}
Console.WriteLine("Query returned result successfully.");
// print results
Console.WriteLine("DataPackage contains " + queryResult.DataObjects.Count + " objects.");
foreach (DataObject dataObject in queryResult.DataObjects)
{
Console.WriteLine(dataObject.Identity.GetValueAsString());
}
}
public QueryResult SimplePassthroughQueryDocument()
{
QueryResult queryResult;
string queryString = "select r_object_id, object_name from eifx_deliverable_doc";
int startingIndex = 0;
int maxResults = 60;
int maxResultsPerSource = 30;
PassthroughQuery q = new PassthroughQuery();
q.QueryString = queryString;
q.AddRepository(DefaultRepository);
QueryExecution queryExec = new QueryExecution(startingIndex,
maxResults,
maxResultsPerSource);
queryExec.CacheStrategyType = CacheStrategyType.NO_CACHE_STRATEGY;
queryResult = searchService.Execute(q, queryExec, null);
QueryStatus queryStatus = queryResult.QueryStatus;
RepositoryStatusInfo repStatusInfo = queryStatus.RepositoryStatusInfos[0];
if (repStatusInfo.Status == Status.FAILURE)
{
Console.WriteLine(repStatusInfo.ErrorTrace);
throw new Exception("Query failed to return result.");
}
Console.WriteLine("Query returned result successfully.");
DataPackage dp = queryResult.DataPackage;
Console.WriteLine("DataPackage contains " + dp.DataObjects.Count + " objects.");
foreach (DataObject dObj in dp.DataObjects)
{
//Console.WriteLine(dObj.Identity.GetValueAsString());
//
PropertySet docProperties = dObj.Properties;
String objectId = dObj.Identity.GetValueAsString();
String docName = docProperties.Get("object_name").GetValueAsString();
Console.WriteLine("Document " + objectId + " name is " + docName);
// result = result + Environment.NewLine + "Document " + objectId + " name is " + docName;
//lstCabinets.Add(new CabinetModel() { ObjectId = objectId, ObjectName = docName });
//
}
return(queryResult);
}
public QueryResult SimplePassthroughQuery()
{
QueryResult queryResult;
string queryString = "select distinct r_object_id from dm_document order by r_object_id ";
int startingIndex = 0;
int maxResults = 60;
int maxResultsPerSource = 20;
PassthroughQuery q = new PassthroughQuery();
q.QueryString = queryString;
q.AddRepository(DefaultRepository);
QueryExecution queryExec = new QueryExecution(startingIndex,
maxResults,
maxResultsPerSource);
queryExec.CacheStrategyType = CacheStrategyType.NO_CACHE_STRATEGY;
queryResult = searchService.Execute(q, queryExec, null);
QueryStatus queryStatus = queryResult.QueryStatus;
RepositoryStatusInfo repStatusInfo = queryStatus.RepositoryStatusInfos[0];
if (repStatusInfo.Status == Status.FAILURE)
{
Console.WriteLine(repStatusInfo.ErrorTrace);
throw new Exception("Query failed to return result.");
}
Console.WriteLine("Query returned result successfully.");
DataPackage dp = queryResult.DataPackage;
Console.WriteLine("DataPackage contains " + dp.DataObjects.Count + " objects.");
foreach (DataObject dataObject in dp.DataObjects)
{
Console.WriteLine(dataObject.Identity.GetValueAsString());
}
return(queryResult);
}
/// <summary>
/// Ricerca fulltext nell'oggetto document
///
/// nb: da fare anche ricerca allegati
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public ArrayList FullTextSearch(ref FullTextSearchContext context)
{
ArrayList result = new ArrayList();
try
{
List <string> fullTextResult = null;
if (context.SearchResultList != null && context.SearchResultList.Length > 0)
{
// Ricerca già effettuata, reperimento dall'oggetto di contesto
// dei risultati precedenti evitando così una dispendiosa
// chiamata al sistema documentale
fullTextResult = new List <string>(context.SearchResultList);
}
else
{
StructuredQuery strQuery = new StructuredQuery();
strQuery.AddRepository(DctmConfigurations.GetRepositoryName());
strQuery.ObjectType = ObjectTypes.DOCUMENTO;
strQuery.IsDatabaseSearch = false;
strQuery.IsIncludeAllVersions = false;
strQuery.IsIncludeHidden = false;
// Inserisce nella ricerca il solo cabinet dell'amministrazione
RepositoryScope repositoryScope = new RepositoryScope();
repositoryScope.RepositoryName = DctmConfigurations.GetRepositoryName();
repositoryScope.LocationPath = DocsPaAdminCabinet.getRootAmministrazione(this.InfoUtente);
repositoryScope.IsDescend = true;
strQuery.Scopes.Add(repositoryScope);
ExpressionSet set = new ExpressionSet();
set.AddExpression(new FullTextExpression(context.TextToSearch));
strQuery.RootExpressionSet = set;
// Query execution
int startIndex = (context.RequestedPageNumber * PAGE_SIZE) - PAGE_SIZE;
int maxResults = this.GetMaxRowCount();
QueryExecution queryExec = new QueryExecution(startIndex, maxResults, maxResults);
ISearchService searchService = DctmServiceFactory.GetServiceInstance <ISearchService>(this.InfoUtente.dst);
QueryResult queryResult = searchService.Execute(strQuery, queryExec, null);
QueryStatus queryStatus = queryResult.QueryStatus;
RepositoryStatusInfo repStatusInfo = queryResult.QueryStatus.RepositoryStatusInfos[0];
if (repStatusInfo.Status == Status.FAILURE)
{
throw new ApplicationException("QueryResult: Status.FAILURE");
}
fullTextResult = new List <string>();
foreach (DataObject dataObject in queryResult.DataObjects)
{
// Reperimento docnumber
string docNumber = dataObject.Properties.Get(TypeDocumento.DOC_NUMBER).GetValueAsString();
if (!fullTextResult.Contains(docNumber)) // Eliminazione dei risultati duplicati
{
fullTextResult.Add(docNumber);
}
}
context.SearchResultList = fullTextResult.ToArray();
context.TotalPageNumber = (fullTextResult.Count / PAGE_SIZE);
context.TotalRecordCount = fullTextResult.Count;
}
// Paginazione dei risultati
if (fullTextResult != null && fullTextResult.Count > 0)
{
int startIndex = (context.RequestedPageNumber * PAGE_SIZE) - PAGE_SIZE;
int count = PAGE_SIZE;
if (fullTextResult.Count < count)
{
count = fullTextResult.Count;
}
List <string> pageContent = fullTextResult.GetRange(startIndex, count);
result = this.GetDocuments(pageContent.ToArray(), InfoUtente);
}
}
catch (Exception ex)
{
result.Clear();
logger.Debug(string.Format("Errore in Documentum.FullTextSearch:\n{0}", ex.ToString()));
}
return(result);
}
public IEnumerable <DocumentModel> SimplePassthroughQueryDocumentWithPath_New(SearchModel search)
{
List <DocumentModel> documentModels = new List <DocumentModel>();
try
{
//string queryString = "select dm_document.r_object_id, dm_document.subject, dm_document.a_content_type,dm_document.object_name,dm_format.dos_extension from dm_document,dm_format where dm_document.a_content_type = dm_format.name";
//string queryString = " select r_object_id, eifx_deliverable_doc.r_modify_date, eifx_deliverable_doc.r_creation_date, object_name, title, eif_revision, er_package_name, eif_issue_reason, er_contract_number, eif_originator, eif_discipline, eif_acceptance_code, er_actual_sub_date from eifx_deliverable_doc ";
string queryStringCount = " select count(r_object_id) as totalcount from eifx_deliverable_doc,dm_document,dm_format where eifx_deliverable_doc.r_object_id = dm_document.r_object_id and dm_document.a_content_type = dm_format.name ";
string queryString = " select r_object_id ,title ,object_name,dm_document.r_creation_date as creationdate"
+ ", dm_document.r_modify_date as modifydate, eif_date_due, eif_acceptance_code, eif_area, eif_revision"
+ ", eif_issue_reason, eif_discipline, eif_originator, eif_type_of_doc, eif_project_ref"
+ ", er_actual_sub_date, er_wbs_level3, er_wbs_level4, er_package_name, er_contract_number"
+ ", dm_document.subject, dm_document.a_content_type, dm_format.dos_extension from eifx_deliverable_doc,dm_document,dm_format where eifx_deliverable_doc.r_object_id = dm_document.r_object_id and dm_document.a_content_type = dm_format.name ";
// string queryString = " select eifx_deliverable_doc.r_object_id ,eifx_deliverable_doc.title ,eifx_deliverable_doc.object_name,eifx_deliverable_doc.r_creation_date"
//+ ",eifx_deliverable_doc.r_modify_date,eifx_deliverable_doc.eif_date_due,eifx_deliverable_doc.eif_acceptance_code,eifx_deliverable_doc.eif_area,eifx_deliverable_doc.eif_revision"
//+ ",eifx_deliverable_doc.eif_issue_reason,eifx_deliverable_doc.eif_discipline,eifx_deliverable_doc.eif_originator,eifx_deliverable_doc.eif_type_of_doc,eifx_deliverable_doc.eif_project_ref"
//+ ",eifx_deliverable_doc.er_actual_sub_date,eifx_deliverable_doc.er_wbs_level3,eifx_deliverable_doc.er_wbs_level4,eifx_deliverable_doc.er_package_name,eifx_deliverable_doc.er_contract_number"
//+ ",dm_document.subject,dm_document.a_content_type,dm_format.dos_extensionfrom eifx_deliverable_doc,dm_document,dm_format ";
//where eifx_deliverable_doc.r_object_id = dm_document.r_object_id and dm_document.a_content_type = dm_format.name
if (!string.IsNullOrEmpty(search.ContractNumber))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " er_contract_number like '%" + search.ContractNumber + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " er_contract_number like '%" + search.ContractNumber + "%' ";
}
if (!string.IsNullOrEmpty(search.DocumentNumber))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " object_name like '%" + search.DocumentNumber + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " object_name like '%" + search.DocumentNumber + "%' ";
}
if (!string.IsNullOrEmpty(search.DocumentTitle))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " title like '%" + search.DocumentTitle + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " title like '%" + search.DocumentTitle + "%' ";
}
if (!string.IsNullOrEmpty(search.PackageName))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.er_package_name like '%" + search.PackageName + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.er_package_name like '%" + search.PackageName + "%' ";
}
if (!string.IsNullOrEmpty(search.DocumentType))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_type_of_doc like '%" + search.DocumentType + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_type_of_doc like '%" + search.DocumentType + "%' ";
}
if (!string.IsNullOrEmpty(search.DocumentAcceptanceStatus))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_acceptance_code like '%" + search.DocumentAcceptanceStatus + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_acceptance_code like '%" + search.DocumentAcceptanceStatus + "%' ";
}
if (!string.IsNullOrEmpty(search.Originator))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_originator like '%" + search.Originator + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_originator like '%" + search.Originator + "%' ";
}
if (!string.IsNullOrEmpty(search.Area))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_area like '%" + search.Area + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_area like '%" + search.Area + "%' ";
}
if (!string.IsNullOrEmpty(search.Revision))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_revision like '%" + search.Revision + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_revision like '%" + search.Revision + "%' ";
}
if (!string.IsNullOrEmpty(search.Discipline))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_discipline like '%" + search.Discipline + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_discipline like '%" + search.Discipline + "%' ";
}
////if (!string.isnullorempty(search.filename))
////{
//// querystring = querystring + (querystring.contains("where") ? " and " : " where ") + " er_contract_number like '%" + search.filename + "%' ";
////}
if (!string.IsNullOrEmpty(search.ProjectReference))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_project_ref like '%" + search.ProjectReference + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_project_ref like '%" + search.ProjectReference + "%' ";
}
if (!string.IsNullOrEmpty(search.IssueReason))
{
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_issue_reason like '%" + search.IssueReason + "%' ";
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + " eifx_deliverable_doc.eif_issue_reason like '%" + search.IssueReason + "%' ";
}
////if (!string.isnullorempty(search.supersearch))
////{
//// querystring = querystring + (querystring.contains("where") ? " and " : " where ") + " er_contract_number like '" + search.supersearch + "' ";
////}
////if (!string.isnullorempty(search.location))
////{
//// querystring = querystring + (querystring.contains("where") ? " and " : " where ") + " er_contract_number like '" + search.location + "' ";
////}
if ((!String.IsNullOrEmpty(search.DateRangeDay)) && (!String.IsNullOrEmpty(search.DateRangeType)))
{
string type = "";
if (search.DateRangeType.ToLower() == "modified date")
{
type = "dm_document.r_modify_date";
}
else if (search.DateRangeType.ToLower() == "created date")
{
type = "dm_document.r_creation_date";
}
else if (search.DateRangeType.ToLower() == "yymsg_date_submittedyy")
{
type = " er_actual_sub_date";
}
else if (search.DateRangeType.ToLower() == "yymsg_duedateyy")
{
type = "eif_date_due";
}
if (search.DateRangeDay.ToLower() == "today")
{
type = type + " >= DATE('" + DateTime.Today.ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + DateTime.Today.ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + DateTime.Today.ToString("MM/dd/yyyy 00:00:00") + " and " + DateTime.Today.ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "yesterday")
{
type = type + " >= DATE('" + DateTime.Today.AddDays(-1).ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + DateTime.Today.AddDays(-1).ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + DateTime.Today.AddDays(-1).ToString("MM/dd/yyyy 00:00:00") + " and " + DateTime.Today.AddDays(-1).ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "last 7 days")
{
type = type + " >= DATE('" + DateTime.Today.AddDays(-7).ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + DateTime.Today.AddDays(-7).ToString("MM/dd/yyyy 00:00:00") + " and " + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "last 30 days")
{
type = type + " >= DATE('" + DateTime.Today.AddDays(-30).ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + DateTime.Today.AddDays(-30).ToString("MM/dd/yyyy 00:00:00") + " and " + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "last 90 days")
{
type = type + " >= DATE('" + DateTime.Today.AddDays(-90).ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + DateTime.Today.AddDays(-90).ToString("MM/dd/yyyy 00:00:00") + " and " + DateTime.Today.AddDays(0).ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "between")
{
type = type + " >= DATE('" + search.DateRangeFrom.ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + search.DateRangeTo.ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
}
else if (search.DateRangeDay.ToLower() == "before")
{
type = type + " <= DATE('" + search.DateRangeTo.ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " <= " + search.DateRangeTo.ToString("MM/dd/yyyy 23:59:00");
}
else if (search.DateRangeDay.ToLower() == "after")
{
type = type + " >= DATE('" + search.DateRangeTo.ToString("MM/dd/yyyy 00:00:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " >= " + search.DateRangeFrom.ToString("MM/dd/yyyy 00:00:00");
}
else if (search.DateRangeDay.ToLower() == "on")
{
type = type + " >= DATE('" + search.DateRangeFrom.ToString("MM/dd/yyyy 00:00:00") + "' , 'MM/dd/yyyy HI:mm:ss') and " + type + " <= DATE('" + search.DateRangeFrom.ToString("MM/dd/yyyy 23:59:00") + "','MM/dd/yyyy HI:mm:ss')";
//type = type + " between " + search.DateRangeFrom.ToString("MM/dd/yyyy 00:00:00") + " and " + search.DateRangeFrom.ToString("MM/dd/yyyy 23:59:00");
}
queryString = queryString + (queryString.Contains("where") ? " and " : " where ") + type;
queryStringCount = queryStringCount + (queryStringCount.Contains("where") ? " and " : " where ") + type;
}
//Logger.WriteLog("QueryStringCount is: " + queryStringCount);
int startingIndex = search.PageNumber;
int maxResults = search.PageSize;
int maxResultsPerSource = search.PageSize;
PassthroughQuery q = new PassthroughQuery();
PassthroughQuery qCount = new PassthroughQuery();
qCount.QueryString = queryStringCount;
qCount.AddRepository(DefaultRepository);
q.QueryString = queryString;
q.AddRepository(DefaultRepository);
QueryExecution queryExecCount = new QueryExecution(0, 10, 10);
QueryResult queryResultCount = searchService.Execute(qCount, queryExecCount, null);
DataPackage dpCount = queryResultCount.DataPackage;
List <DataObject> dpCountObject = dpCount.DataObjects;
//Logger.WriteLog("Total objects returned is: " + dpCountObject.Count);
int totalObjCount = 0;
foreach (DataObject dpCountObj in dpCountObject)
{
PropertySet dpCountProperties = dpCountObj.Properties;
totalObjCount = Convert.ToInt32(dpCountProperties.Get("totalcount").GetValueAsObject());
}
//Logger.WriteLog("totalObjCount is " + totalObjCount);
QueryExecution queryExec = new QueryExecution(startingIndex,
maxResults,
maxResultsPerSource);
queryExec.CacheStrategyType = CacheStrategyType.NO_CACHE_STRATEGY;
QueryResult queryResult = searchService.Execute(q, queryExec, null);
//QueryResult queryResult = queryService.Execute(query, queryEx,
// operationOptions);
QueryStatus queryStatus = queryResult.QueryStatus;
RepositoryStatusInfo repStatusInfo = queryStatus.RepositoryStatusInfos[0];
//Console.WriteLine("Query returned result successfully.");
DataPackage dp = queryResult.DataPackage;
//Console.WriteLine("DataPackage contains " + dp.DataObjects.Count + " objects.");
//Logger.WriteLog("SearchDocuments 353 " + dp.DataObjects.Count);
if (repStatusInfo.Status == Status.FAILURE)
{
//Logger.WriteLog("SearchDocuments 357 " + repStatusInfo.Status);
// Console.WriteLine(repStatusInfo.ErrorTrace);
documentModels.Add(new DocumentModel()
{
ObjectId = "0", ObjectName = repStatusInfo.ErrorMessage, DocumentTitle = repStatusInfo.Name, DocumentNumber = repStatusInfo.Name, TotalCount = 1
});
}
if (dp.DataObjects.Count == 0)
{
//Logger.WriteLog("SearchDocuments 364 " + dp.DataObjects.Count);
documentModels.Add(new DocumentModel()
{
ObjectId = "", ObjectName = "", DocumentTitle = "", DocumentNumber = "No record", TotalCount = 0
});
}
//Logger.WriteLog("SearchDocuments 364 " + dp.DataObjects.Count);
foreach (DataObject dObj in dp.DataObjects)
{
PropertySet docProperties = dObj.Properties;
//foreach (var item in docProperties.Properties)
//{
// Logger.WriteLog("DataObjects " + item.Name);
//}
String objectId = dObj.Identity.GetValueAsString();
String docName = docProperties.Get("object_name").GetValueAsString();
String Extension = "PDF"; //docProperties.Get("dos_extension").GetValueAsString();
string repName = dObj.Identity.RepositoryName;
string doctitle = docProperties.Get("title").GetValueAsString();
string docNumber = docProperties.Get("object_name").GetValueAsString();
//Console.WriteLine("RepositoryName: " + repName + " ,Document: " + objectId + " ,Name:" + docName + " ,Subject:" + docsubject);
string revision = docProperties.Get("eif_revision").GetValueAsString();
string creationDate = docProperties.Get("creationdate").GetValueAsString();
string modifiedDate = docProperties.Get("modifydate").GetValueAsString();
string package = docProperties.Get("er_package_name").GetValueAsString();
string issueReason = docProperties.Get("eif_issue_reason").GetValueAsString();
string contract = docProperties.Get("er_contract_number").GetValueAsString();
string originator = docProperties.Get("eif_originator").GetValueAsString();
string discipline = docProperties.Get("eif_discipline").GetValueAsString();
string acceptanceCode = docProperties.Get("eif_acceptance_code").GetValueAsString();
string actualSubDate = docProperties.Get("er_actual_sub_date").GetValueAsString();
//try
//{
// Logger.WriteLog("SearchDocuments Before er_actual_sub_date Date ");
// Logger.WriteLog("SearchDocuments Before er_actual_sub_date Date 1 ");
// //Logger.WriteLog("SearchDocuments r_creation_date " + docProperties.Get("r_creation_date").ToString());
// Logger.WriteLog("SearchDocuments er_actual_sub_date 2" + docProperties.Get("er_actual_sub_date").GetValueAsString());
// Logger.WriteLog("SearchDocuments after er_actual_sub_date Date ");
//}
//catch (Exception ex)
//{
// Logger.WriteLog("SearchDocuments r_creation_date Exception" + ex.Message);
//}
documentModels.Add(new DocumentModel()
{
ObjectId = objectId,
ObjectName = docName + "." + Extension,
DocumentTitle = doctitle,
DocumentNumber = docNumber,
Revision = revision,
AcceptanceCode = acceptanceCode,
ActualSubDate = actualSubDate,
Contract = contract,
CreationDate = creationDate,
ModifiedDate = modifiedDate,
Discipline = discipline,
IssueReason = issueReason,
Originator = originator,
Package = package,
TotalCount = totalObjCount
});
}
//queryExec.StartingIndex += search.PageSize;
//Logger.WriteLog("SearchDocuments 301 " + q);
//Logger.WriteLog("SearchDocuments 302 " + q);
}
catch (Exception ex)
{
documentModels.Add(new DocumentModel()
{
ObjectId = "1", ObjectName = ex.Message, DocumentTitle = ex.StackTrace, DocumentNumber = "XXXX-1FD-345-QWE",
Revision = "Rev983475",
AcceptanceCode = "TRRTT",
ActualSubDate = "21-09-2020",
Contract = "P34242-Contract",
CreationDate = "21-09-2020",
ModifiedDate = "21-09-2020",
Discipline = "FR8530498",
IssueReason = "Approved",
Originator = "Mark Boyle",
Package = "DFGH54938",
TotalCount = 1
});
Logger.WriteLog("SearchDocuments searchServiceDemo " + ex.InnerException.ToString() + Environment.NewLine +
ex.GetBaseException().ToString() + Environment.NewLine +
ex.GetType().ToString());
}
return(documentModels);
}
