void btn_Click(object sender, EventArgs e)
{
Button tbtn = (Button)sender;
string name = tbtn.Name.ToString();
if (name == "send")
{
if (Feature.Available("Send Mail") == "Yes")
{
string smtpAddress = "";
string emailFrom = "";
string password = "";
int port = 0;
bool Credentials = false;
bool EnableSsl = true;
DataTable dtFirmMailInfo = new DataTable();
Database.GetSqlData("select * from mailer", dtFirmMailInfo);
if (dtFirmMailInfo.Rows.Count > 0)
{
smtpAddress = dtFirmMailInfo.Rows[0]["smtp"].ToString();
emailFrom = dtFirmMailInfo.Rows[0]["emailid"].ToString();
password = dtFirmMailInfo.Rows[0]["password"].ToString();
port = int.Parse(dtFirmMailInfo.Rows[0]["port"].ToString());
Credentials = bool.Parse(dtFirmMailInfo.Rows[0]["Credentials"].ToString());
EnableSsl = bool.Parse(dtFirmMailInfo.Rows[0]["EnableSsl"].ToString());
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (bool.Parse(dataGridView1.Rows[i].Cells["check"].Value.ToString()) == true && (dataGridView1.Rows[i].Cells["Emailid"].Value.ToString() != "None" && dataGridView1.Rows[i].Cells["Emailid"].Value.ToString() != ""))
{
SmtpClient client = new SmtpClient(smtpAddress, port);
client.UseDefaultCredentials = Credentials;
client.EnableSsl = EnableSsl;
client.Credentials = new NetworkCredential(emailFrom, password);
string accnam = dataGridView1.Rows[i].Cells["cname"].Value.ToString();
string emailTo = dataGridView1.Rows[i].Cells["Emailid"].Value.ToString();
string subject = "Customer Report";
string body = "Dear <b>" + accnam + "</b>,<br/>";
body += "Please find enclosed Bills Details.<br/>";
body += "Your Balance is: <b>" + funs.accbal(funs.Select_ac_id(accnam)) + "</b>";
body += "</b><br/><br/>Regards";
body += "<br/><b>" + Database.fname;
MailMessage mail = new MailMessage();
mail.From = new MailAddress(emailFrom);
mail.To.Add(emailTo);
mail.Subject = subject;
mail.Body = body;
mail.IsBodyHtml = true;
try
{
Report gg = new Report();
gg.CustomerDetailBillWise(dateTimePicker1.Value, dateTimePicker2.Value, accnam);
gg.ExportToPdf("System\\Bill-" + accnam + ".pdf");
gg.Close();
gg.Dispose();
System.Net.Mime.ContentType contype = new System.Net.Mime.ContentType();
mail.Attachments.Add(new Attachment("System\\Bill-" + accnam + ".pdf", contype));
object userState = mail;
status = "Mail Sent Successfully";
client.SendCompleted += new SendCompletedEventHandler(SmtpClient_OnCompleted);
client.SendAsync(mail, userState);
}
catch (Exception ex)
{
status = "Mail Not Sent";
}
DataTable dtemail = new DataTable("EmailLOG");
Database.GetSqlData("select * from EmailLOG where id=0", dtemail);
dtemail.Rows.Add();
dtemail.Rows[0]["AccName"] = accnam;
dtemail.Rows[0]["Email"] = emailTo;
dtemail.Rows[0]["Status"] = status;
dtemail.Rows[0]["SDate"] = DateTime.Now.ToString("dd-MMM-yyyy");
dtemail.Rows[0]["STime"] = DateTime.Now.ToString("HH:mm");
Database.SaveData(dtemail);
}
}
this.Close();
this.Dispose();
}
}
else if (name == "quit")
{
this.Close();
this.Dispose();
}
}
