protected void Page_Load(object sender, EventArgs e) { if (Session["LoggedIn"] != null) { ((HtmlAnchor)(FindControl("loginbtn"))).InnerText = "Log Out"; ((HtmlAnchor)FindControl("loginbtn2")).InnerText = "Log Out"; txtUserId.InnerText = (String)Session["LoggedIn"]; ((HtmlAnchor)(FindControl("loginbtn"))).HRef = "#modal2"; ((HtmlAnchor)(FindControl("loginbtn2"))).HRef = "#modal2"; ((HtmlAnchor)(FindControl("loginbtn"))).Attributes.Add("class", "waves-effect waves-light btn modal-trigger green lighten-2"); ((HtmlAnchor)(FindControl("loginbtn2"))).Attributes.Add("class", "waves-effect waves-light btn modal-trigger green lighten-2"); } else { Response.Redirect("default.aspx?dn=Y"); } // retire mag if (!String.IsNullOrEmpty(Request.QueryString["ret"])) { magID = Request.QueryString["ret"]; string CS = ConfigurationManager.ConnectionStrings["ReMag-DBConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("UPDATE MyMags SET retired = 'Y', posted = 'N' WHERE MagID = '" + magID + "'", conn); DataSet ds = new DataSet(); da.Fill(ds); } } // unretire if (!String.IsNullOrEmpty(Request.QueryString["unret"])) { magID = Request.QueryString["unret"]; string CS = ConfigurationManager.ConnectionStrings["ReMag-DBConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("UPDATE MyMags SET retired = 'N', posted = 'N' WHERE MagID = '" + magID + "'", conn); DataSet ds = new DataSet(); da.Fill(ds); } } // post the mag if (!String.IsNullOrEmpty(Request.QueryString["pid"])) { magID = Request.QueryString["pid"]; string CS = ConfigurationManager.ConnectionStrings["ReMag-DBConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("UPDATE MyMags SET posted = 'Y' WHERE MagID = '" + magID + "'", conn); DataSet ds = new DataSet(); da.Fill(ds); } var x = "no title"; var y = "no description"; SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ReMag-DBConnectionString"].ConnectionString); conn2.Open(); var cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM MyMags WHERE [MagID] = " + Request.QueryString["pid"]; cmd.Connection = conn2; var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { x = (string)reader["title"]; y = (string)reader["description"]; } } reader.Close(); conn2.Close(); SendMail senderObject = new SendMail(); List <string> myList = senderObject.GetSubscribedEmails(); // adds all emails to a List<string> senderObject.SendNewMagEmailNow(myList, // sends list to sender object "New Mag available on ReMag", "<h1>New Mag available on ReMag</h1>A user of Remag has posted a new magazine." + "Go to mstrong.ca:88 to view.<br><br><b>title:</b> " + x + "<br><b>description:</b> " + y + "<br/><br/>" + "<a href=\"http://mstrong.ca:88\">http://mstrong.ca:88</a>.<br/><br/><br/>", Request.QueryString["pid"], Session["LoggedInID"].ToString()); } // unpost the mag if (!String.IsNullOrEmpty(Request.QueryString["uid"])) { magID = Request.QueryString["uid"]; string CS = ConfigurationManager.ConnectionStrings["ReMag-DBConnectionString"].ConnectionString; using (SqlConnection conn = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("UPDATE MyMags SET posted = 'N' WHERE MagID = '" + magID + "'", conn); DataSet ds = new DataSet(); da.Fill(ds); } MySharedClasses sharedObject = new MySharedClasses(); sharedObject.Log("magID: " + magID, Int32.Parse(Session["LoggedInID"].ToString()), "mag un-posted"); } }