protected void SendMessage(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
try
{
if (TxtMessageTextBox.Text.Trim().Length > 160)
{
PhoneMessage.Text = "Character count of your message must be less than 161.";
}
else
{
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
//DataSet dsuser = dat.GetData("SELECT * FROM Users WHERE User_ID=" + Session["User"].ToString());
dat.SendText(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dat.MakeGoodPhone(PhoneTextBox.Text) + ProvidersDropDown.SelectedValue, TxtMessageTextBox.Text, "HippoHappenings Info");
PhoneMessage.Text = "Your message has been sent.";
TextPanel.Visible = false;
ThankYouPanel.Visible = true;
}
}
catch (Exception ex)
{
PhoneMessage.Text = ex.ToString();
//PhoneMessage.Text = "Sending message failed! Make sure the number you entered is correct.";
}
}
protected void SendIt(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
string userID = "";
string cookieName = FormsAuthentication.FormsCookieName;
HttpCookie authCookie = Context.Request.Cookies[cookieName];
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
FormsAuthenticationTicket authTicket = null;
try
{
authTicket = FormsAuthentication.Decrypt(authCookie.Value);
string group = authTicket.UserData.ToString();
if (group.Contains("User"))
{
userID = authTicket.Name;
}
else
{
}
}
catch (Exception ex)
{
EmailMessageLabel.Text = ex.ToString();
}
string toUserID = "";
DataSet dsAd = new DataSet();
string subject = "";
if (Session["Subject"] == null)
subject = SubjectTextBox.Text;
else if (Session["Subject"].ToString() == "")
subject = SubjectTextBox.Text;
else
subject = Session["Subject"].ToString();
string body = "";
bool sendEmail = true;
bool sendText = false;
if (Request.QueryString["A"].ToString() == "Connect")
{
dsAd = dat.GetData("SELECT * FROM Ads WHERE Ad_ID=" + Request.QueryString["ID"].ToString());
toUserID = dsAd.Tables[0].Rows[0]["User_ID"].ToString();
body =
"<div style=\"color: #cccccc;\"><br/>A new email from "+Session["UserName"].ToString()+" arrived in your inbox on Hippo Happenings. <br/><br/> Subject: Regarding '"+dsAd.Tables[0].Rows[0]["Header"].ToString()+"'. <br/><br/> Message: " +
MessageTextBox.Text + "<br/><br/> To view the email and reply, <a href=\"HippoHappenings.com/UserLogin.aspx\">" +
"log into Hippo Happenings</a></div>";
}
else
{
toUserID = Request.QueryString["ID"].ToString();
DataSet dsTo = dat.GetData("SELECT * FROM Users U, UserPreferences UP WHERE " +
"UP.UserID=U.User_ID AND U.User_ID=" + toUserID);
if (Request.QueryString["EV"] != null)
{
DataSet ds = new DataSet();
//only send to email if users preferences are set to do so.
if (dsTo.Tables[0].Rows[0]["EmailPrefs"].ToString().Contains("7"))
{
sendEmail = true;
}
else
{
sendEmail = false;
DataView dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%6%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendEmail = true;
dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%7%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendText = true;
}
if (Request.QueryString["EV"] == "V")
{
body =
"<div style=\"color: #cccccc;\"><br/>A new email from " + Session["UserName"].ToString() + " arrived in your inbox on Hippo Happenings. <br/><br/> Subject: Regarding your comment on venue: " + subject + ". <br/><br/> Message: " +
MessageTextBox.Text + "<br/><br/> To view the email and reply, <a href=\"HippoHappenings.com/UserLogin.aspx\">" +
"log into Hippo Happenings</a></div>";
}
else
{
body =
"<div style=\"color: #cccccc;\"><br/>A new email from " + Session["UserName"].ToString() + " arrived in your inbox on Hippo Happenings. <br/><br/> Subject: Regarding your comment on event: " + subject + ". <br/><br/> Message: " +
MessageTextBox.Text + "<br/><br/> To view the email and reply, <a href=\"HippoHappenings.com/UserLogin.aspx\">" +
"log into Hippo Happenings</a></div>";
}
}
else
{
if (Request.QueryString["a"] == "z")
{
//only send to email if users preferences are set to do so.
if (dsTo.Tables[0].Rows[0]["EmailPrefs"].ToString().Contains("7"))
{
sendEmail = true;
}
else
{
sendEmail = false;
DataView dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%6%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendEmail = true;
dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%7%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendText = true;
}
}
else
{
sendEmail = false;
sendText = false;
//only send to email if users preferences are set to do so.
DataView dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%8%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendEmail = true;
dvFirendsIndividual = dat.GetDataDV("SELECT * FROM UserFriendPrefs UFP " +
"WHERE UFP.Preferences LIKE '%9%'AND UFP.UserID=" + toUserID + " AND UFP.FriendID=" + Session["User"].ToString());
if (dvFirendsIndividual.Count > 0)
sendText = true;
}
body =
"<div style=\"color: #cccccc;\"><br/>A new email from " + Session["UserName"].ToString() + " arrived in your inbox on Hippo Happenings. <br/><br/> Subject: " + subject + ". <br/><br/> Message: " +
MessageTextBox.Text + "<br/><br/> To view the email and reply, <a href=\"HippoHappenings.com/UserLogin.aspx\">" +
"log into Hippo Happenings</a></div>";
}
}
if (subject != "")
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, To_UserID, Date, [Read], Mode)"
+ " VALUES(@content, @subject, @fromID, @toID, @date, 'False', 0)", conn);
cmd.Parameters.Add("@content", SqlDbType.Text).Value = MessageTextBox.Text;
cmd.Parameters.Add("@subject", SqlDbType.NVarChar).Value = subject;
cmd.Parameters.Add("@toID", SqlDbType.Int).Value = int.Parse(toUserID);
cmd.Parameters.Add("@fromID", SqlDbType.Int).Value = int.Parse(userID);
cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
cmd.ExecuteNonQuery();
conn.Close();
DataSet dsUser = dat.GetData("SELECT *, PP.Extension AS Ex1 FROM Users U, UserPreferences UP, PhoneProviders PP "+
"WHERE U.User_ID=UP.UserID AND U.PhoneProvider=PP.ID AND U.User_ID=" + toUserID);
DataSet dsUserEmail = dat.GetData("SELECT * FROM Users U, UserPreferences UP " +
"WHERE U.User_ID=UP.UserID AND U.User_ID=" + toUserID);
if (sendEmail)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUserEmail.Tables[0].Rows[0]["Email"].ToString(), body, "HippoHappenings Mail: " + subject);
}
if (sendText)
{
if (dsUser.Tables[0].Rows[0]["PhoneNumber"].ToString().Trim() != "")
{
try
{
string message = MessageTextBox.Text;
if (message.Length > 118)
message = MessageTextBox.Text.Substring(0, 118);
message += " Login to HippoHappenings.com to read more.";
DataView dvF = dat.GetDataDV("SELECT * FROM Users WHERE User_ID=" + Session["User"].ToString());
dat.SendText(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dat.MakeGoodPhone(dsUser.Tables[0].Rows[0]["PhoneNumber"].ToString()) +
dsUser.Tables[0].Rows[0]["Ex1"].ToString(),
message, dvF[0]["UserName"].ToString() + " send you Hippo Message");
}
catch (Exception ex)
{
}
}
}
EmailMessageLabel.Text = "Your message has been sent.";
MessagePanel.Visible = false;
EmailPanel.Visible = false;
ThankYouPanel.Visible = true;
}
else
{
EmailMessageLabel.Text = "Subject is null";
}
}
