public void SendMailToAcountHandler()
{
try
{
string strFrom = "", strTo = "", strSubject = " Report EB member section.", strBody = "", strFromName = "";
//DataSet ds = new DataSet();
//ds = objQuotationBI.GetAccountHandlers(0);
DataView dv = new DataView(objQuotationBI.GetAccountHandlersForMailSend().Tables[0], "", "", DataViewRowState.CurrentRows);
dv.RowFilter = "UserType_AH='AH'" + " and EffectiveEndDate Is NULL";
if (dv != null)
{
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
int UserId = Convert.ToInt32(dv[i]["UserId"]);
strFrom = strTo = dv[i]["Email"].ToString();
strFromName = dv[i]["FirstName"].ToString();
DataSet dsMail = new DataSet();
dsMail = objQuotationBI.GetMailToAccountHandler(UserId);
if (dsMail != null)
{
//Body for html format---
StringBuilder sb = new StringBuilder();
sb.Append("<html><body>");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">");
sb.Append("<tr><td>Greetings!</td></tr>");
sb.Append("<tr><td>  </td></tr>");
sb.Append("<tr><td>  </td></tr>");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" border=\"1\">");
sb.Append("<tr><td> S.No </td><td> Cover Note No. </td><td> Member Code </td><td> Member Name </td><td> Fields With No Data </td></tr>");
int sno = 0;
if (dsMail.Tables["MailToAccountHandler"].Rows.Count > 0)
{
for (int j = 0; j < dsMail.Tables["MailToAccountHandler"].Rows.Count; j++)
{
string strMemberCode, strMemberName, strCoverNoteNo, strFieldsName;
strMemberCode = dsMail.Tables["MailToAccountHandler"].Rows[j]["MemberCode"].ToString();
strMemberName = dsMail.Tables["MailToAccountHandler"].Rows[j]["MemberName"].ToString();
strCoverNoteNo = dsMail.Tables["MailToAccountHandler"].Rows[j]["CoverNoteNo"].ToString();
strFieldsName = dsMail.Tables["MailToAccountHandler"].Rows[j]["FieldsName"].ToString();
sno = j + 1;
sb.Append("<tr><td>" + sno + "</td>");
sb.Append("<td>" + strCoverNoteNo + "</td>");
sb.Append("<td>" + strMemberCode + "</td>");
sb.Append("<td>" + strMemberName + "</td>");
sb.Append("<td>" + strFieldsName + "</td>");
}
}
sb.Append("</tr></table>");
sb.Append("<tr><td>  </td></tr>");
sb.Append("<tr><td>Have a nice day.</td></tr>");
//sb.Append("<tr><td>You are requested to approve the client.</td></tr>");
sb.Append("<tr><td>Thanks and regards.</td></tr>");
sb.Append("<tr><td> " + strFromName + "  </td></tr>");
sb.Append("<tr><td>" + DateTime.Now.ToString("dd/MM/yyyy") + "</td></tr>");
sb.Append("</table>");
sb.Append("</body></html>");
strBody = sb.ToString();
bool result = Utility.UIHelper.SentMail(strFrom, strTo, strSubject, strBody);
if (result)
{
objQuotationBI.UpdateMailToAccountHandler(UserId);
eventLog1.WriteEntry("NWI Mail Service Sent Mail.");
}
}
//return result;
}
}
}
}
catch (Exception ex) { eventLog1.WriteEntry(ex.Message.ToString()); }
}
