示例#1
0
        public static bool UpdateNews(NewsItem news)
        {
            CacheManager.Remove(CacheNames.GetNewsForMainPage());

            SQLDataAccess.ExecuteNonQuery("[Settings].[sp_UpdateNews]", CommandType.StoredProcedure,
                                          new[]
            {
                new SqlParameter("@NewsID", news.NewsID),
                new SqlParameter("@NewsCategoryID", news.NewsCategoryID),
                new SqlParameter("@AddingDate", news.AddingDate),
                new SqlParameter("@Title", news.Title),
                //new SqlParameter("@Picture", news.Picture),
                new SqlParameter("@TextToPublication", news.TextToPublication),
                new SqlParameter("@TextToEmail", news.TextToEmail),
                new SqlParameter("@TextAnnotation", news.TextAnnotation),
                new SqlParameter("@ShowOnMainPage", news.ShowOnMainPage),
                new SqlParameter("@UrlPath", news.UrlPath)
            }
                                          );
            if (news.Meta != null)
            {
                if (news.Meta.Title.IsNullOrEmpty() && news.Meta.MetaKeywords.IsNullOrEmpty() && news.Meta.MetaDescription.IsNullOrEmpty() && news.Meta.H1.IsNullOrEmpty())
                {
                    if (MetaInfoService.IsMetaExist(news.ID, MetaType.News))
                    {
                        MetaInfoService.DeleteMetaInfo(news.ID, MetaType.News);
                    }
                }
                else
                {
                    MetaInfoService.SetMeta(news.Meta);
                }
            }
            return(true);
        }
示例#2
0
        public static void UpdateStaticPage(StaticPage page)
        {
            SQLDataAccess.ExecuteNonQuery(
                @"UPDATE [CMS].[StaticPage] SET [PageName] = @PageName, [PageText] = @PageText, [SortOrder] = @SortOrder, [ModifyDate] = GETDATE(), [IndexAtSiteMap] = @IndexAtSiteMap, 
                    [ParentID] = @ParentID, [Enabled] = @Enabled, UrlPath=@UrlPath WHERE [StaticPageID] = @StaticPageID",
                CommandType.Text,
                new[]
            {
                new SqlParameter("@PageName", page.PageName),
                new SqlParameter("@PageText", page.PageText),
                new SqlParameter("@SortOrder", page.SortOrder),
                new SqlParameter("@IndexAtSiteMap", page.IndexAtSiteMap),
                new SqlParameter("@ParentID", page.ParentId == 0 ?  DBNull.Value : (object)page.ParentId),
                new SqlParameter("@StaticPageID", page.StaticPageId),
                new SqlParameter("@Enabled", page.Enabled),
                new SqlParameter("@UrlPath", page.UrlPath)
            });

            // ---- Meta
            if (page.Meta != null)
            {
                if (page.Meta.Title.IsNullOrEmpty() && page.Meta.MetaKeywords.IsNullOrEmpty() && page.Meta.MetaDescription.IsNullOrEmpty())
                {
                    if (MetaInfoService.IsMetaExist(page.ID, MetaType.StaticPage))
                    {
                        MetaInfoService.DeleteMetaInfo(page.ID, MetaType.StaticPage);
                    }
                }
                else
                {
                    MetaInfoService.SetMeta(page.Meta);
                }
            }
        }
示例#3
0
        /// <summary>
        /// update product
        /// </summary>
        /// <param name="product"></param>
        /// <param name="sentToLuceneIndex"></param>
        /// <param name="db"></param>
        /// <returns></returns>
        public static bool UpdateProduct(Product product, bool sentToLuceneIndex, SQLDataAccess db)
        {
            db.cmd.CommandText = "[Catalog].[sp_UpdateProductById]";
            db.cmd.CommandType = CommandType.StoredProcedure;

            db.cmd.Parameters.Clear();
            db.cmd.Parameters.AddWithValue("@ArtNo", product.ArtNo);
            db.cmd.Parameters.AddWithValue("@Name", product.Name);
            db.cmd.Parameters.AddWithValue("@ProductID", product.ProductId);
            db.cmd.Parameters.AddWithValue("@Ratio", product.Ratio);
            db.cmd.Parameters.AddWithValue("@Discount", product.Discount);
            db.cmd.Parameters.AddWithValue("@Weight", product.Weight);
            db.cmd.Parameters.AddWithValue("@Size", (product.Size ?? ((object)DBNull.Value)));
            db.cmd.Parameters.AddWithValue("@IsFreeShipping", product.IsFreeShipping);
            db.cmd.Parameters.AddWithValue("@ItemsSold", product.ItemsSold);
            db.cmd.Parameters.AddWithValue("@BriefDescription",
                                           (product.BriefDescription ?? ((object)DBNull.Value)));
            db.cmd.Parameters.AddWithValue("@Description",
                                           (product.Description ?? ((object)DBNull.Value)));
            db.cmd.Parameters.AddWithValue("@Enabled", product.Enabled);
            db.cmd.Parameters.AddWithValue("@OrderByRequest", product.OrderByRequest);
            db.cmd.Parameters.AddWithValue("@Recomended", product.Recomended);
            db.cmd.Parameters.AddWithValue("@New", product.New);
            db.cmd.Parameters.AddWithValue("@BestSeller", product.BestSeller);
            db.cmd.Parameters.AddWithValue("@OnSale", product.OnSale);
            db.cmd.Parameters.AddWithValue("@BrandID", product.BrandId == 0 ? ((object)DBNull.Value) : product.BrandId);
            db.cmd.Parameters.AddWithValue("@UrlPath", product.UrlPath);
            db.cmd.ExecuteNonQuery();

            SetProductHierarchicallyEnabled(product.ProductId);

            if (product.Offers != null && product.Offers.Count > 0)
            {
                OfferService.UpdateOffersByProductId(product.ProductId, product.Offers);
            }

            if (product.Meta != null)
            {
                if (product.Meta.Title.IsNullOrEmpty() && product.Meta.MetaKeywords.IsNullOrEmpty() && product.Meta.MetaDescription.IsNullOrEmpty())
                {
                    if (MetaInfoService.IsMetaExist(product.ProductId, MetaType.Product))
                    {
                        MetaInfoService.DeleteMetaInfo(product.ProductId, MetaType.Product);
                    }
                }
                else
                {
                    MetaInfoService.SetMeta(product.Meta);
                }
            }

            if (sentToLuceneIndex)
            {
                LuceneSearch.AddUpdateLuceneIndex(new SampleData(product.ProductId, product.ArtNo, product.Name));
            }
            return(true);
        }
示例#4
0
        /// <summary>
        /// update category
        /// </summary>
        /// <param name="category"></param>
        /// <param name="updateCache">refresh cache</param>
        /// <returns></returns>
        public static bool UpdateCategory(Category category, bool updateCache)
        {
            SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_UpdateCategory]", CommandType.StoredProcedure,
                                          new SqlParameter("@CategoryID", category.CategoryId),
                                          new SqlParameter("@Name", category.Name),
                                          new SqlParameter("@ParentCategory", category.ParentCategoryId),
                                          new SqlParameter("@Description", category.Description),
                                          new SqlParameter("@BriefDescription", category.BriefDescription),
                                          new SqlParameter("@Enabled", category.Enabled),
                                          new SqlParameter("@DisplayStyle", category.DisplayStyle),
                                          new SqlParameter("@displayChildProducts", category.DisplayChildProducts),
                                          new SqlParameter("@DisplayBrandsInMenu", category.DisplayBrandsInMenu),
                                          new SqlParameter("@DisplaySubCategoriesInMenu", category.DisplaySubCategoriesInMenu),
                                          new SqlParameter("@SortOrder", category.SortOrder),
                                          //new SqlParameter("@Picture", !string.IsNullOrEmpty(category.Picture) ? category.Picture : ((object)DBNull.Value)),
                                          //new SqlParameter("@MiniPicture", !string.IsNullOrEmpty(category.MiniPicture) ? category.MiniPicture : ((object)DBNull.Value)),
                                          new SqlParameter("@UrlPath", category.UrlPath),
                                          new SqlParameter("@Sorting", category.Sorting)
                                          );
            if (category.Meta != null)
            {
                if (category.Meta.Title.IsNullOrEmpty() && category.Meta.MetaKeywords.IsNullOrEmpty() && category.Meta.MetaDescription.IsNullOrEmpty() && category.Meta.H1.IsNullOrEmpty())
                {
                    if (MetaInfoService.IsMetaExist(category.CategoryId, MetaType.Category))
                    {
                        MetaInfoService.DeleteMetaInfo(category.CategoryId, MetaType.Category);
                    }
                }
                else
                {
                    MetaInfoService.SetMeta(category.Meta);
                }
            }

            SetCategoryHierarchicallyEnabled(category.CategoryId);

            // Work with cache
            if (updateCache)
            {
                CacheManager.Remove(CacheNames.GetCategoryCacheObjectName(category.CategoryId));
                CacheManager.RemoveByPattern("MenuCatalog");

                if (category.ParentCategoryId == 0)
                {
                    var cacheName = CacheNames.GetBottomMenuCacheObjectName();
                    if (CacheManager.Contains(cacheName))
                    {
                        CacheManager.Remove(cacheName);
                    }
                }
            }
            return(true);
        }
示例#5
0
 public static void UpdateNewsCategory(NewsCategory newsCategory)
 {
     SQLDataAccess.ExecuteNonQuery("Update [Settings].[NewsCategory] set [Name]=@name,[UrlPath] = @UrlPath , [SortOrder] = @SortOrder where NewsCategoryID = @NewsCategoryID",
                                   CommandType.Text,
                                   new SqlParameter("@NewsCategoryID", newsCategory.NewsCategoryID),
                                   new SqlParameter("@Name", newsCategory.Name),
                                   new SqlParameter("@UrlPath", newsCategory.UrlPath),
                                   new SqlParameter("@SortOrder", newsCategory.SortOrder));
     if (newsCategory.Meta != null)
     {
         if (newsCategory.Meta.Title.IsNullOrEmpty() && newsCategory.Meta.MetaKeywords.IsNullOrEmpty() && newsCategory.Meta.MetaDescription.IsNullOrEmpty() && newsCategory.Meta.H1.IsNullOrEmpty())
         {
             if (MetaInfoService.IsMetaExist(newsCategory.NewsCategoryID, MetaType.NewsCategory))
             {
                 MetaInfoService.DeleteMetaInfo(newsCategory.NewsCategoryID, MetaType.NewsCategory);
             }
         }
         else
         {
             MetaInfoService.SetMeta(newsCategory.Meta);
         }
     }
 }