示例#1
0
        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;
        }
示例#2
0
        //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";
                }
            }
        }