public bool DoesEntityExist(string ctid, ref ThisEntity entity)
{
bool exists = false;
entity = EntityServices.GetByCtid(ctid);
if (entity != null && entity.Id > 0)
{
return(true);
}
return(exists);
}
public string Import(string startingDate, string endingDate, int maxRecords, string community, bool downloadOnly = false)
{
bool importingThisType = UtilityManager.GetAppKeyValue("importing_competency_frameworks", true);
if (!importingThisType)
{
LoggingHelper.DoTrace(1, "=== ***************** Skipping import of Competency Frameworks ***************** ");
return("Skipped import of competency_frameworks");
}
LoggingHelper.DoTrace(1, string.Format("=== ***************** {0} ***************** ", thisClassName));
JsonEntity input = new JsonEntity();
ReadEnvelope envelope = new ReadEnvelope();
List <ReadEnvelope> list = new List <ReadEnvelope>();
EntityServices mgr = new EntityServices();
string type = "competency_framework";
int pageNbr = 1;
int pageSize = 75;
string importError = "";
string importResults = "";
string importNote = "";
ThisEntity output = new ThisEntity();
List <string> messages = new List <string>();
//the nbr of records needs to be monitored, to determine the optimum
//NOTE: consider the IOER approach that all candidate records are first downloaded, and then a separate process does the import
int cntr = 0;
int pTotalRows = 0;
int exceptionCtr = 0;
string statusMessage = "";
bool isComplete = false;
bool importSuccessfull = true;
int newImportId = 0;
SaveStatus status = new SaveStatus();
//will need to handle multiple calls - watch for time outs
while (pageNbr > 0 && !isComplete)
{
list = RegistryServices.Search(type, startingDate, endingDate, pageNbr, pageSize, ref pTotalRows, ref statusMessage, community);
//list = GetLatest( type, startingDate, endingDate, pageNbr, pageSize, ref pTotalRows, ref statusMessage, community );
if (list == null || list.Count == 0)
{
isComplete = true;
if (pageNbr == 1)
{
importNote = "Competency Frameworks: No records where found for date range ";
//Console.WriteLine( thisClassName + importNote );
LoggingHelper.DoTrace(4, thisClassName + importNote);
}
break;
}
foreach (ReadEnvelope item in list)
{
cntr++;
string payload = item.DecodedResource.ToString();
LoggingHelper.DoTrace(2, string.Format("{0}. EnvelopeIdentifier: {1} ", cntr, item.EnvelopeIdentifier));
status = new SaveStatus();
status.DoingDownloadOnly = downloadOnly;
importError = "";
importSuccessfull = false;
try
{
//Console.WriteLine( string.Format( "{0}. Competency Frameswork Envelope Identifier {1} ", cntr, item.EnvelopeIdentifier ) );
importSuccessfull = entityImportMgr.ProcessEnvelope(mgr, item, status);
}
catch (Exception ex)
{
if (ex.Message.IndexOf("Path '@context', line 1") > 0)
{
importError = "The referenced registry document is using an old schema. Please republish it with the latest schema!";
status.AddError(importError);
}
else
{
LoggingHelper.LogError(ex, string.Format("Exception encountered in envelopeId: {0}", item.EnvelopeIdentifier), false, "CredentialFinder Import exception");
status.AddError(ex.Message);
importError = ex.Message;
LoggingHelper.DoTrace(1, " show exception to use getting related envelopeId " + ex.Message);
}
//make continue on exceptions an option
exceptionCtr++;
if (maxExceptions > 0 && exceptionCtr > maxExceptions)
{
//arbitrarily stop if large number of exceptions
importNote = string.Format(thisClassName + " - Many exceptions ({0}) were encountered during import - abandoning.", exceptionCtr);
Console.WriteLine(importNote);
LoggingHelper.DoTrace(1, importNote);
LoggingHelper.LogError(importNote, true, thisClassName + "- many exceptions");
isComplete = true;
break;
}
}
finally
{
if (!importSuccessfull)
{
if (string.IsNullOrWhiteSpace(importError))
{
importError = string.Join("\r\n", status.GetAllMessages().ToArray());
}
}
//store document
//add indicator of success
newImportId = importMgr.Add(item, entityTypeId, status.Ctid, importSuccessfull, importError, ref messages);
if (newImportId > 0 && status.Messages != null && status.Messages.Count > 0)
{
importMgr.AddMessages(newImportId, status, ref messages);
}
} //finally
if (maxRecords > 0 && cntr > maxRecords)
{
break;
}
} //end foreach
pageNbr++;
if ((maxRecords > 0 && cntr > maxRecords) || cntr == pTotalRows)
{
isComplete = true;
if (cntr < pTotalRows)
{
LoggingHelper.DoTrace(2, string.Format("CompetencyFramesworkImport EARLY EXIT. Completed {0} records out of a total of {1} ", cntr, pTotalRows));
}
}
} //
importResults = string.Format("{0} - Processed {1} records, with {2} exceptions. \r\n", thisClassName, cntr, exceptionCtr);
if (!string.IsNullOrWhiteSpace(importNote))
{
importResults += importNote;
}
//always call, as deletes are not tracked
if (UtilityManager.GetAppKeyValue("updateCompetencyFrameworkReportTotals", false) == true)
{
mgr.UpdateCompetencyFrameworkReportTotals();
}
return(importResults);
}
