Exemplo n.º 1
0
        //Emp Grid Bind
        #region [Emp Grid Bind]

        private void GrdViewEmployeeBind()
        {
            try
            {
                EWA_EmpAssignSubject objEWA = new EWA_EmpAssignSubject();
                BL_EmpAssignSubject  objBL  = new BL_EmpAssignSubject();
                objEWA.Action            = "FetchAssignedEmployee";
                objEWA.OrgId             = Session["OrgId"].ToString();
                objEWA.DesignationTypeId = "1";
                objEWA.ClassId           = ddlClass.SelectedValue.ToString();
                objEWA.CourseId          = ddlCourse.SelectedValue.ToString();
                objEWA.BranchId          = ddlBranch.SelectedValue.ToString();
                objEWA.SubjectId         = ddlSubject.SelectedValue.ToString();
                DataSet ds = objBL.EmployeeGridBind_BL(objEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    GrdViewEmployee.DataSource = ds;
                    GrdViewEmployee.DataBind();
                    GrdViewEmployee.Columns[3].Visible = true;
                }
                else
                {
                    ShowEmptyGridView(GrdViewEmployee);
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemplo n.º 2
0
        //Emp Bind
        #region [Emp Bind]

        private void GrdViewEmployeeBind()
        {
            try
            {
                EWA_AssignDeptDes objEWA = new EWA_AssignDeptDes();
                BL_AssignDeptDes  objBL  = new BL_AssignDeptDes();
                objEWA.Action       = "FetchAssignedEmployee";
                objEWA.OrgId        = Session["OrgId"].ToString();
                objEWA.DepartmentId = ddlDepartment.SelectedValue.ToString();

                objEWA.DesignationTypeId = rbtlDesType.SelectedValue.ToString();
                objEWA.DesignationId     = ddlDesignation.SelectedValue.ToString();
                DataSet ds = objBL.EmployeeGridBind_BL(objEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    GrdViewEmployee.DataSource = ds;
                    GrdViewEmployee.DataBind();
                    dsGrdViewEmployee = ds.Copy();
                    GrdViewEmployee.Columns[3].Visible = true;
                }
                else
                {
                    GrdViewEmployee.DataSource = null;
                    GrdViewEmployee.DataBind();
                }
            }

            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemplo n.º 3
0
        //Emp Page Index Change
        #region [Emp Page Index Change]

        protected void GrdViewEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            try
            {
                GrdViewEmployee.PageIndex  = e.NewPageIndex;
                GrdViewEmployee.DataSource = dsGrdViewEmployee;
                GrdViewEmployee.DataBind();
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemplo n.º 4
0
        private void ViewAllEmployee()
        {
            if (GrdViewEmployee.Rows.Count < 1)
            {
                GrdViewEmployee.EmptyDataText = "There is no Employee to view.";
            }

            using (SqlConnection con = new SqlConnection(CS))
            {
                SqlDataAdapter da = new SqlDataAdapter("SELECT EmpID, EmpFstName, EmpLstName, EmpEmail, Gender, PhnNo, CONVERT(nvarchar(30), DOB, 103) as DOB, Designation, Comment, EmpImage FROM Employees", con);
                con.Open();
                DataTable dt = new DataTable();

                da.Fill(dt);

                GrdViewEmployee.DataSource = dt;
                GrdViewEmployee.DataBind();
            }
        }
Exemplo n.º 5
0
        //DDL Design Index Changed
        #region [Design Index Changed]

        protected void ddlDesignation_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                if (ddlDesignation.SelectedItem.Text.Equals("Select"))
                {
                    GrdViewEmployee.DataSource = null;
                    GrdEmployee.DataSource     = null;
                    GrdEmployee.DataBind();
                    GrdViewEmployee.DataBind();
                }
                else
                {
                    GrdViewEmployeeBind();
                    GrdEmployeeBind();
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }