protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
anm_Utility ut = new anm_Utility();
if (Request.QueryString["tag"] == null)
{
if (Request.QueryString["author"] == null)
{
if (Request.QueryString["category"] != null)
{
string category = Request.QueryString["category"];
if (Request.QueryString["year"] == null)
{
GridView2.DataSourceID = "SqlDataSource3";
GridView3.DataSourceID = "SqlDataSource5";
GridView4.DataSourceID = "SqlDataSource7";
Page.Title = ut.GetCategory(Request.QueryString["category"]) + " - " + ut.GetSetting("SiteName");
}
else
{
int year = Convert.ToInt32(Request.QueryString["year"].ToString());
int categ = Convert.ToInt32(category);
int month = Convert.ToInt32(Request.QueryString["month"].ToString());
if (ut.GetNumberArticles(month, year, categ) == 0)
{
int i = 1;
while (i < 13 && ut.GetNumberArticles(i, year, categ) == 0)
{
i++;
}
if (i != 13)
{
Response.Redirect(apath + "/month_" + i + "/year_" + year + "/category" + categ + ".aspx");
}
}
if (ut.GetNumberArticles(1, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "January").ToString() + " (" + ut.GetNumberArticles(1, year, categ) + ")", "1"));
}
if (ut.GetNumberArticles(2, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "February").ToString() + " (" + ut.GetNumberArticles(2, year, categ) + ")", "2"));
}
if (ut.GetNumberArticles(3, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "March").ToString() + " (" + ut.GetNumberArticles(3, year, categ) + ")", "3"));
}
if (ut.GetNumberArticles(4, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "April").ToString() + " (" + ut.GetNumberArticles(4, year, categ) + ")", "4"));
}
if (ut.GetNumberArticles(5, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "May").ToString() + " (" + ut.GetNumberArticles(5, year, categ) + ")", "5"));
}
if (ut.GetNumberArticles(6, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "June").ToString() + " (" + ut.GetNumberArticles(6, year, categ) + ")", "6"));
}
if (ut.GetNumberArticles(7, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "July").ToString() + " (" + ut.GetNumberArticles(7, year, categ) + ")", "7"));
}
if (ut.GetNumberArticles(8, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "August").ToString() + " (" + ut.GetNumberArticles(8, year, categ) + ")", "8"));
}
if (ut.GetNumberArticles(9, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "September").ToString() + "(" + ut.GetNumberArticles(9, year, categ) + ")", "9"));
}
if (ut.GetNumberArticles(10, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "October").ToString() + " (" + ut.GetNumberArticles(10, year, categ) + ")", "10"));
}
if (ut.GetNumberArticles(11, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "November").ToString() + " (" + ut.GetNumberArticles(11, year, categ) + ")", "11"));
}
if (ut.GetNumberArticles(12, year, categ) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "December").ToString() + " (" + ut.GetNumberArticles(12, year, categ) + ")", "12"));
}
int archiveYear = Convert.ToInt32(ut.GetSetting("Year").ToString());
int currentYear = DateTime.Now.Year;
while (archiveYear <= currentYear)
{
ddYear.Items.Add(new ListItem(archiveYear.ToString(), archiveYear.ToString()));
archiveYear++;
}
ddYear.Visible = lblYear.Visible = lblMonth.Visible = ddMonth.Visible = true;
ddYear.SelectedValue = Request.QueryString["year"].ToString();
ddMonth.SelectedValue = Request.QueryString["month"].ToString();
if (Request.QueryString["month"] != null)
{
Page.Title = ut.GetCategory(ut.GetIdFather(category)) + " - " + ut.GetCategory(category) + " - " + GetGlobalResourceObject("language", "Year") + ": " + Request.QueryString["year"].ToString() + " - " + GetGlobalResourceObject("language", "Month") + ": " + ut.SetLongMonth(Convert.ToInt32(Request.QueryString["month"].ToString())) + " - " + ut.GetSetting("SiteName");
}
else
{
Page.Title = ut.GetCategory(ut.GetIdFather(category)) + " - " + ut.GetCategory(category) + " - " + GetGlobalResourceObject("language", "Year") + ": " + Request.QueryString["year"].ToString() + " - " + ut.GetSetting("SiteName");
}
GridView2.DataSourceID = "SqlDataSource15";
GridView3.DataSourceID = "SqlDataSource11";
GridView4.DataSourceID = "SqlDataSource13";
}
}
else
{
if (Request.QueryString["year"] == null)
{
GridView2.DataSourceID = "SqlDataSource4";
GridView3.DataSourceID = "SqlDataSource6";
GridView4.DataSourceID = "SqlDataSource8";
Page.Title = ut.GetSetting("SiteName");
}
else
{
int year = Convert.ToInt32(Request.QueryString["year"].ToString());
int month = Convert.ToInt32(Request.QueryString["month"].ToString());
if (ut.GetNumberArticles(month, year) == 0)
{
int i = 1;
while (i < 13 && ut.GetNumberArticles(i, year) == 0)
{
i++;
}
if (i != 13)
{
Response.Redirect(apath + "/year_" + year + "/month_" + i + ".aspx");
}
}
if (ut.GetNumberArticles(1, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "January").ToString() + " (" + ut.GetNumberArticles(1, year) + ")", "1"));
}
if (ut.GetNumberArticles(2, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "February").ToString() + " (" + ut.GetNumberArticles(2, year) + ")", "2"));
}
if (ut.GetNumberArticles(3, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "March").ToString() + " (" + ut.GetNumberArticles(3, year) + ")", "3"));
}
if (ut.GetNumberArticles(4, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "April").ToString() + " (" + ut.GetNumberArticles(4, year) + ")", "4"));
}
if (ut.GetNumberArticles(5, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "May").ToString() + " (" + ut.GetNumberArticles(5, year) + ")", "5"));
}
if (ut.GetNumberArticles(6, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "June").ToString() + " (" + ut.GetNumberArticles(6, year) + ")", "6"));
}
if (ut.GetNumberArticles(7, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "July").ToString() + " (" + ut.GetNumberArticles(7, year) + ")", "7"));
}
if (ut.GetNumberArticles(8, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "August").ToString() + " (" + ut.GetNumberArticles(8, year) + ")", "8"));
}
if (ut.GetNumberArticles(9, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "September").ToString() + " (" + ut.GetNumberArticles(9, year) + ")", "9"));
}
if (ut.GetNumberArticles(10, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "October").ToString() + " (" + ut.GetNumberArticles(10, year) + ")", "10"));
}
if (ut.GetNumberArticles(11, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "November").ToString() + " (" + ut.GetNumberArticles(11, year) + ")", "11"));
}
if (ut.GetNumberArticles(12, year) != 0)
{
ddMonth.Items.Add(new ListItem(GetGlobalResourceObject("language", "December").ToString() + " (" + ut.GetNumberArticles(12, year) + ")", "12"));
}
int archiveYear = Convert.ToInt32(ut.GetSetting("Year").ToString());
int currentYear = DateTime.Now.Year;
while (archiveYear <= currentYear)
{
ddYear.Items.Add(new ListItem(archiveYear.ToString(), archiveYear.ToString()));
archiveYear++;
}
ddYear.Visible = lblYear.Visible = lblMonth.Visible = ddMonth.Visible = true;
ddYear.SelectedValue = Request.QueryString["year"].ToString();
ddMonth.SelectedValue = Request.QueryString["month"].ToString();
if (Request.QueryString["month"] != null)
{
Page.Title = GetGlobalResourceObject("language", "Year") + ": " + Request.QueryString["year"].ToString() + " - " + GetGlobalResourceObject("language", "Month") + ": " + ut.SetLongMonth(Convert.ToInt32(Request.QueryString["month"].ToString())) + " - " + ut.GetSetting("SiteName");
}
else
{
Page.Title = GetGlobalResourceObject("language", "Year") + ": " + Request.QueryString["year"].ToString() + " - " + ut.GetSetting("SiteName");
}
GridView2.DataSourceID = "SqlDataSource16";
GridView3.DataSourceID = "SqlDataSource12";
GridView4.DataSourceID = "SqlDataSource14";
}
}
}
else
{
string value = ut.UrlDecode(Request.QueryString["author"].ToString());
Page.Title = GetGlobalResourceObject("language", "PostedByAllArticles") + " " + value + " - " + ut.GetSetting("SiteName");
lblauthor.Text = GetGlobalResourceObject("language", "PostedByAllArticles") + " <b>" + value + "</b>:";
lblauthor.Font.Size = 16;
}
}
else
{
string text = ut.UrlDecode(Request.QueryString["tag"].ToString());
string value = text.Replace("[", "[[]");
value = value.Replace("%", "[%]");
value = value.Replace("_", "[_]");
Page.Title = GetGlobalResourceObject("language", "RelatedToAllArticles") + " " + value + " - " + ut.GetSetting("SiteName");
lblauthor.Text = GetGlobalResourceObject("language", "RelatedToAllArticles") + " <b>" + text + "</b>:";
lblauthor.Font.Size = 16;
}
if (Request.QueryString["page"] != null)
{
Page.Title = Page.Title + " - " + GetGlobalResourceObject("language", "Page") + ": " + Request.QueryString["page"];
}
HtmlMeta keywords = new HtmlMeta();
keywords.Name = "description";
keywords.Content = Page.Title;
Page.Header.Controls.Add(keywords);
if (Request.QueryString["category"] != null & Request.QueryString["month"] != null)
{
HLContentArchive.NavigateUrl = apath + "/archive/month_" + Request.QueryString["month"] + "/year_" + Request.QueryString["year"] + "/category" + Request.QueryString["category"] + ".aspx";
}
else if (Request.QueryString["category"] != null)
{
HLContentArchive.NavigateUrl = apath + "/archive/month_" + DateTime.Now.Month + "/year_" + DateTime.Now.Year + "/category" + Request.QueryString["category"] + ".aspx";
}
else if (Request.QueryString["month"] != null)
{
HLContentArchive.NavigateUrl = apath + "/archive/year_" + Request.QueryString["year"] + "/month_" + Request.QueryString["month"] + ".aspx";
}
else
{
HLContentArchive.NavigateUrl = apath + "/archive/year_" + DateTime.Now.Year + "/month_" + DateTime.Now.Month + ".aspx";
}
}
}
protected void BtnFatherCat_Click(object sender, EventArgs e)
{
try
{
string idf = DdlFatherCat.SelectedValue;
string strConn = ConfigurationManager.ConnectionStrings["anmcs"].ToString();
SqlConnection myConnection = new SqlConnection(strConn);
SqlCommand myCommand = new SqlCommand("anm_getCategoriesById", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@idcategory", SqlDbType.Int).Value = DdlFatherCat.SelectedValue;
myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();
string idrootcat = "";
while (reader.Read())
{
if (reader["idrootcat"].ToString() == "0" || reader["idrootcat"].ToString() == "" || reader["idrootcat"].ToString() == null)
{
idrootcat = DdlFatherCat.SelectedValue;
}
else
{
idrootcat = reader["idrootcat"].ToString();
}
}
myConnection.Close();
string idc = lblidc.Text;
if (idf != idc)
{
anm_Utility ut = new anm_Utility();
string father = ut.GetIdFather(idf);
if (father != idc)
{
SqlConnection myConnection2 = new SqlConnection(strConn);
SqlCommand myCommand2 = new SqlCommand();
myCommand2.Connection = myConnection2;
myConnection2.Open();
myCommand2.Parameters.Add("@idfather", SqlDbType.Int).Value = Convert.ToInt32(idf);
myCommand2.Parameters.Add("@idcategory", SqlDbType.Int).Value = Convert.ToInt32(idc);
myCommand2.Parameters.Add("@idrootcat", SqlDbType.NVarChar).Value = idrootcat;
myCommand2.CommandText = "UPDATE anm_Categories SET idfather = @idfather, idrootcat = @idrootcat WHERE idcategory = @idcategory";
myCommand2.ExecuteScalar();
myConnection2.Close();
GridView1.DataBind();
Label1.Text = GetGlobalResourceObject("language", "CategoryUpdated").ToString();
Label1.Visible = true;
lblcfc.Visible = DdlFatherCat.Visible = BtnFatherCat.Visible = false;
}
else
{
Label1.Text = GetGlobalResourceObject("language", "chooseanothercat").ToString();
Label1.Visible = true;
}
}
else
{
Label1.Text = GetGlobalResourceObject("language", "cannotchoosesamecat").ToString();
Label1.Visible = true;
}
}
catch (Exception ex)
{
Label1.Text = ex.Message;
Label1.Visible = true;
}
}
protected string ViewSideMenu()
{
anm_Utility ut = new anm_Utility();
string category = "";
if (Request.QueryString["news"] != null)
{
category = ut.GetCategoryFromNews(Request.QueryString["news"]);
}
if (Request.QueryString["category"] != null)
{
category = Request.QueryString["category"];
}
if (category == "")
{
string menu = "";
if (ut.GetSetting("SideMenu") == "True")
{
menu = ut.GetSideMenu();
}
return(menu);
}
else
{
string apath = anm_Utility.GetWebAppRoot();
string idfather = ut.GetIdFather(category);
String[] categories = new String[20];
string res = "";
int i = 1;
categories[0] = category;
while (!idfather.Equals("0"))
{
categories[i] = idfather;
idfather = ut.GetIdFather(idfather);
i++;
}
for (int j = 0; categories[j] != null; j++)
{
string cat = ut.GetCategory(categories[j]);
string url = ut.GetCategoryUrl(categories[j]);
if (url == "" || url == null)
{
res = "<li><a href='" + apath + "/subscribe/" + categories[j] + ".aspx'><img src='" + apath + "/images/rssicon.gif' alt='rss' style='border: none;' /></a> <strong><a href='" + apath + "/category" + categories[j] + ".aspx'>" + cat + "</a></strong></li>" + res;
}
else
{
res = "<li> <strong><a href='" + url + "'>" + cat + "</a></strong></li>" + res;
}
}
string linksons = "";
string strConn = ConfigurationManager.ConnectionStrings["anmcs"].ToString();
SqlConnection myConnection = new SqlConnection(strConn);
SqlCommand myCommand = new SqlCommand("anm_getSonCategories", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@idcategory", SqlDbType.NVarChar).Value = category;
myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();
while (reader.Read())
{
string url = reader["url"].ToString();
string idc = reader["idcategory"].ToString();
string cat = reader["category"].ToString();
if (url == "" || url == null)
{
linksons += "<li class='menulinksons'><a href='" + apath + "/subscribe/" + idc + ".aspx'><img src='" + apath + "/images/rssicon.gif' alt='rss' style='border: none;' /></a> <strong><a href='" + apath + "/category" + idc + ".aspx'>" + cat + "</a></strong></li>";
}
else
{
linksons += "<li class='menulinksons'> <strong><a href='" + url + "'>" + cat + "</a></strong></li>";
}
}
myConnection.Close();
if (linksons != "")
{
//res += "<ul class='menulinksons'>" + linksons + "</ul>";
res += linksons;
}
if (ut.GetSetting("SideMenu") == "True")
{
return("<h2>" + HttpContext.GetGlobalResourceObject("language", "Menu") + "</h2><div class='sp'><ul>" + res + "</ul></div>");
}
else
{
return("");
}
}
}
