private void SendMailFunction(string senderMailId, string password, int port, string sendTo, string who) { try { if (String.IsNullOrEmpty(sendTo)) { return; } grdsendCustomerGaugeStatus.DataSource = null; grdsendCustomerGaugeStatus.DataBind(); string sendQuery = null; if (who == "EMP") { sendQuery = @"Select cs.calibration_schedule_id, cs.gauge_id, gm.gauge_sr_no, gm.gauge_name, cs.next_due_date from calibration_schedule_TB as cs Left Outer Join gaugeMaster_TB as gm ON cs.gauge_id=gm.gauge_id where cs.status=1 and cs.customer_id=" + Convert.ToInt32(Session["Customer_ID"]) + " and cs.created_by_id=" + Convert.ToInt32(Session["User_ID"]) + " and cs.next_due_date <= (now()+15)"; DataTable getnextDueStatus = g.ReturnData(sendQuery); grdsendCustomerGaugeStatus.DataSource = getnextDueStatus; grdsendCustomerGaugeStatus.DataBind(); } else { try { string stprocedure = "spDashBoardQuery"; DataSet ds = q.ProcdureWithTwoParam(stprocedure, 1, Convert.ToInt32(Session["Customer_ID"])); grdsendCustomerGaugeStatus.DataSource = ds.Tables[0]; grdsendCustomerGaugeStatus.DataBind(); } catch (Exception ex) { Logger.Error(ex.Message); //g.ShowMessage(this.Page, ex.Message); } } string[] strarryEmailId = sendTo.Split(','); string[] strsmtpget = senderMailId.Split('@'); string a = strsmtpget[1].ToString(); string b = "smtp."; b = b + a; for (int i = 0; i < strarryEmailId.Count(); i++) { MailMessage objMail = new MailMessage(); //string str1 = "*****@*****.**"; string strSendTo = strarryEmailId[i].ToString(); System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); mail.To.Add(strSendTo); mail.From = new MailAddress(senderMailId); mail.Subject = "Gauge Due Status"; mail.Body = "<br><br>Hi Dear ..!!<br><br><br> "; mail.Body += "Your gauge next due status date as below list:"; mail.Body += GetGridviewData(grdsendCustomerGaugeStatus); mail.Body += "<br><br><br><b>Gauge Management System!!</b><br><br><br>"; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.UseDefaultCredentials = false; smtp.Host = b;// "smtp.gmail.com"; smtp.Credentials = new System.Net.NetworkCredential(senderMailId, password); smtp.EnableSsl = true; smtp.Port = port; smtp.Send(mail); } DateTime date = new DateTime(); date = DateTime.Now; string strDate = date.ToString("yyyy-MM-dd H:mm:ss"); DataTable dtsavemailhist = g.ReturnData("Insert into sendMailHistoryTB (customer_id,user_id,send_Date) values(" + Convert.ToInt32(Session["Customer_ID"]) + "," + Convert.ToInt32(Session["User_ID"]) + ",'" + strDate + "')"); //using (TTMSDataClassesDataContext ds = new TTMSDataClassesDataContext()) // { // sendMailHistoryTB sm = new sendMailHistoryTB(); // sm.customer_id = Convert.ToInt32(Session["Customer_ID"]); // sm.user_id = Convert.ToInt32(Session["User_ID"]); // sm.send_Date = DateTime.Now; // ds.sendMailHistoryTBs.InsertOnSubmit(sm); // ds.SubmitChanges(); // } } catch (Exception ex) { Logger.Error(ex.Message); // g.ShowMessage(this.Page, ex.Message); } }