TransactionalNodeService.Common.SearchedNode.LoadNodeRecord C# (CSharp) Method

        public void LoadNodeRecord(IDataReader record)
        {
            if (record["MapNodeUid"] != null && record["MapNodeUid"] != DBNull.Value)
            {
                MapNodeUid = (Guid)record["MapNodeUid"];
            }

            if (record["NodeUid"] != null && record["NodeUid"] != DBNull.Value)
            {
                NodeUid = (Guid)record["NodeUid"];
            }

            if (record["NodeOriginalId"] != null && record["NodeOriginalId"] != DBNull.Value)
            {
                NodeOriginalId = (string)record["NodeOriginalId"];
            }

            if (record["NodeTypeUid"] != null && record["NodeTypeUid"] != DBNull.Value)
            {
                NodeTypeUid = (Guid)record["NodeTypeUid"];
            }

            if (record["DomainUid"] != null && record["DomainUid"] != DBNull.Value)
            {
                DomainUid = (Guid)record["DomainUid"];
            }

            if (record["RootMapUid"] != null && record["RootMapUid"] != DBNull.Value)
            {
                RootMapUid = (Guid)record["RootMapUid"];
            }

            if (record["Created"] != null && record["Created"] != DBNull.Value)
            {
                Created = (DateTime)record["Created"];
            }

            if (record["Modified"] != null && record["Modified"] != DBNull.Value)
            {
                Modified = (DateTime)record["Modified"];
            }

            if (record["CreatedBy"] != null && record["CreatedBy"] != DBNull.Value)
            {
                CreatedByLogin = (string)record["CreatedBy"];

                //CreatedBy = mapObjects.FindUsersName(CreatedByLogin);
                CreatedBy = CreatedByLogin;
            }

            if (record["ModifiedBy"] != null && record["ModifiedBy"] != DBNull.Value)
            {
                ModifiedByLogin = (string)record["ModifiedBy"];

                //ModifiedBy = mapObjects.FindUsersName(ModifiedByLogin);
                ModifiedBy = ModifiedByLogin;
            }
        }

        public Dictionary<Guid, SearchedNode> GetNodes(DataTable nodesList)
        {
            SqlParameter nodesListParameter = new SqlParameter();
            nodesListParameter.ParameterName = "@Nodes";
            nodesListParameter.SqlDbType = SqlDbType.Structured;
            nodesListParameter.Value = nodesList;

            SqlCommand queryNodesCommand = new SqlCommand("QueryNodes", MapDbConnection.Connection);
            queryNodesCommand.CommandType = CommandType.StoredProcedure;
            queryNodesCommand.Parameters.Add(nodesListParameter);

            SqlDataReader queryNodesResults = queryNodesCommand.ExecuteReader();

            Dictionary<Guid, string> mapNames = new Dictionary<Guid, string>();
            Dictionary<Guid, SearchedNode> searchedNodes = new Dictionary<Guid, SearchedNode>();

            do
            {
                while (queryNodesResults.Read())
                {
                    if (queryNodesResults.GetSchemaTable().Select("ColumnName = 'NodeUid'").Length > 0)
                    {
                        if (queryNodesResults["NodeUid"] != null && queryNodesResults["NodeUid"] != DBNull.Value)
                        {
                            SearchedNode node;
                            Guid nodeId = (Guid)queryNodesResults["NodeUid"];

                            if (queryNodesResults.GetSchemaTable().Select("ColumnName = 'MetadataId'").Length > 0)
                            {
                                if (searchedNodes.ContainsKey(nodeId))
                                {
                                    node = searchedNodes[nodeId];
                                    node.AddMetadataRecord(queryNodesResults);
                                }
                                else if (mapNames.ContainsKey(nodeId))
                                {
                                    if (queryNodesResults["MetadataName"] != null && queryNodesResults["MetadataName"] != DBNull.Value)
                                    {
                                        string metadataName = (string)queryNodesResults["MetadataName"];

                                        if (metadataName == "Name")
                                        {
                                            if (queryNodesResults["MetadataValue"] != null & queryNodesResults["MetadataValue"] != DBNull.Value)
                                            {
                                                string metadataValue = (string)queryNodesResults["MetadataValue"];
                                                mapNames[nodeId] = metadataValue;
                                            }
                                        }
                                    }
                                }
                            }
                            else if (queryNodesResults.GetSchemaTable().Select("ColumnName = 'MapNodeUid'").Length > 0)
                            {
                                if (!searchedNodes.ContainsKey(nodeId))
                                {
                                    node = new SearchedNode();
                                    node.LoadNodeRecord(queryNodesResults);

                                    searchedNodes[nodeId] = node;
                                    mapNames[node.MapNodeUid] = null;
                                }
                            }
                        }
                    }
                }
            }
            while (queryNodesResults.NextResult());

            foreach (SearchedNode searchedNode in searchedNodes.Values)
            {
                if (mapNames.ContainsKey(searchedNode.MapNodeUid))
                {
                    searchedNode.MapNodeName = mapNames[searchedNode.MapNodeUid];
                }
            }

            return searchedNodes;
        }