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