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