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