Hi Gean,

can you share your code that you are trying to do the query with?

Hi Brendan,

please see below for the sample code. what we want to achieve is to able to search the created item so we could update it on daily process.

Thank you for your quick response.

using Essential.Umbraco.Core.Models;
using Essential.Umbraco.Service.Data;
using System;
using System.Data.Entity;
using System.Linq;
using System.Threading.Tasks;
using Umbraco.Core.Composing;
using Umbraco.Core.Services;

namespace Essential.Umbraco.Service.Services
{
    public class WebCatService : IDisposable
    {
        private readonly IContentService _contentService;

        private readonly Guid PRODUCT_PAREND_ID = Guid.Parse("6d302ab9-b948-4bbd-a067-7ff568d57184");
        public WebCatService()
        {
            _contentService = Current.Services.ContentService;
        }

        public async Task ProcessProductList()
        {
            using (var db = new EssentialDBContext())
            {
                var webcats = await db.WebCat
                    .Select(s => new WebCatDTO
                    {
                        Barcode = s.Barcode,
                        catname = s.catname,
                        Code = s.Code,         
                        Description = s.Description,
                        Kilo = s.Kilo,
                        Pack_Size = s.Pack_Size,
                        Price = s.Price,
                    })
                    .ToListAsync();

                foreach (var item in webcats)
                {
                    if (!UpdateIfExist(item))
                        Create(item);
                }
            }
        }

        public void Create(WebCatDTO item)
        {
            var contentService = _contentService;

            var productItem = contentService.Create($"{item.catname} - {item.Code}", PRODUCT_PAREND_ID, "product");

            productItem.SetValue("webCatname", item.catname);
            productItem.SetValue("code", item.Code);
            productItem.SetValue("description", item.Description);
            productItem.SetValue("packSize", item.Pack_Size);
            productItem.SetValue("price", item.Price);
            productItem.SetValue("Kilo", item.Kilo);
            productItem.SetValue("barcode", item.Barcode);

            contentService.SaveAndPublish(productItem);
        }

        public bool UpdateIfExist(WebCatDTO item)
        {
            var exist = false;
            //
            // Query to check if the product exists by item.code
            //

            if (exist) return false;

            //
            // Code to update the item if exist
            //

            return false;
        }

        public void Dispose()
        {
            GC.Collect();
        }
    }
}

~ Kyle

Hi Gean,

Generally speaking, this code looks like not the best architecture.

But you can get node by property value with this code:

var existingItem = Umbraco.AssignedContentItem.Root().Descendants().FirstOrDefault(x => x.HasValue("code") && x.Value("code") == item.Code);

It's not the best in terms of performance; you probably have to use Examine index for retrieving existing items or some caching.

Thanks,

Alex

Hi

You choose a better way, cool, thanks for sharing.

Thanks,

Alex

is working on a reply...