private void Send(string detail)
{
try
{
string userMail = "";
MySqlCommand cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Users.Email FROM Orders INNER JOIN Users on(Orders.User_id=Users.User_id) WHERE Orders.Order_id='" + OrderId + "';")
};
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
userMail = reader.GetString(0);
}
reader.Close();
Mailer.Generator generator = new Mailer.Generator();
string body = generator.GenerateActiveBody(detail, OrderId, "SunComp");
string subject = generator.GenerateSubject("SunComp", OrderId);
Mailer.Mailer mailer = new Mailer.Mailer();
mailer.SendMail(userMail, "*****@*****.**", "", subject, body);
}
catch (Exception ex)
{
}
}
private void Send()
{
try
{
string userMail = "";
MySqlCommand cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Users.Email FROM Orders INNER JOIN Users on(Orders.User_id=Users.User_id) WHERE Orders.Order_id='" + dataGridView1.CurrentRow.Cells[0].Value + "';")
};
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
userMail = reader.GetString(0);
}
reader.Close();
Mailer.Generator generator = new Mailer.Generator();
string body = generator.GenerateCompleteOrderBody((int)dataGridView1.CurrentRow.Cells[0].Value, "SunComp");
string subject = generator.GenerateSubject("SunComp", (int)dataGridView1.CurrentRow.Cells[0].Value);
Mailer.Mailer mailer = new Mailer.Mailer();
mailer.SendMail(userMail, "*****@*****.**", "", subject, body);
}
catch (Exception ex)
{
}
}
private void Send()
{
string userMail = "";
MySqlCommand cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Users.Email FROM Users INNER JOIN Orders on(Orders.User_id=Users.User_id) WHERE Orders.Order_id='" + Index + "';")
};
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
userMail = reader.GetString(0);
}
reader.Close();
Mailer.Generator generator = new Mailer.Generator();
string body = generator.GenerateCompleteBody(Login, Index, "ServiCEntre");
string subject = generator.GenerateSubject("ServiCEntre", Index);
Mailer.Mailer mailer = new Mailer.Mailer();
mailer.SendMail(userMail, "*****@*****.**", "", subject, body);
MessageBox.Show("Замовлення виконано!");
}
public void SendRemember()
{
string emails = "";
foreach (var student in this.Course.Students)
{
emails += student.Email + " ";
}
string emailBody = "Hi , there is " + this.Course.Teacher.Name + " fom course " + this.Course.Name + ". <br /> I want to remember you about home work '" + this.Title + "'";
Mailer.Mailer mail = new Mailer.Mailer();
mail.SetGeter(emails);
mail.SetTitleAndBody("Home work remember", emailBody);
mail.Send();
}
public void FireDatabaseEvents()
{
RssContext context = new RssContext();
var rss = context.RssItem.ToList();
BlockingCollection <string> mailList = new BlockingCollection <string>();
context.Customer.Select(s => s.Email).ToList().ForEach(f => mailList.Add(f));
foreach (RssItem item in rss)
{
var mailer = new Mailer.Mailer(mailList, item);
mailer.StartEmailRun();
}
BroadcastToClients(rss);
}
public async Task <RegistrationStatus> RegisterStudent(CreateStudentView model)
{
RegistrationStatus status = model.Verify();
try
{
if (status.Result)
{
var user = new ApplicationUser()
{
UserName = model.UserName
};
user.Student = new Student(model);
user.Role = ApplicationConstants.STUDENT;
string passowrd = Membership.GeneratePassword(10, 0); // will be password
var result = await UserManager.CreateAsync(user, passowrd);
status = new RegistrationStatus(model, result.Succeeded, StudentRegResults.OK, result.Errors);
if (result.Succeeded)
{
var student = UserManager.FindByName(user.UserName);
UserManager.AddToRole(student.Id, ApplicationConstants.STUDENT);
Mailer.Mailer mail = new Mailer.Mailer();
mail.SetGeter(user.Student.Email);
string emailText = "You was ordet to the course ****** , by *******. <br /> ";
emailText += "User name: " + user.UserName + " <br /> ";
emailText += "Password: "******"Order to Course", emailText);
mail.Send();
}
}
}
catch (Exception ex)
{
status = new RegistrationStatus(model, false, StudentRegResults.Exception, new List <string>()
{
ex.Message
});
}
return(status);
}
private void Send()
{
try
{
//////////////////get_orderID
int orderId = 0;
MySqlCommand cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT MAX(Order_id) FROM Orders;")
};
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
orderId = reader.GetInt32(0);
}
reader.Close();
/////////////////////USer Email
string userMail = "";
cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Users.Email FROM Orders INNER JOIN Users on(Orders.User_id=Users.User_id) WHERE Orders.Order_id='" + orderId + "';")
};
reader = cmd1.ExecuteReader();
while (reader.Read())
{
userMail = reader.GetString(0);
}
reader.Close();
Mailer.Generator generator = new Mailer.Generator();
string body = generator.GenerateNewOrderBody(orderId, "SunComp");
string subject = generator.GenerateSubject("SunComp", orderId);
Mailer.Mailer mailer = new Mailer.Mailer();
mailer.SendMail(userMail, "*****@*****.**", "", subject, body);
}
catch (Exception ex)
{
}
}
public static void RemoteMessage(LoggingSource loggingSource,
LoggingType loggingType,
string message,
params object[] args)
{
string formattedMessage = string.Format(message, args);
bool isSuccess;
if ((loggingSource & LoggingSource.Mail) == LoggingSource.Mail)
{
string subject = loggingType + " логирование с сайта";
var mailerConfig = new MailerConfig {
IsHtmlBody = false,
DisplayName = subject,
SendToAdmins = true
};
var mailer = new Mailer.Mailer();
string mailAddress = loggingType.HasFlag(LoggingType.Error) ? MailAddresses.EXCEPTIONS : MailAddresses.SUPPORT;
isSuccess = mailer.SendMail(mailAddress, mailAddress, subject, formattedMessage, mailerConfig);
if (!isSuccess)
{
LogTo(LoggerName.Errors).ErrorFormat(
"LoggerWrapper.RemoteMessage не удалось отправить сообщение по почте: {0}",
formattedMessage);
}
}
/*if ((loggingSource & LoggingSource.Db) == LoggingSource.Db) {
* isSuccess = _loggerQuery.Create(loggingType, formattedMessage);
*
* if (!isSuccess) {
* LogTo(LoggerName.Errors).ErrorFormat(
* "LoggerWrapper.RemoteMessage не удалось записать сообщение в БД: {0}",
* formattedMessage);
* }
* }*/
}
private void Send()
{
//////////////////get_orderID
int orderId = 0;
MySqlCommand cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT MAX(Order_id) FROM Orders;")
};
MySqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
orderId = reader.GetInt32(0);
}
reader.Close();
/////////////////////USer Email
string userMail = "";
cmd1 = new MySqlCommand
{
Connection = conn,
CommandText = string.Format("SELECT Email FROM Users WHERE Login='******';")
};
reader = cmd1.ExecuteReader();
while (reader.Read())
{
userMail = reader.GetString(0);
}
reader.Close();
Mailer.Generator generator = new Mailer.Generator();
string body = generator.GenerateBody(Login, orderId, "ServiCEntre");
string subject = generator.GenerateSubject("ServiCEntre", orderId);
Mailer.Mailer mailer = new Mailer.Mailer();
mailer.SendMail(userMail, "*****@*****.**", "", subject, body);
}
