/// <summary>
        /// Gets detached content associated with the product variant.
        /// </summary>
        /// <param name="productVariantKeys">
        /// The product variant keys.
        /// </param>
        /// <returns>
        /// The <see cref="IEnumerable{IProductVariantDetachedContent}"/>.
        /// </returns>
        internal IEnumerable <IProductVariantDetachedContent> GetProductVariantDetachedContents(IEnumerable <Guid> productVariantKeys)
        {
            var sql = new Sql();

            sql.Select("*")
            .From <ProductVariantDetachedContentDto>(SqlSyntax)
            .InnerJoin <DetachedContentTypeDto>(SqlSyntax)
            .On <ProductVariantDetachedContentDto, DetachedContentTypeDto>(
                SqlSyntax,
                left => left.DetachedContentTypeKey,
                right => right.Key)
            .WhereIn <ProductVariantDetachedContentDto>(x => x.ProductVariantKey, productVariantKeys);

            var dtos = Database.Fetch <ProductVariantDetachedContentDto, DetachedContentTypeDto>(sql);

            var factory = new ProductVariantDetachedContentFactory();

            return(dtos.Select(factory.BuildEntity));
        }
Beispiel #2
0
        /// <summary>
        /// Gets detached content associated with the product variant.
        /// </summary>
        /// <param name="productVariantKey">
        /// The product variant key.
        /// </param>
        /// <returns>
        /// The <see cref="IEnumerable{IProductVariantDetachedContent}"/>.
        /// </returns>
        internal IEnumerable <IProductVariantDetachedContent> GetProductVariantDetachedContents(Guid productVariantKey)
        {
            var sql = new Sql();

            sql.Select("*")
            .From <ProductVariantDetachedContentDto>()
            .InnerJoin <DetachedContentTypeDto>()
            .On <ProductVariantDetachedContentDto, DetachedContentTypeDto>(
                left => left.DetachedContentTypeKey,
                right => right.Key)
            .Where(
                "[merchProductVariantDetachedContent].[productVariantKey] = @Key",
                new { @Key = productVariantKey });

            var dtos = Database.Fetch <ProductVariantDetachedContentDto, DetachedContentTypeDto>(sql);

            var factory = new ProductVariantDetachedContentFactory();

            return(dtos.Select(factory.BuildEntity));
        }
        /// <summary>
        /// The save detached content.
        /// </summary>
        /// <param name="detachedContent">
        /// The detached content.
        /// </param>
        /// <param name="slug">
        /// The generated slug
        /// </param>
        internal void SaveDetachedContent(IProductVariantDetachedContent detachedContent, string slug)
        {
            var factory = new ProductVariantDetachedContentFactory();

            if (!detachedContent.HasIdentity)
            {
                ((Entity)detachedContent).AddingEntity();
                detachedContent.Slug = this.EnsureSlug(detachedContent, slug);
                var dto = factory.BuildDto(detachedContent);
                Database.Insert(dto);
                detachedContent.Key = dto.Key;
            }
            else
            {
                ((Entity)detachedContent).UpdatingEntity();
                detachedContent.Slug = this.EnsureSlug(detachedContent, detachedContent.Slug);
                var dto = factory.BuildDto(detachedContent);

                const string Update =
                    "UPDATE [merchProductVariantDetachedContent] SET [merchProductVariantDetachedContent].[detachedContentTypeKey] = @Dctk, [merchProductVariantDetachedContent].[templateId] = @Tid, [merchProductVariantDetachedContent].[slug] = @Slug, [merchProductVariantDetachedContent].[values] = @Vals, [merchProductVariantDetachedContent].[canBeRendered] = @Cbr, [merchProductVariantDetachedContent].[updateDate] = @Ud WHERE [merchProductVariantDetachedContent].[cultureName] = @Cn AND [merchProductVariantDetachedContent].[productVariantKey] = @Pvk";


                Database.Execute(
                    Update,
                    new
                {
                    @Dctk = dto.DetachedContentTypeKey,
                    @Tid  = dto.TemplateId,
                    @Slug = dto.Slug,
                    @Vals = dto.Values,
                    @Cbr  = dto.CanBeRendered,
                    @Ud   = dto.UpdateDate,
                    @Cn   = dto.CultureName,
                    @Pvk  = dto.ProductVariantKey
                });
            }
        }
        /// <summary>
        /// Bulk save detached contents.
        /// </summary>
        /// <param name="productVariants">
        /// The product variants.
        /// </param>
        internal void SaveDetachedContents(IEnumerable <IProductVariant> productVariants)
        {
            var variants = productVariants as IProductVariant[] ?? productVariants.ToArray();
            var factory  = new ProductVariantDetachedContentFactory();
            var existing = this.GetProductVariantDetachedContents(variants.Select(x => x.Key)).ToArray();

            var sqlStatement = string.Empty;

            var parms      = new List <object>();
            var paramIndex = 0;
            var inserts    = new List <ProductVariantDetachedContentDto>();

            foreach (var variant in variants)
            {
                if (variant.DetachedContents.Any() || existing.Any(x => x.ProductVariantKey == variant.Key))
                {
                    if (existing.Any(x => x.ProductVariantKey == variant.Key) && !variant.DetachedContents.Any())
                    {
                        sqlStatement += string.Format(" DELETE [merchProductVariantDetachedContent] WHERE [productVariantKey] = @{0}", paramIndex++);
                    }

                    var slug = PathHelper.ConvertToSlug(variant.Name);
                    foreach (var dc in variant.DetachedContents)
                    {
                        if (!dc.HasIdentity)
                        {
                            ((Entity)dc).AddingEntity();
                            dc.Slug = this.EnsureSlug(dc, slug);
                            var dto = factory.BuildDto(dc);
                            inserts.Add(dto);
                        }
                        else
                        {
                            ((Entity)dc).UpdatingEntity();
                            var dto = factory.BuildDto(dc);
                            sqlStatement +=
                                string.Format(
                                    " UPDATE [merchProductVariantDetachedContent] SET [merchProductVariantDetachedContent].[detachedContentTypeKey] = @{0}, [merchProductVariantDetachedContent].[templateId] = @{1}, [merchProductVariantDetachedContent].[slug] = @{2}, [merchProductVariantDetachedContent].[values] = @{3}, [merchProductVariantDetachedContent].[canBeRendered] = @{4}, [merchProductVariantDetachedContent].[updateDate] = @{5} WHERE [merchProductVariantDetachedContent].[cultureName] = @{6} AND [merchProductVariantDetachedContent].[productVariantKey] = @{7}",
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++,
                                    paramIndex++);

                            parms.Add(dto.DetachedContentTypeKey);
                            parms.Add(dto.TemplateId);
                            parms.Add(dto.Slug);
                            parms.Add(dto.Values);
                            parms.Add(dto.CanBeRendered);
                            parms.Add(dto.UpdateDate);
                            parms.Add(dto.CultureName);
                            parms.Add(dto.ProductVariantKey);
                        }
                    }
                }
            }

            if (!string.IsNullOrEmpty(sqlStatement))
            {
                Database.Execute(sqlStatement, parms.ToArray());
            }

            if (inserts.Any())
            {
                BulkInsertRecordsWithKey <ProductVariantDetachedContentDto>(inserts);
            }
        }