protected void btnTwitterUpdate_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
DataTable dtMember = dl.GetMemberBy_Email(sMember);
string sTwitterUsername = dtMember.Rows[0].ItemArray[26].ToString();
string sTwitterPassword = dtMember.Rows[0].ItemArray[27].ToString();
Yedda.Twitter t = new Yedda.Twitter();
t.Update(sTwitterUsername, sTwitterPassword, tbxTwitterUpdate.Text, Yedda.Twitter.OutputFormatType.XML);
}
protected void btnTwitterUpdate_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
DataTable dtMember = dl.GetMemberBy_Email(sMember);
string sTwitterUsername = dtMember.Rows[0].ItemArray[26].ToString();
string sTwitterPassword = dtMember.Rows[0].ItemArray[27].ToString();
Yedda.Twitter t = new Yedda.Twitter();
t.Update(sTwitterUsername, sTwitterPassword, tbxTwitterUpdate.Text, Yedda.Twitter.OutputFormatType.XML);
}
public string GetMessages(Credentials credentials)
{
var twit = new Twitter();
twit.TwitterClient = "Unite";
twit.TwitterClientUrl = "http://github.com/jcbozonier/irontwit/tree/master";
twit.TwitterClientVersion = "0.1";
var result = twit.GetFriendsTimelineAsJSON(credentials.UserName, credentials.Password);
return result;
}
public string SendMessage(Credentials credentials, string message)
{
var twit = new Twitter();
twit.TwitterClient = "Unite";
twit.TwitterClientUrl = "http://github.com/jcbozonier/irontwit/tree/master";
twit.TwitterClientVersion = "0.1";
var result = twit.UpdateAsJSON(credentials.UserName, credentials.Password, message);
return result;
}
public string GetContacts(Credentials credentials)
{
var twit = new Twitter();
twit.TwitterClient = "Alloy";
twit.TwitterClientUrl = "http://github.com/jcbozonier/irontwit/tree/master";
twit.TwitterClientVersion = "0.8";
var result = twit.GetFriendsAsJSON(credentials.UserName, credentials.Password);
return result;
}
public string SendMessage(string message)
{
var twit = new Twitter
{
TwitterClient = "Unite",
TwitterClientUrl = "http://github.com/jcbozonier/irontwit/tree/master",
TwitterClientVersion = "0.1"
};
var result = twit.UpdateAsJSON("JudgingTwit", "110001", message);
return result;
}
void Window1_Loaded(object sender, RoutedEventArgs e)
{
Yedda.Twitter twit = new Twitter();
var resultString = twit.GetUserTimeline("*****@*****.**", "You Cant Have My Password!", Twitter.OutputFormatType.JSON);
var str = new StringReader(resultString);
var converter = new JsonSerializer();
converter.MissingMemberHandling = MissingMemberHandling.Ignore;
var obj = (List<TwitObj>)converter.Deserialize(str, typeof(List<TwitObj>));
TwitterListView.ItemsSource = obj;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
if (Request.QueryString["topic"] != null)
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
dl.UpdateForumTopic(iTopicID, tbxTitle.Text, rteBody.Value);
Response.Redirect("Topic.aspx?topic=" + iTopicID.ToString(), true);
}
else
{
int iBoardID = Convert.ToInt32(Request.QueryString["board"]);
DateTime dtPostedDate = DateTime.Now;
dl.AddForumTopic(iBoardID, User.Identity.Name, tbxTitle.Text, rteBody.Value, dtPostedDate, cbxSticky.Checked, cbxLocked.Checked);
SqlCommand sc = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc.Parameters.Add(new SqlParameter("Date", dtPostedDate));
DataSet ds = dl.CustomQuery(sc);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Topic.aspx?topic=" + 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 Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
SmtpMail.SmtpServer = "relay-hosting.secureserver.net";
MailMessage mm;
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = "[email protected];[email protected]";
mm.From = "*****@*****.**";
mm.Subject = "Someone posted a new forum topic.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted a new forum topic titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Topic.aspx?topic=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The post is below:<br /><br />" + rteBody.Value;
SmtpMail.Send(mm);
Response.Redirect("Topic.aspx?topic=" + ds.Tables[0].Rows[0].ItemArray[0].ToString(), true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
if (Request.QueryString["topic"] != null)
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
dl.UpdateForumTopic(iTopicID, tbxTitle.Text, rteBody.Value);
Response.Redirect("Topic.aspx?topic=" + iTopicID.ToString(), true);
}
else
{
int iBoardID = Convert.ToInt32(Request.QueryString["board"]);
DateTime dtPostedDate = DateTime.Now;
dl.AddForumTopic(iBoardID, User.Identity.Name, tbxTitle.Text, rteBody.Value, dtPostedDate, cbxSticky.Checked, cbxLocked.Checked);
SqlCommand sc = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE Title=@Title AND Date=@Date");
sc.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc.Parameters.Add(new SqlParameter("Date", dtPostedDate));
DataSet ds = dl.CustomQuery(sc);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Topic.aspx?topic=" + 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 Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Forum Topic: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
SmtpMail.SmtpServer = "relay-hosting.secureserver.net";
MailMessage mm;
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = "[email protected];[email protected]";
mm.From = "*****@*****.**";
mm.Subject = "Someone posted a new forum topic.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted a new forum topic titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Topic.aspx?topic=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The post is below:<br /><br />" + rteBody.Value;
SmtpMail.Send(mm);
Response.Redirect("Topic.aspx?topic=" + ds.Tables[0].Rows[0].ItemArray[0].ToString(), true);
}
}
public void Run()
{
Console.WriteLine( "new thread to retrieve friends' tweets");
Twitter twitter = new Twitter();
// 発言のあったお友達リストをアップデート
TextReader stringReader = new StringReader(twitter.GetFriendsTimeline("username", "passwd", Twitter.OutputFormatType.XML));
XDocument xdoc = XDocument.Load(stringReader);
friends = User.UserList(xdoc, new List<User>());
}
public static string GetCurrentStatus(string user, string password)
{
Twitter twitter = new Twitter();
//get user status history
XmlDocument featuredXml = twitter.GetUserTimelineAsXML(user, password);
//get status nodes
XmlNodeList statii = featuredXml.SelectNodes("//status");
//first not is most recent
XmlNode node = statii[0];
//get text node
XmlNode textNode = node.SelectSingleNode("//text");
//return status
return textNode.InnerText;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!cbxDelete.Checked)
{
if (bNew)
{
dtDate = DateTime.Now;
int iBlogNum = DataLayer.GetBlogCountDeleted();
DataLayer.AddBlog(tbxTitle.Text, rteBody.Text.Replace("<", "<").Replace(">", ">").Replace("&", "&"), dtDate);
try
{
Yedda.Twitter t = new Yedda.Twitter();
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.fordscleaning.com/Blog.aspx?blog=" + iBlogNum.ToString());
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
string sURL = objReader.ReadToEnd();
t.Update("WALTatRNX", "robinwalt98", "New Blog Post: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
Response.Redirect("http://www.fordscleaning.com/Blog.aspx?blog=" + Convert.ToString(DataLayer.GetBlogCountDeleted() - 1));
}
else
{
DataLayer.UpdateBlog(iBlogID, tbxTitle.Text, rteBody.Text.Replace("<", "<").Replace(">", ">").Replace("&", "&"));
Response.Redirect("http://www.fordscleaning.com/Blog.aspx?blog=" + iBlogID.ToString());
}
}
else
{
DataLayer.DeleteBlog(iBlogID);
Response.Redirect("http://www.fordscleaning.com/FordsBlog.aspx");
}
}
public IEnumerable<Tweet> GetMessages()
{
var twit = new Twitter
{
TwitterClient = "Unite",
TwitterClientUrl = "http://github.com/jcbozonier/irontwit/tree/master",
TwitterClientVersion = "0.1"
};
var result = twit.GetFriendsTimelineAsJSON("JudgingTwit", "110001");
var str = new StringReader(result);
var converter = new JsonSerializer
{
MissingMemberHandling = MissingMemberHandling.Ignore
};
// Convert the sender property to proper twitter form.
var tweets = (List<Tweet>)converter.Deserialize(str, typeof(List<Tweet>));
return tweets;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!cbxDelete.Checked)
{
if (bNew)
{
dtDate = DateTime.Now;
int iBlogNum = DataLayer.GetBlogCountDeleted();
DataLayer.AddBlog(tbxTitle.Text, rteBody.Text.Replace("<", "<").Replace(">", ">").Replace("&", "&"), dtDate);
try
{
Yedda.Twitter t = new Yedda.Twitter();
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.fordscleaning.com/Blog.aspx?blog=" + iBlogNum.ToString());
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
string sURL = objReader.ReadToEnd();
t.Update("WALTatRNX", "robinwalt98", "New Blog Post: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
Response.Redirect("http://www.fordscleaning.com/Blog.aspx?blog=" + Convert.ToString(DataLayer.GetBlogCountDeleted() - 1));
}
else
{
DataLayer.UpdateBlog(iBlogID, tbxTitle.Text, rteBody.Text.Replace("<", "<").Replace(">", ">").Replace("&", "&"));
Response.Redirect("http://www.fordscleaning.com/Blog.aspx?blog=" + iBlogID.ToString());
}
}
else
{
DataLayer.DeleteBlog(iBlogID);
Response.Redirect("http://www.fordscleaning.com/FordsBlog.aspx");
}
}
public static status DeserializeSingle(string response, Twitter.Account Account)
{
status s = null;
if (string.IsNullOrEmpty(response))
{
return new status();
}
if (Account == null ||
(Account.ServerURL.ServerType != Twitter.TwitterServer.brightkite &&
Account.ServerURL.ServerType != Twitter.TwitterServer.pingfm))
{
using (var r = new StringReader(response))
{
s = (status) singleSerializer.Deserialize(r);
}
if (s.text == null)
{
throw new Exception("Unable to deserialize the response");
}
}
return s;
}
public static status[] Deserialize(string response, Twitter.Account Account)
{
return Deserialize(response, Account, StatusTypes.Normal);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (lbxBlogs.SelectedIndex == -1)
{
DataLayer dl = new DataLayer();
DateTime dtPostTime = DateTime.Now;
dl.AddBlog(User.Identity.Name, dtPostTime, tbxTitle.Text, rteBody.Value, ddlAccessLevel.SelectedValue);
SqlCommand sc = new SqlCommand("SELECT BlogID FROM rnxBlogs 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/Blog.aspx?bid=" + 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 Blog: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Blog: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Blog: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
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 a blog.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted a blog titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Blog.aspx?bid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The blog is below:<br /><br />" + rteBody.Value;
smtp.Send(mm);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Blog Added";
Session["resultMessage"] = "Blog Added Successfuly";
Session["resultReturnURL"] = "Blog.aspx?bid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString();
Response.Redirect("Result.aspx");
}
else
{
if (cbxDeleteBlog.Checked)
{
DataLayer dl = new DataLayer();
dl.DeleteBlog(Convert.ToInt32(lbxBlogs.SelectedValue));
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Blog Deleted";
Session["resultMessage"] = "Blog Deleted Successfuly";
Session["resultReturnURL"] = "ManageBlogs.aspx";
Response.Redirect("Result.aspx");
}
else
{
DataLayer dl = new DataLayer();
dl.UpdateBlog(Convert.ToInt32(lbxBlogs.SelectedValue), tbxTitle.Text, rteBody.Value, ddlAccessLevel.SelectedValue);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Blog Updated";
Session["resultMessage"] = "Blog Updated Successfuly";
Session["resultReturnURL"] = "ManageBlogs.aspx";
Response.Redirect("Result.aspx");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (lbxMembers.SelectedIndex == -1)
{
string sSubscriptionID = "Free";
string sMembershipType = "0.00";
DataLayer dl = new DataLayer();
DateTime dtJoinDate = DateTime.Now;
int iPassword = rPassword.Next(9999999);
dl.AddMember(tbxEmail.Text, iPassword.ToString(), tbxName.Text, "no_avatar.gif", "", "", "", "", tbxBusinessName.Text, "no_logo.gif", "", dtJoinDate, "", "", "", "", "", "", cbxAdmin.Checked, cbxModerator.Checked, cbxCanPostBlog.Checked, cbxMemberNewsletter.Checked, cbxDailyMotivator.Checked, false, false, "", "", "Not Specified", 0, DateTime.Today, "", "#77BB77,#ffffff,#DDFFDD,#444444,#1985b5,#77BB77,#ffffff,#ffffff,#000000,#0000EE,#CCDDCC", ddlArticleColumn.SelectedValue, sSubscriptionID, sMembershipType);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Profile.aspx?member=" + tbxEmail.Text);
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 Member! " + dl.GetFullMemberNameBy_Email(tbxEmail.Text) + " has joined us on ReferralNetworX.com " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd", "New Member! " + dl.GetFullMemberNameBy_Email(tbxEmail.Text) + " has joined us on ReferralNetworX.com " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New Member! " + dl.GetFullMemberNameBy_Email(tbxEmail.Text) + " has joined us on ReferralNetworX.com " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{
}
SmtpMail.SmtpServer = "relay-hosting.secureserver.net";
MailMessage mm;
////////////////// -= Add Comment To New Member's Profile =- ////////////////////////
int iPerson = rand.Next(2);
string sPerson;
if (iPerson == 0)
{
int iComment = rand.Next(10);
string sComment = "";
if (iComment == 0)
{
sComment = "Welcome to the site! I hope you like what you find.<br /><br />- Alex";
}
else if (iComment == 1)
{
sComment = "Welcome to Referral NetworX! We are glad to have you as a member.<br /><br />- Alex";
}
else if (iComment == 2)
{
sComment = "I love seeing new faces! Welcome to the site.<br /><br />- Alex";
}
else if (iComment == 3)
{
sComment = "Welcome to the site! I look forward to networking with you.<br /><br />- Alex";
}
else if (iComment == 4)
{
sComment = "A new member! I am excited that you have joined us!<br /><br />- Alex";
}
else if (iComment == 5)
{
sComment = "Welcome to the site! We are excited to benefit from the knowledge you have to offer!<br /><br />- Alex";
}
else if (iComment == 6)
{
sComment = "We are excited to have you here! I am confident you will make a great addition to the RNX community!<br /><br />- Alex";
}
else if (iComment == 7)
{
sComment = "Glad you could join us! I look forward to networking with you.<br /><br />- Alex";
}
else if (iComment == 8)
{
sComment = "I am happy you decided to be a part of Referral NetworX! Here is your first thumbs up!<br /><br />- Alex";
}
else if (iComment == 9)
{
sComment = "Welcome to ReferralNetworX.com! Let me know if you need anything at all!<br /><br />- Alex";
}
dl.AddComment("*****@*****.**", DateTime.Now, sComment, "Member", true, -1, tbxEmail.Text);
dl.AddThumbsUp(tbxEmail.Text);
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = tbxEmail.Text;
mm.From = "*****@*****.**";
mm.Subject = "Someone posted a comment on your profile!";
mm.Body = "Alex Ford posted a comment on your profile.";
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/profile.aspx?member=" + tbxEmail.Text + "\">Click to view</a>";
SmtpMail.Send(mm);
}
else if (iPerson == 1)
{
int iComment = rand.Next(6);
string sComment = "";
if (iComment == 0)
{
sComment = "Hi and welcome to Referral NetworX! Our mission is your success!<br /><br />- Walt";
}
else if (iComment == 1)
{
sComment = "Welcome to Referral NetworX! I am really looking forward to networking with you. Here's to you continued success!<br /><br />- Walt";
}
else if (iComment == 2)
{
sComment = "Its great to have you as a member of Referral NetworX! We are here to help you with your continued success!<br /><br />- Walt";
}
else if (iComment == 3)
{
sComment = "Congratulations! You are now a member of Referral NetworX. Our mission is your success!<br /><br />- Walt";
}
else if (iComment == 4)
{
sComment = "Welcome! Referral NetworX is your beginning to expanding your personal network! Relationship, Relationship, Relationship!<br /><br />- Walt";
}
else if (iComment == 5)
{
sComment = "Welcome to Referral NetworX! Your journey to building quality relationships and expanding your network has begun!<br /><br />- Walt";
}
dl.AddComment("*****@*****.**", DateTime.Now, sComment, "Member", true, -1, tbxEmail.Text);
dl.AddThumbsUp(tbxEmail.Text);
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = tbxEmail.Text;
mm.From = "*****@*****.**";
mm.Subject = "Someone posted a comment on your profile!";
mm.Body = "Walt Ford posted a comment on your profile.";
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/profile.aspx?member=" + tbxEmail.Text + "\">Click to view</a>";
SmtpMail.Send(mm);
}
//////////////////////////////////////////////////////////////
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = "[email protected];[email protected]";
mm.From = "*****@*****.**";
mm.Subject = "Someone signed up on ReferralNetworX.com!";
mm.Body = tbxName.Text + " signed up on ReferralNetworX.com.";
mm.Body += "<br /><br /><a href=\"http://www.referralnetworx.com/profile.aspx?member=" + tbxEmail.Text + "\">Click to view</a>";
SmtpMail.Send(mm);
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = tbxEmail.Text;
mm.From = "*****@*****.**";
mm.Subject = "Welcome to ReferralNetworX.com!";
mm.Body = "Welcome " + dl.GetMemberNameBy_Email(tbxEmail.Text) + ",<br /><br />";
mm.Body += " We are dedicated to helping you and your business succeed. I truly hope RNX helps you to grow to new heights and accomplish your goals. I am confident that you will provide a lot of value to the RNX community and that your knowledge will benefit everyone! Please <a href=\"http://www.referralnetworx.com/referralnetworx/Topic.aspx?topic=50\">visit our forums to say hi</a> to fellow members and get to know everyone. Also, be sure to log in and edit your profile. The more information you provide about yourself and your business, the more you will get noticed and more opportunities will be presented to you.<br /><br />Here is your username and temporary password:<br />Password - " + iPassword.ToString() + " (You can change this after logging in)<br />Username - " + tbxEmail.Text + "<br /><br />Alex Ford<br />Referral NetworX Administrator";
SmtpMail.Send(mm);
try
{
dl.DeleteNonMember(tbxEmail.Text);
}
catch { }
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Member Added";
Session["resultMessage"] = "Member Added Successfuly";
Session["resultReturnURL"] = "ManageMembers.aspx";
Response.Redirect("Result.aspx");
}
else
{
if (cbxDeleteMember.Checked)
{
DataLayer dl = new DataLayer();
dl.DeleteMember(lbxMembers.SelectedValue);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Member Deleted";
Session["resultMessage"] = "Member Deleted Successfuly";
Session["resultReturnURL"] = "ManageMembers.aspx";
Response.Redirect("Result.aspx");
}
else
{
DataLayer dl = new DataLayer();
DataTable dt = dl.GetMemberBy_Email(lbxMembers.SelectedValue);
string sTwitterFeedStyles = dt.Rows[0].ItemArray[32].ToString();
string sPersonalAvatar = dt.Rows[0].ItemArray[3].ToString();
string sMemberAvatar = dt.Rows[0].ItemArray[3].ToString();
string sPhone = dt.Rows[0].ItemArray[4].ToString();
string sInterests = dt.Rows[0].ItemArray[5].ToString();
string sWebsite = dt.Rows[0].ItemArray[6].ToString();
string sPersonalBio = dt.Rows[0].ItemArray[7].ToString();
string sBusinessLogo = dt.Rows[0].ItemArray[9].ToString();
string sBusinessBio = dt.Rows[0].ItemArray[10].ToString();
string sAIM = dt.Rows[0].ItemArray[13].ToString();
string sMSN = dt.Rows[0].ItemArray[14].ToString();
string sYahoo = dt.Rows[0].ItemArray[15].ToString();
string sGoogleTalk = dt.Rows[0].ItemArray[16].ToString();
string sLocation = dt.Rows[0].ItemArray[17].ToString();
string sSignature = dt.Rows[0].ItemArray[18].ToString();
bool bShowEmail = Convert.ToBoolean(dt.Rows[0].ItemArray[24]);
bool bUpdateTwitter = Convert.ToBoolean(dt.Rows[0].ItemArray[25]);
string sTwitterUsername = dt.Rows[0].ItemArray[26].ToString();
string sTwitterPassword = dt.Rows[0].ItemArray[27].ToString();
string sGender = dt.Rows[0].ItemArray[28].ToString();
DateTime dtBirthday = Convert.ToDateTime(dt.Rows[0].ItemArray[30]);
string sBusinessCategory = dt.Rows[0].ItemArray[31].ToString();
dl.UpdateMember(lbxMembers.SelectedValue, tbxName.Text, sPersonalAvatar, sPhone, sInterests, sWebsite, sPersonalBio, tbxBusinessName.Text, sBusinessLogo, sBusinessBio, sAIM, sMSN, sYahoo, sGoogleTalk, sLocation, sSignature, cbxAdmin.Checked, cbxModerator.Checked, cbxCanPostBlog.Checked, cbxMemberNewsletter.Checked, cbxDailyMotivator.Checked, bShowEmail, bUpdateTwitter, sTwitterUsername, sTwitterPassword, sGender, dtBirthday, sBusinessCategory, sTwitterFeedStyles, ddlArticleColumn.SelectedValue);
if (lbxMembers.SelectedValue.ToUpper() != tbxEmail.Text.ToUpper())
{
if (sPersonalAvatar != "no_avatar.gif")
{
string sExt = sPersonalAvatar.Remove(0, sPersonalAvatar.LastIndexOf('.'));
string sNewPersonalAvatar = tbxEmail.Text + sExt;
if (File.Exists(MapPath("~/images/MemberAvatars/" + sNewPersonalAvatar)))
{
File.Delete(MapPath("~/images/MemberAvatars/" + sNewPersonalAvatar));
}
File.Move(MapPath("~/images/MemberAvatars/" + sPersonalAvatar), MapPath("~/images/MemberAvatars/" + sNewPersonalAvatar));
sPersonalAvatar = sNewPersonalAvatar;
}
if (sBusinessLogo != "no_logo.gif")
{
string sExt = sBusinessLogo.Remove(0, sBusinessLogo.LastIndexOf('.'));
string sNewBusinessLogo = tbxEmail.Text + sExt;
if (File.Exists(MapPath("~/images/BusinessLogos/" + sNewBusinessLogo)))
{
File.Delete(MapPath("~/images/BusinessLogos/" + sNewBusinessLogo));
}
File.Move(MapPath("~/images/BusinessLogos/" + sBusinessLogo), MapPath("~/images/BusinessLogos/" + sNewBusinessLogo));
sBusinessLogo = sNewBusinessLogo;
}
dl.UpdateMemberEmail(lbxMembers.SelectedValue, tbxEmail.Text, sPersonalAvatar, sBusinessLogo);
if (User.Identity.Name.ToUpper() == lbxMembers.SelectedValue.ToUpper())
{
FormsAuthentication.SignOut();
FormsAuthentication.SetAuthCookie(tbxEmail.Text, false);
}
}
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Member Updated";
Session["resultMessage"] = "Member Updated Successfuly ";
Session["resultReturnURL"] = "ManageMembers.aspx";
Response.Redirect("Result.aspx");
}
}
}
public bool Delete()
{
Yedda.Twitter Twitter = new Yedda.Twitter();
Yedda.Twitter.Account account = ClientSettings.GetAcountForUser(user.screen_name);
if (account == null)
return false;
Twitter.AccountInfo = account;
Cursor.Current = Cursors.WaitCursor;
try
{
string response = Twitter.Destroy_Status(id, Twitter.OutputFormatType.XML);
if (response != null)
{
LocalStorage.DataBaseUtility.DeleteStatus(id);
return true;
}
else
{
return false;
}
}
finally
{
Cursor.Current = Cursors.Default;
}
}
public static status[] DeserializeFromAtom(string response, Twitter.Account Account)
{
var resultList = new List<status>();
var results = new XmlDocument();
results.LoadXml(response);
var nm = new XmlNamespaceManager(results.NameTable);
nm.AddNamespace("google", "http://base.google.com/ns/1.0");
nm.AddNamespace("openSearch", "http://a9.com/-/spec/opensearch/1.1/");
nm.AddNamespace("s", "http://www.w3.org/2005/Atom");
XmlNodeList entries = results.SelectNodes("//s:entry", nm);
Debug.WriteLine(entries.Count);
try
{
foreach (XmlNode entry in entries)
{
var newStat = new status();
newStat.text = entry.SelectSingleNode("s:title", nm).InnerText;
newStat.id = entry.SelectSingleNode("s:id", nm).InnerText;
newStat.created_at = entry.SelectSingleNode("s:published", nm).InnerText;
string userName = entry.SelectSingleNode("s:author/s:name", nm).InnerText;
newStat.created_at = entry.SelectSingleNode("s:published", nm).InnerText;
string userscreenName = userName.Split(new char[] {' '})[0];
newStat.user = new User();
newStat.user.screen_name = userscreenName;
newStat.user.profile_image_url =
entry.SelectSingleNode("s:link[@type=\"image/png\"]", nm).Attributes["href"].Value;
newStat.user.needsFetching = true;
resultList.Add(newStat);
}
}
catch
{
}
foreach (status stat in resultList)
{
stat.TypeofMessage = StatusTypes.SearchResult;
stat.Account = Account;
}
return resultList.ToArray();
}
private bool DoPost(PicturePostObject postData, Twitter.Account account, bool successEvent)
{
this.account = account;
#region Argument check
this.account = account;
//Check for empty path
if (string.IsNullOrEmpty(postData.Filename))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
//Check for empty credentials
if (string.IsNullOrEmpty(account.OAuth_token) ||
string.IsNullOrEmpty(account.OAuth_token_secret))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
#endregion
using (System.IO.FileStream file = new FileStream(postData.Filename, FileMode.Open, FileAccess.Read))
{
try
{
postData.PictureStream = file;
XmlDocument uploadResult = UploadPicture(API_UPLOAD, postData, account);
if (uploadResult == null) // occurs in the event of an error
return false;
string URL = uploadResult.SelectSingleNode("//url").InnerText;
postData.URL = URL;
if(successEvent)
{
OnUploadFinish(new PictureServiceEventArgs(PictureServiceErrorLevel.OK, URL, string.Empty, postData.Filename));
}
}
catch (Exception /*ex*/)
{
// could do with catching a SocketException here, so we can give more useful information to the user
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
return false;
}
}
return true;
}
/// <summary>
/// Fetch a picture
/// </summary>
/// <param name="pictureURL"></param>
public override void FetchPicture(string pictureURL, Twitter.Account account)
{
#region Argument check
this.account = account;
//Need a url to read from.
if (string.IsNullOrEmpty(pictureURL))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, "", API_ERROR_DOWNLOAD));
}
#endregion
try
{
workerPPO = new PicturePostObject();
workerPPO.Message = pictureURL;
if (workerThread == null)
{
workerThread = new System.Threading.Thread(new System.Threading.ThreadStart(ProcessDownload));
workerThread.Name = "PictureUpload";
workerThread.Start();
}
else
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.NotReady, "", "A request is already running."));
}
}
catch (Exception)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, "", API_ERROR_DOWNLOAD));
}
}
/// <summary>
/// Upload the picture
/// </summary>
/// <param name="url">URL to upload picture to</param>
/// <param name="ppo">Postdata</param>
/// <returns></returns>
private XmlDocument UploadPicture(string url, PicturePostObject ppo, Twitter.Account account)
{
try
{
HttpWebRequest request = WebRequestFactory.CreateHttpRequest(url);
request.Timeout = 60000;
request.AllowWriteStreamBuffering = false; // don't want to buffer 3MB files, thanks
request.AllowAutoRedirect = false;
Multipart contents = new Multipart();
contents.UploadPart += new Multipart.UploadPartEvent(contents_UploadPart);
contents.Add("source", "PockeTwit");
contents.Add("sourceLink", "http://code.google.com/p/pocketwit/");
if (!string.IsNullOrEmpty(ppo.Message))
{
contents.Add("message", ppo.Message);
}
contents.Add("media", ppo.PictureStream, Path.GetFileName(ppo.Filename), ppo.ContentType);
OAuthAuthorizer.AuthorizeEcho(request, account.OAuth_token, account.OAuth_token_secret);
return contents.UploadXML(request);
}
catch (WebException ex)
{
if (ex.Response is HttpWebResponse)
{
using(HttpWebResponse response = ex.Response as HttpWebResponse)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, String.Format(PockeTwit.Localization.XmlBasedResourceManager.GetString("Error Uploading: Service returned message '{0}'"), response.StatusDescription), ppo.Filename));
}
}
else if (ex.InnerException is System.Net.Sockets.SocketException)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, ex.Message, ppo.Filename));
}
else
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD, ppo.Filename));
return null;
}
catch (Exception)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
return null;
}
}
/// <summary>
/// Post a picture
/// </summary>
/// <param name="postData"></param>
public virtual Uri UploadAttachment(UploadAttachment Attachment, Twitter.Account account)
{
if(string.IsNullOrEmpty(account.OAuth_token) || string.IsNullOrEmpty(account.OAuth_token_secret))
throw new InvalidOperationException(Localization.XmlBasedResourceManager.GetString("No credentials supplied"));
using (Stream contentStream = Attachment.GetStream())
{
if (contentStream == null)
throw new InvalidOperationException(Localization.XmlBasedResourceManager.GetString("Unable to open file"));
HttpWebRequest request = WebRequestFactory.CreateHttpRequest(API_UPLOAD);
request.Timeout = 60000;
request.AllowWriteStreamBuffering = false; // don't want to buffer 3MB files, thanks
request.AllowAutoRedirect = false;
Multipart contents = new Multipart();
contents.UploadPart += new Multipart.UploadPartEvent(contents_UploadPart);
contents.Add("source", "PockeTwit");
contents.Add("sourceLink", "http://code.google.com/p/pocketwit/");
if (!string.IsNullOrEmpty(Attachment.Caption))
contents.Add("message", Attachment.Caption);
contents.Add("media",
contentStream,
Path.GetFileName(Attachment.Name),
(Attachment.MediaType != null) ?
Attachment.MediaType.ContentType
: string.Empty
);
OAuthAuthorizer.AuthorizeEcho(request, account.OAuth_token, account.OAuth_token_secret);
XmlDocument uploadResult = contents.UploadXML(request);
if (uploadResult == null)
throw new InvalidOperationException("Error parsing result");
return new Uri(uploadResult.SelectSingleNode("//url").InnerText);
}
}
/// <summary>
/// Post a picture
/// </summary>
/// <param name="postData"></param>
public override bool PostPicture(PicturePostObject postData, Twitter.Account account)
{
#region Argument check
//Check for empty path
if (string.IsNullOrEmpty(postData.Filename))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
//Check for empty credentials
if (string.IsNullOrEmpty(account.OAuth_token) ||
string.IsNullOrEmpty(account.OAuth_token_secret))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
#endregion
_account = account;
using (postData.PictureStream = new FileStream(postData.Filename, FileMode.Open, FileAccess.Read))
{
try
{
XmlDocument uploadResult = UploadPicture(API_UPLOAD, postData, account);
if (uploadResult == null)
{
return false;
}
string URL = uploadResult.SelectSingleNode("//url").InnerText;
postData.URL = URL;
OnUploadFinish(new PictureServiceEventArgs(PictureServiceErrorLevel.OK, URL, string.Empty, postData.Filename));
return true;
}
catch
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
return false;
}
}
}
public static status[] Deserialize(string response, Twitter.Account Account, StatusTypes TypeOfMessage)
{
status[] statuses = null;
try
{
if (string.IsNullOrEmpty(response))
{
statuses = new status[0];
}
else
{
if (Account == null || Account.ServerURL.ServerType != Twitter.TwitterServer.brightkite)
{
using (var r = new StringReader(response))
{
statuses = (status[]) statusSerializer.Deserialize(r);
}
}
else if (Account.ServerURL.ServerType == Twitter.TwitterServer.brightkite)
{
statuses = FromBrightKite(response);
}
}
if (Account != null)
{
foreach (status stat in statuses)
{
stat.Account = Account;
stat.TypeofMessage = TypeOfMessage;
}
}
}
catch{}
return statuses;
}
/// <summary>
/// Use a imageId to retrieve and save a thumbnail to the device.
/// </summary>
/// <param name="imageId">Id for the image</param>
/// <returns></returns>
private string RetrievePicture(string imageId, Twitter.Account account)
{
try
{
HttpWebRequest myRequest = WebRequestFactory.CreateHttpRequest(API_SHOW_THUMB + imageId);
OAuthAuthorizer.AuthorizeEcho(myRequest, account.OAuth_token, account.OAuth_token_secret);
myRequest.Method = "GET";
String pictureFileName = String.Empty;
using (HttpWebResponse response = (HttpWebResponse)myRequest.GetResponse())
{
using (Stream dataStream = response.GetResponseStream())
{
int totalSize = 0;
int totalResponseSize = (int)response.ContentLength;
byte[] readBuffer = new byte[PT_READ_BUFFER_SIZE];
pictureFileName = GetPicturePath(imageId);
int responseSize = dataStream.Read(readBuffer, 0, PT_READ_BUFFER_SIZE);
totalSize = responseSize;
OnDownloadPart(new PictureServiceEventArgs(responseSize, totalSize, totalResponseSize));
while (responseSize > 0)
{
SavePicture(pictureFileName, readBuffer, responseSize);
try
{
totalSize += responseSize;
responseSize = dataStream.Read(readBuffer, 0, PT_READ_BUFFER_SIZE);
OnDownloadPart(new PictureServiceEventArgs(responseSize, totalSize, totalResponseSize));
}
catch
{
responseSize = 0;
}
System.Threading.Thread.Sleep(100);
}
dataStream.Close();
}
response.Close();
}
return pictureFileName;
}
catch (Exception)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_DOWNLOAD));
return string.Empty;
}
}
public static status[] DeserializeArrayFromJSON(string response, Twitter.Account Accournt, StatusTypes TypeOfMessage)
{
var ret = new List<status>();
var List = (System.Collections.Hashtable)JSON.JsonDecode(response);
if (List == null) { return null; }
var results = (System.Collections.ArrayList)List["results"];
foreach (var result in results)
{
var resultHash = (System.Collections.Hashtable) result;
ret.Add(DeserializeSingleJSONStatus(resultHash, TypeOfMessage));
}
return ret.ToArray();
}
/// <summary>
/// Upload the picture
/// </summary>
/// <param name="url">URL to upload picture to</param>
/// <param name="ppo">Postdata</param>
/// <returns></returns>
private XmlDocument UploadPicture(string url, PicturePostObject ppo, Twitter.Account account)
{
try
{
HttpWebRequest request = WebRequestFactory.CreateHttpRequest(url);
request.Timeout = 20000;
request.AllowWriteStreamBuffering = false; // don't want to buffer 3MB files, thanks
request.AllowAutoRedirect = false;
Multipart contents = new Multipart();
contents.UploadPart += new Multipart.UploadPartEvent(contents_UploadPart);
contents.Add("key", TwitPicKey);
if (!string.IsNullOrEmpty(ppo.Message))
contents.Add("message", ppo.Message);
else
contents.Add("message", "");
contents.Add("media", ppo.PictureStream, Path.GetFileName(ppo.Filename), ppo.ContentType);
OAuthAuthorizer.AuthorizeEcho(request, account.OAuth_token, account.OAuth_token_secret);
return contents.UploadXML(request);
}
catch (Exception /*e*/)
{
//Socket exception 10054 could occur when sending large files.
// Should be more specific
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
return null;
}
}
public static status[] FromDirectReplies(string response, Twitter.Account Account)
{
var resultList = new List<status>();
var results = new XmlDocument();
results.LoadXml(response);
XmlNodeList entries = results.SelectNodes("//direct_message");
foreach (XmlNode entry in entries)
{
var newStat = new status();
newStat.text = entry.SelectSingleNode("text").InnerText;
newStat.id = entry.SelectSingleNode("id").InnerText;
newStat.created_at = entry.SelectSingleNode("created_at").InnerText;
newStat.user = new User();
newStat.user.screen_name = entry.SelectSingleNode("sender/screen_name").InnerText;
newStat.user.id = entry.SelectSingleNode("sender/id").InnerText;
newStat.user.profile_image_url = entry.SelectSingleNode("sender/profile_image_url").InnerText;
newStat.user.location = entry.SelectSingleNode("sender/location").InnerText;
newStat.user.name = entry.SelectSingleNode("sender/name").InnerText;
newStat.user.description = entry.SelectSingleNode("sender/description").InnerText;
newStat.favorited = "false";
newStat.source = "";
newStat.in_reply_to_status_id = "";
resultList.Add(newStat);
}
foreach (status stat in resultList)
{
stat.TypeofMessage = StatusTypes.Direct;
stat.Account = Account;
}
return resultList.ToArray();
}
public static string GetLatestItem(Twitter.Account account, TimelineManagement.TimeLineType typeToGet)
{
return GetLatestItem(account, typeToGet, "");
}
public static User FromId(string ID, Twitter.Account Account)
{
var t = new Twitter {AccountInfo = Account};
string response = null;
try
{
response = t.Show(ID, Twitter.OutputFormatType.XML);
}
catch
{
var toReturn = new User {screen_name = "PockeTwitUnknownUser"};
return toReturn;
}
try
{
var s = new XmlSerializer(typeof (User));
if (string.IsNullOrEmpty(response))
{
var toReturn = new User {screen_name = "PockeTwitUnknownUser"};
return toReturn;
}
using (var r = new StringReader(response))
{
User result = (User)s.Deserialize(r);
result._needsFetching = false;
return result;
}
}
catch
{
var toReturn = new User {screen_name = "PockeTwitUnknownUser"};
return toReturn;
}
}
public static string GetLatestItem(Twitter.Account account, TimelineManagement.TimeLineType typeToGet, string ExtraArguments)
{
string FetchQuery = SQLGetLastStatusID;
switch (typeToGet)
{
case TimelineManagement.TimeLineType.Friends:
FetchQuery = FetchQuery + " AND " + SQLFetchFriends + SQLOrder + SQLLimit;
break;
case TimelineManagement.TimeLineType.Replies:
FetchQuery = FetchQuery + " AND " + SQLFetchReplies + SQLOrder + SQLLimit;
break;
case TimelineManagement.TimeLineType.Direct:
FetchQuery = FetchQuery + " AND " + SQLFetchDirects + SQLOrder + SQLLimit;
break;
case TimelineManagement.TimeLineType.Messages:
FetchQuery = FetchQuery + " AND " + SQLFetchRepliesAndMessages + SQLOrder + SQLLimit;
break;
case TimelineManagement.TimeLineType.Searches:
FetchQuery = FetchQuery + " AND " + ExtraArguments + SQLFetchSearches + SQLOrder + SQLLimit;
break;
}
using (SQLiteConnection conn = GetConnection())
{
using (var comm = new SQLiteCommand(FetchQuery, conn))
{
comm.Parameters.Add(new SQLiteParameter("@accountsummary", account.Summary));
comm.Parameters.Add(new SQLiteParameter("@count", 1));
conn.Open();
return (string) comm.ExecuteScalar();
}
}
}
/*
*/
public void SendTweet(object src, CommandEventArgs e)
{
ErrorLog.ErrorRoutine(false, "Sending Tweet");
string status, strSQL;
Yedda.Twitter tw = new Yedda.Twitter();
IDBManager dbManager = new DBManager(DataProvider.SqlServer);
dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;;
strSQL = @"SELECT e.iD, e.dCreateDate, e.iHtFt, e.iHtIn, e.Location, e.iCategory, e.iUser, e.txtBrand, e.txtOtherBoardType, e.txtGearItem, e.fltPrice, e.iStatus
FROM tblEntry e
WHERE e.adType = '1' AND e.iD =" + e.CommandArgument;
try
{
dbManager.Open();
dbManager.ExecuteReader(CommandType.Text, strSQL);
if (dbManager.DataReader.Read())
{
string htft = dbManager.DataReader["iHtFt"].ToString() + "'";
string htin = dbManager.DataReader["iHtIn"].ToString() + "\"";
string brand = dbManager.DataReader["txtBrand"].ToString();
status = "A " + htft + " " + htin + " " + brand + " is for sale on Boardhunt.com";
status += " Check it out: http://www.malzook.com/surfboard.aspx?iD=" + e.CommandArgument;
//TODO: Obsolete OLD Yedda Code
//retVal = tw.Update("*****@*****.**", "boardhunt3", status, Twitter.OutputFormatType.XML);
string url = "";
string xml = "";
classes.oAuthTwitter oAuth = new classes.oAuthTwitter();
oAuth.Token = "26946523-qrX1XQqBrNlIGr0P4pbCOMPFWOa0wFFtTWfqt6c";
oAuth.TokenSecret = "gGJrAimUXenzBRxCUbNPrBhTZt1kuuPeiXsrsnAaJGo";
//26946523-qrX1XQqBrNlIGr0P4pbCOMPFWOa0wFFtTWfqt6c
//gGJrAimUXenzBRxCUbNPrBhTZt1kuuPeiXsrsnAaJGo
//Get the access token and secret.
//oAuth.AccessTokenGet(Request["oauth_token"], Request["oauth_verifier"]);
//if (oAuth.TokenSecret.Length > 0)
//{
ErrorLog.ErrorRoutine(false, "Token: " + oAuth.Token.ToString());
ErrorLog.ErrorRoutine(false, "Secret: " + oAuth.TokenSecret.ToString());
//We now have the credentials, so make a call to the Twitter API.
url = "http://twitter.com/account/verify_credentials.xml";
xml = oAuth.oAuthWebRequest(classes.oAuthTwitter.Method.GET, url, String.Empty);
//apiResponse.InnerHtml = Server.HtmlEncode(xml);
ErrorLog.ErrorRoutine(false, "AuthXML: " + Server.HtmlEncode(xml));
lblMessage.Text = Server.HtmlEncode(xml);
return;
//POST Test
url = "http://twitter.com/statuses/update.xml";
xml = oAuth.oAuthWebRequest(classes.oAuthTwitter.Method.POST, url, "status=" + oAuth.UrlEncode("BH oAuth Test"));
lblMessage.Text = Server.HtmlEncode(xml);
//}
//ErrorLog.ErrorRoutine(false, "Tweet retVal:" + retVal);
//lblMessage.Text = "Tweet OK";
}
}
catch (Exception ex)
{
ErrorLog.ErrorRoutine(false, "PostMaster:SendTweet:Error:" + ex.Message);
ErrorLog.ErrorRoutine(false, "PostMaster:SendTweet:Error:" + ex.InnerException);
lblMessage.Text = "Tweet failed";
}
finally
{
dbManager.Close();
dbManager.Dispose();
}
}
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");
}
}
}
/// <summary>
/// Post a picture
/// </summary>
/// <param name="postData"></param>
public override bool PostPicture(PicturePostObject postData, Twitter.Account account)
{
return DoPost(postData, account, true);
}
private bool DoPost(PicturePostObject postData, Twitter.Account account, bool successEvent)
{
#region Argument check
this._account = account;
//Check for empty path
if (string.IsNullOrEmpty(postData.Filename))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
//Check for empty credentials
if (string.IsNullOrEmpty(account.OAuth_token) ||
string.IsNullOrEmpty(account.OAuth_token_secret))
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
}
#endregion
using (System.IO.FileStream file = new FileStream(postData.Filename, FileMode.Open, FileAccess.Read))
{
try
{
#region async
//if (postData.UseAsync)
//{
// workerPPO = (PicturePostObject) postData.Clone();
// workerPPO.PictureData = incoming;
// if (workerThread == null)
// {
// workerThread = new System.Threading.Thread(new System.Threading.ThreadStart(ProcessUpload));
// workerThread.Name = "PictureUpload";
// workerThread.Start();
// }
// else
// {
// OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.NotReady, string.Empty, "A request is already running."));
// }
//}
//else
//{
#endregion
//use sync.
postData.PictureStream = file;
XmlDocument uploadResult = UploadPicture(API_UPLOAD_V2, postData);
//if (File.Exists("mobyresult.txt"))
//{
// File.Delete("mobyresult.txt");
//}
//XmlTextWriter xm = new XmlTextWriter("mobyresult.txt", Encoding.UTF8);
//uploadResult.Save(xm);
//XmlDocument uploadResult = new XmlDocument();
//uploadResult.Load("mobyresult.txt");
if (uploadResult == null) // occurs in the event of an error
{
return false;
}
if (successEvent)
{
string URL = uploadResult.SelectSingleNode("//mediaurl").InnerText;
postData.URL = URL;
OnUploadFinish(new PictureServiceEventArgs(PictureServiceErrorLevel.OK, URL, string.Empty, postData.Filename));
}
}
catch (Exception)
{
OnErrorOccured(new PictureServiceEventArgs(PictureServiceErrorLevel.Failed, string.Empty, API_ERROR_UPLOAD));
return false;
}
}
return true;
}
