/// <summary>
/// Calling this will send an email to a specified agent for a general query
/// </summary>
/// <returns></returns>
public ActionResult SendEmailContact()
{
var post = Request.Form;
int agent_id = int.Parse(post["agent_id"]);
string client_msg = post["body"]; // todo escape string en check security
string client_name = post["client_name"];
string client_phone = post["client_phone"];
string client_email = post["client_email"];
string subject = "General query ";
string body = "<html><h3>Curious Client</h3>";
body += "<h2>" + client_name + "</h2>";
body += "<p>email: " + client_email + "</p>";
body += "</br><p>phone number: " + client_phone + "</p>";
body += "</br><h3>Client Message: </h3>";
body += "</br><p>" + client_msg + "</p></html>";
// Read agent email
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "Select Agent_Name, Agent_Surname, Agent_Phone, Agent_Email from Agent where Agent_Id=@agent_id";
command.Parameters.AddWithValue("@agent_id", agent_id);
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
string agent_email = reader.GetString("Agent_Email");
string from = ConfigurationManager.AppSettings["webEmail"];
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(from, agent_email);
msg.Subject = subject;
msg.Body = body;
msg.IsBodyHtml = true;
StandardSMTPEmailer emailer = new StandardSMTPEmailer();
emailer.Send(msg);
return Redirect(Request.UrlReferrer.ToString());
}
/// <summary>
/// Calling this will send an email for the interested buyer to an agent with the parameters specified in post
/// </summary>
/// <returns></returns>
public ActionResult SendEmail()
{
var post = Request.Form;
int agent_id = int.Parse(post["agent_id"]);
string client_msg = post["body"]; // todo escape string en check security
//int property_id = int.Parse(post["property_id"]);
int listing_id = int.Parse(post["listing_id"]);
string client_name = post["client_name"];
string client_phone = post["client_phone"];
string client_email = post["client_email"];
string link = Url.Action("Residence", "Estates") + "?id=" + listing_id;
string subject = string.Format("Interest in " + listing_id);
string body = string.Format("<html>Interest in <a href=\"{0}\">listing {1}</a><br><h3>Interested buyer</h3>", link, listing_id);
body += "<h2>" + client_name + "</h2>";
body += string.Format("<a href=\"{0}\" mailto>email: {0} </p>", client_email);
body += "</br><p>phone number: " + client_phone + "</p>";
body += "</br><h3>Client Message: </h3>";
body += "</br><p>" + client_msg + "</p></html>";
// Read agent email
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
connection.Open();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "Select Agent_Name, Agent_Surname, Agent_Phone, Agent_Email from Agent where Agent_Id=@agent_id";
command.Parameters.AddWithValue("@agent_id", agent_id);
MySqlDataReader reader = command.ExecuteReader();
reader.Read();
if(!reader.HasRows)
{
return null;
}
string agent_email = reader.GetString("Agent_Email");
string from = ConfigurationManager.AppSettings["webEmail"];
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(from, agent_email);
msg.Subject = subject;
msg.Body = body;
msg.IsBodyHtml = true;
StandardSMTPEmailer emailer = new StandardSMTPEmailer();
emailer.Send(msg);
return Redirect(Request.UrlReferrer.ToString());
}
