public void SendMail(string toList, string from, string ccList, string subject, string body, string attachFile = null)
{
Config.Mailer.MailerConfig mailer = new Config.Mailer.MailerConfig();
MailMessage message = new MailMessage();
SmtpClient smtpClient = new SmtpClient();
try
{
MailAddress fromAddress = new MailAddress(from);
message.From = fromAddress;
message.To.Add(toList);
if (ccList != null && ccList != string.Empty)
{
message.CC.Add(ccList);
}
if (!string.IsNullOrEmpty(attachFile))
{
message.Attachments.Add(new Attachment(attachFile));
}
message.Subject = subject;
message.IsBodyHtml = true;
message.Body = body;
// We use gmail as our smtp client
smtpClient.Host = mailer.host;
smtpClient.Port = mailer.port;
smtpClient.EnableSsl = true;
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new NetworkCredential(
mailer.userName, mailer.password);
smtpClient.EnableSsl = true;
smtpClient.Send(message);
}
catch (Exception)
{
}
}
public string GenerateActiveBody(string detail, int order_id, string ComandName)
{
string result = "";
Config.Mailer.MailerConfig mailer = new Config.Mailer.MailerConfig();
string mail = mailer.userName;
////////////USER INFO
string user_surname = "";
string user_name = "";
string user_fname = "";
///////////////ORDER INFO
string Service_type = "";
string Service_name = "";
string Status_name = "";
string Order_date = "";
string Address = "";
try
{
SetConnection();
///USER INFO
MySqlCommand cmd = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Office.Address FROM Users INNER JOIN Office on(Users.Office_id=Office.Office_id) WHERE Users.User_id=(SELECT Worker_id FROM Orders WHERE Order_id= " + order_id + ");")
};
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Address = reader.GetString(0);
}
reader.Close();
//////////////ORDER INFO
cmd = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Service_type.Type_name, Services.Service_name, Status.Status_name, Orders.Order_date, Users.U_surname, Users.U_name, Users.U_fname FROM Orders INNER JOIN Services on(Services.Service_id=Orders.Service_id) INNER JOIN Status on(Status.Status_id=Orders.Status_id) INNER JOIN Service_type on(Service_type.Type_id=Services.Type_id) INNER JOIN Users on(Users.User_id=Orders.User_id) WHERE Orders.Order_id=" + order_id + ";")
};
reader = cmd.ExecuteReader();
while (reader.Read())
{
Service_type = reader.GetString(0);
Service_name = reader.GetString(1);
Status_name = reader.GetString(2);
Order_date = reader.GetString(3).Remove(10);
user_surname = reader.GetString(4);
user_name = reader.GetString(5);
user_fname = reader.GetString(6);
}
reader.Close();
///////////GET RESULT
result = "Dear user " + user_surname + " " + user_name + " " + user_fname + "." + "<br>" + /*< font size = "5" color = "red" face = "Arial" > П </ font >*/
"Your order #" + order_id + " has been reviewed, the current status - " + Status_name + "." + "<br>" +
"Order detail:" + "<br>" +
"Service: " + Service_type + " " + Service_name + ";" + "<br>" +
"Addons: " + detail + "<br>" +
"Order date: " + Order_date + ";" + "<br>" + "<br>" +
"For more information, please visit our office at: " + Address + "<br>" +
"Email: " + mail + ";" + "<br>" +
"Phone for help: 937-99-92" + "<br>" + "<br>" +
"Sincerely team " + ComandName + " ! :)";
}
catch (Exception ex)
{
}
CloseCOnnection();
return(result);
}
