protected void Page_Load(object sender, EventArgs e)
{
EntityHelper CategoryHelper = AppLogic.LookupHelper("Category", 0);
ThisCustomer = (Page as SkinBase).ThisCustomer;
baseSkinID = (Page as SkinBase).SkinID;
using (SqlConnection conn = DB.dbConn())
{
conn.Open();
using (IDataReader rs = DB.GetRS("select p.*, pv.name variantname from product p with (NOLOCK) join productvariant pv with (NOLOCK) on p.ProductID = pv.ProductID and pv.isdefault = 1 where p.ProductID=" + ProductID.ToString(), conn))
{
if (!rs.Read())
{
Response.Redirect("default.aspx");
}
SEName = DB.RSField(rs, "SEName");
ProductName = DB.RSFieldByLocale(rs, "Name", ThisCustomer.LocaleSetting);
VariantName = DB.RSFieldByLocale(rs, "VariantName", ThisCustomer.LocaleSetting);
RequiresReg = DB.RSFieldBool(rs, "RequiresRegistration");
ProductDescription = DB.RSFieldByLocale(rs, "Description", ThisCustomer.LocaleSetting);
if (AppLogic.ReplaceImageURLFromAssetMgr)
{
ProductDescription = ProductDescription.Replace("../images", "images");
}
String FileDescription = new ProductDescriptionFile(ProductID, ThisCustomer.LocaleSetting, baseSkinID).Contents;
if (FileDescription.Length != 0)
{
ProductDescription += "<div align=\"left\">" + FileDescription + "</div>";
}
}
}
String SourceEntityInstanceName = String.Empty;
SourceEntity = Profile.LastViewedEntityName;
SourceEntityInstanceName = Profile.LastViewedEntityInstanceName;
SourceEntityID = int.Parse(CommonLogic.IIF(CommonLogic.IsInteger(Profile.LastViewedEntityInstanceID), Profile.LastViewedEntityInstanceID, "0"));;
// validate that source entity id is actually valid for this product:
if (SourceEntityID != 0)
{
String sqlx = "select count(*) as N from dbo.productentity with (NOLOCK) where ProductID=" + ProductID.ToString() + " and EntityID=" + SourceEntityID.ToString() + " and EntityType = " + DB.SQuote(SourceEntity);
if (DB.GetSqlN(sqlx) == 0)
{
SourceEntityID = 0;
}
}
// we had no entity context coming in, try to find a category context for this product, so they have some context if possible:
if (SourceEntityID == 0)
{
SourceEntityID = EntityHelper.GetProductsFirstEntity(ProductID, EntityDefinitions.readonly_CategoryEntitySpecs.m_EntityName);
if (SourceEntityID > 0)
{
CategoryID = SourceEntityID;
CategoryName = CategoryHelper.GetEntityName(CategoryID, ThisCustomer.LocaleSetting);
Profile.LastViewedEntityName = EntityDefinitions.readonly_CategoryEntitySpecs.m_EntityName;
Profile.LastViewedEntityInstanceID = CategoryID.ToString();
Profile.LastViewedEntityInstanceName = CategoryName;
SourceEntity = EntityDefinitions.readonly_CategoryEntitySpecs.m_EntityName;
SourceEntityInstanceName = CategoryName;
}
}
// we had no entity context coming in, try to find a section context for this product, so they have some context if possible:
if (SourceEntityID == 0)
{
SourceEntityID = EntityHelper.GetProductsFirstEntity(ProductID, EntityDefinitions.readonly_SectionEntitySpecs.m_EntityName);
if (SourceEntityID > 0)
{
SectionID = SourceEntityID;
SectionName = CategoryHelper.GetEntityName(SectionID, ThisCustomer.LocaleSetting);
Profile.LastViewedEntityName = EntityDefinitions.readonly_SectionEntitySpecs.m_EntityName;
Profile.LastViewedEntityInstanceID = SectionID.ToString();
Profile.LastViewedEntityInstanceName = SectionName;
SourceEntity = EntityDefinitions.readonly_SectionEntitySpecs.m_EntityName;
SourceEntityInstanceName = SectionName;
}
}
// we had no entity context coming in, try to find a Manufacturer context for this product, so they have some context if possible:
if (SourceEntityID == 0)
{
SourceEntityID = EntityHelper.GetProductsFirstEntity(ProductID, EntityDefinitions.readonly_ManufacturerEntitySpecs.m_EntityName);
if (SourceEntityID > 0)
{
ManufacturerID = SourceEntityID;
ManufacturerName = CategoryHelper.GetEntityName(ManufacturerID, ThisCustomer.LocaleSetting);
Profile.LastViewedEntityName = EntityDefinitions.readonly_ManufacturerEntitySpecs.m_EntityName;
Profile.LastViewedEntityInstanceID = ManufacturerID.ToString();
Profile.LastViewedEntityInstanceName = ManufacturerName;
SourceEntity = EntityDefinitions.readonly_ManufacturerEntitySpecs.m_EntityName;
SourceEntityInstanceName = ManufacturerName;
}
}
// build up breadcrumb if we need:
(Page as SkinBase).SectionTitle = Breadcrumb.GetProductBreadcrumb(ProductID, ProductName, SourceEntity, SourceEntityID, ThisCustomer);
reqToAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.13", baseSkinID, ThisCustomer.LocaleSetting);
regexToAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.14", baseSkinID, ThisCustomer.LocaleSetting);
reqFromAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.16", baseSkinID, ThisCustomer.LocaleSetting);
regexFromAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.17", baseSkinID, ThisCustomer.LocaleSetting);
if (!this.IsPostBack)
{
InitializePageContent();
}
}
protected void Page_Load(object sender, EventArgs e)
{
productID = CommonLogic.QueryStringUSInt("productId");
ItemCode = InterpriseHelper.GetInventoryItemCode(productID);
EntityHelper CategoryHelper = AppLogic.LookupHelper(base.EntityHelpers, "Category");
EntityHelper SectionHelper = AppLogic.LookupHelper(base.EntityHelpers, "Department");
EntityHelper ManufacturerHelper = AppLogic.LookupHelper(base.EntityHelpers, "Manufacturer");
CategoryID = CommonLogic.QueryStringCanBeDangerousContent("CategoryID");
DepartmentID = CommonLogic.QueryStringCanBeDangerousContent("DepartmentID");
ManufacturerID = CommonLogic.QueryStringCanBeDangerousContent("ManufacturerID");
String SourceEntity = "Category";
String SourceEntityID = String.Empty;
if (AppLogic.AppConfigBool("GoNonSecureAgain"))
{
SkinBase.GoNonSecureAgain();
}
// DOS attack prevention:
if (AppLogic.OnLiveServer() && (Request.UrlReferrer == null || Request.UrlReferrer.Authority != Request.Url.Authority))
{
Response.Redirect(SE.MakeDriverLink("EmailError"));
}
if (ItemCode == String.Empty)
{
Response.Redirect("default.aspx");
}
if (AppLogic.ProductHasBeenDeleted(productID))
{
Response.Redirect(SE.MakeDriverLink("ProductNotFound"));
}
using (SqlConnection con = DB.NewSqlConnection())
{
con.Open();
using (IDataReader rs = DB.GetRSFormat(con, "SELECT * FROM EcommerceViewProduct with (NOLOCK) " +
" WHERE Counter=" + productID +
" AND ShortString=" + DB.SQuote(ThisCustomer.LocaleSetting) +
" AND WebSiteCode=" + DB.SQuote(InterpriseHelper.ConfigInstance.WebSiteCode)))
{
if (!rs.Read())
{
Response.Redirect("default.aspx");
}
SEName = SE.MungeName(DB.RSField(rs, "SEName"));
if (DB.RSField(rs, "ItemDescription").ToString() != String.Empty)
{
ProductName = DB.RSField(rs, "ItemDescription");
}
else
{
ProductName = DB.RSField(rs, "ItemName");
}
RequiresReg = DB.RSFieldBool(rs, "RequiresRegistration");
ProductDescription = DB.RSField(rs, "ItemDescription");
if (AppLogic.ReplaceImageURLFromAssetMgr)
{
ProductDescription = ProductDescription.Replace("../images", "images");
}
String FileDescription = new ProductDescriptionFile(ItemCode, ThisCustomer.LocaleSetting, SkinID).Contents;
if (FileDescription.Length != 0)
{
ProductDescription += "<div align=\"left\">" + FileDescription + "</div>";
}
}
}
if (Convert.ToInt32(CategoryID) == 0)
{
// no category passed in, pick first one that this product is mapped to:
String tmpS = CategoryHelper.GetObjectEntities(ItemCode, false);
if (tmpS.Length != 0)
{
String[] catIDs = tmpS.Split(',');
CategoryID = Convert.ToString(Localization.ParseUSInt(catIDs[0]));
}
}
string CategoryName = CommonLogic.IIF(CategoryHelper.GetEntityField(CategoryID, "Description", ThisCustomer.LocaleSetting) != String.Empty, CategoryHelper.GetEntityField(CategoryID, "Description", ThisCustomer.LocaleSetting), CategoryHelper.GetEntityName(CategoryID, ThisCustomer.LocaleSetting));
string SectionName = CommonLogic.IIF(SectionHelper.GetEntityField(DepartmentID, "Description", ThisCustomer.LocaleSetting) != String.Empty, SectionHelper.GetEntityField(DepartmentID, "Description", ThisCustomer.LocaleSetting), SectionHelper.GetEntityName(DepartmentID, ThisCustomer.LocaleSetting));
string ManufacturerName = CommonLogic.IIF(ManufacturerHelper.GetEntityField(ManufacturerID, "Description", ThisCustomer.LocaleSetting) != String.Empty, ManufacturerHelper.GetEntityField(ManufacturerID, "Description", ThisCustomer.LocaleSetting), ManufacturerHelper.GetEntityName(ManufacturerID, ThisCustomer.LocaleSetting));
SourceEntity = CommonLogic.CookieCanBeDangerousContent("LastViewedEntityName", true);
String SourceEntityInstanceName = CommonLogic.CookieCanBeDangerousContent("LastViewedEntityInstanceName", true);
SourceEntityID = CommonLogic.CookieCanBeDangerousContent("LastViewedEntityInstanceID", true);
// validate that source entity id is actually valid for this product:
if (SourceEntityID.Length != 0)
{
ArrayList alE = EntityHelper.GetProductEntityList(ItemCode, SourceEntity);
if (alE.IndexOf(Localization.ParseNativeInt(SourceEntityID)) == -1)
{
SourceEntityID = String.Empty;
}
}
if (SourceEntityID.Length != 0)
{
PickupBreadCrumb(ref SourceEntity, ref SourceEntityInstanceName, ref SourceEntityID, false);
}
else
{
PickupBreadCrumb(ref SourceEntity, ref SourceEntityInstanceName, ref SourceEntityID, true);
}
SectionTitle += "<span class=\"SectionTitleText\">";
SectionTitle += ProductName;
SectionTitle += "</span>";
reqToAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.13", SkinID, ThisCustomer.LocaleSetting, true);
regexToAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.14", SkinID, ThisCustomer.LocaleSetting, true);
reqFromAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.16", SkinID, ThisCustomer.LocaleSetting, true);
regexFromAddress.ErrorMessage = AppLogic.GetString("emailproduct.aspx.17", SkinID, ThisCustomer.LocaleSetting, true);
if (!this.IsPostBack)
{
InitializePageContent();
}
}
