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 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()
{
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("Замовлення виконано!");
}
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)
{
}
}
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);
}