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()); }
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); } }
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); }
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); }
//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))); }
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); }