public void SendMail(string toList, string from, string ccList, string subject, string body, string attachFile = null) { MailerConfig mailer = new 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 GenerateBody(string login, int order_id, string ComandName) { string result = ""; MailerConfig mailer = new MailerConfig(); string mail = mailer.userName; List <string> detail = new List <string>(); string userName = ""; string status_name = ""; string service_name = ""; string Item_name = ""; string M_name = ""; string model_name = ""; string serial_name = ""; string complete_set = ""; string Worker_name = ""; string order_price = ""; string order_date = ""; string worker_phone = ""; string office_name = ""; string address = ""; try { SetConnection(); MySqlCommand cmd = new MySqlCommand { Connection = conn, CommandText = string.Format("SELECT User_surname, User_name, User_fname FROM Users WHERE Login='******';") }; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { userName = reader.GetString(0) + " " + reader.GetString(1) + " " + reader.GetString(2); } reader.Close(); //////////////////// cmd = new MySqlCommand { Connection = conn, CommandText = string.Format("SELECT Status.Status_name, Service.Service_name, Item.Item_name, Manufacturer.M_name, Model.Model_name, Serial.Serial_number, Orders.Complete_set, Worker.Worker_surname,Worker.Worker_name,Worker.Worker_fname, Orders.Order_price, Orders.Order_Date, Worker.Phone, Office.Address, Office.Office_name FROM Orders INNER JOIN Service on(Service.Service_id=Orders.Service_id) INNER JOIN Serial on(Orders.Serial_number=Serial.Serial_number) INNER JOIN Model on(Serial.Model_id=Model.Model_id) INNER JOIN Item on(Model.Item_id=Item.Item_id) INNER JOIN Manufacturer on(Item.M_id=Manufacturer.M_id) INNER JOIN Status on(Status.Status_id=Orders.Status_id) INNER JOIN Worker on(Orders.Worker_id=Worker.Worker_id) INNER JOIN Office on(Office.Office_id=Worker.Office_id) WHERE Orders.Order_id=" + order_id + ";") }; reader = cmd.ExecuteReader(); while (reader.Read()) { status_name = reader.GetString(0); service_name = reader.GetString(1); Item_name = reader.GetString(2); M_name = reader.GetString(3); model_name = reader.GetString(4); serial_name = reader.GetString(5); complete_set = reader.GetString(6); Worker_name = reader.GetString(7) + " " + reader.GetString(8) + " " + reader.GetString(9); order_price = reader.GetString(10); order_date = reader.GetString(11); worker_phone = reader.GetString(12); address = reader.GetString(13); office_name = reader.GetString(14); } reader.Close(); result = "Шановний користувач " + userName + "." + "<br>" + "Ваше замовлення #" + order_id + " зареєстровано в базі системи, статус замовлення " + status_name + "." + "<br>" + "Деталі замовлення:" + "<br>" + "Сервіс: " + service_name + ";" + "<br>" + "Пристрій: " + Item_name + " " + M_name + " " + model_name + " serial:" + serial_name + ";" + "<br>" + "Комплектація: " + complete_set + ";" + "<br>" + "<br>" + "Заявку прийняв майстер: " + Worker_name + ";" + "<br>" + "Адреса: " + address + " офіс " + office_name + ";" + "<br>" + "<br>"; cmd = new MySqlCommand { Connection = conn, CommandText = string.Format("SELECT Detail.Detail_name, Detail.Prod_country, Detail.Price FROM Detail INNER JOIN is_for on(Detail.Detail_id=is_for.Detail_id) WHERE is_for.Order_id=" + order_id + ";") }; reader = cmd.ExecuteReader(); while (reader.Read()) { detail.Add(reader.GetString(0) + " -> " + reader.GetString(1) + " - " + reader.GetString(2)); } if (detail.Count > 0) { result += "Прайс лист:" + "<br>"; foreach (var item in detail) { result += item + ";" + "<br>"; } } result += "Загальна ціна замовлення: " + order_price + ";" + "<br>" + "Дата замовлення: " + order_date.Remove(10) + ";" + "<br>" + "<br>" + "Дякуємо, що скористалися послугами нашої компанії!" + "<br>" + "Додаткова інформація доступна в додатку." + "<br>" + "Телефон майстра: " + worker_phone + ";" + "<br>" + "Електронна пошта: " + mail + ";" + "<br>" + "Телефон для довідки: 937-99-92" + "<br>" + "<br>" + "З повагою команда " + ComandName + " ! :)"; } catch (Exception ex) { } CloseCOnnection(); return(result); }