public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
SqlCommand command = SelectDeleteRelationshipDescriptorsMetadataCommand(connectionAbstraction.Connection, transactionWrapper.RelationshipParameter.Value);
connectionAbstraction.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Relationship deletedRelationship = new Relationship();
deletedRelationship.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedRelationship, TransactionType.DeleteRelationship));
if (reader.NextResult())
{
while (reader.Read())
{
Descriptor deletedDescriptor = new Descriptor();
deletedDescriptor.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedDescriptor, TransactionType.DeleteRelationship));
}
}
if (reader.NextResult())
{
while (reader.Read())
{
Metadata deletedMetadata = new Metadata();
deletedMetadata.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedMetadata, TransactionType.DeleteRelationship));
}
}
transactionWrapper.ResponseParameter.Value = deletedRelationship.RelationshipUid;
}
connectionAbstraction.Close();
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
SqlCommand command = SelectDeleteMetadataCommand(connectionAbstraction.Connection, transactionWrapper.MetadataParameter.Value);
connectionAbstraction.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Metadata deletedMetadata = new Metadata();
deletedMetadata.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedMetadata, TransactionType.DeleteMetadata));
transactionWrapper.ResponseParameter.Value = deletedMetadata.MetadataId;
}
connectionAbstraction.Close();
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
Descriptor newDescriptor = new Descriptor();
newDescriptor.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
newDescriptor.NodeUid = transactionWrapper.NodeParameter.Value;
newDescriptor.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
Guid newDescriptorId;
SqlCommand command = CreateDescriptorCommand(connectionAbstraction.Connection, out newDescriptorId, newDescriptor);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newDescriptor.DescriptorUid = newDescriptorId;
response.Changes.Add(new MapChange(transaction.TransactionId, newDescriptor, TransactionType.CreateDescriptor));
transactionWrapper.ResponseParameter.Value = newDescriptorId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Relationship newRelationship = new Relationship();
newRelationship.RelationshipTypeUid = transaction.RelationshipTypeUid.Value;
newRelationship.DomainUid = transactionWrapper.DomainParameter.Value;
if (transactionWrapper.RootMapParameter != null)
{
newRelationship.RootMapUid = transactionWrapper.RootMapParameter.Value;
}
else
{
newRelationship.RootMapUid = null;
}
newRelationship.Created = currentTime;
newRelationship.Modified = currentTime;
newRelationship.CreatedBy = transaction.User;
newRelationship.ModifiedBy = transaction.User;
Guid newRelationshipId;
SqlCommand command = CreateRelationshipCommand(connectionAbstraction.Connection, out newRelationshipId, newRelationship);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newRelationship.RelationshipUid = newRelationshipId;
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, newRelationship, TransactionType.CreateRelationship));
transactionWrapper.ResponseParameter.Value = newRelationshipId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now.ToUniversalTime();
Relationship updatedRelationship = new Relationship();
updatedRelationship.DomainUid = transactionWrapper.DomainParameter.Value;
updatedRelationship.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
updatedRelationship.RelationshipTypeUid = transaction.RelationshipTypeUid.Value;
updatedRelationship.Modified = currentTime;
updatedRelationship.ModifiedBy = transaction.User;
SqlCommand updateRelationshipCommand = UpdateRelationshipCommand(connectionAbstraction.Connection, updatedRelationship);
connectionAbstraction.Open();
updateRelationshipCommand.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedRelationship, TransactionType.UpdateRelationship));
transactionWrapper.ResponseParameter.Value = updatedRelationship.RelationshipUid;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Node updatedNode = new Node();
updatedNode.DomainUid = transactionWrapper.DomainParameter.Value;
updatedNode.NodeUid = transactionWrapper.NodeParameter.Value;
updatedNode.NodeTypeUid = transaction.NodeTypeUid.Value;
updatedNode.Modified = currentTime;
updatedNode.ModifiedBy = transaction.User;
SqlCommand updateNodeCommand = UpdateNodeCommand(connectionAbstraction.Connection, updatedNode);
connectionAbstraction.Open();
updateNodeCommand.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedNode, TransactionType.UpdateNode));
transactionWrapper.ResponseParameter.Value = updatedNode.NodeUid;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now.ToUniversalTime();
Metadata updatedMetadata = new Metadata();
updatedMetadata.MetadataId = transactionWrapper.MetadataParameter.Value;
updatedMetadata.MetadataName = transaction.MetadataName;
updatedMetadata.MetadataValue = transaction.MetadataValue;
updatedMetadata.Modified = currentTime;
updatedMetadata.ModifiedBy = transaction.User;
SqlCommand command = UpdateMetadataCommand(connectionAbstraction.Connection, updatedMetadata);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedMetadata, TransactionType.UpdateMetadata));
transactionWrapper.ResponseParameter.Value = updatedMetadata.MetadataId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
Descriptor updatedDescriptor = new Descriptor();
updatedDescriptor.NodeUid = transactionWrapper.NodeParameter.Value;
updatedDescriptor.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
updatedDescriptor.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
SqlCommand command = UpdateDescriptorCommand(connectionAbstraction.Connection, updatedDescriptor);
connectionAbstraction.Open();
object descriptorUidAsObject = command.ExecuteScalar();
connectionAbstraction.Close();
if (descriptorUidAsObject != null && descriptorUidAsObject != DBNull.Value)
{
updatedDescriptor.DescriptorUid = (Guid)descriptorUidAsObject;
}
else
{
// This case occurs if the relationship type has been changed and previously this descriptor didn't exist for this relationship type.
Guid newDescriptorUid;
SqlCommand createDescriptorCommand = CreateDescriptorCommand(connectionAbstraction.Connection, out newDescriptorUid, updatedDescriptor);
updatedDescriptor.DescriptorUid = newDescriptorUid;
connectionAbstraction.Open();
createDescriptorCommand.ExecuteNonQuery();
connectionAbstraction.Close();
}
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedDescriptor, TransactionType.UpdateDescriptor));
transactionWrapper.ResponseParameter.Value = updatedDescriptor.DescriptorUid;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now.ToUniversalTime();
Relationship updatedRelationship = new Relationship();
updatedRelationship.DomainUid = transactionWrapper.DomainParameter.Value;
updatedRelationship.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
updatedRelationship.RelationshipTypeUid = transaction.RelationshipTypeUid.Value;
updatedRelationship.Modified = currentTime;
updatedRelationship.ModifiedBy = transaction.User;
SqlCommand updateRelationshipCommand = UpdateRelationshipCommand(connectionAbstraction.Connection, updatedRelationship);
connectionAbstraction.Open();
updateRelationshipCommand.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedRelationship, TransactionType.UpdateRelationship));
transactionWrapper.ResponseParameter.Value = updatedRelationship.RelationshipUid;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
Descriptor newDescriptor = new Descriptor();
newDescriptor.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
newDescriptor.NodeUid = transactionWrapper.NodeParameter.Value;
newDescriptor.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
Guid newDescriptorId;
SqlCommand command = CreateDescriptorCommand(connectionAbstraction.Connection, out newDescriptorId, newDescriptor);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newDescriptor.DescriptorUid = newDescriptorId;
response.Changes.Add(new MapChange(transaction.TransactionId, newDescriptor, TransactionType.CreateDescriptor));
transactionWrapper.ResponseParameter.Value = newDescriptorId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
SqlCommand command = SelectDeleteMetadataCommand(connectionAbstraction.Connection, transactionWrapper.MetadataParameter.Value);
connectionAbstraction.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Metadata deletedMetadata = new Metadata();
deletedMetadata.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedMetadata, TransactionType.DeleteMetadata));
transactionWrapper.ResponseParameter.Value = deletedMetadata.MetadataId;
}
connectionAbstraction.Close();
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now.ToUniversalTime();
Metadata updatedMetadata = new Metadata();
updatedMetadata.MetadataId = transactionWrapper.MetadataParameter.Value;
updatedMetadata.MetadataName = transaction.MetadataName;
updatedMetadata.MetadataValue = transaction.MetadataValue;
updatedMetadata.Modified = currentTime;
updatedMetadata.ModifiedBy = transaction.User;
SqlCommand command = UpdateMetadataCommand(connectionAbstraction.Connection, updatedMetadata);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedMetadata, TransactionType.UpdateMetadata));
transactionWrapper.ResponseParameter.Value = updatedMetadata.MetadataId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Node newNode = new Node();
newNode.NodeTypeUid = transaction.NodeTypeUid.Value;
newNode.DomainUid = transactionWrapper.DomainParameter.Value;
if (transactionWrapper.RootMapParameter != null)
{
newNode.RootMapUid = transactionWrapper.RootMapParameter.Value;
}
else
{
newNode.RootMapUid = null;
}
newNode.Created = currentTime;
newNode.Modified = currentTime;
newNode.CreatedBy = transaction.User;
newNode.ModifiedBy = transaction.User;
Guid newNodeId;
SqlCommand command = CreateNodeCommand(connectionAbstraction.Connection, out newNodeId, newNode);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newNode.NodeUid = newNodeId;
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, newNode, TransactionType.CreateNode));
transactionWrapper.ResponseParameter.Value = newNodeId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
Descriptor updatedDescriptor = new Descriptor();
updatedDescriptor.NodeUid = transactionWrapper.NodeParameter.Value;
updatedDescriptor.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
updatedDescriptor.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
SqlCommand command = UpdateDescriptorCommand(connectionAbstraction.Connection, updatedDescriptor);
connectionAbstraction.Open();
object descriptorUidAsObject = command.ExecuteScalar();
connectionAbstraction.Close();
if (descriptorUidAsObject != null && descriptorUidAsObject != DBNull.Value)
{
updatedDescriptor.DescriptorUid = (Guid)descriptorUidAsObject;
}
else
{
// This case occurs if the relationship type has been changed and previously this descriptor didn't exist for this relationship type.
Guid newDescriptorUid;
SqlCommand createDescriptorCommand = CreateDescriptorCommand(connectionAbstraction.Connection, out newDescriptorUid, updatedDescriptor);
updatedDescriptor.DescriptorUid = newDescriptorUid;
connectionAbstraction.Open();
createDescriptorCommand.ExecuteNonQuery();
connectionAbstraction.Close();
}
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedDescriptor, TransactionType.UpdateDescriptor));
transactionWrapper.ResponseParameter.Value = updatedDescriptor.DescriptorUid;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Metadata newMetadata = new Metadata();
newMetadata.MetadataTypeUid = transaction.MetadataTypeUid.Value;
newMetadata.DomainUid = transactionWrapper.DomainParameter.Value;
if (transactionWrapper.RootMapParameter != null)
{
newMetadata.RootMapUid = transactionWrapper.RootMapParameter.Value;
}
else
{
newMetadata.RootMapUid = null;
}
newMetadata.Created = currentTime;
newMetadata.Modified = currentTime;
newMetadata.CreatedBy = transaction.User;
newMetadata.ModifiedBy = transaction.User;
if (transactionWrapper.NodeParameter == null)
{
newMetadata.NodeUid = null;
}
else
{
newMetadata.NodeUid = transactionWrapper.NodeParameter.Value;
}
if (transactionWrapper.RelationshipParameter == null)
{
newMetadata.RelationshipUid = null;
}
else
{
newMetadata.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
}
if (transaction.DescriptorTypeUid == null)
{
newMetadata.DescriptorTypeUid = null;
}
else
{
newMetadata.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
}
newMetadata.MetadataName = transaction.MetadataName;
newMetadata.MetadataValue = transaction.MetadataValue;
Guid newMetadataId;
SqlCommand command = CreateMetadataCommand(connectionAbstraction.Connection, out newMetadataId, newMetadata);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newMetadata.MetadataId = newMetadataId;
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, newMetadata, TransactionType.CreateMetadata));
transactionWrapper.ResponseParameter.Value = newMetadataId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
SqlCommand command = SelectDeleteNodeRelationshipsDescriptorsMetadataCommand(connectionAbstraction.Connection, transactionWrapper.NodeParameter.Value);
connectionAbstraction.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Node deletedNode = new Node();
deletedNode.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedNode, TransactionType.DeleteNode));
if (reader.NextResult())
{
while (reader.Read())
{
Metadata deletedMetadata = new Metadata();
deletedMetadata.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedMetadata, TransactionType.DeleteMetadata));
}
}
if (reader.NextResult())
{
while (reader.Read())
{
Relationship deletedRelationship = new Relationship();
deletedRelationship.LoadElement(reader);
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, deletedRelationship, TransactionType.DeleteRelationship));
}
}
transactionWrapper.ResponseParameter.Value = deletedNode.NodeUid;
}
connectionAbstraction.Close();
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Metadata newMetadata = new Metadata();
newMetadata.MetadataTypeUid = transaction.MetadataTypeUid.Value;
newMetadata.DomainUid = transactionWrapper.DomainParameter.Value;
if (transactionWrapper.RootMapParameter != null)
{
newMetadata.RootMapUid = transactionWrapper.RootMapParameter.Value;
}
else
{
newMetadata.RootMapUid = null;
}
newMetadata.Created = currentTime;
newMetadata.Modified = currentTime;
newMetadata.CreatedBy = transaction.User;
newMetadata.ModifiedBy = transaction.User;
if (transactionWrapper.NodeParameter == null)
{
newMetadata.NodeUid = null;
}
else
{
newMetadata.NodeUid = transactionWrapper.NodeParameter.Value;
}
if (transactionWrapper.RelationshipParameter == null)
{
newMetadata.RelationshipUid = null;
}
else
{
newMetadata.RelationshipUid = transactionWrapper.RelationshipParameter.Value;
}
if (transaction.DescriptorTypeUid == null)
{
newMetadata.DescriptorTypeUid = null;
}
else
{
newMetadata.DescriptorTypeUid = transaction.DescriptorTypeUid.Value;
}
newMetadata.MetadataName = transaction.MetadataName;
newMetadata.MetadataValue = transaction.MetadataValue;
Guid newMetadataId;
SqlCommand command = CreateMetadataCommand(connectionAbstraction.Connection, out newMetadataId, newMetadata);
connectionAbstraction.Open();
command.ExecuteNonQuery();
connectionAbstraction.Close();
newMetadata.MetadataId = newMetadataId;
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, newMetadata, TransactionType.CreateMetadata));
transactionWrapper.ResponseParameter.Value = newMetadataId;
}
public void ExecuteTransaction(IDbConnectionAbstraction connectionAbstraction, MapTransactionWrapper transactionWrapper, ref MapResponse response)
{
IMapTransaction transaction = (IMapTransaction)transactionWrapper;
DateTime currentTime = DateTime.Now;
Node updatedNode = new Node();
updatedNode.DomainUid = transactionWrapper.DomainParameter.Value;
updatedNode.NodeUid = transactionWrapper.NodeParameter.Value;
updatedNode.NodeTypeUid = transaction.NodeTypeUid.Value;
updatedNode.Modified = currentTime;
updatedNode.ModifiedBy = transaction.User;
SqlCommand updateNodeCommand = UpdateNodeCommand(connectionAbstraction.Connection, updatedNode);
connectionAbstraction.Open();
updateNodeCommand.ExecuteNonQuery();
connectionAbstraction.Close();
response.Changes.Add(new MapChange(transaction.TransactionId, transactionWrapper.ResponseParameter.Id, updatedNode, TransactionType.UpdateNode));
transactionWrapper.ResponseParameter.Value = updatedNode.NodeUid;
}
