private void SendNotifSupportingDocumentNotAvailable()
{
GeneralController gc = new GeneralController();
DataTable dt = gc.loi_supporting_document_notavailable_data();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string htmltabledetail = string.Empty;
DataTable dtemail = gc.LOI_Detail_getEmailData(Convert.ToInt32(dr["RequestId"]));
htmltabledetail = CreateHtmlTableApproved(dtemail);
if (dtemail.Rows.Count > 0)
{
string ReceiverMail = dr["Email"].ToString();
string ReceiverName = dr["Name"].ToString();
gc.sendMail(ReceiverName, ReceiverMail, htmltabledetail, "notifnotavailabledoc", "System", Convert.ToInt32(dr["RequestId"]));
}
}
}
}
private void SendNotifApprovalTracking()
{
GeneralController gc = new GeneralController();
DataTable dtreceiver = gc.Email_CDM_getdata();
foreach (DataRow dr in dtreceiver.Rows)
{
DataTable dtemail = gc.report_loi_approvaltracking_detail_getdata(Convert.ToInt32(dr["USR_ID"]), dr["CTName"].ToString());
if (dtemail.Rows.Count > 0)
{
string htmltabledetail = string.Empty;
htmltabledetail = CreateHtmlTableApprovealTracking(dtemail);
if (dtemail.Rows.Count > 0)
{
string ReceiverMail = dr["Email"].ToString();
string ReceiverName = dr["Name"].ToString();
gc.sendMail(ReceiverName, ReceiverMail, htmltabledetail, "ApprovalTracking", "System", 0);
}
}
}
}