protected void rgUpComingProject_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { objBLL = new MetisBLL(); DataTable dt = new DataTable(); dt = objBLL.getAllUpComingProject(); DataView 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) //{ // 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"; } } }