protected void btnSubmit_Click(object sender, EventArgs e)
{
if (lbxArticles.SelectedIndex == -1)
{
DataLayer dl = new DataLayer();
DateTime dtPostTime = DateTime.Now;
dl.AddArticle(dtPostTime, tbxTitle.Text, rteBody.Value, User.Identity.Name, ddlCategory.SelectedValue);
SqlCommand sc = new SqlCommand("SELECT ArticleID FROM rnxArticles WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds = dl.CustomQuery(sc);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString());
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
string sURL = objReader.ReadToEnd();
Yedda.Twitter t = new Yedda.Twitter();
t.Update("ReferralNetworX", "1million!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{ }
if (cbxDiscussionThread.Checked)
{
dl.AddForumTopic(14, User.Identity.Name, tbxTitle.Text, "<a href=\"Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view article</a><br /><br />Discuss this article below.", dtPostTime, false, false);
SqlCommand sc2 = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc2.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc2.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds2 = dl.CustomQuery(sc2);
string sTopicID = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
dl.UpdateArticle(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), tbxTitle.Text, rteBody.Value + "<br /><br /><a href=\"Topic.aspx?topic=" + sTopicID + "\">Click to discuss this article</a>");
}
SmtpClient smtp = new SmtpClient("localhost");
MailMessage mm;
mm = new MailMessage();
mm.IsBodyHtml = true;
mm.To.Add("*****@*****.**");
mm.To.Add("*****@*****.**");
mm.From = new MailAddress("*****@*****.**");
mm.Subject = "Someone posted an article.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted an article titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The article is below:<br /><br />" + rteBody.Value;
smtp.Send(mm);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Added";
Session["resultMessage"] = "Article Added Successfuly";
Session["resultReturnURL"] = "Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString();
Response.Redirect("Result.aspx");
}
else
{
if (cbxDeleteArticle.Checked)
{
DataLayer dl = new DataLayer();
DataTable dtArticle = dl.GetArticleBy_ArticleID(Convert.ToInt32(lbxArticles.SelectedValue));
try
{
SqlCommand sc = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", dtArticle.Rows[0].ItemArray[2].ToString()));
sc.Parameters.Add(new SqlParameter("Date", Convert.ToDateTime(dtArticle.Rows[0].ItemArray[1])));
DataSet ds = dl.CustomQuery(sc);
dl.DeleteForumTopic(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]));
}
catch
{
}
dl.DeleteArticle(Convert.ToInt32(lbxArticles.SelectedValue));
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Deleted";
Session["resultMessage"] = "Article Deleted Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
else
{
DataLayer dl = new DataLayer();
dl.UpdateArticle(Convert.ToInt32(lbxArticles.SelectedValue), tbxTitle.Text, rteBody.Value);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Updated";
Session["resultMessage"] = "Article Updated Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (lbxArticles.SelectedIndex == -1)
{
DataLayer dl = new DataLayer();
DateTime dtPostTime = DateTime.Now;
dl.AddArticle(dtPostTime, tbxTitle.Text, rteBody.Value, User.Identity.Name, ddlCategory.SelectedValue);
SqlCommand sc = new SqlCommand("SELECT ArticleID FROM rnxArticles WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds = dl.CustomQuery(sc);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString());
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
string sURL = objReader.ReadToEnd();
Yedda.Twitter t = new Yedda.Twitter();
t.Update("ReferralNetworX", "1million!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{ }
if (cbxDiscussionThread.Checked)
{
dl.AddForumTopic(14, User.Identity.Name, tbxTitle.Text, "<a href=\"Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view article</a><br /><br />Discuss this article below.", dtPostTime, false, false);
SqlCommand sc2 = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc2.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc2.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds2 = dl.CustomQuery(sc2);
string sTopicID = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
dl.UpdateArticle(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), tbxTitle.Text, rteBody.Value + "<br /><br /><a href=\"Topic.aspx?topic=" + sTopicID + "\">Click to discuss this article</a>");
}
SmtpClient smtp = new SmtpClient("localhost");
MailMessage mm;
mm = new MailMessage();
mm.IsBodyHtml = true;
mm.To.Add("*****@*****.**");
mm.To.Add("*****@*****.**");
mm.From = new MailAddress("*****@*****.**");
mm.Subject = "Someone posted an article.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted an article titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The article is below:<br /><br />" + rteBody.Value;
smtp.Send(mm);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Added";
Session["resultMessage"] = "Article Added Successfuly";
Session["resultReturnURL"] = "Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString();
Response.Redirect("Result.aspx");
}
else
{
if (cbxDeleteArticle.Checked)
{
DataLayer dl = new DataLayer();
DataTable dtArticle = dl.GetArticleBy_ArticleID(Convert.ToInt32(lbxArticles.SelectedValue));
try
{
SqlCommand sc = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", dtArticle.Rows[0].ItemArray[2].ToString()));
sc.Parameters.Add(new SqlParameter("Date", Convert.ToDateTime(dtArticle.Rows[0].ItemArray[1])));
DataSet ds = dl.CustomQuery(sc);
dl.DeleteForumTopic(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]));
}
catch
{
}
dl.DeleteArticle(Convert.ToInt32(lbxArticles.SelectedValue));
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Deleted";
Session["resultMessage"] = "Article Deleted Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
else
{
DataLayer dl = new DataLayer();
dl.UpdateArticle(Convert.ToInt32(lbxArticles.SelectedValue), tbxTitle.Text, rteBody.Value);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Updated";
Session["resultMessage"] = "Article Updated Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
}
}