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