public void Tag_ItemDataBound( object sender, RepeaterItemEventArgs e ) { if ( e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem ) { DbDataRecord rd = ( DbDataRecord )e.Item.DataItem; var TagCloud = e.Item.FindControl( "TagCloud" ) as Literal; myFunctions myFunctionsInstance = new myFunctions(); string Tag = myFunctionsInstance.Stripper( rd["Tag"].ToString() ); string Slug = rd[ "Slug" ].ToString(); int TagID = Convert.ToInt32(rd["TagID"]); TagCloud.Text = "<li><a class=\"btn\" href=\"/" + varConst.cSEODirectory + "/tag/" + TagID + "/" + Slug + "/\">" + rd["Tag"] + " Shirts</a></li>"; } }
public void Tag_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DbDataRecord rd = ( DbDataRecord )e.Item.DataItem; var TagCloud = e.Item.FindControl("TagCloud") as Literal; myFunctions myFunctionsInstance = new myFunctions(); string Tag = myFunctionsInstance.Stripper(rd["Tag"].ToString()); string Slug = rd["Slug"].ToString(); int TagID = Convert.ToInt32(rd["TagID"]); TagCloud.Text = "<li><a class=\"btn\" href=\"/" + varConst.cSEODirectory + "/tag/" + TagID + "/" + Slug + "/\">" + rd["Tag"] + " Shirts</a></li>"; } }
//BUILD THE SHIRT'S TAG LIST public void ShirtTags_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DbDataRecord dbrd = (DbDataRecord)e.Item.DataItem; var ShirtTagCloud = e.Item.FindControl("ShirtTags") as Literal; string Tag = myFunctionsInstance.Stripper(dbrd["Tag"].ToString()); int TagID = Convert.ToInt32(dbrd["TagID"]); if (varConst.cSiteName == "damptshirts") { ShirtTagCloud.Text = "<li><a class=\"btn\" href='/" + varConst.cSEODirectory + "/tag/" + TagID + "/" + Tag + "/'>" + dbrd["Tag"] + "</a></li>"; } else { ShirtTagCloud.Text = "<li><a class=\"btn\" href='/" + Tag + "/tag/" + TagID + "/'>" + dbrd["Tag"] + "</a></li>"; } } }
public void Page_Load(object sender, EventArgs e) { (( DampTShirts )this.Master).strImage = varConst.cDefaultShareIMG; strImage = varConst.cDefaultShareIMG; strURL = "http://www." + varConst.cSiteName + ".com/"; //if ( Request.Cookies[varConst.cSiteName] != null ) { //myCookie = Server.HtmlEncode(Request.Cookies[varConst.cSiteName].Value); //Trace.Write("MY NEW COOKIE: " + myCookie); //} string Search = myFunctionsInstance.unStrip(Request.QueryString["Search"] ?? "0"); string TempTagID = Request.QueryString["TagID"] ?? "0"; int TagID = Convert.ToInt32(TempTagID); string Tag = Request.QueryString["Tag"] ?? ""; string tempPage = Request.QueryString["Page"] ?? "1"; PageNum = Convert.ToInt32(tempPage); NextPage = PageNum + 1; PreviousPage = PageNum - 1; if (PreviousPage == 0) { PreviousPage = 1; } // START VARIABLES // if (Search != "0") { strH1 = varConst.cH1Search + Search; this.Page.Title = varConst.cTitle; metaKeywords = Search + ", " + metaKeywords; metaDescription = "The best " + Search + " shirts from all over the internet. Vote for the best t-shirts on " + varConst.cSiteName + ".com"; } else if (TagID > 0) { string myTag = ""; varDbConn.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = varDbConn.conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Digg_GetTagDetail"; cmd.Parameters.Add("@TagID", SqlDbType.Int); cmd.Parameters["@TagID"].Value = TagID; SqlDataReader rdrTag = cmd.ExecuteReader(); if (rdrTag.HasRows) { while (rdrTag.Read()) { myTag = rdrTag["Tag"].ToString(); metaKeywords = rdrTag["MetaKeywords"].ToString(); strImage = rdrTag["Image"].ToString(); strURL = strURL + "shirt/tag/" + TagID + "/" + myFunctionsInstance.Stripper(myTag).ToString() + "/"; } } rdrTag.Close(); varDbConn.conn.Close(); strH1 = myTag; if (TagID != 474) { strH1 = strH1 + varConst.cH1Tag; } this.Page.Title = myTag + varConst.cH1Tag; metaKeywords = myTag + " shirts, " + metaKeywords; metaDescription = "The best " + myTag + " shirts from all over the internet. Vote for the best t-shirts on " + varConst.cSiteName + ".com"; } else { strH1 = varConst.cH1Default; this.Page.Title = varConst.cTitle; metaKeywords = varConst.keywords(); metaDescription = varConst.cDescription; } Trace.Write("Page is: " + Page); Trace.Write("TagID is: " + TagID); Trace.Write("Tag is: " + Tag); Trace.Write("Search is: " + Search); using (varDbConn.conn) { varDbConn.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = varDbConn.conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Damp_Products"; cmd.Parameters.Add("@TagID", SqlDbType.Int); cmd.Parameters["@TagID"].Value = TagID; cmd.Parameters.Add("@Search", SqlDbType.VarChar, 50); cmd.Parameters["@Search"].Value = Search; cmd.Parameters.Add("@SiteName", SqlDbType.VarChar, 50); cmd.Parameters["@SiteName"].Value = varConst.cSiteName; cmd.Parameters.Add("@Page", SqlDbType.Int); cmd.Parameters["@Page"].Value = PageNum; cmd.Parameters.Add("@PageSize", SqlDbType.Int); cmd.Parameters["@PageSize"].Value = varConst.perPage; cmd.Parameters.Add("@OrderBy", SqlDbType.VarChar, 50); cmd.Parameters["@OrderBy"].Value = "thumbs"; using (SqlDataReader Products = cmd.ExecuteReader()) { ProductList.DataSource = Products; ProductList.DataBind(); } //JavaScriptSerializer serializer = new JavaScriptSerializer(); //ArrayList arrShirts = new ArrayList(); // while ( drShirts.Read() ) // { // object[] values = new object[ drShirts.FieldCount ]; // drShirts.GetValues( values ); // arrShirts.Add( values ); //} //jsonShirts = serializer.Serialize( arrShirts ); //Trace.Write("JSON: " + jsonShirts); } }
protected void Page_Load(object sender, EventArgs e) { StringBuilder strXML = new StringBuilder(); strXML.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>"); strXML.Append("<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">"); strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/tag-list/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); if (varConst.cSiteName == "damptshirts") { strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/t-shirt-coupons/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/what-is-damp-t-shirts/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/contact/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); } using (varConst.conn) { varConst.conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = varConst.conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = varConst.cSP_SiteMap_Links; cmd.Parameters.Add("@SiteName", SqlDbType.VarChar, 50); cmd.Parameters["@SiteName"].Value = varConst.cSiteName; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { string Product; string Slug; int DiggID; while (rdr.Read()) { Product = Server.UrlEncode(myFunctionsInstance.Stripper(rdr["Title"].ToString())); Slug = rdr["Slug"].ToString(); DiggID = Convert.ToInt32(rdr["DiggID"]); if (Product == "") { Product = varConst.cSiteName + "-shirt"; } if (varConst.cSiteName == "damptshirts") { strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/t/" + varConst.cSEODirectory + "/" + DiggID + "/" + Slug + "/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); } else { strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/" + Slug + "/shirt/" + DiggID + "/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); } } } rdr.Close(); SqlCommand cmd2 = new SqlCommand(); cmd2.Connection = varConst.conn; cmd2.CommandType = CommandType.StoredProcedure; cmd2.CommandText = varConst.cSP_SiteMap_Tags; cmd2.Parameters.Add("@SiteName", SqlDbType.VarChar, 50); cmd2.Parameters["@SiteName"].Value = varConst.cSiteName; SqlDataReader rdr2 = cmd2.ExecuteReader(); if (rdr2.HasRows) { string Tag; string TagSlug; int TagID; while (rdr2.Read()) { Tag = Server.UrlEncode(myFunctionsInstance.Stripper(rdr2["Tag"].ToString())); TagSlug = rdr2["Slug"].ToString(); TagID = Convert.ToInt32(rdr2["TagID"]); if (varConst.cSiteName == "damptshirts") { strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/" + varConst.cSEODirectory + "/tag/" + TagID + "/" + TagSlug + "/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); } else { strXML.Append("<url>"); strXML.Append("<loc>http://www." + varConst.cSiteName + ".com/" + TagSlug + "/tag/" + TagID + "/</loc>"); strXML.Append("<changefreq>weekly</changefreq>"); strXML.Append("</url>"); } } } rdr2.Close(); strXML.Append("</urlset>"); StreamWriter swFromFile = new StreamWriter(varConst.cSiteDirectory + "sitemap.xml"); swFromFile.Write(strXML); swFromFile.Flush(); swFromFile.Close(); } }