Пример #1
0
        public ActionResult SiteMap(string lang)
        {
            int              orgId  = GetOrganizationId(Request);
            DbDataContext    db     = new DbDataContext("CloudAppWebSiteView");
            SeoUrlController sc     = new SeoUrlController();
            COrganization    cg     = db.Organizations.Where(k => k.OrganizationId == orgId).FirstOrDefault();
            string           adress = cg.AdressBindings.OrderByDescending(s => s.Address.Length).FirstOrDefault().Address;

            if (cg != null)
            {
                Response.Clear();
                Response.ContentType = "text/xml";
                XmlTextWriter xr = new XmlTextWriter(Response.OutputStream, Encoding.UTF8);
                xr.WriteStartDocument();
                xr.WriteStartElement("urlset");//urlset etiketi açıyoruz
                xr.WriteAttributeString("xmlns", "http://www.sitemaps.org/schemas/sitemap/0.9");
                xr.WriteAttributeString("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
                xr.WriteAttributeString("xsi:schemaLocation", "http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/siteindex.xsd");
                /* sitemap dosyamızın olmazsa olmazını ekledik. Şeması bu dedik buraya kadar.  */

                //--------1-----------//
                xr.WriteStartElement("url");
                xr.WriteElementString("loc", "http://" + adress);
                xr.WriteElementString("lastmod", DateTime.Now.ToString("yyyy-MM-dd"));
                xr.WriteElementString("changefreq", "daily");
                xr.WriteElementString("priority", "1");
                xr.WriteEndElement();
                //------2---------//

                foreach (var p in cg.Texts.Where(p => p.ActiveStatus == EActiveStatus.Active && p.Category.ActiveStatus == EActiveStatus.Active))
                {
                    xr.WriteStartElement("url");
                    xr.WriteElementString("loc", "http://" + adress + "/" + sc.GetUrlString(p.Id, EMenuType.Text, orgId, lang));
                    xr.WriteElementString("lastmod", p.CreatedDate != null ? p.CreatedDate.ToString("yyyy-MM-dd") : DateTime.Now.ToString("yyyy-MM-dd"));
                    xr.WriteElementString("priority", "0.5");
                    xr.WriteElementString("changefreq", "monthly");
                    xr.WriteEndElement();
                }

                foreach (var p in cg.Categories.Where(p => p.ActiveStatus == EActiveStatus.Active))
                {
                    xr.WriteStartElement("url");
                    xr.WriteElementString("loc", "http://" + adress + "/" + sc.GetUrlString(p.Id, EMenuType.Category, orgId, lang));
                    xr.WriteElementString("lastmod", p.CreatedDate != null ? p.CreatedDate.ToString("yyyy-MM-dd") : DateTime.Now.ToString("yyyy-MM-dd"));
                    xr.WriteElementString("priority", "0.5");
                    xr.WriteElementString("changefreq", "monthly");
                    xr.WriteEndElement();
                }


                xr.WriteEndDocument();
                //urlset etiketini kapattık
                xr.Flush();
                xr.Close();
                Response.End();
            }
            return(View());
        }
Пример #2
0
        public ViewPartialObject GetMenuPartial(int id, HttpRequestBase req, string lang)
        {
            string rootPath = "~/blog/Theme/";
            int    orgId    = GetOrganizationId(req);

            rootPath += orgId.ToString() + "/Views/MenuPartial/";
            SeoUrlController sc = new SeoUrlController();
            DbDataContext    db = new DbDataContext("CloudAppWebSiteView");
            CMenu            mm = db.Menus.Where(p => p.Id == id && p.OrganizationId == orgId && p.ActiveStatus == EActiveStatus.Active).FirstOrDefault();

            if (mm == null)
            {
                return(null);
            }
            else
            {
                ViewPartialObject menu = new ViewPartialObject();
                menu.ViewName  = rootPath + mm.ItemTheme.ThemePath;
                menu.ViewModel = sc.GetViewMenu(mm, lang);
                return(menu);
            }
        }
Пример #3
0
        public List <ViewNavigation> GetCategoryNavigation(CCategory text, HttpRequestBase req, string lang)
        {
            List <ViewNavigation> nList = new List <ViewNavigation>();
            DbDataContext         db    = new DbDataContext("CloudAppWebSiteView");
            SeoUrlController      sc    = new SeoUrlController();

            nList.Add(new ViewNavigation {
                Name = "Anasayfa", Level = -1, Url = "#"
            });
            nList.Add(new ViewNavigation {
                Name = text.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? text.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Level = 999, Url = sc.GetUrlString(text.Id, EMenuType.Category, text.OrganizationId.Value, lang)
            });
            if (text.TopCategory != null)
            {
                nList.Add(new ViewNavigation {
                    Name = text.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? text.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Level = 4, Url = sc.GetUrlString(text.TopCategory.Id, EMenuType.Category, GetOrganizationId(req), lang)
                });
                if (text.TopCategory.TopCategory != null)
                {
                    nList.Add(new ViewNavigation {
                        Name = text.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? text.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Level = 3, Url = sc.GetUrlString(text.TopCategory.TopCategory.Id, EMenuType.Category, GetOrganizationId(req), lang)
                    });
                    if (text.TopCategory.TopCategory.TopCategory != null)
                    {
                        nList.Add(new ViewNavigation {
                            Name = text.TopCategory.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? text.TopCategory.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Level = 2, Url = sc.GetUrlString(text.TopCategory.TopCategory.TopCategory.Id, EMenuType.Category, GetOrganizationId(req), lang)
                        });
                        if (text.TopCategory.TopCategory.TopCategory.TopCategory != null)
                        {
                            nList.Add(new ViewNavigation {
                                Name = text.TopCategory.TopCategory.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? text.TopCategory.TopCategory.TopCategory.TopCategory.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Level = 1, Url = sc.GetUrlString(text.TopCategory.TopCategory.TopCategory.TopCategory.Id, EMenuType.Category, GetOrganizationId(req), lang)
                            });
                        }
                    }
                }
            }
            return(nList);
        }
Пример #4
0
        private HtmlDocument ConvertStaticLink(HtmlDocument doc, DbDataContext db)
        {
            SeoUrlController seo = new SeoUrlController();
            int orgId            = Convert.ToInt32(_OrganizationId);

            foreach (var item in doc.DocumentNode.SelectNodes("//*[@data-staticmenu='true']"))
            {
                string dataType         = item.Attributes["data-type"] != null ? item.Attributes["data-type"].Value : "";
                string dataName         = item.Attributes["data-name"] != null ? item.Attributes["data-name"].Value : "";
                string dataCategoryName = item.Attributes["data-categoryname"] != null ? item.Attributes["data-categoryname"].Value : "";
                string dataItemTheme    = item.Attributes["data-itemtheme"] != null ? item.Attributes["data-itemtheme"].Value : "";
                if (dataType == "category")
                {
                    CCategory cat;
                    cat = db.Categories.Where(k => k.ActiveStatus == EActiveStatus.Active &&
                                              k.OrganizationId == orgId &&
                                              k.Name == dataCategoryName).FirstOrDefault();
                    if (cat == null)
                    {
                        CItemTheme itemTheme = new CItemTheme();
                        itemTheme = db.ItemThemes.Where(k => k.OrganizationId == orgId &&
                                                        k.Name == _CategoryThemeString &&
                                                        k.ActiveStatus == EActiveStatus.Active &&
                                                        k.ThemeType == EItemTheme.Category).FirstOrDefault();

                        if (itemTheme == null)
                        {
                            itemTheme                = new CItemTheme();
                            itemTheme.Name           = _CategoryThemeString;
                            itemTheme.OrganizationId = orgId;
                            itemTheme.ThemeType      = EItemTheme.Category;
                            itemTheme.ThemePath      = _CategoryThemeString;
                            itemTheme.ActiveStatus   = EActiveStatus.Active;
                            db.ItemThemes.Add(itemTheme);
                            db.SaveChanges();
                        }

                        cat                = new CCategory();
                        cat.Name           = dataCategoryName;
                        cat.ActiveStatus   = EActiveStatus.Active;
                        cat.CreatedDate    = DateTime.Now;
                        cat.CreatedUserId  = 1;
                        cat.OrganizationId = orgId;
                        cat.ItemThemeId    = itemTheme.Id;
                        db.Categories.Add(cat);
                        db.SaveChanges();
                    }

                    item.Attributes["href"].Value = seo.GetUrlString(cat.Id, EMenuType.Category, orgId);
                }
                else if (dataType == "text")
                {
                    CText     text;
                    CCategory cat;
                    text = db.Texts.Where(k => k.OrganizationId == orgId &&
                                          k.Name == dataName &&
                                          k.Category.Name == dataCategoryName &&
                                          k.ActiveStatus == EActiveStatus.Active).FirstOrDefault();

                    cat = db.Categories.Where(k => k.ActiveStatus == EActiveStatus.Active &&
                                              k.OrganizationId == orgId &&
                                              k.Name == dataCategoryName).FirstOrDefault();

                    if (cat == null)
                    {
                        CItemTheme itemTheme;
                        itemTheme = db.ItemThemes.Where(k => k.OrganizationId == orgId &&
                                                        k.Name == _CategoryThemeString &&
                                                        k.ActiveStatus == EActiveStatus.Active &&
                                                        k.ThemeType == EItemTheme.Category).FirstOrDefault();

                        if (itemTheme == null)
                        {
                            itemTheme                = new CItemTheme();
                            itemTheme.Name           = _CategoryThemeString;
                            itemTheme.OrganizationId = orgId;
                            itemTheme.ThemeType      = EItemTheme.Category;
                            itemTheme.ThemePath      = _CategoryThemeString;
                            itemTheme.ActiveStatus   = EActiveStatus.Active;
                            itemTheme.CreatedUserId  = 1;
                            itemTheme.CreatedDate    = DateTime.Now;
                            db.ItemThemes.Add(itemTheme);
                            db.SaveChanges();
                        }

                        cat                = new CCategory();
                        cat.Name           = dataCategoryName;
                        cat.ActiveStatus   = EActiveStatus.Active;
                        cat.CreatedDate    = DateTime.Now;
                        cat.CreatedUserId  = 1;
                        cat.ItemThemeId    = itemTheme.Id;
                        cat.OrganizationId = orgId;
                        db.Categories.Add(cat);
                        db.SaveChanges();
                    }

                    if (text == null)
                    {
                        if (String.IsNullOrEmpty(dataItemTheme))
                        {
                            throw new Exception("Yazının 'data-itemtheme' değeri boş geçilemez.");
                        }
                        CItemTheme itemThemeText;
                        itemThemeText = db.ItemThemes.Where(k => k.OrganizationId == orgId &&
                                                            k.Name == dataItemTheme &&
                                                            k.ActiveStatus == EActiveStatus.Active &&
                                                            k.ThemeType == EItemTheme.Text).FirstOrDefault();

                        if (itemThemeText == null)
                        {
                            itemThemeText                = new CItemTheme();
                            itemThemeText.Name           = dataItemTheme;
                            itemThemeText.OrganizationId = orgId;
                            itemThemeText.ThemeType      = EItemTheme.Text;
                            itemThemeText.CreatedDate    = DateTime.Now;
                            itemThemeText.CreatedUserId  = 1;
                            itemThemeText.ThemePath      = dataItemTheme + ".cshtml";
                            itemThemeText.ActiveStatus   = EActiveStatus.Active;
                            db.ItemThemes.Add(itemThemeText);
                            db.SaveChanges();
                        }


                        text                = new CText();
                        text.Name           = dataName;
                        text.OrganizationId = orgId;
                        text.PageTitle      = dataName;
                        text.CategoryId     = cat.Id;
                        text.ItemThemeId    = itemThemeText.Id;
                        text.CreatedDate    = DateTime.Now;
                        text.ActiveStatus   = EActiveStatus.Active;
                        text.CreatedUserId  = 1;
                        db.Texts.Add(text);
                        db.SaveChanges();
                    }
                    item.Attributes.Remove("data-staticmenu");
                    item.Attributes.Remove("data-name");
                    item.Attributes.Remove("data-type");
                    item.Attributes.Remove("data-categoryname");
                    item.Attributes.Remove("data-itemtheme");
                    item.Attributes["href"].Value = seo.GetUrlString(text.Id, EMenuType.Text, orgId);
                }
            }
            return(doc);
        }
Пример #5
0
        //public bool SeedDataStart()
        //{
        //    DbDataContext context = new DbDataContext();
        //    COrganization org = new COrganization
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        IsOffline = false,
        //        Name = "Organization",
        //        CreatedDate = DateTime.Now
        //    };
        //    context.Organizations.Add(org);
        //    context.SaveChanges();

        //    context.AddressBindings.Add(new CAddressBindings
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        Address = "localhost",
        //        Port = "6565",
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Users.Add(new CUser
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "ismail.erden",
        //        OrganizationId = org.OrganizationId,
        //        UserName = "******",
        //        Password = "******"
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Ana Menü",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_MainMenu.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Menu
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Footer Menü",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_FooterMenu.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Menu
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Ürün Kategorisi",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_ProductCategory.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Category
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Yazı Kategorisi",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_TextCategory.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Category
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Yazı",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_OnlyText.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Text
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Galeri",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_MainPageSlider.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Slider
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "Ürün",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_ProductDetail.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Text
        //    });
        //    context.SaveChanges();
        //    context.ItemThemes.Add(new CItemTheme
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        Name = "İletişim",
        //        OrganizationId = org.OrganizationId,
        //        ThemePath = "_Contact.cshtml",
        //        ThemeType = Data.Enum.EItemTheme.Text
        //    });
        //    context.SaveChanges();
        //    context.Categories.Add(new CCategory
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_ProductCategory.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Category).Id,
        //        OrganizationId = org.OrganizationId,
        //        Name = "Ürün Kategorisi"
        //    });
        //    context.SaveChanges();
        //    context.Categories.Add(new CCategory
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_TextCategory.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Category).Id,
        //        OrganizationId = org.OrganizationId,
        //        Name = "Site Yazıları"
        //    });
        //    context.SaveChanges();
        //    context.Menus.Add(new CMenu
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_MainMenu.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Menu).Id,
        //        Name = "Ana Menü",
        //        OrganizationId = org.OrganizationId
        //    });
        //    context.SaveChanges();
        //    context.Menus.Add(new CMenu
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CreatedDate = DateTime.Now,
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_FooterMenu.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Menu).Id,
        //        Name = "Footer Menü",
        //        OrganizationId = org.OrganizationId
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Site Yazıları").Id,
        //        Name = "Kurumsal",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_OnlyText.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Site Yazıları").Id,
        //        Name = "Hakkımızda",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_OnlyText.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Site Yazıları").Id,
        //        Name = "İletişim",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_Contact.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Ürün Kategorisi").Id,
        //        Name = "Ürün 1",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_ProductDetail.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Ürün Kategorisi").Id,
        //        Name = "Ürün 2",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_ProductDetail.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Texts.Add(new CText
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        CategoryId = context.Categories.FirstOrDefault(s => s.Name == "Ürün Kategorisi").Id,
        //        Name = "Ürün 3",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_ProductDetail.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Text).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();
        //    context.Sliders.Add(new CSlider
        //    {
        //        ActiveStatus = Data.Enum.EActiveStatus.Active,
        //        Name = "Galeri",
        //        ItemThemeId = context.ItemThemes.FirstOrDefault(f => f.ThemePath == "_MainPageSlider.cshtml" && f.ThemeType == Data.Enum.EItemTheme.Slider).Id,
        //        OrganizationId = org.OrganizationId,
        //        CreatedDate = DateTime.Now
        //    });
        //    context.SaveChanges();

        //    return true;
        //}
        public ActionResult SalesPoint(string lang)
        {
            SeoUrlController sc = new SeoUrlController();

            return(Redirect("/" + sc.GetUrlString(Convert.ToInt32(Request.Form["frmWhere"]), CloudApp.Data.Enum.EMenuType.Category, 1, lang)));
        }
Пример #6
0
        public List <ViewNavigation> GetSimilarCategory(CText text, HttpRequestBase req, string lang, string catId = "")
        {
            List <ViewNavigation> nList = new List <ViewNavigation>();
            DbDataContext         db    = new DbDataContext("CloudAppWebSiteView");
            SeoUrlController      sc    = new SeoUrlController();
            int orgId = GetOrganizationId(req);

            if (catId == "")
            {
                if (text.Category.TopCategory != null)
                {
                    foreach (var item in text.Category.TopCategory.SubCategory.Where(p => p.ActiveStatus == EActiveStatus.Active).ToList())
                    {
                        nList.Add(new ViewNavigation {
                            Name = item.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? item.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Url = sc.GetUrlString(item.Id, EMenuType.Category, GetOrganizationId(req), lang)
                        });
                    }
                }
                else
                {
                    foreach (var item in db.Categories.Where(p => p.ActiveStatus == EActiveStatus.Active && p.OrganizationId == orgId && (p.Level == 0 || p.Level == null)).ToList())
                    {
                        nList.Add(new ViewNavigation {
                            Name = item.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? item.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Url = sc.GetUrlString(item.Id, EMenuType.Category, GetOrganizationId(req), lang)
                        });
                    }
                }
            }
            else
            {
                List <int> intList     = new List <int>();
                string[]   arrCategory = catId.Split(',');
                foreach (var k in arrCategory)
                {
                    intList.Add(Convert.ToInt32(k));
                }
                List <CCategory> cg = db.Categories.Where(p => p.OrganizationId == orgId && intList.Contains(p.Id) && p.ActiveStatus == EActiveStatus.Active).ToList();
                foreach (var item in cg)
                {
                    if (item.TopCategory != null)
                    {
                        foreach (var item1 in item.TopCategory.SubCategory.Where(p => p.ActiveStatus == EActiveStatus.Active).ToList())
                        {
                            nList.Add(new ViewNavigation {
                                Name = item1.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? item1.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Url = sc.GetUrlString(item1.Id, EMenuType.Category, GetOrganizationId(req), lang)
                            });
                        }
                    }
                    else
                    {
                        foreach (var item1 in db.Categories.Where(p => p.ActiveStatus == EActiveStatus.Active && p.OrganizationId == orgId && (p.Level == 0 || p.Level == null)).ToList())
                        {
                            nList.Add(new ViewNavigation {
                                Name = item1.LanguageValues.FirstOrDefault(f => f.Lang == lang) != null ? item1.LanguageValues.FirstOrDefault(f => f.Lang == lang).Name : "-", Url = sc.GetUrlString(item1.Id, EMenuType.Category, GetOrganizationId(req), lang)
                            });
                        }
                    }
                }
            }
            return(nList);
        }