protected void rgActionItem_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
objBLL = new MetisBLL();
DataTable dt = new DataTable();
if (chkbArchive.Checked)
{
dt = objBLL.getAllArchiveActionItem();
}
else
{
dt = objBLL.getAllActionItem();
}
DataView dv = new DataView(dt);
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
rgActionItem.DataSource = dv;
}
protected void btnEmail_Click(object sender, ImageClickEventArgs e)
{
objBLL = new MetisBLL();
DataTable dtActionItem = new DataTable();
DataTable dtDistinctResourceEmail = new DataTable();
if (chkbArchive.Checked)
{
dtActionItem = objBLL.getAllArchiveActionItem();
}
else
{
dtActionItem = objBLL.getAllActionItem();
}
dtDistinctResourceEmail = objBLL.getAllActionItemsResourceEmail(); // get distinct email
DataView dv = new DataView(dtActionItem);
DataView dv2 = new DataView(dtDistinctResourceEmail);
GridColumn gridResourceColumn = rgActionItem.MasterTableView.GetColumnSafe("Resource_name");
GridColumn gridActionItemColumn = rgActionItem.MasterTableView.GetColumnSafe("ActionItem");
dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'" +
" AND Resource_name like '%" + (gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridResourceColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'" +
" AND Action_Item like '%" + (gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''") == String.Empty ? "" : gridActionItemColumn.CurrentFilterValue.ToString().Replace("'", "''")) + "%'";
dv2.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'";
//Storing ResourceName and Email in Dictionary
mapDataTableToDictionary(dv2);
/// loop through DV (DataView) and transform datarows to html Table
foreach (DataRowView drv in dv)
{
transformRowsToHTMLTable(drv);
}
string cc = ConfigurationSettings.AppSettings["ActionItemsCC"];
string from = ConfigurationSettings.AppSettings["ActionItemsFrom"];
string replyto = ConfigurationSettings.AppSettings["ActionItemsReplyto"];
for (int i = 0; i < emailBodyList.Count; i++)
{
SendMail("smtp.gmail.com", from, emailBodyList.ElementAt(i).Key + "@streebo.com", cc, replyto, "<b>To do List</b><br/>" + emailBodyList.ElementAt(i).Value + "</table>", "Your Action Items", true);
}
}
