/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.Participant"/>. /// </returns> public virtual CDP4Common.DTO.Participant MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempIsActive; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.Participant(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Person = Guid.Parse(reader["Person"].ToString()); dto.Role = Guid.Parse(reader["Role"].ToString()); dto.Domain.AddRange(Array.ConvertAll((string[])reader["Domain"], Guid.Parse)); dto.SelectedDomain = Guid.Parse(reader["SelectedDomain"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("IsActive", out tempIsActive)) { dto.IsActive = bool.Parse(tempIsActive); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.Definition"/>. /// </returns> public virtual CDP4Common.DTO.Definition MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempLanguageCode; string tempContent; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.Definition(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Note.AddRange(Utils.ParseOrderedList <string>(reader["Note"] as string[, ])); dto.Example.AddRange(Utils.ParseOrderedList <string>(reader["Example"] as string[, ])); dto.Citation.AddRange(Array.ConvertAll((string[])reader["Citation"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("LanguageCode", out tempLanguageCode)) { dto.LanguageCode = tempLanguageCode.UnEscape(); } if (valueDict.TryGetValue("Content", out tempContent)) { dto.Content = tempContent.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.SiteDirectoryThingReference"/>. /// </returns> public virtual CDP4Common.DTO.SiteDirectoryThingReference MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempReferencedRevisionNumber; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.SiteDirectoryThingReference(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ReferencedThing = Guid.Parse(reader["ReferencedThing"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ReferencedRevisionNumber", out tempReferencedRevisionNumber)) { dto.ReferencedRevisionNumber = int.Parse(tempReferencedRevisionNumber); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.Publication"/>. /// </returns> public virtual CDP4Common.DTO.Publication MapToDto(NpgsqlDataReader reader) { string tempCreatedOn; string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.Publication(iid, revisionNumber); dto.Domain.AddRange(Array.ConvertAll((string[])reader["Domain"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.PublishedParameter.AddRange(Array.ConvertAll((string[])reader["PublishedParameter"], Guid.Parse)); if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.SiteReferenceDataLibrary"/>. /// </returns> public virtual CDP4Common.DTO.SiteReferenceDataLibrary MapToDto(NpgsqlDataReader reader) { string tempIsDeprecated; string tempModifiedOn; string tempName; string tempShortName; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.SiteReferenceDataLibrary(iid, revisionNumber); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.BaseQuantityKind.AddRange(Utils.ParseOrderedList <Guid>(reader["BaseQuantityKind"] as string[, ])); dto.BaseUnit.AddRange(Array.ConvertAll((string[])reader["BaseUnit"], Guid.Parse)); dto.Constant.AddRange(Array.ConvertAll((string[])reader["Constant"], Guid.Parse)); dto.DefinedCategory.AddRange(Array.ConvertAll((string[])reader["DefinedCategory"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.FileType.AddRange(Array.ConvertAll((string[])reader["FileType"], Guid.Parse)); dto.Glossary.AddRange(Array.ConvertAll((string[])reader["Glossary"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.ParameterType.AddRange(Array.ConvertAll((string[])reader["ParameterType"], Guid.Parse)); dto.ReferenceSource.AddRange(Array.ConvertAll((string[])reader["ReferenceSource"], Guid.Parse)); dto.RequiredRdl = reader["RequiredRdl"] is DBNull ? (Guid?)null : Guid.Parse(reader["RequiredRdl"].ToString()); dto.Rule.AddRange(Array.ConvertAll((string[])reader["Rule"], Guid.Parse)); dto.Scale.AddRange(Array.ConvertAll((string[])reader["Scale"], Guid.Parse)); dto.Unit.AddRange(Array.ConvertAll((string[])reader["Unit"], Guid.Parse)); dto.UnitPrefix.AddRange(Array.ConvertAll((string[])reader["UnitPrefix"], Guid.Parse)); if (valueDict.TryGetValue("IsDeprecated", out tempIsDeprecated)) { dto.IsDeprecated = bool.Parse(tempIsDeprecated); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.UnitFactor"/>. /// </returns> public virtual CDP4Common.DTO.UnitFactor MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempExponent; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.UnitFactor(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Unit = Guid.Parse(reader["Unit"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Exponent", out tempExponent)) { dto.Exponent = tempExponent.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.EmailAddress"/>. /// </returns> public virtual CDP4Common.DTO.EmailAddress MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempVcardType; string tempValue; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.EmailAddress(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("VcardType", out tempVcardType)) { dto.VcardType = Utils.ParseEnum <CDP4Common.SiteDirectoryData.VcardEmailAddressKind>(tempVcardType); } if (valueDict.TryGetValue("Value", out tempValue)) { dto.Value = tempValue.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.ParameterGroup"/>. /// </returns> public virtual CDP4Common.DTO.ParameterGroup MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.ParameterGroup(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ContainingGroup = reader["ContainingGroup"] is DBNull ? (Guid?)null : Guid.Parse(reader["ContainingGroup"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.IdCorrespondence"/>. /// </returns> public virtual CDP4Common.DTO.IdCorrespondence MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempInternalThing; string tempExternalId; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.IdCorrespondence(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("InternalThing", out tempInternalThing)) { dto.InternalThing = Guid.Parse(tempInternalThing); } if (valueDict.TryGetValue("ExternalId", out tempExternalId)) { dto.ExternalId = tempExternalId.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.ActualFiniteState"/>. /// </returns> public virtual CDP4Common.DTO.ActualFiniteState MapToDto(NpgsqlDataReader reader) { string tempKind; string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.ActualFiniteState(iid, revisionNumber); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.PossibleState.AddRange(Array.ConvertAll((string[])reader["PossibleState"], Guid.Parse)); if (valueDict.TryGetValue("Kind", out tempKind)) { dto.Kind = Utils.ParseEnum <CDP4Common.EngineeringModelData.ActualFiniteStateKind>(tempKind); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.DiagramEdge"/>. /// </returns> public virtual CDP4Common.DTO.DiagramEdge MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.DiagramEdge(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.DiagramElement.AddRange(Array.ConvertAll((string[])reader["DiagramElement"], Guid.Parse)); dto.Bounds.AddRange(Array.ConvertAll((string[])reader["Bounds"], Guid.Parse)); dto.DepictedThing = reader["DepictedThing"] is DBNull ? (Guid?)null : Guid.Parse(reader["DepictedThing"].ToString()); dto.LocalStyle.AddRange(Array.ConvertAll((string[])reader["LocalStyle"], Guid.Parse)); dto.SharedStyle = reader["SharedStyle"] is DBNull ? (Guid?)null : Guid.Parse(reader["SharedStyle"].ToString()); dto.Source = Guid.Parse(reader["Source"].ToString()); dto.Target = Guid.Parse(reader["Target"].ToString()); dto.Point.AddRange(Utils.ParseOrderedList <Guid>(reader["Point"] as string[, ])); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.StakeHolderValueMapSettings"/>. /// </returns> public virtual CDP4Common.DTO.StakeHolderValueMapSettings MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.StakeHolderValueMapSettings(iid, revisionNumber); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.GoalToValueGroupRelationship = reader["GoalToValueGroupRelationship"] is DBNull ? (Guid?)null : Guid.Parse(reader["GoalToValueGroupRelationship"].ToString()); dto.StakeholderValueToRequirementRelationship = reader["StakeholderValueToRequirementRelationship"] is DBNull ? (Guid?)null : Guid.Parse(reader["StakeholderValueToRequirementRelationship"].ToString()); dto.ValueGroupToStakeholderValueRelationship = reader["ValueGroupToStakeholderValueRelationship"] is DBNull ? (Guid?)null : Guid.Parse(reader["ValueGroupToStakeholderValueRelationship"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.NestedElement"/>. /// </returns> public virtual CDP4Common.DTO.NestedElement MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempIsVolatile; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.NestedElement(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.RootElement = Guid.Parse(reader["RootElement"].ToString()); dto.ElementUsage.AddRange(Utils.ParseOrderedList <Guid>(reader["ElementUsage"] as string[, ])); dto.NestedParameter.AddRange(Array.ConvertAll((string[])reader["NestedParameter"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("IsVolatile", out tempIsVolatile)) { dto.IsVolatile = bool.Parse(tempIsVolatile); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.CommonFileStore"/>. /// </returns> public virtual CDP4Common.DTO.CommonFileStore MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; string tempCreatedOn; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.CommonFileStore(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Folder.AddRange(Array.ConvertAll((string[])reader["Folder"], Guid.Parse)); dto.File.AddRange(Array.ConvertAll((string[])reader["File"], Guid.Parse)); dto.Owner = Guid.Parse(reader["Owner"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.PrefixedUnit"/>. /// </returns> public virtual CDP4Common.DTO.PrefixedUnit MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempIsDeprecated; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.PrefixedUnit(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.ReferenceUnit = Guid.Parse(reader["ReferenceUnit"].ToString()); dto.Prefix = Guid.Parse(reader["Prefix"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("IsDeprecated", out tempIsDeprecated)) { dto.IsDeprecated = bool.Parse(tempIsDeprecated); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.EngineeringModel"/>. /// </returns> public virtual CDP4Common.DTO.EngineeringModel MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempLastModifiedOn; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.EngineeringModel(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.EngineeringModelSetup = Guid.Parse(reader["EngineeringModelSetup"].ToString()); dto.CommonFileStore.AddRange(Array.ConvertAll((string[])reader["CommonFileStore"], Guid.Parse)); dto.LogEntry.AddRange(Array.ConvertAll((string[])reader["LogEntry"], Guid.Parse)); dto.Iteration.AddRange(Array.ConvertAll((string[])reader["Iteration"], Guid.Parse)); dto.Book.AddRange(Utils.ParseOrderedList <Guid>(reader["Book"] as string[, ])); dto.GenericNote.AddRange(Array.ConvertAll((string[])reader["GenericNote"], Guid.Parse)); dto.ModellingAnnotation.AddRange(Array.ConvertAll((string[])reader["ModellingAnnotation"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("LastModifiedOn", out tempLastModifiedOn)) { dto.LastModifiedOn = Utils.ParseUtcDate(tempLastModifiedOn); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.EnumerationValueDefinition"/>. /// </returns> public virtual CDP4Common.DTO.EnumerationValueDefinition MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; string tempShortName; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.EnumerationValueDefinition(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.BinaryRelationship"/>. /// </returns> public virtual CDP4Common.DTO.BinaryRelationship MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.BinaryRelationship(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ParameterValue.AddRange(Array.ConvertAll((string[])reader["ParameterValue"], Guid.Parse)); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.Owner = Guid.Parse(reader["Owner"].ToString()); dto.Source = Guid.Parse(reader["Source"].ToString()); dto.Target = Guid.Parse(reader["Target"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.ParameterSubscriptionValueSet"/>. /// </returns> public virtual CDP4Common.DTO.ParameterSubscriptionValueSet MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempManual; string tempValueSwitch; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.ParameterSubscriptionValueSet(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.SubscribedValueSet = Guid.Parse(reader["SubscribedValueSet"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Manual", out tempManual)) { dto.Manual = tempManual.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("ValueSwitch", out tempValueSwitch)) { dto.ValueSwitch = Utils.ParseEnum <CDP4Common.EngineeringModelData.ParameterSwitchKind>(tempValueSwitch); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.RelationshipParameterValue"/>. /// </returns> public virtual CDP4Common.DTO.RelationshipParameterValue MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempValue; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.RelationshipParameterValue(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ParameterType = Guid.Parse(reader["ParameterType"].ToString()); dto.Scale = reader["Scale"] is DBNull ? (Guid?)null : Guid.Parse(reader["Scale"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Value", out tempValue)) { dto.Value = tempValue.FromHstoreToValueArray <string>(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.File"/>. /// </returns> public virtual CDP4Common.DTO.File MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.File(iid, revisionNumber); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.FileRevision.AddRange(Array.ConvertAll((string[])reader["FileRevision"], Guid.Parse)); dto.LockedBy = reader["LockedBy"] is DBNull ? (Guid?)null : Guid.Parse(reader["LockedBy"].ToString()); dto.Owner = Guid.Parse(reader["Owner"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.DependentParameterTypeAssignment"/>. /// </returns> public virtual CDP4Common.DTO.DependentParameterTypeAssignment MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.DependentParameterTypeAssignment(iid, revisionNumber); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.MeasurementScale = reader["MeasurementScale"] is DBNull ? (Guid?)null : Guid.Parse(reader["MeasurementScale"].ToString()); dto.ParameterType = Guid.Parse(reader["ParameterType"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.ParameterValueSet"/>. /// </returns> public virtual CDP4Common.DTO.ParameterValueSet MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempPublished; string tempFormula; string tempComputed; string tempManual; string tempReference; string tempValueSwitch; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.ParameterValueSet(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ActualState = reader["ActualState"] is DBNull ? (Guid?)null : Guid.Parse(reader["ActualState"].ToString()); dto.ActualOption = reader["ActualOption"] is DBNull ? (Guid?)null : Guid.Parse(reader["ActualOption"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Published", out tempPublished)) { dto.Published = tempPublished.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("Formula", out tempFormula)) { dto.Formula = tempFormula.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("Computed", out tempComputed)) { dto.Computed = tempComputed.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("Manual", out tempManual)) { dto.Manual = tempManual.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("Reference", out tempReference)) { dto.Reference = tempReference.FromHstoreToValueArray <string>(); } if (valueDict.TryGetValue("ValueSwitch", out tempValueSwitch)) { dto.ValueSwitch = Utils.ParseEnum <CDP4Common.EngineeringModelData.ParameterSwitchKind>(tempValueSwitch); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.TextualNote"/>. /// </returns> public virtual CDP4Common.DTO.TextualNote MapToDto(NpgsqlDataReader reader) { string tempContent; string tempCreatedOn; string tempLanguageCode; string tempModifiedOn; string tempName; string tempShortName; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.TextualNote(iid, revisionNumber); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.Owner = Guid.Parse(reader["Owner"].ToString()); if (valueDict.TryGetValue("Content", out tempContent)) { dto.Content = tempContent.UnEscape(); } if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } if (valueDict.TryGetValue("LanguageCode", out tempLanguageCode)) { dto.LanguageCode = tempLanguageCode.UnEscape(); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.DerivedQuantityKind"/>. /// </returns> public virtual CDP4Common.DTO.DerivedQuantityKind MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; string tempShortName; string tempSymbol; string tempIsDeprecated; string tempQuantityDimensionSymbol; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.DerivedQuantityKind(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.PossibleScale.AddRange(Array.ConvertAll((string[])reader["PossibleScale"], Guid.Parse)); dto.DefaultScale = Guid.Parse(reader["DefaultScale"].ToString()); dto.QuantityKindFactor.AddRange(Utils.ParseOrderedList <Guid>(reader["QuantityKindFactor"] as string[, ])); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } if (valueDict.TryGetValue("Symbol", out tempSymbol)) { dto.Symbol = tempSymbol.UnEscape(); } if (valueDict.TryGetValue("IsDeprecated", out tempIsDeprecated)) { dto.IsDeprecated = bool.Parse(tempIsDeprecated); } if (valueDict.TryGetValue("QuantityDimensionSymbol", out tempQuantityDimensionSymbol) && tempQuantityDimensionSymbol != null) { dto.QuantityDimensionSymbol = tempQuantityDimensionSymbol.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.SiteDirectory"/>. /// </returns> public virtual CDP4Common.DTO.SiteDirectory MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempLastModifiedOn; string tempCreatedOn; string tempName; string tempShortName; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.SiteDirectory(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Organization.AddRange(Array.ConvertAll((string[])reader["Organization"], Guid.Parse)); dto.Person.AddRange(Array.ConvertAll((string[])reader["Person"], Guid.Parse)); dto.ParticipantRole.AddRange(Array.ConvertAll((string[])reader["ParticipantRole"], Guid.Parse)); dto.DefaultParticipantRole = reader["DefaultParticipantRole"] is DBNull ? (Guid?)null : Guid.Parse(reader["DefaultParticipantRole"].ToString()); dto.SiteReferenceDataLibrary.AddRange(Array.ConvertAll((string[])reader["SiteReferenceDataLibrary"], Guid.Parse)); dto.Model.AddRange(Array.ConvertAll((string[])reader["Model"], Guid.Parse)); dto.PersonRole.AddRange(Array.ConvertAll((string[])reader["PersonRole"], Guid.Parse)); dto.DefaultPersonRole = reader["DefaultPersonRole"] is DBNull ? (Guid?)null : Guid.Parse(reader["DefaultPersonRole"].ToString()); dto.LogEntry.AddRange(Array.ConvertAll((string[])reader["LogEntry"], Guid.Parse)); dto.DomainGroup.AddRange(Array.ConvertAll((string[])reader["DomainGroup"], Guid.Parse)); dto.Domain.AddRange(Array.ConvertAll((string[])reader["Domain"], Guid.Parse)); dto.NaturalLanguage.AddRange(Array.ConvertAll((string[])reader["NaturalLanguage"], Guid.Parse)); dto.Annotation.AddRange(Array.ConvertAll((string[])reader["Annotation"], Guid.Parse)); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("LastModifiedOn", out tempLastModifiedOn)) { dto.LastModifiedOn = Utils.ParseUtcDate(tempLastModifiedOn); } if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.ModelLogEntry"/>. /// </returns> public virtual CDP4Common.DTO.ModelLogEntry MapToDto(NpgsqlDataReader reader) { string tempContent; string tempCreatedOn; string tempLanguageCode; string tempLevel; string tempModifiedOn; string tempThingPreference; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.ModelLogEntry(iid, revisionNumber); dto.AffectedDomainIid.AddRange(Array.ConvertAll((string[])reader["AffectedDomainIid"], Guid.Parse)); dto.AffectedItemIid.AddRange(Array.ConvertAll((string[])reader["AffectedItemIid"], Guid.Parse)); dto.Author = reader["Author"] is DBNull ? (Guid?)null : Guid.Parse(reader["Author"].ToString()); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.LogEntryChangelogItem.AddRange(Array.ConvertAll((string[])reader["LogEntryChangelogItem"], Guid.Parse)); if (valueDict.TryGetValue("Content", out tempContent)) { dto.Content = tempContent.UnEscape(); } if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } if (valueDict.TryGetValue("LanguageCode", out tempLanguageCode)) { dto.LanguageCode = tempLanguageCode.UnEscape(); } if (valueDict.TryGetValue("Level", out tempLevel)) { dto.Level = Utils.ParseEnum <CDP4Common.CommonData.LogLevelKind>(tempLevel); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.IterationSetup"/>. /// </returns> public virtual CDP4Common.DTO.IterationSetup MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempIterationIid; string tempIterationNumber; string tempDescription; string tempFrozenOn; string tempIsDeleted; string tempCreatedOn; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.IterationSetup(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.SourceIterationSetup = reader["SourceIterationSetup"] is DBNull ? (Guid?)null : Guid.Parse(reader["SourceIterationSetup"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("IterationIid", out tempIterationIid)) { dto.IterationIid = Guid.Parse(tempIterationIid); } if (valueDict.TryGetValue("IterationNumber", out tempIterationNumber)) { dto.IterationNumber = int.Parse(tempIterationNumber); } if (valueDict.TryGetValue("Description", out tempDescription)) { dto.Description = tempDescription.UnEscape(); } if (valueDict.TryGetValue("FrozenOn", out tempFrozenOn) && tempFrozenOn != null) { dto.FrozenOn = Utils.ParseUtcDate(tempFrozenOn); } if (valueDict.TryGetValue("IsDeleted", out tempIsDeleted)) { dto.IsDeleted = bool.Parse(tempIsDeleted); } if (valueDict.TryGetValue("CreatedOn", out tempCreatedOn)) { dto.CreatedOn = Utils.ParseUtcDate(tempCreatedOn); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.BinaryRelationshipRule"/>. /// </returns> public virtual CDP4Common.DTO.BinaryRelationshipRule MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; string tempShortName; string tempIsDeprecated; string tempForwardRelationshipName; string tempInverseRelationshipName; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.BinaryRelationshipRule(iid, revisionNumber); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.RelationshipCategory = Guid.Parse(reader["RelationshipCategory"].ToString()); dto.SourceCategory = Guid.Parse(reader["SourceCategory"].ToString()); dto.TargetCategory = Guid.Parse(reader["TargetCategory"].ToString()); if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ShortName", out tempShortName)) { dto.ShortName = tempShortName.UnEscape(); } if (valueDict.TryGetValue("IsDeprecated", out tempIsDeprecated)) { dto.IsDeprecated = bool.Parse(tempIsDeprecated); } if (valueDict.TryGetValue("ForwardRelationshipName", out tempForwardRelationshipName)) { dto.ForwardRelationshipName = tempForwardRelationshipName.UnEscape(); } if (valueDict.TryGetValue("InverseRelationshipName", out tempInverseRelationshipName)) { dto.InverseRelationshipName = tempInverseRelationshipName.UnEscape(); } return(dto); }
/// <summary> /// The mapping from a database record to data transfer object. /// </summary> /// <param name="reader"> /// An instance of the SQL reader. /// </param> /// <returns> /// A deserialized instance of <see cref="CDP4Common.DTO.Bounds"/>. /// </returns> public virtual CDP4Common.DTO.Bounds MapToDto(NpgsqlDataReader reader) { string tempHeight; string tempModifiedOn; string tempName; string tempThingPreference; string tempWidth; string tempX; string tempY; var valueDict = (Dictionary <string, string>)reader["ValueTypeSet"]; var iid = Guid.Parse(reader["Iid"].ToString()); var revisionNumber = int.Parse(valueDict["RevisionNumber"]); var dto = new CDP4Common.DTO.Bounds(iid, revisionNumber); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); if (valueDict.TryGetValue("Height", out tempHeight)) { dto.Height = float.Parse(tempHeight); } if (valueDict.TryGetValue("ModifiedOn", out tempModifiedOn)) { dto.ModifiedOn = Utils.ParseUtcDate(tempModifiedOn); } if (valueDict.TryGetValue("Name", out tempName)) { dto.Name = tempName.UnEscape(); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } if (valueDict.TryGetValue("Width", out tempWidth)) { dto.Width = float.Parse(tempWidth); } if (valueDict.TryGetValue("X", out tempX)) { dto.X = float.Parse(tempX); } if (valueDict.TryGetValue("Y", out tempY)) { dto.Y = float.Parse(tempY); } return(dto); }