} //
public static ThisEntity GetByCtid(string ctid)
{
ThisEntity entity = new ThisEntity();
if (string.IsNullOrWhiteSpace(ctid))
{
return(entity);
}
try
{
using (var context = new EntityContext())
{
//lookup by SubjectWebpage, or SourceUrl
DBEntity item = context.TransferValueProfile
.FirstOrDefault(s => s.CTID.ToLower() == ctid.ToLower());
if (item != null && item.Id > 0)
{
MapFromDB(item, entity);
}
}
}
catch (Exception ex)
{
LoggingHelper.LogError(ex, thisClassName + ".GetByCtid: " + ctid);
}
return(entity);
} //
/// <summary>
/// Get a competency record
/// </summary>
/// <param name="profileId"></param>
/// <returns></returns>
public static ThisEntity Get(int profileId)
{
ThisEntity entity = new ThisEntity();
if (profileId == 0)
{
return(entity);
}
try
{
using (var context = new EntityContext())
{
DBEntity item = context.TransferValueProfile
.SingleOrDefault(s => s.Id == profileId);
if (item != null && item.Id > 0)
{
MapFromDB(item, entity);
}
}
}
catch (Exception ex)
{
LoggingHelper.LogError(ex, thisClassName + ".Get");
}
return(entity);
} //
public int AddPendingRecord(Guid entityUid, string ctid, string registryAtId, ref string status)
{
DBEntity efEntity = new DBEntity();
try
{
using (var context = new EntityContext())
{
if (!IsValidGuid(entityUid))
{
status = thisClassName + " - A valid GUID must be provided to create a pending entity";
return(0);
}
//quick check to ensure not existing
ThisEntity entity = GetByCtid(ctid);
if (entity != null && entity.Id > 0)
{
return(entity.Id);
}
//only add DB required properties
//NOTE - an entity will be created via trigger
efEntity.Name = "Placeholder until full document is downloaded";
efEntity.Description = "Placeholder until full document is downloaded";
efEntity.EntityStateId = 1;
efEntity.RowId = entityUid;
//watch that Ctid can be updated if not provided now!!
efEntity.CTID = ctid;
efEntity.CTID = ctid;
efEntity.SubjectWebpage = registryAtId;
efEntity.Created = System.DateTime.Now;
efEntity.LastUpdated = System.DateTime.Now;
context.TransferValueProfile.Add(efEntity);
int count = context.SaveChanges();
if (count > 0)
{
return(efEntity.Id);
}
status = thisClassName + " Error - the save was not successful, but no message provided. ";
}
}
catch (Exception ex)
{
string message = FormatExceptions(ex);
LoggingHelper.LogError(ex, thisClassName + string.Format(".AddPendingRecord. entityUid: {0}, ctid: {1}", entityUid, ctid));
status = thisClassName + " Error - the save was not successful. " + message;
}
return(0);
}
/// <summary>
/// Delete a framework - only if no remaining references!!
/// MAY NOT expose initially
/// </summary>
/// <param name="recordId"></param>
/// <param name="statusMessage"></param>
/// <returns></returns>
public bool Delete(int recordId, ref string statusMessage)
{
bool isOK = true;
using (var context = new EntityContext())
{
DBEntity p = context.TransferValueProfile.FirstOrDefault(s => s.Id == recordId);
if (p != null && p.Id > 0)
{
context.TransferValueProfile.Remove(p);
int count = context.SaveChanges();
}
else
{
statusMessage = string.Format("The record was not found: {0}", recordId);
isOK = false;
}
}
return(isOK);
}
} //
public static void MapFromDB(DBEntity input, ThisEntity output, bool gettingAll = true)
{
output.Id = input.Id;
output.RowId = input.RowId;
output.EntityStateId = input.EntityStateId;
output.Name = input.Name;
output.Description = input.Description;
output.CTID = input.CTID;
if (input.Created != null)
{
output.Created = ( DateTime )input.Created;
}
if (input.LastUpdated != null)
{
output.LastUpdated = ( DateTime )input.LastUpdated;
}
if (IsGuidValid(input.OwningAgentUid))
{
output.OwningAgentUid = ( Guid )input.OwningAgentUid;
output.OwningOrganization = OrganizationManager.GetForSummary(output.OwningAgentUid);
//get roles
OrganizationRoleProfile orp = Entity_AgentRelationshipManager.AgentEntityRole_GetAsEnumerationFromCSV(output.RowId, output.OwningAgentUid);
output.OwnerRoles = orp.AgentRole;
}
//
output.OrganizationRole = Entity_AgentRelationshipManager.AgentEntityRole_GetAll_ToEnumeration(output.RowId, true);
//
//get related ....
var relatedEntity = EntityManager.GetEntity(output.RowId, false);
if (relatedEntity != null && relatedEntity.Id > 0)
{
output.EntityLastUpdated = relatedEntity.LastUpdated;
}
//
output.SubjectWebpage = input.SubjectWebpage;
output.CredentialRegistryId = input.CredentialRegistryId ?? "";
output.LifecycleStatusType = string.IsNullOrWhiteSpace(input.LifecycleStatusType) ? "lifecycle:Active" : input.LifecycleStatusType;
//output.CodedNotation = input.CodedNotation;
//20-12-16 changed to a string as partial dates are possible
if (!string.IsNullOrWhiteSpace(input.StartDate))
{
output.StartDate = input.StartDate;
}
else
{
output.StartDate = "";
}
//
if (!string.IsNullOrWhiteSpace(input.EndDate))
{
output.EndDate = input.EndDate;
}
else
{
output.EndDate = "";
}
//derived from ....
//get json and expand
output.IdentifierJson = input.IdentifierJson;
output.TransferValueJson = input.TransferValueJson;
output.TransferValueFromJson = input.TransferValueFromJson;
output.TransferValueForJson = input.TransferValueForJson;
//
if (!string.IsNullOrWhiteSpace(output.IdentifierJson))
{
output.Identifier = JsonConvert.DeserializeObject <List <Entity_IdentifierValue> >(output.IdentifierJson);
}
if (!string.IsNullOrWhiteSpace(output.TransferValueJson))
{
output.TransferValue = JsonConvert.DeserializeObject <List <ValueProfile> >(output.TransferValueJson);
}
if (!gettingAll)
{
return;
}
//the top level object may not be enough. First need to confirm if reference lopps and asmts can have detail pages.
if (!string.IsNullOrWhiteSpace(output.TransferValueFromJson))
{
output.TransferValueFrom = JsonConvert.DeserializeObject <List <TopLevelObject> >(output.TransferValueFromJson);
var lopps = output.TransferValueFrom.Where(s => s.EntityTypeId == 7).ToList();
foreach (var item in lopps)
{
output.TransferValueFromLopp.Add(LearningOpportunityManager.GetForDetail(item.Id));
}
var assmts = output.TransferValueFrom.Where(s => s.EntityTypeId == 3).ToList();
foreach (var item in assmts)
{
output.TransferValueFromAsmt.Add(AssessmentManager.GetForDetail(item.Id));
}
var creds = output.TransferValueFrom.Where(s => s.EntityTypeId == 1).ToList();
foreach (var item in creds)
{
output.TransferValueFromCredential.Add(CredentialManager.GetForDetail(item.Id));
}
}
//
if (!string.IsNullOrWhiteSpace(output.TransferValueForJson))
{
output.TransferValueFor = JsonConvert.DeserializeObject <List <TopLevelObject> >(output.TransferValueForJson);
var lopps = output.TransferValueFor.Where(s => s.EntityTypeId == 7).ToList();
foreach (var item in lopps)
{
output.TransferValueForLopp.Add(LearningOpportunityManager.GetForDetail(item.Id));
}
var assmts = output.TransferValueFor.Where(s => s.EntityTypeId == 3).ToList();
foreach (var item in assmts)
{
output.TransferValueForAsmt.Add(AssessmentManager.GetForDetail(item.Id));
}
var creds = output.TransferValueFor.Where(s => s.EntityTypeId == 1).ToList();
foreach (var item in creds)
{
output.TransferValueForCredential.Add(CredentialManager.GetForDetail(item.Id));
}
}
//this should be a summary level, not the full TVP
output.DerivedFrom = Entity_TransferValueProfileManager.GetAll(output.RowId);
//
List <ProcessProfile> processes = Entity_ProcessProfileManager.GetAll(output.RowId);
foreach (ProcessProfile item in processes)
{
if (item.ProcessTypeId == Entity_ProcessProfileManager.DEV_PROCESS_TYPE)
{
output.DevelopmentProcess.Add(item);
}
else
{
//unexpected
}
}
}
public static void MapToDB(ThisEntity input, DBEntity output)
{
//want to ensure fields from create are not wiped
//to.Id = from.Id;
output.Name = input.Name;
//TODO - can't have pending or references
output.EntityStateId = 3;
output.Description = input.Description;
output.CTID = input.CTID;
output.SubjectWebpage = input.SubjectWebpage ?? "";
output.CredentialRegistryId = input.CredentialRegistryId ?? "";
output.OwningAgentUid = input.OwningAgentUid;
//need to handle a partial date
if (!string.IsNullOrWhiteSpace(input.StartDate))
{
output.StartDate = input.StartDate;
if ((output.StartDate ?? "").Length > 20)
{
output.StartDate = output.StartDate.Substring(0, 10);
}
}
else
{
output.StartDate = null;
}
//
if (!string.IsNullOrWhiteSpace(input.EndDate))
{
output.EndDate = input.EndDate;
if ((output.EndDate ?? "").Length > 20)
{
output.EndDate = output.EndDate.Substring(0, 10);
}
}
else
{
output.EndDate = null;
}
output.LifecycleStatusType = string.IsNullOrWhiteSpace(input.LifecycleStatusType) ? "lifecycle:Active" : input.LifecycleStatusType;
//output.CodedNotation = input.CodedNotation;
//just store the json
output.IdentifierJson = input.IdentifierJson;
output.TransferValueJson = input.TransferValueJson;
output.TransferValueFromJson = input.TransferValueFromJson;
output.TransferValueForJson = input.TransferValueForJson;
//output.ProfileGraph = input.ProfileGraph;
//ensure we don't reset the graph
//if ( !string.IsNullOrWhiteSpace( input.ProfileGraph ) )
// output.ProfileGraph = input.ProfileGraph;
//else
//{
//}
} //
/// <summary>
/// Add/Update a TransferValueProfile
/// </summary>
/// <param name="entity"></param>
/// <param name="messages"></param>
/// <returns></returns>
public bool Save(ThisEntity entity, ref SaveStatus status)
{
bool isValid = true;
int count = 0;
DBEntity efEntity = new DBEntity();
try
{
using (var context = new EntityContext())
{
if (ValidateProfile(entity, ref status) == false)
{
return(false);
}
if (entity.Id == 0)
{
//add
efEntity = new DBEntity();
MapToDB(entity, efEntity);
if (IsValidDate(status.EnvelopeCreatedDate))
{
efEntity.Created = status.LocalCreatedDate;
efEntity.LastUpdated = status.LocalCreatedDate;
}
else
{
efEntity.Created = System.DateTime.Now;
efEntity.LastUpdated = System.DateTime.Now;
}
if (IsValidGuid(entity.RowId))
{
efEntity.RowId = entity.RowId;
}
else
{
efEntity.RowId = Guid.NewGuid();
}
context.TransferValueProfile.Add(efEntity);
count = context.SaveChanges();
entity.Id = efEntity.Id;
entity.RowId = efEntity.RowId;
if (count == 0)
{
status.AddWarning(string.Format(" Unable to add Profile: {0} <br\\> ", string.IsNullOrWhiteSpace(entity.Name) ? "no description" : entity.Name));
}
else
{
//add log entry
SiteActivity sa = new SiteActivity()
{
ActivityType = "TransferValueProfile",
Activity = "Import",
Event = "Add",
Comment = string.Format("New Transfer Value Profile was found by the import. Name: {0}, URI: {1}", entity.Name, entity.SubjectWebpage),
ActivityObjectId = entity.Id
};
new ActivityManager().SiteActivityAdd(sa);
if (!UpdateParts(entity, ref status))
{
isValid = false;
}
}
}
else
{
efEntity = context.TransferValueProfile.FirstOrDefault(s => s.Id == entity.Id);
if (efEntity != null && efEntity.Id > 0)
{
entity.RowId = efEntity.RowId;
//update
MapToDB(entity, efEntity);
if (IsValidDate(status.EnvelopeCreatedDate) && status.LocalCreatedDate < efEntity.Created)
{
efEntity.Created = status.LocalCreatedDate;
}
if (IsValidDate(status.EnvelopeUpdatedDate) && status.LocalUpdatedDate != efEntity.LastUpdated)
{
efEntity.LastUpdated = status.LocalUpdatedDate;
}
//has changed?
if (HasStateChanged(context))
{
if (IsValidDate(status.EnvelopeUpdatedDate))
{
efEntity.LastUpdated = status.LocalUpdatedDate;
}
else
{
efEntity.LastUpdated = DateTime.Now;
}
count = context.SaveChanges();
//add log entry
SiteActivity sa = new SiteActivity()
{
ActivityType = "TransferValueProfile",
Activity = "Import",
Event = "Update",
Comment = string.Format("Updated Transfer Value Profile found by the import. Name: {0}, URI: {1}", entity.Name, entity.SubjectWebpage),
ActivityObjectId = entity.Id
};
new ActivityManager().SiteActivityAdd(sa);
}
if (!UpdateParts(entity, ref status))
{
isValid = false;
}
}
}
}
}
catch (Exception ex)
{
LoggingHelper.LogError(ex, "TransferValueProfileManager.Save()");
}
return(isValid);
}