protected void Page_Load(object sender, EventArgs e) { eID = CommonLogic.QueryStringNativeInt("EntityID"); eName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); eSpecs = EntityDefinitions.LookupSpecs(eName); switch (eName.ToUpperInvariant()) { case "SECTION": ViewState["entityname"] = "Section"; EntityPlural = "Sections"; break; case "MANUFACTURER": ViewState["entityname"] = "Manufacturer"; EntityPlural = "Manufacturers"; break; case "DISTRIBUTOR": ViewState["entityname"] = "Distributor"; EntityPlural = "Distributors"; break; case "GENRE": ViewState["entityname"] = "Genre"; EntityPlural = "Genres"; break; case "VECTOR": ViewState["entityname"] = "Vector"; EntityPlural = "Vectors"; break; case "LIBRARY": ViewState["entityname"] = "Library"; EntityPlural = "Libraries"; break; default: ViewState["entityname"] = "Category"; EntityPlural = "Categories"; break; } if (eID == 0) { lblpagehdr.Text = "Set " + ViewState["entityname"].ToString() + " Display Order"; lblpagehdr.Visible = true; } else { lblpagehdr.Visible = false; } if (!IsPostBack) { EntityXml = new EntityHelper(0, eSpecs, !AppLogic.IsAdminSite, 0).m_TblMgr.XmlDoc; LoadBody(); } }
protected void Page_Load(object sender, System.EventArgs e) { Response.ContentType = "text/xml"; Response.ContentEncoding = new System.Text.UTF8Encoding(); Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); String EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); if (EntityName.IndexOf("<script>", StringComparison.InvariantCultureIgnoreCase) != -1) { throw new ArgumentException("SECURITY EXCEPTION"); } String EntityID = CommonLogic.QueryStringCanBeDangerousContent("EntityID"); EntityHelper eHlp = new EntityHelper(EntityDefinitions.LookupSpecs(EntityName)); Response.Write("<urlset xmlns=\"" + AppLogic.AppConfig("GoogleSiteMap.Xmlns") + "\">"); Response.Write("<url>"); Response.Write("<loc>" + XmlCommon.XmlEncode(AppLogic.GetStoreHTTPLocation(false) + SE.MakeEntityLink(EntityName, EntityID, String.Empty)) + "</loc> "); Response.Write("<changefreq>" + AppLogic.AppConfig("GoogleSiteMap.EntityChangeFreq") + "</changefreq> "); Response.Write("<priority>" + AppLogic.AppConfig("GoogleSiteMap.EntityPriority") + "</priority> "); Response.Write("</url>"); Response.Write(eHlp.GetEntityGoogleObjectList(EntityID, Localization.WebConfigLocale, String.Empty, String.Empty)); Response.Write("</urlset>"); }
protected void Page_Load(object sender, EventArgs e) { EntityId = CommonLogic.QueryStringNativeInt("EntityID"); EntityType = string.IsNullOrEmpty(CommonLogic.QueryStringCanBeDangerousContent("EntityType")) ? EntityTypes.Category.ToString() : CommonLogic.QueryStringCanBeDangerousContent("EntityType"); EntitySpecs = EntityDefinitions.LookupSpecs(EntityType); EntityHelper = new EntityHelper(0, EntitySpecs, 0); if (IsPostBack) { return; } ddEntityType.SelectedValue = EntityType.ToLower(); ddEntity.SelectedValue = EntityId.ToString(); var currentEntity = new Entity(EntityId, EntityType); TopLevelString = BuildTopLevelString(EntityType); CurrentEntityName = GetCurrentEntityName(currentEntity); PopulateEntityDropDown(EntityType); SetupBreadcrumbData(currentEntity); DataBind(); }
protected void Page_Load(object sender, System.EventArgs e) { Response.ContentType = "text/xml"; Response.ContentEncoding = new System.Text.UTF8Encoding(); Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"); String EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); AppLogic.CheckForScriptTag(EntityName); int EntityID = CommonLogic.QueryStringUSInt("EntityID"); EntityHelper eHlp = AppLogic.LookupHelper(EntityName, AppLogic.StoreID()); Response.Write("<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9' xmlns:mobile='http://www.google.com/schemas/sitemap-mobile/1.0'>\n"); Response.Write("<url>"); Response.Write("<loc>" + XmlCommon.XmlEncode(AppLogic.GetStoreHTTPLocation(false, false) + SE.MakeEntityLink(EntityName, EntityID, String.Empty)) + "</loc> "); Response.Write("<changefreq>" + AppLogic.AppConfig("GoogleSiteMap.EntityChangeFreq") + "</changefreq> "); Response.Write("<priority>" + AppLogic.AppConfig("GoogleSiteMap.EntityPriority") + "</priority> "); Response.Write("<mobile:mobile/></url>\n"); Response.Write(GetMobileEntityGoogleObjectList(EntityDefinitions.LookupSpecs(EntityName), EntityID, Localization.GetDefaultLocale(), 0, 0)); Response.Write("</urlset>"); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); cust = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; EntityID = CommonLogic.QueryStringUSInt("EntityID"); if (EntityID < 1) { EntityID = CommonLogic.FormNativeInt("EntityID"); } EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); if (String.IsNullOrEmpty(EntityName)) { EntityName = CommonLogic.FormCanBeDangerousContent("EntityName"); } m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { ProductCollection products = new ProductCollection(m_EntitySpecs.m_EntityName, EntityID); products.PageSize = 0; products.PageNum = 1; products.PublishedOnly = false; products.ReturnAllVariants = true; DataSet dsProducts = products.LoadFromDB(); int NumProducts = products.NumProducts; foreach (DataRow row in dsProducts.Tables[0].Rows) { if (DB.RowFieldBool(row, "IsDownload")) { int ThisProductID = DB.RowFieldInt(row, "ProductID"); int ThisVariantID = DB.RowFieldInt(row, "VariantID"); StringBuilder sql = new StringBuilder(1024); sql.Append("update productvariant set "); String DLoc = CommonLogic.FormCanBeDangerousContent("DownloadLocation_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); if (DLoc.StartsWith("/")) { DLoc = DLoc.Substring(1, DLoc.Length - 1); // remove leading / char! } sql.Append("DownloadLocation=" + DB.SQuote(DLoc)); sql.Append(" where VariantID=" + ThisVariantID.ToString()); DB.ExecuteSQL(sql.ToString()); } } dsProducts.Dispose(); } LoadBody(); }
protected override void OnInit(EventArgs e) { EntitySpecs = EntityDefinitions.LookupSpecs(EntityType); EntityHelper = new EntityHelper(0, EntitySpecs, 0); HeaderText.Text = String.Format("Products for {0}", EntityHelper.GetEntityBreadcrumb6(EntityId, ThisCustomer.LocaleSetting)); base.OnInit(e); }
protected void UpdateDisplayOrder(object sender, EventArgs e) { foreach (RepeaterItem ri in subcategories.Items) { TextBox d = (TextBox)ri.FindControl("DisplayOrder"); TextBox eid = (TextBox)ri.FindControl("entityid"); string displayorder = CommonLogic.IIF(CommonLogic.IsInteger(d.Text), d.Text, "1"); DB.ExecuteSQL("update " + ViewState["entityname"].ToString() + " set displayorder = " + displayorder + " where " + ViewState["entityname"].ToString() + "ID = " + eid.Text); } //refresh the static entityhelper switch (ViewState["entityname"].ToString().ToUpperInvariant()) { case "CATEGORY": AppLogic.CategoryStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Category"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Category"), false, 0).m_TblMgr.XmlDoc; break; case "SECTION": AppLogic.SectionStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Section"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Section"), false, 0).m_TblMgr.XmlDoc; break; case "MANUFACTURER": AppLogic.ManufacturerStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Manufacturer"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Manufacturer"), false, 0).m_TblMgr.XmlDoc; break; case "DISTRIBUTOR": AppLogic.DistributorStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Distributor"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Distributor"), false, 0).m_TblMgr.XmlDoc; break; case "GENRE": AppLogic.GenreStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Genre"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Genre"), false, 0).m_TblMgr.XmlDoc; break; case "VECTOR": AppLogic.VectorStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Vector"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Genre"), false, 0).m_TblMgr.XmlDoc; break; case "LIBRARY": AppLogic.LibraryStoreEntityHelper[0] = new EntityHelper(0, EntityDefinitions.LookupSpecs("Library"), true, 0); EntityXml = new EntityHelper(0, EntityDefinitions.LookupSpecs("Library"), false, 0).m_TblMgr.XmlDoc; break; } LoadBody(); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); if (CommonLogic.QueryStringCanBeDangerousContent("EntityName").Length == 0) { Response.Redirect(AppLogic.AdminLinkUrl("default.aspx")); } m_EntitySpecs = EntityDefinitions.LookupSpecs(CommonLogic.QueryStringCanBeDangerousContent("EntityName")); m_ErrorMsg = AdminLogic.EntityEditPageFormHandler(this, m_EntitySpecs, ThisCustomer, SkinID); SectionTitle = "<a href=\"" + AppLogic.AdminLinkUrl("entities.aspx") + "?entityname=" + m_EntitySpecs.m_EntityName + "\">" + AppLogic.GetString("AppConfig." + m_EntitySpecs.m_EntityName + "PromptPlural", SkinID, ThisCustomer.LocaleSetting) + "</a> - Manage " + AppLogic.GetString("AppConfig." + m_EntitySpecs.m_EntityName + "PromptPlural", SkinID, ThisCustomer.LocaleSetting); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); if (CommonLogic.QueryStringCanBeDangerousContent("EntityName").Length == 0) { Response.Redirect(AppLogic.AdminLinkUrl("default.aspx")); } m_EntitySpecs = EntityDefinitions.LookupSpecs(CommonLogic.QueryStringCanBeDangerousContent("EntityName")); SectionTitle = String.Format(AppLogic.GetString("Token", ThisCustomer.SkinID, ThisCustomer.LocaleSetting), AppLogic.GetString("AppConfig." + m_EntitySpecs.m_EntityName + "PromptPlural", SkinID, ThisCustomer.LocaleSetting)); AdminLogic.EntityListPageFormHandler(m_EntitySpecs, ThisCustomer, SkinID); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); cust = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = "Invalid Parameters"; return; } if (CommonLogic.FormBool("IsSubmit")) { if (EntityID != 0) { DB.ExecuteSQL(String.Format("delete from {0}{1} where {2}ID={3}", m_EntitySpecs.m_ObjectName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_EntityName, EntityID.ToString())); } for (int i = 0; i <= Request.Form.Count - 1; i++) { if (Request.Form.Keys[i].IndexOf("DisplayOrder_") != -1) { String[] keys = Request.Form.Keys[i].Split('_'); int ObjectID = Localization.ParseUSInt(keys[1]); int DispOrd = 1; try { DispOrd = Localization.ParseUSInt(Request.Form[Request.Form.Keys[i]]); } catch { } DB.ExecuteSQL(String.Format("insert into {0}{1}({2}ID,{3}ID,DisplayOrder) values({4},{5},{6})", m_EntitySpecs.m_ObjectName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_ObjectName, EntityID.ToString(), ObjectID.ToString(), DispOrd.ToString())); } } } LoadBody(); }
protected void Page_Load(object sender, System.EventArgs e) { EntityId = CommonLogic.QueryStringUSInt("EntityID"); EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(EntitySpecs, 0); if (EntityId == 0 || EntityName.Length == 0) { RenderContainer.Text = "Invalid Parameters"; return; } SelectedLocale = LocaleSource.GetDefaultLocale(); Render(SelectedLocale.Name); DataBind(); }
protected void Page_Load(object sender, System.EventArgs e) { EntityId = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(EntitySpecs, 0); if (EntityId == 0 || EntityName.Length == 0) { AlertMessageDisplay.PushAlertMessage(AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); MainBody.Visible = false; return; } SelectedLocale = LocaleSource.GetDefaultLocale(); LoadBody(SelectedLocale.Name); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = AppLogic.LookupHelper(EntityHelpers, m_EntitySpecs.m_EntityName); if (EntityID == 0 || EntityName.Length == 0) { Response.Redirect(AppLogic.AdminLinkUrl("default.aspx")); } if (CommonLogic.FormBool("IsSubmit")) { if (EntityID != 0) { DB.ExecuteSQL(String.Format("delete from {0}{1} where {2}ID={3}", m_EntitySpecs.m_ObjectName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_EntityName, EntityID.ToString())); } for (int i = 0; i <= Request.Form.Count - 1; i++) { if (Request.Form.Keys[i].IndexOf("DisplayOrder_") != -1) { String[] keys = Request.Form.Keys[i].Split('_'); int ObjectID = Localization.ParseUSInt(keys[1]); int DispOrd = 1; try { DispOrd = Localization.ParseUSInt(Request.Form[Request.Form.Keys[i]]); } catch { } DB.ExecuteSQL(String.Format("insert into {0}{1}({2}ID,{3}ID,DisplayOrder) values({4},{5},{6})", m_EntitySpecs.m_ObjectName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_EntityName, m_EntitySpecs.m_ObjectName, EntityID.ToString(), ObjectID.ToString(), DispOrd.ToString())); } } } SectionTitle = AppLogic.GetString("admin.sectiontitle.displayorder", SkinID, LocaleSetting); RenderHtml(); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); cust = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } LoadBody(); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); String EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); if (EntityName.IndexOf("<script>", StringComparison.InvariantCultureIgnoreCase) != -1) { throw new ArgumentException("SECURITY EXCEPTION"); } String EntityID = CommonLogic.QueryStringCanBeDangerousContent("EntityID"); if (EntityName.Length != 0 && EntityID != String.Empty) { EntityHelper eHlp = new EntityHelper(EntityDefinitions.LookupSpecs(EntityName)); Response.Write(XmlCommon.XmlEncode(AppLogic.GetStoreHTTPLocation(false) + SE.MakeEntityLink(EntityName, EntityID, String.Empty)) + Environment.NewLine); Response.Write(eHlp.GetEntityYahooObjectList(EntityID, Localization.WebConfigLocale, String.Empty, String.Empty)); } }
protected void loadDD() { ddCategory.Items.Clear(); ddSection.Items.Clear(); ddManufacturer.Items.Clear(); ddCategory.Items.Add(new ListItem(" - " + AppLogic.GetString("admin.common.AllCategories", SkinID, LocaleSetting) + " - ", "0")); ddSection.Items.Add(new ListItem(" - " + AppLogic.GetString("admin.common.AllSections", SkinID, LocaleSetting) + " - ", "0")); ddManufacturer.Items.Add(new ListItem(" - " + AppLogic.GetString("admin.common.AllManufacturers", SkinID, LocaleSetting) + " -", "0")); //Categories EntityHelper Helper = new EntityHelper(EntityDefinitions.LookupSpecs("Category"), 0); ArrayList al = Helper.GetEntityArrayList(0, String.Empty, 0, cust.LocaleSetting, false); foreach (ListItemClass li in al) { ddCategory.Items.Add(new ListItem(li.Item, li.Value.ToString())); } //Sections Helper = new EntityHelper(EntityDefinitions.LookupSpecs("Section"), 0); al = Helper.GetEntityArrayList(0, String.Empty, 0, cust.LocaleSetting, false); foreach (ListItemClass li in al) { ddSection.Items.Add(new ListItem(li.Item, li.Value.ToString())); } //Products //Manufacturers Helper = new EntityHelper(EntityDefinitions.LookupSpecs("Manufacturer"), 0); al = Helper.GetEntityArrayList(0, String.Empty, 0, cust.LocaleSetting, false); foreach (ListItemClass li in al) { ddManufacturer.Items.Add(new ListItem(li.Item, li.Value.ToString())); } }
private void InitializeEntityTypes() { entitySpecs = EntityDefinitions.LookupSpecs(EntityType); switch (EntityType.ToUpperInvariant()) { case "MANUFACTURER": InitializeClientSideHelpers("Manufacturer"); entityHelper = AppLogic.ManufacturerStoreEntityHelper[0]; break; case "DISTRIBUTOR": ShowEmailFields(); InitializeClientSideHelpers("Distributor"); entityHelper = AppLogic.DistributorStoreEntityHelper[0]; break; default: InitializeClientSideHelpers("Category"); entityHelper = AppLogic.CategoryStoreEntityHelper[0]; break; } }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); cust = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { for (int i = 0; i <= Request.Form.Count - 1; i++) { String FieldName = Request.Form.Keys[i]; if (FieldName.StartsWith("shippingcost", StringComparison.InvariantCultureIgnoreCase) && !FieldName.EndsWith("_vldt", StringComparison.InvariantCultureIgnoreCase)) { String[] FieldNameSplit = FieldName.Split('_'); int ThisVariantID = Localization.ParseUSInt(FieldNameSplit[1]); int ThisShippingMethodID = Localization.ParseUSInt(FieldNameSplit[2]); decimal ShippingCost = CommonLogic.FormUSDecimal(FieldName); DB.ExecuteSQL("delete from ShippingByProduct where VariantID=" + ThisVariantID.ToString() + " and ShippingMethodID=" + ThisShippingMethodID.ToString()); DB.ExecuteSQL("insert ShippingByProduct(VariantID,ShippingMethodID,ShippingCost) values(" + ThisVariantID.ToString() + "," + ThisShippingMethodID.ToString() + "," + Localization.CurrencyStringForDBWithoutExchangeRate(ShippingCost) + ")"); } } } LoadBody(); }
protected void Page_Load(object sender, System.EventArgs e) { EntityId = CommonLogic.QueryStringUSInt("EntityID"); EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(EntitySpecs, 0); if (EntityId == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { for (var i = 0; i <= Request.Form.Count - 1; i++) { var fieldName = Request.Form.Keys[i]; if (fieldName.StartsWith("shippingcost", StringComparison.InvariantCultureIgnoreCase) && !fieldName.EndsWith("_vldt", StringComparison.InvariantCultureIgnoreCase)) { var fieldNameSplit = fieldName.Split('_'); var variantId = Localization.ParseUSInt(fieldNameSplit[1]); var shippingMethodId = Localization.ParseUSInt(fieldNameSplit[2]); var shippingCost = CommonLogic.FormUSDecimal(fieldName); DB.ExecuteSQL("delete from ShippingByProduct where VariantID=" + variantId.ToString() + " and ShippingMethodID=" + shippingMethodId.ToString()); DB.ExecuteSQL("insert ShippingByProduct(VariantID,ShippingMethodID,ShippingCost) values(" + variantId.ToString() + "," + shippingMethodId.ToString() + "," + Localization.CurrencyStringForDBWithoutExchangeRate(shippingCost) + ")"); } } AlertMessageDisplay.PushAlertMessage("The shipping costs have been saved.", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } SelectedLocale = LocaleSource.GetDefaultLocale(); LoadBody(SelectedLocale.Name); }
protected void Page_Load(object sender, System.EventArgs e) { Customer ThisCustomer = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; MobileHelper.RedirectPageWhenMobileIsDisabled("~/googleindex.aspx", ThisCustomer); Response.ContentType = "text/xml"; Response.ContentEncoding = new System.Text.UTF8Encoding(); Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"); Response.Write("<sitemapindex xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n"); Response.Write("<sitemap>"); Response.Write("<loc>" + AppLogic.GetStoreHTTPLocation(false) + "mobilegoogletopics.aspx</loc>"); Response.Write("</sitemap>\n"); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.CategoryStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Category"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.SectionStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Section"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.ManufacturerStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Manufacturer"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.DistributorStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Distributor"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.GenreStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Genre"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.VectorStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Vector"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write(GetMobileEntityGoogleSiteMap(AppLogic.LibraryStoreEntityHelper[0], EntityDefinitions.LookupSpecs("Library"), 0, MobilePlatform.MobileLocaleDefault, true, true)); Response.Write("</sitemapindex>"); }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); cust = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { ProductCollection products = new ProductCollection(m_EntitySpecs.m_EntityName, EntityID); products.PageSize = 0; products.PageNum = 1; products.PublishedOnly = false; products.ReturnAllVariants = true; DataSet dsProducts = products.LoadFromDB(); int NumProducts = products.NumProducts; foreach (DataRow row in dsProducts.Tables[0].Rows) { int ThisProductID = DB.RowFieldInt(row, "ProductID"); int ThisVariantID = DB.RowFieldInt(row, "VariantID"); decimal Price = System.Decimal.Zero; decimal SalePrice = System.Decimal.Zero; decimal MSRP = System.Decimal.Zero; decimal Cost = System.Decimal.Zero; if (CommonLogic.FormCanBeDangerousContent("Price_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { Price = CommonLogic.FormUSDecimal("Price_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("SalePrice_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { SalePrice = CommonLogic.FormUSDecimal("SalePrice_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("MSRP_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { MSRP = CommonLogic.FormUSDecimal("MSRP_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("Cost_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { Cost = CommonLogic.FormUSDecimal("Cost_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } StringBuilder sql = new StringBuilder(1024); sql.Append("update productvariant set "); sql.Append("Price=" + Localization.DecimalStringForDB(Price) + ","); sql.Append("SalePrice=" + CommonLogic.IIF(SalePrice != System.Decimal.Zero, Localization.DecimalStringForDB(SalePrice), "NULL") + ","); sql.Append("MSRP=" + CommonLogic.IIF(MSRP != System.Decimal.Zero, Localization.DecimalStringForDB(MSRP), "NULL") + ","); sql.Append("Cost=" + CommonLogic.IIF(Cost != System.Decimal.Zero, Localization.DecimalStringForDB(Cost), "NULL")); sql.Append(" where VariantID=" + ThisVariantID.ToString()); DB.ExecuteSQL(sql.ToString()); } dsProducts.Dispose(); } LoadBody(); }
protected void Page_Load(object sender, EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); ThisCustomer = ((AspDotNetStorefrontPrincipal)Context.User).ThisCustomer; eID = CommonLogic.QueryStringNativeInt("EntityID"); eName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); eSpecs = EntityDefinitions.LookupSpecs(eName); entity = new EntityHelper(eSpecs, 0); pID = CommonLogic.QueryStringNativeInt("ProductID"); ProductSKU = AppLogic.GetProductSKU(pID); if (!IsPostBack) { ltEntity.Text = entity.GetEntityBreadcrumb6(eID, ThisCustomer.LocaleSetting); ltProduct.Text = "<a href=\"" + AppLogic.AdminLinkUrl("entityEditProducts.aspx") + "?iden=" + pID + "&entityName=" + eName + "&entityFilterID=" + eID + "\">" + AppLogic.GetProductName(pID, ThisCustomer.LocaleSetting) + " (" + pID + ")</a>"; string query = CommonLogic.QueryStringCanBeDangerousContent("searchfor"); ViewState["SQLString"] = selectSQL; //set page settings if (ThisCustomer.ThisCustomerSession.Session("productVariantsSort").Length == 0) { ViewState["Sort"] = "DisplayOrder, Name"; } else { ViewState["Sort"] = ThisCustomer.ThisCustomerSession.Session("productVariantsSort"); } if (ThisCustomer.ThisCustomerSession.Session("productVariantsOrder").Length == 0) { ViewState["SortOrder"] = "ASC"; } else { ViewState["SortOrder"] = ThisCustomer.ThisCustomerSession.Session("productVariantsOrder"); } if (ThisCustomer.ThisCustomerSession.Session("productVariantsSearch").Length != 0) { query = ThisCustomer.ThisCustomerSession.Session("productVariantsSearch"); } resultFilter(query); btnDeleteVariants.Attributes.Add("onclick", string.Format( "return confirm('{0}');", DeleteAllPrompt)); if (0 < DB.GetSqlN("select count(*) N from ShoppingCart with (NOLOCK) where ProductID=" + pID.ToString() + " and CartType=" + ((int)CartTypeEnum.RecurringCart).ToString())) { btnDeleteVariants.Enabled = false; btnDeleteVariants.Visible = false; } AppLogic.MakeSureProductHasAtLeastOneVariant(pID); } AppLogic.EnsureProductHasADefaultVariantSet(pID); }
protected void Page_Load(object sender, System.EventArgs e) { EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { AlertMessageDisplay.PushAlertMessage(AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting), AspDotNetStorefrontControls.AlertMessage.AlertType.Error); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { var products = new ProductCollection(m_EntitySpecs.m_EntityName, EntityID); products.PageSize = 0; products.PageNum = 1; products.PublishedOnly = false; products.ReturnAllVariants = true; var dsProducts = products.LoadFromDB(); var NumProducts = products.NumProducts; foreach (DataRow row in dsProducts.Tables[0].Rows) { var ThisProductID = DB.RowFieldInt(row, "ProductID"); var ThisVariantID = DB.RowFieldInt(row, "VariantID"); var Price = System.Decimal.Zero; var SalePrice = System.Decimal.Zero; var MSRP = System.Decimal.Zero; var Cost = System.Decimal.Zero; if (CommonLogic.FormCanBeDangerousContent("Price_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { Price = CommonLogic.FormUSDecimal("Price_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("SalePrice_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { SalePrice = CommonLogic.FormUSDecimal("SalePrice_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("MSRP_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { MSRP = CommonLogic.FormUSDecimal("MSRP_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } if (CommonLogic.FormCanBeDangerousContent("Cost_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()).Length != 0) { Cost = CommonLogic.FormUSDecimal("Cost_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); } var sql = new StringBuilder(1024); sql.Append("update productvariant set "); sql.Append("Price=" + Localization.DecimalStringForDB(Price) + ","); sql.Append("SalePrice=" + CommonLogic.IIF(SalePrice != System.Decimal.Zero, Localization.DecimalStringForDB(SalePrice), "NULL") + ","); sql.Append("MSRP=" + CommonLogic.IIF(MSRP != System.Decimal.Zero, Localization.DecimalStringForDB(MSRP), "NULL") + ","); sql.Append("Cost=" + CommonLogic.IIF(Cost != System.Decimal.Zero, Localization.DecimalStringForDB(Cost), "NULL")); sql.Append(" where VariantID=" + ThisVariantID.ToString()); DB.ExecuteSQL(sql.ToString()); } dsProducts.Dispose(); AlertMessageDisplay.PushAlertMessage("The prices have been updated.", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } SelectedLocale = LocaleSource.GetDefaultLocale(); LoadBody(SelectedLocale.Name); }
protected void Page_Load(object sender, System.EventArgs e) { EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { Response.Redirect(AppLogic.AdminLinkUrl("default.aspx")); } SelectedLocale = LocaleSource.GetDefaultLocale(); if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { for (var i = 0; i <= Request.Form.Count - 1; i++) { var FieldName = Request.Form.Keys[i]; if (FieldName.StartsWith("setitle", StringComparison.InvariantCultureIgnoreCase)) { var FieldNameSplit = FieldName.Split('_'); var TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); var TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); var inputVal = AppLogic.FormLocaleXml("SETitle", CommonLogic.FormCanBeDangerousContent(FieldName), SelectedLocale.Name, "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SETitle=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SETitle=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } if (FieldName.StartsWith("sekeywords", StringComparison.InvariantCultureIgnoreCase)) { var FieldNameSplit = FieldName.Split('_'); var TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); var TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); var inputVal = AppLogic.FormLocaleXml("SEKeywords", CommonLogic.FormCanBeDangerousContent(FieldName), SelectedLocale.Name, "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SEKeywords=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SEKeywords=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } if (FieldName.StartsWith("sedescription", StringComparison.InvariantCultureIgnoreCase)) { var FieldNameSplit = FieldName.Split('_'); var TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); var TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); var inputVal = AppLogic.FormLocaleXml("SEDescription", CommonLogic.FormCanBeDangerousContent(FieldName), SelectedLocale.Name, "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SEDescription=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SEDescription=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } } AlertMessageDisplay.PushAlertMessage("The search engine fields have been saved.", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } LoadBody(SelectedLocale.Name); }
protected void Page_Load(object sender, System.EventArgs e) { EntityID = CommonLogic.QueryStringUSInt("EntityID"); if (EntityID < 1) { EntityID = CommonLogic.FormNativeInt("EntityID"); } EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); if (String.IsNullOrEmpty(EntityName)) { EntityName = CommonLogic.FormCanBeDangerousContent("EntityName"); } m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { ltBody.Text = AppLogic.GetString("admin.common.InvalidParameters", SkinID, LocaleSetting); return; } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { var products = new ProductCollection(m_EntitySpecs.m_EntityName, EntityID); products.PageSize = 0; products.PageNum = 1; products.PublishedOnly = false; products.ReturnAllVariants = true; using (var dsProducts = products.LoadFromDB()) { var NumProducts = products.NumProducts; foreach (DataRow row in dsProducts.Tables[0].Rows) { if (DB.RowFieldBool(row, "IsDownload")) { var ThisProductID = DB.RowFieldInt(row, "ProductID"); var ThisVariantID = DB.RowFieldInt(row, "VariantID"); var sql = new StringBuilder(1024); sql.Append("update productvariant set "); var DLoc = CommonLogic.FormCanBeDangerousContent("DownloadLocation_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString()); if (DLoc.StartsWith("/")) { DLoc = DLoc.Substring(1, DLoc.Length - 1); // remove leading / char! } sql.Append("DownloadLocation=" + DB.SQuote(DLoc)); sql.Append(" where VariantID=" + ThisVariantID.ToString()); DB.ExecuteSQL(sql.ToString()); } } } AlertMessage.PushAlertMessage("Download Files Saved", AspDotNetStorefrontControls.AlertMessage.AlertType.Success); } SelectedLocale = LocaleSource.GetDefaultLocale(); LoadBody(SelectedLocale.Name); }
protected void Page_Load(object sender, EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); eID = CommonLogic.QueryStringNativeInt("EntityFilterID"); eName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); eSpecs = EntityDefinitions.LookupSpecs(eName); switch (eName.ToUpperInvariant()) { case "SECTION": ltPreEntity.Text = AppLogic.GetString("admin.common.SectionApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_SectionEntitySpecs, 0); break; case "MANUFACTURER": ltPreEntity.Text = AppLogic.GetString("admin.common.ManufacturerApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_ManufacturerEntitySpecs, 0); break; case "DISTRIBUTOR": ltPreEntity.Text = AppLogic.GetString("admin.common.DistributorApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_DistributorEntitySpecs, 0); break; case "GENRE": ltPreEntity.Text = AppLogic.GetString("admin.common.GenreApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_GenreEntitySpecs, 0); break; case "VECTOR": ltPreEntity.Text = AppLogic.GetString("admin.common.VectorApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_VectorEntitySpecs, 0); break; case "LIBRARY": ltPreEntity.Text = AppLogic.GetString("admin.common.LibraryApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_LibraryEntitySpecs, 0); break; default: ltPreEntity.Text = AppLogic.GetString("admin.common.CategoryApos", SkinID, LocaleSetting); entity = new EntityHelper(EntityDefinitions.readonly_CategoryEntitySpecs, 0); break; } if (!IsPostBack) { ltEntity.Text = entity.GetEntityBreadcrumb6(eID, LocaleSetting); string query = CommonLogic.QueryStringCanBeDangerousContent("searchfor"); loadTree(); loadTypes(); ViewState["SQLString"] = selectSQL; //set page settings if (ThisCustomer.ThisCustomerSession.Session("ProductsSort").Length == 0) { ViewState["Sort"] = "Name"; } else { ViewState["Sort"] = ThisCustomer.ThisCustomerSession.Session("ProductsSort"); } if (ThisCustomer.ThisCustomerSession.Session("ProductsOrder").Length == 0) { ViewState["SortOrder"] = "ASC"; } else { ViewState["SortOrder"] = ThisCustomer.ThisCustomerSession.Session("ProductsOrder"); } if (ThisCustomer.ThisCustomerSession.Session("ProductsSearch").Length != 0) { query = ThisCustomer.ThisCustomerSession.Session("ProductsSearch"); } if (ThisCustomer.ThisCustomerSession.Session("ProductsTree").Length != 0) { treeMain.FindNode(ThisCustomer.ThisCustomerSession.Session("ProductsTree")).Selected = true; } if (ThisCustomer.ThisCustomerSession.Session("ProductsType").Length != 0) { ddTypes.Items.FindByValue(ThisCustomer.ThisCustomerSession.Session("ProductsType")).Selected = true; } resultFilter(query); txtSearch.Attributes.Add("onKeyPress", "javascript:if (event.keyCode == 13) __doPostBack('btnSearch','')"); if (AppLogic.MaxProductsExceeded()) { btnAdd.Enabled = false; btnAdd.CssClass = "normalButtonsDisabled"; ltError.Text = "<font class=\"errorMsg\">" + AppLogic.GetString("admin.entityProducts.ErrorMsg", SkinID, LocaleSetting) + "</font> "; } else { btnAdd.Enabled = true; btnAdd.CssClass = "normalButtons"; } } }
protected void Page_Load(object sender, System.EventArgs e) { Response.CacheControl = "private"; Response.Expires = 0; Response.AddHeader("pragma", "no-cache"); EntityID = CommonLogic.QueryStringUSInt("EntityID");; EntityName = CommonLogic.QueryStringCanBeDangerousContent("EntityName"); m_EntitySpecs = EntityDefinitions.LookupSpecs(EntityName); Helper = new EntityHelper(m_EntitySpecs, 0); if (EntityID == 0 || EntityName.Length == 0) { Response.Redirect(AppLogic.AdminLinkUrl("default.aspx")); } if (CommonLogic.FormCanBeDangerousContent("IsSubmit").Equals("TRUE", StringComparison.InvariantCultureIgnoreCase)) { for (int i = 0; i <= Request.Form.Count - 1; i++) { String FieldName = Request.Form.Keys[i]; if (FieldName.StartsWith("setitle", StringComparison.InvariantCultureIgnoreCase)) { String[] FieldNameSplit = FieldName.Split('_'); int TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); int TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); string inputVal = AppLogic.FormLocaleXml("SETitle", CommonLogic.FormCanBeDangerousContent(FieldName), ThisCustomer.ThisCustomerSession.Session("entityUserLocale"), "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SETitle=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SETitle=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } if (FieldName.StartsWith("sekeywords", StringComparison.InvariantCultureIgnoreCase)) { String[] FieldNameSplit = FieldName.Split('_'); int TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); int TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); string inputVal = AppLogic.FormLocaleXml("SEKeywords", CommonLogic.FormCanBeDangerousContent(FieldName), ThisCustomer.ThisCustomerSession.Session("entityUserLocale"), "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SEKeywords=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SEKeywords=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } if (FieldName.StartsWith("sedescription", StringComparison.InvariantCultureIgnoreCase)) { String[] FieldNameSplit = FieldName.Split('_'); int TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); int TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); string inputVal = AppLogic.FormLocaleXml("SEDescription", CommonLogic.FormCanBeDangerousContent(FieldName), ThisCustomer.ThisCustomerSession.Session("entityUserLocale"), "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SEDescription=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SEDescription=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } if (FieldName.StartsWith("senoscript", StringComparison.InvariantCultureIgnoreCase)) { String[] FieldNameSplit = FieldName.Split('_'); int TheProductID = Localization.ParseUSInt(FieldNameSplit[1]); int TheVariantID = Localization.ParseUSInt(FieldNameSplit[2]); string inputVal = AppLogic.FormLocaleXml("SENoScript", CommonLogic.FormCanBeDangerousContent(FieldName), ThisCustomer.ThisCustomerSession.Session("entityUserLocale"), "Product", TheProductID); if (inputVal.Length == 0) { DB.ExecuteSQL("update Product set SENoScript=NULL where ProductID=" + TheProductID.ToString()); } else { DB.ExecuteSQL("update Product set SENoScript=" + DB.SQuote(inputVal) + " where ProductID=" + TheProductID.ToString()); } } } } LoadBody(); }
public ViewResult Index(int?productTypeFilterId) { var customer = HttpContext.GetCustomer(); var settings = SiteMapSettingsProvider.LoadSiteMapSettings(); var viewModel = new SiteMapViewModel { ShowCategories = settings.ShowCategories, ShowManufacturers = settings.ShowManufacturers, ShowSections = settings.ShowSections, ShowTopics = settings.ShowTopics, ShowProducts = settings.ShowProducts, ShowCustomerService = settings.ShowCustomerService }; if (settings.ShowProducts) { // Using named routes drastically improves performance for sites with many products. var routingConfiguration = RoutingConfigurationProvider.GetRoutingConfiguration(); string productRouteName; if (routingConfiguration.LegacyRouteGenerationEnabled) { productRouteName = RouteNames.Product; } else if (routingConfiguration.SeNameOnlyRoutesEnabled) { productRouteName = RouteNames.ModernProductSeNameOnly; } else { productRouteName = RouteNames.ModernProduct; } using (var connection = new SqlConnection(DB.GetDBConn())) using (var command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "aspdnsf_GetProducts"; command.Parameters.AddWithValue("@CustomerLevelID", customer.CustomerLevelID); command.Parameters.AddWithValue("@affiliateID", customer.AffiliateID); command.Parameters.AddWithValue("@ProductTypeID", productTypeFilterId); command.Parameters.AddWithValue("@InventoryFilter", settings.InventoryThreshold); command.Parameters.AddWithValue("@localeName", customer.LocaleSetting); command.Parameters.AddWithValue("@storeID", customer.StoreID); command.Parameters.AddWithValue("@filterProduct", settings.ProductFiltering); command.Parameters.AddWithValue("@ViewType", 1); command.Parameters.AddWithValue("@pagenum", 1); command.Parameters.AddWithValue("@pagesize", 2147483647); command.Parameters.AddWithValue("@StatsFirst", 0); command.Parameters.AddWithValue("@publishedonly", 1); command.Parameters.AddWithValue("@ExcludeKits", 0); command.Parameters.AddWithValue("@ExcludeSysProds", 1); connection.Open(); using (var reader = command.ExecuteReader()) while (reader.Read()) { var id = reader.FieldInt("ProductID"); var localizedName = XmlCommon.GetLocaleEntry( reader.Field("name"), customer.LocaleSetting, fallBack: true); var seName = reader.Field("sename"); viewModel.Products.Add( new Models.SiteMapEntity { Name = localizedName, Url = Url.BuildProductLink(id, seName) }); } } } if (settings.ShowTopics) { using (var connection = DB.dbConn()) { connection.Open(); using (var reader = DB.GetRS( @"declare @storeSpecificTopics table ( topicid int, name varchar(max), title varchar(max), storeid int, displayorder int ) insert into @storeSpecificTopics select topicid, name, title, storeid, displayorder from topic as dt with (nolock) where showinsitemap = 1 and deleted = 0 and published = 1 and(storeid = @storeId) and @filterTopic = 1 select topicid, name, title, storeid, displayorder from topic as dt with (nolock) where showinsitemap = 1 and deleted = 0 and published = 1 and(storeid = 0) and name not in (select name from @storeSpecificTopics) union select * from @storeSpecificTopics order by displayorder, title" , connection, new SqlParameter("@filterTopic", settings.TopicFiltering), new SqlParameter("@storeId", customer.StoreID))) { while (reader.Read()) { var topicId = reader.FieldInt("topicid"); var name = reader.Field("name"); var localizedTitle = XmlCommon.GetLocaleEntry( reader.Field("title"), customer.LocaleSetting, fallBack: true); viewModel.Topics.Add( new Models.SiteMapEntity() { Name = localizedTitle, Url = Url.BuildTopicLink(name) }); } } } } if (settings.ShowCustomerService) { viewModel.CustomerService.Add( new Models.SiteMapEntity() { Name = AppLogic.GetString("menu.YourAccount"), Url = Url.Action(ActionNames.Index, ControllerNames.Account) }); viewModel.CustomerService.Add( new Models.SiteMapEntity() { Name = AppLogic.GetString("menu.OrderHistory"), Url = string.Concat( Url.Action(ActionNames.Index, ControllerNames.Account), "#orderhistory") }); viewModel.CustomerService.Add( new Models.SiteMapEntity() { Name = AppLogic.GetString("menu.Contact"), Url = Url.Action(ActionNames.Index, ControllerNames.ContactUs) }); } if (settings.ShowCategories) { EntityHelper entityHelper = new EntityHelper( CacheMinutes: 0, eSpecs: EntityDefinitions.LookupSpecs(EntityTypes.Category), PublishedOnly: true, StoreID: 0); viewModel.Categories = AddEntities( entityHelper .m_TblMgr .XmlDoc .SelectNodes("/root/Entity"), customer, EntityTypes.Category); } if (settings.ShowSections) { EntityHelper entityHelper = new EntityHelper( CacheMinutes: 0, eSpecs: EntityDefinitions.LookupSpecs(EntityTypes.Section), PublishedOnly: true, StoreID: 0); viewModel.Sections = AddEntities( entityHelper .m_TblMgr .XmlDoc .SelectNodes("/root/Entity"), customer, EntityTypes.Section); } if (settings.ShowManufacturers) { EntityHelper entityHelper = new EntityHelper( CacheMinutes: 0, eSpecs: EntityDefinitions.LookupSpecs(EntityTypes.Manufacturer), PublishedOnly: true, StoreID: 0); viewModel.Manufacturers = AddEntities( entityHelper .m_TblMgr .XmlDoc .SelectNodes("/root/Entity"), customer, EntityTypes.Manufacturer); } return(View(ViewNames.SiteMap, viewModel)); }