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); } }
//protected void Page_Load(object sender, EventArgs e) //{ // if (!IsPostBack) // { // objBLL = new MetisBLL(); // DataTable dt = objBLL.getDeparments(); // ddlDepartment.DataSource = dt; // ddlDepartment.DataTextField = dt.Columns[1].ToString(); // ddlDepartment.DataValueField = dt.Columns[0].ToString(); // ddlDepartment.DataBind(); // ddlDepartment.SelectedValue = "dpt_02"; // dt = new DataTable(); // 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; // rgActionItem.DataBind(); // dt = new DataTable(); // dt = objBLL.getAllUpComingProject(); // dv = new DataView(dt); // dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'"; // rgUpComingProject.DataSource = dv; // } //} protected void Page_Load(object sender, EventArgs e) { //int x = Convert.ToInt32(Session["isLogin"]); //if (x == 0) // RFSs.Visible = false; //else // RFSs.Visible = true; if (!IsPostBack) { #region Check Login if (Convert.ToString(Session["user"]) == "") { Response.Redirect("Login.aspx"); } #endregion #region Check Rights b_CanView = false; objBLL = new MetisBLL(); System.Data.DataTable dt = objBLL.getAccessRights(Convert.ToString(Session["user"])); foreach (System.Data.DataRow row in dt.Rows) { if (row["EntityName"].ToString() == "UpcomingProj") { b_CanView = Convert.ToBoolean(row["Can_View"]); } } // If Admin thn bypass security if (b_CanView == false) { objBLL = new MetisBLL(); if (Convert.ToBoolean(objBLL.IsAdmin(Convert.ToString(Session["user"])))) { b_CanView = true; } } #endregion if (b_CanView) { objBLL = new MetisBLL(); dt = depManager.getDeparments(); ddlDepartment.DataSource = dt; ddlDepartment.DataTextField = dt.Columns[1].ToString(); ddlDepartment.DataValueField = dt.Columns[0].ToString(); ddlDepartment.DataBind(); ddlDepartment.SelectedValue = "dpt_01"; // IM - SSL By Default if (Session["ddlDepartment"] != null) { ddlDepartment.SelectedValue = Session["ddlDepartment"].ToString(); } Session["ddlDepartment"] = ddlDepartment.SelectedValue; dt = new DataTable(); 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; rgActionItem.DataBind(); dt = new DataTable(); dt = objBLL.getAllUpComingProject(); dv = new DataView(dt); dv.RowFilter = "Dept_name like '%" + (ddlDepartment.SelectedItem.ToString().Replace("'", "''") == "All" ? "" : ddlDepartment.SelectedItem.ToString().Replace("'", "''")) + "%'"; rgUpComingProject.DataSource = dv; } else { main.Visible = false; lblErr.Text = "403 Forbidden"; } } }