/// <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.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.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.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.ActualFiniteStateList"/>. /// </returns> public virtual CDP4Common.DTO.ActualFiniteStateList 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.ActualFiniteStateList(iid, revisionNumber); dto.ActualState.AddRange(Array.ConvertAll((string[])reader["ActualState"], Guid.Parse)); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.ExcludeOption.AddRange(Array.ConvertAll((string[])reader["ExcludeOption"], Guid.Parse)); dto.Owner = Guid.Parse(reader["Owner"].ToString()); dto.PossibleFiniteStateList.AddRange(Utils.ParseOrderedList <Guid>(reader["PossibleFiniteStateList"] as string[, ])); 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.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.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.EnumerationParameterType"/>. /// </returns> public virtual CDP4Common.DTO.EnumerationParameterType MapToDto(NpgsqlDataReader reader) { string tempModifiedOn; string tempName; string tempShortName; string tempSymbol; string tempIsDeprecated; string tempAllowMultiSelect; 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.EnumerationParameterType(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.ValueDefinition.AddRange(Utils.ParseOrderedList <Guid>(reader["ValueDefinition"] 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("AllowMultiSelect", out tempAllowMultiSelect)) { dto.AllowMultiSelect = bool.Parse(tempAllowMultiSelect); } 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.Requirement"/>. /// </returns> public virtual CDP4Common.DTO.Requirement 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.Requirement(iid, revisionNumber); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], 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.Group = reader["Group"] is DBNull ? (Guid?)null : Guid.Parse(reader["Group"].ToString()); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.Owner = Guid.Parse(reader["Owner"].ToString()); dto.ParameterValue.AddRange(Array.ConvertAll((string[])reader["ParameterValue"], Guid.Parse)); dto.ParametricConstraint.AddRange(Utils.ParseOrderedList <Guid>(reader["ParametricConstraint"] as string[, ])); 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.Book"/>. /// </returns> public virtual CDP4Common.DTO.Book MapToDto(NpgsqlDataReader reader) { string tempCreatedOn; 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.Book(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()); dto.Section.AddRange(Utils.ParseOrderedList <Guid>(reader["Section"] as string[, ])); 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("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.FileRevision"/>. /// </returns> public virtual CDP4Common.DTO.FileRevision MapToDto(NpgsqlDataReader reader) { string tempContentHash; string tempCreatedOn; string tempModifiedOn; string tempName; 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.FileRevision(iid, revisionNumber); dto.ContainingFolder = reader["ContainingFolder"] is DBNull ? (Guid?)null : Guid.Parse(reader["ContainingFolder"].ToString()); dto.Creator = Guid.Parse(reader["Creator"].ToString()); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.FileType.AddRange(Utils.ParseOrderedList <Guid>(reader["FileType"] as string[, ])); if (valueDict.TryGetValue("ContentHash", out tempContentHash)) { dto.ContentHash = tempContentHash.UnEscape(); } 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("Name", out tempName)) { dto.Name = tempName.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.PossibleFiniteStateList"/>. /// </returns> public virtual CDP4Common.DTO.PossibleFiniteStateList 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.PossibleFiniteStateList(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.PossibleState.AddRange(Utils.ParseOrderedList <Guid>(reader["PossibleState"] as string[, ])); dto.DefaultState = reader["DefaultState"] is DBNull ? (Guid?)null : Guid.Parse(reader["DefaultState"].ToString()); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], 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("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.SampledFunctionParameterType"/>. /// </returns> public virtual CDP4Common.DTO.SampledFunctionParameterType MapToDto(NpgsqlDataReader reader) { string tempDegreeOfInterpolation; string tempInterpolationPeriod; string tempIsDeprecated; string tempModifiedOn; string tempName; string tempShortName; string tempSymbol; 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.SampledFunctionParameterType(iid, revisionNumber); dto.Alias.AddRange(Array.ConvertAll((string[])reader["Alias"], Guid.Parse)); dto.Category.AddRange(Array.ConvertAll((string[])reader["Category"], Guid.Parse)); dto.Definition.AddRange(Array.ConvertAll((string[])reader["Definition"], Guid.Parse)); dto.DependentParameterType.AddRange(Utils.ParseOrderedList <Guid>(reader["DependentParameterType"] as string[, ])); dto.ExcludedDomain.AddRange(Array.ConvertAll((string[])reader["ExcludedDomain"], Guid.Parse)); dto.ExcludedPerson.AddRange(Array.ConvertAll((string[])reader["ExcludedPerson"], Guid.Parse)); dto.HyperLink.AddRange(Array.ConvertAll((string[])reader["HyperLink"], Guid.Parse)); dto.IndependentParameterType.AddRange(Utils.ParseOrderedList <Guid>(reader["IndependentParameterType"] as string[, ])); if (valueDict.TryGetValue("DegreeOfInterpolation", out tempDegreeOfInterpolation) && tempDegreeOfInterpolation != null) { dto.DegreeOfInterpolation = int.Parse(tempDegreeOfInterpolation); } if (valueDict.TryGetValue("InterpolationPeriod", out tempInterpolationPeriod)) { dto.InterpolationPeriod = tempInterpolationPeriod.FromHstoreToValueArray <string>(); } 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("Symbol", out tempSymbol)) { dto.Symbol = tempSymbol.UnEscape(); } if (valueDict.TryGetValue("ThingPreference", out tempThingPreference) && tempThingPreference != null) { dto.ThingPreference = tempThingPreference.UnEscape(); } return(dto); }