public static void MapFromDB(DBEntity input, ThisEntity output,
bool includingParts)
{
output.Id = input.Id;
output.RowId = input.RowId;
output.EntityStateId = input.EntityStateId;
output.Name = input.Name == null ? "" : input.Name;
output.Description = input.Description == null ? "" : input.Description;
output.CTID = input.CTID;
if (IsValidDate(input.DateEffective))
{
output.DateEffective = (( DateTime )input.DateEffective).ToString("yyyy-MM-dd");
}
else
{
output.DateEffective = "";
}
//
output.LowEarnings = input.LowEarnings ?? 0;
output.MedianEarnings = input.MedianEarnings ?? 0;
output.HighEarnings = input.HighEarnings ?? 0;
output.PostReceiptMonths = input.PostReceiptMonths ?? 0;
output.Source = GetUrlData(input.Source);
if (IsValidDate(input.Created))
{
output.Created = ( DateTime )input.Created;
}
if (IsValidDate(input.LastUpdated))
{
output.LastUpdated = ( DateTime )input.LastUpdated;
}
if (string.IsNullOrWhiteSpace(output.CTID) || output.EntityStateId < 3)
{
output.IsReferenceVersion = true;
return;
}
//=====
var relatedEntity = EntityManager.GetEntity(output.RowId, false);
if (relatedEntity != null && relatedEntity.Id > 0)
{
output.EntityLastUpdated = relatedEntity.LastUpdated;
}
//components
if (includingParts)
{
//
output.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(output.RowId);
//get datasetprofiles
output.RelevantDataSet = DataSetProfileManager.GetAll(output.RowId, true);
}
} //
public static void MapFromDB(DBEntity from, ThisEntity to, bool includingItems = true)
{
to.Id = from.Id;
to.RowId = from.RowId;
to.ParentId = from.EntityId;
to.Description = from.Description;
to.RevocationCriteriaDescription = from.RevocationCriteriaDescription;
to.RevocationCriteriaUrl = from.RevocationCriteriaUrl;
if (IsValidDate(from.DateEffective))
{
to.DateEffective = (( DateTime )from.DateEffective).ToString("yyyy-MM-dd");
}
else
{
to.DateEffective = "";
}
to.RevocationCriteriaUrl = from.RevocationCriteriaUrl;
if ((from.Entity.EntityBaseName ?? "").Length > 3)
{
to.ParentSummary = from.Entity.EntityBaseName;
}
//not used:
to.ProfileSummary = SetEntitySummary(to);
//no longer using name, but need for the editor list
to.ProfileName = to.ProfileSummary;
if (IsValidDate(from.Created))
{
to.Created = ( DateTime )from.Created;
}
if (IsValidDate(from.LastUpdated))
{
to.LastUpdated = ( DateTime )from.LastUpdated;
}
if (includingItems)
{
to.CredentialProfiled = Entity_CredentialManager.GetAll(to.RowId);
//
to.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId);
to.Region = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId, Entity_JurisdictionProfileManager.JURISDICTION_PURPOSE_RESIDENT);
}
}
public static void MapFromDB(DBEntity from, ThisEntity to,
bool includingItems
)
{
//TODO - add option for get during import to get less data
to.Id = from.Id;
to.RowId = from.RowId;
to.Description = (from.Description ?? "");
//ProfileName is for display purposes
to.ProfileName = to.Description.Length < 80 ? to.Description : to.Description.Substring(0, 79) + " ...";
if (from.HolderMustAuthorize != null)
{
to.HolderMustAuthorize = ( bool )from.HolderMustAuthorize;
}
if (IsValidDate(from.DateEffective))
{
to.DateEffective = (( DateTime )from.DateEffective).ToShortDateString();
}
else
{
to.DateEffective = "";
}
to.SubjectWebpage = from.SubjectWebpage;
to.VerificationServiceUrl = from.VerificationService;
to.VerificationDirectory = from.VerificationDirectory;
to.VerificationMethodDescription = from.VerificationMethodDescription;
if (IsGuidValid(from.OfferedByAgentUid))
{
to.OfferedByAgentUid = ( Guid )from.OfferedByAgentUid;
to.OfferedByAgent = OrganizationManager.GetBasics(to.OfferedByAgentUid);
}
if (includingItems)
{
//TODO 170803- need to chg to a list
//only get if:
//edit - get profile list
//detail - get basic
bool isForDetailPageCredential = true;
to.TargetCredential = Entity_CredentialManager.GetAll(to.RowId, isForDetailPageCredential);
to.EstimatedCost = CostProfileManager.GetAll(to.RowId);
to.ClaimType = EntityPropertyManager.FillEnumeration(to.RowId, CodesManager.PROPERTY_CATEGORY_CLAIM_TYPE);
to.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId, Entity_JurisdictionProfileManager.JURISDICTION_PURPOSE_SCOPE);
to.Region = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId, Entity_JurisdictionProfileManager.JURISDICTION_PURPOSE_RESIDENT);
to.JurisdictionAssertions = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId, Entity_JurisdictionProfileManager.JURISDICTION_PURPOSE_OFFERREDIN);
//to.VerificationStatus = Entity_VerificationStatusManager.GetAll( to.Id );
}
if (IsValidDate(from.Created))
{
to.Created = ( DateTime )from.Created;
}
if (IsValidDate(from.LastUpdated))
{
to.LastUpdated = ( DateTime )from.LastUpdated;
}
}
public static void MapFromDB(DBEntity from, ThisEntity to, bool includingItems, bool getForList)
{
to.Id = from.Id;
to.RowId = from.RowId;
//HANDLE PROCESS TYPES
if (from.ProcessTypeId != null && ( int )from.ProcessTypeId > 0)
{
to.ProcessTypeId = ( int )from.ProcessTypeId;
}
else
{
to.ProcessTypeId = 1;
}
to.ProfileName = to.ProcessType;
//need to distinguish if for detail
to.ProcessProfileType = GetProfileType(to.ProcessTypeId);
to.Description = from.Description;
if ((to.Description ?? "").Length > 5)
{
//this should just be the type now
to.ProfileName = GetProfileType(to.ProcessTypeId);
//to.ProfileName = to.Description.Length > 100 ? to.Description.Substring(0,100) + " . . ." : to.Description;
}
if (from.Entity != null)
{
to.ParentId = from.Entity.Id;
}
to.ProfileSummary = SetEntitySummary(to);
//- provide minimum option, for lists
if (getForList)
{
return;
}
if (IsGuidValid(from.ProcessingAgentUid))
{
to.ProcessingAgentUid = ( Guid )from.ProcessingAgentUid;
to.ProcessingAgent = OrganizationManager.GetBasics(to.ProcessingAgentUid);
}
if (IsValidDate(from.DateEffective))
{
to.DateEffective = (( DateTime )from.DateEffective).ToString("yyyy-MM-dd");
}
else
{
to.DateEffective = "";
}
to.SubjectWebpage = from.SubjectWebpage;
to.ProcessFrequency = from.ProcessFrequency;
//to.TargetCompetencyFramework = from.TargetCompetencyFramework;
//to.RequiresCompetenciesFrameworks = Entity_CompetencyFrameworkManager.GetAll( to.RowId, "requires" );
to.ProcessMethod = from.ProcessMethod;
to.ProcessMethodDescription = from.ProcessMethodDescription;
to.ProcessStandards = from.ProcessStandards;
to.ProcessStandardsDescription = from.ProcessStandardsDescription;
to.ScoringMethodDescription = from.ScoringMethodDescription;
to.ScoringMethodExample = from.ScoringMethodExample;
to.ScoringMethodExampleDescription = from.ScoringMethodExampleDescription;
to.VerificationMethodDescription = from.VerificationMethodDescription;
if (IsValidDate(from.DateEffective))
{
to.DateEffective = (( DateTime )from.DateEffective).ToString("yyyy-MM-dd");
}
else
{
to.DateEffective = "";
}
//enumerations
to.DataCollectionMethodType = EntityPropertyManager.FillEnumeration(to.RowId, CodesManager.PROPERTY_CATEGORY_DATA_COLLECTION_METHOD_TYPE);
to.ExternalInputType = EntityPropertyManager.FillEnumeration(to.RowId, CodesManager.PROPERTY_CATEGORY_EXTERNAL_INPUT_TYPE);
if (includingItems)
{
to.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId);
//will only be one, but could model with multiple
to.TargetCredential = Entity_CredentialManager.GetAll(to.RowId, BaseFactory.RELATIONSHIP_TYPE_HAS_PART);
to.TargetAssessment = Entity_AssessmentManager.GetAll(to.RowId, BaseFactory.RELATIONSHIP_TYPE_HAS_PART);
to.TargetLearningOpportunity = Entity_LearningOpportunityManager.LearningOpps_GetAll(to.RowId, true);
to.TargetCompetencyFramework = Entity_CompetencyFrameworkManager.GetAll(to.RowId);
}
if (IsValidDate(from.Created))
{
to.Created = ( DateTime )from.Created;
}
if (IsValidDate(from.LastUpdated))
{
to.LastUpdated = ( DateTime )from.LastUpdated;
}
}
public static void MapFromDB(DBEntity from, ThisEntity to, bool includingItems)
{
to.Id = from.Id;
to.RowId = from.RowId;
to.EntityId = from.EntityId;
to.ProfileName = from.ProfileName;
to.Description = from.Description;
if (IsValidDate(from.ExpirationDate))
{
to.EndDate = (( DateTime )from.ExpirationDate).ToString("yyyy-MM-dd");
}
else
{
to.EndDate = "";
}
if (IsValidDate(from.DateEffective))
{
to.StartDate = (( DateTime )from.DateEffective).ToString("yyyy-MM-dd");
}
else
{
to.StartDate = "";
}
to.CostDetails = from.DetailsUrl;
to.CurrencyTypeId = (int)(from.CurrencyTypeId ?? 0);
Views.Codes_Currency code = CodesManager.GetCurrencyItem(to.CurrencyTypeId);
if (code != null && code.NumericCode > 0)
{
to.Currency = code.Currency;
to.CurrencySymbol = code.HtmlCodes;
}
to.ProfileSummary = SetCostProfileSummary(to);
if (IsValidDate(from.Created))
{
to.Created = ( DateTime )from.Created;
}
if (IsValidDate(from.LastUpdated))
{
to.LastUpdated = ( DateTime )from.LastUpdated;
}
to.Condition = Entity_ReferenceManager.GetAll(to.RowId, CodesManager.PROPERTY_CATEGORY_CONDITION_ITEM);
if (includingItems)
{
//TODO - the items should be part of the EF record
if (from.Entity_CostProfileItem != null && from.Entity_CostProfileItem.Count > 0)
{
CostProfileItem row = new CostProfileItem();
foreach (EM.Entity_CostProfileItem item in from.Entity_CostProfileItem)
{
row = new CostProfileItem();
//TODO
CostProfileItemManager.MapFromDB(item, row, true);
to.Items.Add(row);
}
}
to.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId);
to.Region = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(to.RowId, Entity_JurisdictionProfileManager.JURISDICTION_PURPOSE_RESIDENT);
}
}
public static void MapFromDB(DBEntity input, ThisEntity output,
bool includingParts)
{
output.Id = input.Id;
output.RowId = input.RowId;
output.EntityStateId = input.EntityStateId;
output.Name = input.Name == null ? "" : input.Name;
output.Description = input.Description == null ? "" : input.Description;
output.CTID = input.CTID;
if (IsValidDate(input.DateEffective))
{
output.DateEffective = (( DateTime )input.DateEffective).ToString("yyyy-MM-dd");
}
else
{
output.DateEffective = "";
}
//
//output.JobsObtained = input.JobsObtained ?? 0;
if (!string.IsNullOrEmpty(input.JobsObtainedJson))
{
var jp = JsonConvert.DeserializeObject <EmploymentOutcomeProfileProperties>(input.JobsObtainedJson);
if (jp != null)
{
//unpack JobsObtainedList
output.JobsObtainedList = jp.JobsObtainedList;
}
}
output.Source = GetUrlData(input.Source);
if (IsValidDate(input.Created))
{
output.Created = ( DateTime )input.Created;
}
if (IsValidDate(input.LastUpdated))
{
output.LastUpdated = ( DateTime )input.LastUpdated;
}
if (string.IsNullOrWhiteSpace(output.CTID) || output.EntityStateId < 3)
{
output.IsReferenceVersion = true;
return;
}
//=====
var relatedEntity = EntityManager.GetEntity(output.RowId, false);
if (relatedEntity != null && relatedEntity.Id > 0)
{
output.EntityLastUpdated = relatedEntity.LastUpdated;
}
//components
if (includingParts)
{
//
output.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(output.RowId);
//get datasetprofiles
output.RelevantDataSet = DataSetProfileManager.GetAll(output.RowId, true);
}
} //
public static void MapFromDB(DBEntity input, ThisEntity output)
{
output.Id = input.Id;
output.RowId = input.RowId;
output.Name = input.Name == null ? "" : input.Name;
output.Description = input.Description == null ? "" : input.Description;
output.DemographicInformation = input.DemographicInformation == null ? "" : input.DemographicInformation;
if (IsValidDate(input.DateEffective))
{
output.DateEffective = (( DateTime )input.DateEffective).ToString("yyyy-MM-dd");
}
else
{
output.DateEffective = "";
}
//
output.NumberAwarded = (input.NumberAwarded ?? 0);
output.LowEarnings = (input.LowEarnings ?? 0);
output.MedianEarnings = (input.MedianEarnings ?? 0);
output.HighEarnings = (input.HighEarnings ?? 0);
output.PostReceiptMonths = (input.PostReceiptMonths ?? 0);
output.Source = GetUrlData(input.Source);
output.Currency = input.Currency;
Views.Codes_Currency code = CodesManager.GetCurrencyItem(output.Currency);
if (code != null && code.NumericCode > 0)
{
output.Currency = code.Currency;
output.CurrencySymbol = code.HtmlCodes;
}
if (IsValidDate(input.Created))
{
output.Created = ( DateTime )input.Created;
}
if (IsValidDate(input.LastUpdated))
{
output.LastUpdated = ( DateTime )input.LastUpdated;
}
if (!string.IsNullOrEmpty(input.JobsObtainedJson))
{
var jobsObtained = JsonConvert.DeserializeObject <List <QuantitativeValue> >(input.JobsObtainedJson);
if (jobsObtained != null)
{
output.JobsObtained = jobsObtained;
}
}
//=====
//var relatedEntity = EntityManager.GetEntity( output.RowId, false );
//if ( relatedEntity != null && relatedEntity.Id > 0 )
// output.EntityLastUpdated = relatedEntity.LastUpdated;
//components
//
output.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(output.RowId);
//get datasetprofiles
output.RelevantDataSet = DataSetProfileManager.GetAll(output.RowId, true);
//==========
} //
public static void MapFromDB(DBEntity input, ThisEntity output,
bool includingParts)
{
output.Id = input.Id;
output.RowId = input.RowId;
output.EntityStateId = input.EntityStateId;
output.Description = input.Description == null ? "" : input.Description;
output.CTID = input.CTID;
output.DataSuppressionPolicy = input.DataSuppressionPolicy;
output.SubjectIdentification = input.SubjectIdentification;
output.Source = GetUrlData(input.Source);
//
if (IsGuidValid(input.DataProviderUID))
{
output.DataProviderUID = ( Guid )input.DataProviderUID;
output.DataProvider = OrganizationManager.GetForSummary(output.DataProviderUID);
}
//
output.InstructionalProgramType = Reference_FrameworksManager.FillEnumeration(output.RowId, CodesManager.PROPERTY_CATEGORY_CIP);
//
if (input.DistributionFile != null)
{
var list = input.DistributionFile.Split('|');
foreach (var item in list)
{
if (!string.IsNullOrWhiteSpace(item))
{
output.DistributionFile.Add(item);
}
}
}
else
{
output.DistributionFile = new List <string>();
}
//
if (IsValidDate(input.Created))
{
output.Created = ( DateTime )input.Created;
}
if (IsValidDate(input.LastUpdated))
{
output.LastUpdated = ( DateTime )input.LastUpdated;
}
if (string.IsNullOrWhiteSpace(output.CTID) || output.EntityStateId < 3)
{
output.IsReferenceVersion = true;
return;
}
//=====
var relatedEntity = EntityManager.GetEntity(output.RowId, false);
if (relatedEntity != null && relatedEntity.Id > 0)
{
output.EntityLastUpdated = relatedEntity.LastUpdated;
}
//components
if (includingParts)
{
var processProfiles = Entity_ProcessProfileManager.GetAll(input.RowId);
foreach (ProcessProfile item in processProfiles)
{
if (item.ProcessTypeId == Entity_ProcessProfileManager.ADMIN_PROCESS_TYPE)
{
output.AdministrationProcess.Add(item);
}
}
//
output.Jurisdiction = Entity_JurisdictionProfileManager.Jurisdiction_GetAll(output.RowId);
//get DataSetTimePeriod
output.DataSetTimePeriod = DataSetTimeFrameManager.GetAll(output.Id);
}
} //
