public void LoadGoogleAnalytics() { try { OrderInfo order = (OrderInfo)ClientContext.Context["LatestOrder"]; Mediachase.eCF.BusLayer.Orders.Order _order; _order = new Mediachase.eCF.BusLayer.Orders.Order(); _order.LoadByPrimaryKey(order.OrderId); _order = new Mediachase.eCF.BusLayer.Orders.Order(); _order.LoadByPrimaryKey(order.OrderId); StringBuilder sb = new StringBuilder(); sb.AppendLine("<script>"); sb.AppendLine("var pageTracker = _gat._getTracker('UA-8292597-1');"); sb.AppendLine("pageTracker._trackPageview();"); sb.AppendFormat("pageTracker._addTrans('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}' );\n", _order.OrderId, "", Math.Round(_order.TotalPrice, 2), Math.Round(_order.Tax, 2), Math.Round(_order.ShippingCost, 2), order.BillingAddress.City, order.BillingAddress.State, order.BillingAddress.Country); DataSet ds = null; string sql = "select * from dbo.v_OrderSKU where orderid = "+ _order.OrderId; ds = getsql(sql); foreach (DataRow row in ds.Tables[0].Rows) { sb.AppendFormat("pageTracker._addItem('{0}','{1}','{2}','{3}','{4}','{5}');\n", _order.OrderId, row["SKUCode"].ToString(), row["SKUName"].ToString(), "", Math.Round(Convert.ToDouble(row["SKUPrice"].ToString()), 2), row["OrderSKUQuantity"].ToString()); } sb.AppendLine("pageTracker._trackTrans();"); sb.AppendLine("</script>"); GoogleAnalytics.Text = sb.ToString(); } catch (Exception e) { } }
public void LoadDFAPixel() { try { string order_number = ""; OrderInfo order = (OrderInfo)ClientContext.Context["LatestOrder"]; Mediachase.eCF.BusLayer.Orders.Order _order; _order = new Mediachase.eCF.BusLayer.Orders.Order(); _order.LoadByPrimaryKey(order.OrderId); StringBuilder sb = new StringBuilder(); sb.AppendLine("<iframe src=~https://fls.doubleclick.net/activityi;src=2751412;type=zquie919;cat=zquie885;ord=TRANSACTION~?~ width=~1~ height=~1~ frameborder=~0~></iframe>"); sb.Replace("TRANSACTION", order.OrderId.ToString()); sb.Replace("~", ((char)(34)).ToString()); DFAPixel.Text = sb.ToString(); StringBuilder sb1 = new StringBuilder(); sb1.Append("<iframe src =~_SOURCE_~width=~1~ height=~1~ frameborder=~0~></iframe>"); sb1.Replace("_SOURCE_", "https://fls.doubleclick.net/activityi;src=2751412;type=zquie919;cat=zquie885;ord=TRANSACTION~?~"); sb1.Replace("TRANSACTION", order.OrderId.ToString()); sb1.Replace("~", ((char)(34)).ToString()); DFAPixelFrame.Text = sb1.ToString(); } catch (Exception e) { } }
public void DisplayPage() { try { ItemInfo = false; OrderInfo order = (OrderInfo)ClientContext.Context["LatestOrder"]; Mediachase.eCF.BusLayer.Orders.Order _order; _order = new Mediachase.eCF.BusLayer.Orders.Order(); string orderID = Request["orderID"]; if (order == null && string.IsNullOrEmpty(orderID) == false) { _order.LoadByPrimaryKey(int.Parse(orderID)); } else { _order.LoadByPrimaryKey(order.OrderId); } if (_order == null) { Response.Redirect("~"); } StringBuilder sb = new StringBuilder(); DataSet ds21 = getsql("select uid from [order] where orderid=" + _order.OrderId.ToString()); LitPixel2.Text = ""; if (ds21.Tables.Count > 0) { if (ds21.Tables[0].Rows.Count > 0) { if (ds21.Tables[0].Rows[0].ItemArray[0] != null) { if (ds21.Tables[0].Rows[0].ItemArray[0].ToString().ToUpper() == "ASN_ZZZ_0001") { LitPixel2.Text = "<img src='https://www.howlifeworks.com/Lib/conversion_tracker.aspx?Adv_ID=403' width='1' height='1' alt='' />"; } } } } // foreach (OrderItem i in order.OrderItems) foreach (OrderSku i in _order.OrderSku) { StringBuilder _sb = new StringBuilder(); _sb.Append(table); // _sb.Replace("{Description}", i.ProductTitle); _sb.Replace("{Description}", i.Sku.MetaFields["Everything_Description"].ToString()); //_sb.Replace("{Description}", i.Sku.Name); if (i.SkuId == 347) { _sb.Replace("{Quantity}", i.Quantity.ToString()); _sb.Replace("{Price}*", "7.95".ToString()); } else if (i.SkuId == 336) { ItemInfo = true; _sb.Replace("{Quantity}", i.Quantity.ToString()); _sb.Replace("{Price}", "9.95".ToString()); } else { _sb.Replace("{Quantity}", i.Quantity.ToString()); _sb.Replace("{Price}*", Math.Round(Convert.ToDouble((i.Quantity * i.Price).ToString()), 2).ToString()); } sb.Append(_sb.ToString()); } sb.Replace("~", ((char)(34)).ToString()); LiteralTableRows.Text = sb.ToString(); LiteralSubTotal.Text = Math.Round(_order.SubTotal, 2).ToString(); LiteralShipping.Text = Math.Round(_order.ShippingCost, 2).ToString(); LiteralTax.Text = Math.Round(_order.Tax, 2).ToString(); LiteralTotal.Text = Math.Round((_order.SubTotal + _order.ShippingCost + _order.Tax), 2).ToString(); DataSet shippingAddress = getsql("SELECT A.*, country.Code FROM [ORDERSHIPMENT] OS INNER JOIN ADDRESS A ON A.ADDRESSID = OS.ADDRESSID LEFT OUTER JOIN COUNTRY ON COUNTRY.COUNTRYID = A.COUNTRYID WHERE ORDERID = " + _order.OrderId); if (shippingAddress != null && shippingAddress.Tables.Count > 0) { LiteralName.Text = shippingAddress.Tables[0].Rows[0]["FirstName"].ToString() + " " + shippingAddress.Tables[0].Rows[0]["LastName"].ToString(); LiteralAddress.Text = shippingAddress.Tables[0].Rows[0]["Address1"].ToString(); LiteralAddress2.Text = shippingAddress.Tables[0].Rows[0]["Address2"].ToString(); LiteralCity.Text = shippingAddress.Tables[0].Rows[0]["City"].ToString(); LiteralState.Text = shippingAddress.Tables[0].Rows[0]["StateProvince"].ToString(); LiteralZip.Text = shippingAddress.Tables[0].Rows[0]["ZipPostalCode"].ToString(); LiteralCountry.Text = shippingAddress.Tables[0].Rows[0]["Code"].ToString(); } LiteralEmail.Text = _order.Email.ToString(); DataSet billingAddress = getsql("SELECT A.*, country.Code FROM [ORDER] O INNER JOIN ADDRESS A ON A.ADDRESSID = O.BILLINGADDRESSID LEFT OUTER JOIN COUNTRY ON COUNTRY.COUNTRYID = A.COUNTRYID WHERE ORDERID = " + _order.OrderId); if (billingAddress != null && shippingAddress.Tables.Count > 0) { LiteralName_b.Text = shippingAddress.Tables[0].Rows[0]["FirstName"].ToString() + " " + shippingAddress.Tables[0].Rows[0]["LastName"].ToString(); LiteralAddress_b.Text = shippingAddress.Tables[0].Rows[0]["Address1"].ToString(); LiteralAddress2_b.Text = shippingAddress.Tables[0].Rows[0]["Address2"].ToString(); LiteralCity_b.Text = shippingAddress.Tables[0].Rows[0]["City"].ToString(); LiteralState_b.Text = shippingAddress.Tables[0].Rows[0]["StateProvince"].ToString(); LiteralZip_b.Text = shippingAddress.Tables[0].Rows[0]["ZipPostalCode"].ToString(); LiteralCountry_b.Text = shippingAddress.Tables[0].Rows[0]["Code"].ToString(); } ConversionSystems.MediaChase.Web.ProductHelper.SendOrderCompletedEmail(_order, ClientContext.Context.CurrentLanguage, RM, ItemInfo); //Get 3rd Party Upsell. broker mySSOLWS = new broker(); WDIAuthHeader myAuthHeader = new WDIAuthHeader(); mySSOLWS.Url = "https://secure.majorsavings.com/SmartSellOnlineWS/broker.asmx?wsdl"; myAuthHeader.Username = "******"; myAuthHeader.Password = "******"; myAuthHeader.AffiliateId = 98; mySSOLWS.WDIAuthHeaderValue = myAuthHeader; SSTeaser myTeaser = default(SSTeaser); string ccexp = Convert.ToDateTime(_order.CreditCardExpired).ToString("MMyyyy"); string ccnum = _order.CreditCardNumber; string cctype = ""; if (_order.CreditCardName.ToLower().Contains("visa")) { cctype = "V"; } else if (_order.CreditCardName.ToLower().Contains("AmericanExpress")) { cctype = "A"; } else if (_order.CreditCardName.ToLower().Contains("Discover")) { cctype = "D"; } else if (_order.CreditCardName.ToLower().Contains("MasterCard")) { cctype = "M"; } else if (_order.CreditCardName.ToLower().Contains("amex")) { cctype = "A"; } string countryCode = ""; if (LiteralCountry_b.Text.ToLower().Contains("us")) { countryCode = "1"; } else if (LiteralCountry_b.Text.Contains("canada")) { countryCode = "2"; } string t = "ZQUIET2" + "" + _order.Email + LiteralName_b.Text + LiteralAddress_b.Text + "" + LiteralCity_b.Text + LiteralState_b.Text + LiteralZip_b.Text + countryCode + GetCleanPhoneNumber(billingAddress.Tables[0].Rows[0]["PhoneNumber"].ToString()) + cctype + ccnum + ccexp + _order.OrderId + "N"; myTeaser = mySSOLWS.getTeaser("ZQUIET2", "", _order.Email, billingAddress.Tables[0].Rows[0]["FirstName"].ToString(), billingAddress.Tables[0].Rows[0]["LastName"].ToString(), LiteralAddress_b.Text, "", LiteralCity_b.Text, LiteralState_b.Text, LiteralZip_b.Text, countryCode, GetCleanPhoneNumber(billingAddress.Tables[0].Rows[0]["PhoneNumber"].ToString()), cctype, ccnum, ccexp, _order.OrderId, "N"); test.Text = t; if (myTeaser.rc == 0) { SmartSell.NavigateUrl = myTeaser.target; SmartSell.ImageUrl = myTeaser.source; SmartSell.Visible = true; } else { SmartSell.Visible = false; } PanelItemInfo.Visible = ItemInfo; } catch (Exception e) { } }