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