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"]));
}
}
}
}