Example #1
0
        public PartialViewResult SiteBlock(string title)
        {
            var    routeValues       = HttpContext.Request.RequestContext.RouteData.Values;
            string currentController = (string)routeValues["controller"];

            HtmlBlocks result = EntityRepository.HtmlBlocks.Where(s => s.ParentTitle == title && s.SitePage == currentController).FirstOrDefault();

            return(PartialView(result));
        }
Example #2
0
        public ViewResult CreateEdit(Guid?Id, string type, string game = null)
        {
            switch (type)
            {
            case "Product":
                Product prod = EntityRepository.Products.Where(p => p.ProductId == Id).FirstOrDefault();
                if (prod != null)
                {
                    return(View("Save" + type, new ProductDetails
                    {
                        Product = prod,
                        ProductId = prod.ProductId,
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), prod?.ProductGame.GameName ?? "Select Game"),
                        SelectedGame = prod?.ProductGame.GameName,
                        CategoriesList = new SelectList(EntityRepository.Games.Where(g => game == null || g.GameName == game).SelectMany(g => g.ProductCategory).Select(p => p.ProductCategoryName), prod?.ProductCategory.ProductCategoryName ?? "Select Category"),
                        SelectedCategory = prod?.ProductCategory.ProductCategoryName,
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), prod?.SEO.MetaTagTitle ?? "Select Meta tag title from List"),
                        SelectedMetaTagTitle = prod?.SEO.MetaTagTitle,
                        ProductOptions = prod.ProductOptions,
                        ProductName = prod.ProductName,
                        InStock = prod.InStock,
                        PreOrder = prod.PreOrder,
                        ProductEnabled = prod.ProductEnabled,
                        ProductQuantity = prod.ProductQuantity,
                        ProductImageThumb = prod.ProductImageThumb,
                        ProductImage = prod.ProductImage,
                        ProductPriority = prod.ProductPriority,
                        ProductPriceEU = prod.ProductPrice.Where(p => p.Region == "Europe").Select(p => p.Price).FirstOrDefault(),
                        ProductPriceUS = prod.ProductPrice.Where(p => p.Region == "US&Oceania").Select(p => p.Price).FirstOrDefault(),
                        ProductSaleEU = prod.ProductPrice.Where(p => p.Region == "Europe").Select(p => p.ProductSale).FirstOrDefault(),
                        ProductSaleUS = prod.ProductPrice.Where(p => p.Region == "US&Oceania").Select(p => p.ProductSale).FirstOrDefault(),
                        Description = prod.ProductDescription.Description,
                        SubDescriptionTitle1 = prod.ProductDescription.SubDescriptionTitle1,
                        SubDescription1 = prod.ProductDescription.SubDescription1,
                        SubDescriptionTitle2 = prod.ProductDescription.SubDescriptionTitle2,
                        SubDescription2 = prod.ProductDescription.SubDescription2,
                        SubDescriptionTitle3 = prod.ProductDescription.SubDescriptionTitle3,
                        SubDescription3 = prod.ProductDescription.SubDescription3,
                        SubDescriptionTitle4 = prod.ProductDescription.SubDescriptionTitle4,
                        SubDescription4 = prod.ProductDescription.SubDescription4,
                        SubDescriptionTitle5 = prod.ProductDescription.SubDescriptionTitle5,
                        SubDescription5 = prod.ProductDescription.SubDescription5,
                    }));
                }
                else
                {
                    return(View("Save" + type, new ProductDetails
                    {
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), "Select Game"),
                        CategoriesList = new SelectList(EntityRepository.Games.Where(g => game == null || g.GameName == game).SelectMany(g => g.ProductCategory).Select(p => p.ProductCategoryName), "Select Category"),
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), "Select Meta tag title from List"),
                    }));
                }

            case "TemplateOptions":
                TemplateOptions templateOptions = EntityRepository.TemplateOptions.Where(p => p.OptionId == Id).FirstOrDefault();
                if (templateOptions != null)
                {
                    return(View("Save" + type, new TemplateOptionDetails
                    {
                        TempOptionId = templateOptions.OptionId,
                        TempOptionName = templateOptions.OptionName,
                        TempOptionType = templateOptions.OptionType,
                        TempOptionParamsDetailsCollection = TemplateOptionDetails.PopulateTempOptionParamsDetailsCollection(templateOptions)
                    }));
                }
                else
                {
                    return(View("Save" + type, new TemplateOptionDetails {
                    }));
                }

            case "ProductGame":
                ProductGame productGame = EntityRepository.Games.Where(p => p.ProductGameId == Id).FirstOrDefault();
                if (productGame != null)
                {
                    return(View("Save" + type, new ProductGameDetails
                    {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), productGame.SEO?.MetaTagTitle ?? "Select Meta tag title from List"),
                        ProductGameId = productGame.ProductGameId,
                        GameName = productGame.GameName,
                        GameDescription = productGame.GameDescription,
                        GameShortUrl = productGame.GameShortUrl,
                        GameSeoId = productGame.GameSeoId
                    }));
                }
                else
                {
                    return(View("Save" + type, new ProductGameDetails
                    {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), "Select Meta tag title from List"),
                    }));
                }

            case "HtmlBlocks":
                HtmlBlocks siteBlock = EntityRepository.HtmlBlocks.Where(p => p.SiteBlockId == Id).FirstOrDefault();
                if (siteBlock != null)
                {
                    return(View("Save" + type, new HtmlBlockDetails
                    {
                        SiteBlockId = siteBlock.SiteBlockId,
                        ParentTitle = siteBlock.ParentTitle,
                        ParentCSSClass = siteBlock.ParentCSSClass,
                        ChildCSSClass = siteBlock.ChildCSSClass,
                        SitePage = siteBlock.SitePage,
                        Order = siteBlock.Order,
                        HtmlBlockChildDetailsCollection = HtmlBlockDetails.PopulateHtmlBlockCollection(siteBlock)
                    }));
                }
                else
                {
                    var result = new HtmlBlockDetails {
                        SiteBlockId = Guid.NewGuid(), HtmlBlockChildDetailsCollection = new List <HtmlBlockDetails.HtmlBlockChildrenDetails>()
                    };
                    return(View("Save" + type, result));
                }

            case "SEO":
                SEO seo = EntityRepository.SEOs.Where(p => p.SEOId == Id).FirstOrDefault();
                if (seo != null)
                {
                    return(View("Save" + type, new SeoDetails
                    {
                        SEOId = seo.SEOId,
                        MetaTagTitle = seo.MetaTagTitle,
                        MetaTagDescription = seo.MetaTagDescription,
                        MetaTagKeyWords = seo.MetaTagKeyWords,
                        SEOTags = seo.SEOTags,
                        CustomTitle1 = seo.CustomTitle1,
                        CustomTitle2 = seo.CustomTitle2,
                        CustomImageTitle = seo.CustomImageTitle,
                        CustomImageAlt = seo.CustomImageAlt,
                        MetaRobots = seo.MetaRobots,
                        UrlKeyWord = seo.UrlKeyWord,
                        SEOImage = seo.SEOImage
                    }));
                }
                else
                {
                    return(View("Save" + type, new SeoDetails {
                    }));
                }

            case "Users":
                Users user = EntityRepository.Users.Where(p => p.UserId == Id).FirstOrDefault();
                if (user != null)
                {
                    return(View("Save" + type, new UsersDetails
                    {
                        UserId = user.UserId,
                        UserName = user.UserName,
                        UserPassword = user.UserPassword,
                        Email = user.Email,
                        RoleId = user.RoleId
                    }));
                }
                else
                {
                    return(View("Save" + type, new UsersDetails {
                    }));
                }

            case "Ranks":
                Ranks ranks = EntityRepository.Ranks.Where(p => p.RankId == Id).FirstOrDefault();
                if (ranks != null)
                {
                    return(View("Save" + type, new RankDetails
                    {
                        RankId = ranks.RankId,
                        Name = ranks.Name,
                        Sale = ranks.Sale
                    }));
                }
                else
                {
                    return(View("Save" + type, new RankDetails {
                    }));
                }

            case "Customers":
                Customers customers = EntityRepository.Customers.Where(p => p.CustomerId == Id).FirstOrDefault();
                if (customers != null)
                {
                    return(View("Save" + type, new CustomersDetails
                    {
                        CustomerId = customers.CustomerId,
                        Name = customers.Name,
                        Password = customers.Password,
                        Email = customers.Email,
                        CarryCoinsValue = customers.CarryCoinsValue
                    }));
                }
                else
                {
                    return(View("Save" + type, new CustomersDetails {
                    }));
                }

            case "Roles":
                Roles roles = EntityRepository.Roles.Where(p => p.RoleId == Id).FirstOrDefault();
                if (roles != null)
                {
                    return(View("Save" + type, new RolesDetails
                    {
                        RoleId = roles.RoleId,
                        RoleName = roles.RoleName
                    }));
                }
                else
                {
                    return(View("Save" + type, new RolesDetails {
                    }));
                }

            case "Article":
                Article article = EntityRepository.Articles.Where(p => p.ArticleId == Id).FirstOrDefault();
                if (article != null)
                {
                    return(View("Save" + type, new ArticleDetails
                    {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), article.SEO?.MetaTagTitle ?? "Select Meta tag title from List"),
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), article?.ProductGame.GameName ?? "Select Game"),
                        ArticleId = article.ArticleId,
                        Title = article.Title,
                        ShortDescription = article.ShortDescription,
                        Description = article.Description,
                        ReadTime = article.ReadTime,
                        Tags = article.Tags,
                        ImagePath = article.ImagePath,
                        Enabled = article.Enabled,
                        Rating = article.Rating,
                        ArticleCreateTime = article.ArticleCreateTime,
                        ArticleUpdateTime = article.ArticleUpdateTime,
                        ArticlePostTime = article.ArticlePostTime
                    }));
                }
                else
                {
                    return(View("Save" + type, new ArticleDetails
                    {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), "Select Meta tag title from List"),
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), "Select Game")
                    }));
                }

            case "Orders":
                Orders orders = EntityRepository.Orders.Where(p => p.OrderId == Id).FirstOrDefault();
                if (orders != null)
                {
                    return(View("Save" + type, new OrderDetails
                    {
                        OrderId = orders.OrderId,
                        Discord = orders.Discord,
                        Comments = orders.Comment,
                        Email = orders.Email,
                        PaymentMethod = orders.PaymentMethod,
                        PaymentCode = orders.PaymentCode,
                        Total = orders.Total,
                        OrderStatus = orders.OrderStatus,
                        Currency = orders.Currency,
                        CustomerIP = orders.CustomerIP,
                        UserAgent = orders.UserAgent,
                        OrderCreateTime = orders.OrderCreateTime,
                        OrderUpdateTime = orders.OrderUpdateTime,
                        EmailSended = orders.EmailSended,
                        EmailSendTime = orders.EmailSendTime,
                        CarryCoinsSpent = orders.CarryCoinsSpent,
                        CarryCoinsCollected = orders.CarryCoinsCollected,
                        ShlCharacterName = orders.OrderCustomFields.ShlCharacterName,
                        ShlRealmName = orders.OrderCustomFields.ShlRealmName,
                        ShlFaction = orders.OrderCustomFields.ShlFaction,
                        ShlRegion = orders.OrderCustomFields.ShlRegion,
                        ShlBattleTag = orders.OrderCustomFields.ShlBattleTag,
                        Poe_CharacterName = orders.OrderCustomFields.PoeCharacterName,
                        Poe_AccountName = orders.OrderCustomFields.PoeAccountName,
                        Classic_CharacterName = orders.OrderCustomFields.ClassicCharacterName,
                        Classic_RealmName = orders.OrderCustomFields.ClassicRealmName,
                        Classic_Faction = orders.OrderCustomFields.ClassicFaction,
                        Classic_Region = orders.OrderCustomFields.ClassicRegion,
                        Classic_BattleTag = orders.OrderCustomFields.ClassicBattleTag
                    }));
                }
                else
                {
                    return(View("Save" + type, new OrderDetails {
                    }));
                }

            case "ProductCategory":
                ProductCategory productCategory = EntityRepository.ProductCategory.Where(p => p.ProductCategoryId == Id).FirstOrDefault();
                if (productCategory != null)
                {
                    return(View("Save" + type, new ProductCategoryDetails
                    {
                        ProductCategoryId = productCategory.ProductCategoryId,
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), productCategory.SEO?.MetaTagTitle ?? "Select Meta tag title from List"),
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), productCategory?.ProductGame.GameName ?? "Select Game"),
                        ProductCategoryName = productCategory.ProductCategoryName,
                        CategoryDescription = productCategory.CategoryDescription
                    }));
                }
                else
                {
                    return(View("Save" + type, new ProductCategoryDetails {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), "Select Meta tag title from List"),
                        GamesList = new SelectList(EntityRepository.Games.Select(g => g.GameName), "Select Game")
                    }));
                }

            case "ProductSubCategory":
                ProductSubCategory productSubCategory = EntityRepository.ProductSubCategories.Where(p => p.ProductSubCategoryId == Id).FirstOrDefault();
                if (productSubCategory != null)
                {
                    return(View("Save" + type, new ProductSubCategoryDetails
                    {
                        ProductSubCategoryId = productSubCategory.ProductSubCategoryId,
                        ProductCategoryName = productSubCategory.ProductCategoryName,
                        CategoryDescription = productSubCategory.CategoryDescription,
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), productSubCategory.SEO?.MetaTagTitle ?? "Select Meta tag title from List"),
                        CategoryList = new SelectList(EntityRepository.ProductCategory.Select(s => s.ProductCategoryName), productSubCategory.ProductCategory?.ProductCategoryName ?? "Select Product Category from List")
                    }));
                }
                else
                {
                    return(View("Save" + type, new ProductSubCategoryDetails
                    {
                        MetaTagTitleList = new SelectList(EntityRepository.SEOs.Select(s => s.MetaTagTitle), "Select Meta tag title from List"),
                        CategoryList = new SelectList(EntityRepository.ProductCategory.Select(s => s.ProductCategoryName), "Select Product Category from List")
                    }));
                }

            default: return(View("Admin"));
            }
        }
Example #3
0
        //foreach (ProductGameDetails.ProductCategoryDetails item in productGameDetails.ProductCategoryDetailsCollection)
        //{
        //    ProductCategory dbProductCategory = context.ProductGame.Find(productGameDetails.ProductGameId).ProductCategory.Where(p => p.ProductCategoryId == item.ProductCategoryId).FirstOrDefault();
        //    if (dbProductCategory != null)
        //    {
        //        dbProductCategory.ProductCategoryName = item.ProductCategoryName;
        //        dbProductCategory.ProductGameId = item.ProductGameId;
        //        dbProductCategory.CategoryDescription = item.CategoryDescription;
        //        dbProductCategory.ProductSubCategoryId = item.ProductSubCategoryId;
        //        dbProductCategory.CategorySeoId = item.CategorySeoId;
        //    }
        //}

        public void SaveHtmlBlock(HtmlBlockDetails htmlBlockDetails)
        {
            HtmlBlocks dbhtmlBlocks = context.HtmlBlocks.Find(htmlBlockDetails.SiteBlockId);

            if (dbhtmlBlocks != null)
            {
                dbhtmlBlocks.ParentCSSClass = htmlBlockDetails.ParentCSSClass;
                dbhtmlBlocks.ParentTitle    = htmlBlockDetails.ParentTitle;
                dbhtmlBlocks.ChildCSSClass  = htmlBlockDetails.ChildCSSClass;
                dbhtmlBlocks.SitePage       = htmlBlockDetails.SitePage;
                dbhtmlBlocks.Order          = htmlBlockDetails.Order;

                foreach (HtmlBlockDetails.HtmlBlockChildrenDetails item in htmlBlockDetails.HtmlBlockChildDetailsCollection)
                {
                    HtmlBlocksChildren dbhtmlBlocksChildren = context.HtmlBlocks.Find(htmlBlockDetails.SiteBlockId).HtmlBlocksChildren.Where(p => p.SiteBlockChildsId == item.SiteBlockChildsId).FirstOrDefault();
                    if (dbhtmlBlocksChildren != null)
                    {
                        dbhtmlBlocksChildren.Text       = item.Text;
                        dbhtmlBlocksChildren.Title      = item.Title;
                        dbhtmlBlocksChildren.Image      = item.Image;
                        dbhtmlBlocksChildren.CSSClass   = item.CSSClass;
                        dbhtmlBlocksChildren.ChildOrder = item.ChildOrder;
                    }
                    else
                    {
                        dbhtmlBlocksChildren = new HtmlBlocksChildren {
                        };
                        dbhtmlBlocksChildren.SiteBlockChildsId = item.SiteBlockChildsId;
                        dbhtmlBlocksChildren.SiteBlockId       = dbhtmlBlocks.SiteBlockId;
                        dbhtmlBlocksChildren.Text       = item.Text;
                        dbhtmlBlocksChildren.Title      = item.Title;
                        dbhtmlBlocksChildren.Image      = item.Image;
                        dbhtmlBlocksChildren.CSSClass   = item.CSSClass;
                        dbhtmlBlocksChildren.ChildOrder = item.ChildOrder;

                        context.HtmlBlocksChildren.Add(dbhtmlBlocksChildren);
                    }
                }
            }
            else
            {
                dbhtmlBlocks                = new HtmlBlocks();
                dbhtmlBlocks.SiteBlockId    = Guid.NewGuid();
                dbhtmlBlocks.ParentCSSClass = htmlBlockDetails.ParentCSSClass;
                dbhtmlBlocks.ParentTitle    = htmlBlockDetails.ParentTitle;
                dbhtmlBlocks.ChildCSSClass  = htmlBlockDetails.ChildCSSClass;
                dbhtmlBlocks.SitePage       = htmlBlockDetails.SitePage;
                dbhtmlBlocks.Order          = htmlBlockDetails.Order;

                if (htmlBlockDetails.HtmlBlockChildDetailsCollection != null)
                {
                    foreach (HtmlBlockDetails.HtmlBlockChildrenDetails item in htmlBlockDetails.HtmlBlockChildDetailsCollection)
                    {
                        HtmlBlocksChildren dbhtmlBlocksChildren = new HtmlBlocksChildren {
                        };
                        dbhtmlBlocksChildren.SiteBlockChildsId = Guid.NewGuid();
                        dbhtmlBlocksChildren.SiteBlockId       = dbhtmlBlocks.SiteBlockId;
                        dbhtmlBlocksChildren.Text       = item.Text;
                        dbhtmlBlocksChildren.Title      = item.Title;
                        dbhtmlBlocksChildren.Image      = item.Image;
                        dbhtmlBlocksChildren.CSSClass   = item.CSSClass;
                        dbhtmlBlocksChildren.ChildOrder = item.ChildOrder;

                        context.HtmlBlocksChildren.Add(dbhtmlBlocksChildren);
                    }
                }
                context.HtmlBlocks.Add(dbhtmlBlocks);
            }
            context.SaveChanges();
        }