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