protected SqlCommand CreateDomainCommand(out Guid newDomainId, out Guid newDomainNodeId, string domainOriginalId = default(string))
{
SqlCommand createDomainCommand = new SqlCommand();
createDomainCommand.CommandText = "INSERT INTO [Domains] ([DomainUid], [DomainOriginalId]) VALUES (@DomainUid, @DomainOriginalId); INSERT INTO [Nodes] ([NodeUid], [NodeOriginalId], [NodeTypeUid], [DomainUid]) VALUES (@NodeUid, @DomainOriginalId, @DomainNodeTypeUid, @DomainUid)";
createDomainCommand.Connection = Connection;
newDomainId = Guid.NewGuid();
newDomainNodeId = Guid.NewGuid();
createDomainCommand.Parameters.AddWithValue("@DomainUid", newDomainId);
createDomainCommand.Parameters.AddWithValue("@NodeUid", newDomainNodeId);
createDomainCommand.Parameters.AddWithValue("@DomainNodeTypeUid", DomainNodeTypeId);
if (domainOriginalId == default(string))
{
createDomainCommand.Parameters.AddWithValue("@DomainOriginalId", newDomainId.ToString());
}
else
{
createDomainCommand.Parameters.AddWithValue("@DomainOriginalId", domainOriginalId);
}
return createDomainCommand;
}