Example #1
0
        /// <summary>
        /// Assing a modifiers to a product
        /// </summary>
        /// <param name="productId"></param>
        /// <param name="productModifierClient"></param>
        /// <returns></returns>
        public void UpsertDeleteProductModifiers(Product product, List <ProductModifier> productModifierClient)
        {
            var productId = product.Id;

            var productModifierDb   = product.ProductModifier;
            var noRecordsInDatabase = productModifierDb.Count() == 0;

            if (noRecordsInDatabase)
            {
                foreach (var item in productModifierClient)
                {
                    item.ProductId = productId;
                    productModifierDb.Add(item);
                }
            }
            else
            {
                foreach (var item in productModifierClient)
                {
                    var noRecordMatchInDatabase = !productModifierDb.Any(_ => _.ProductId == productId &&
                                                                         _.ModifierId == item.ModifierId);
                    if (noRecordMatchInDatabase)
                    {
                        item.ProductId = productId;
                        _context.Add(item);
                    }
                }

                foreach (var item in productModifierDb)
                {
                    var noRecordMatchInClient = !productModifierClient.Any(_ => _.ProductId == productId &&
                                                                           _.ModifierId == item.ModifierId);
                    if (noRecordMatchInClient)
                    {
                        _context.Remove(item);
                    }
                }
            }
        }