//Emp Grid #region [Employee Grid Bind] private void GrdEmployeeBind() { try { EWA_EmpAssignSubject objEWA = new EWA_EmpAssignSubject(); BL_EmpAssignSubject objBL = new BL_EmpAssignSubject(); objEWA.Action = "FetchFacultyCourseClass"; objEWA.OrgId = Session["OrgId"].ToString(); objEWA.DesignationTypeId = "1"; objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); objEWA.SubjectId = ddlSubject.SelectedValue.ToString(); DataSet ds = objBL.EmployeeGridBind_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { GrdEmployee.DataSource = ds; GrdEmployee.DataBind(); GrdEmployee.Columns[3].Visible = true; } else { ShowEmptyGridView(GrdEmployee); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Grid Emp Bind #region [Grid Emp Bind] private void GrdEmployeeBind() { try { EWA_AssignDeptDes objEWA = new EWA_AssignDeptDes(); BL_AssignDeptDes objBL = new BL_AssignDeptDes(); objEWA.Action = "FetchNotAssignedEmployee"; 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) { GrdEmployee.DataSource = ds; GrdEmployee.DataBind(); dsGrdEmployee = ds.Copy(); GrdEmployee.Columns[3].Visible = true; } else { ShowEmptyGridView(GrdEmployee); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Delete Role #region [Delete Role] public void DeleteRole(string Uid) { try { objEWA = new EWA_Role(); objEWA.Action = "DeleteRole"; objEWA.UserId = Uid; objEWA.OrganizationId = Convert.ToInt32(Session["OrgId"].ToString()); objBL.DeleteRole_BL(objEWA); DDL_Role.ClearSelection(); GrdAssinedRole.DataSource = EmptyGridView(); GrdAssinedRole.DataBind(); GrdEmployee.DataSource = EmptyGridView(); GrdEmployee.DataBind(); msgBox.ShowMessage("Role removed Successfully !!!", "Successfull", UserControls.MessageBox.MessageStyle.Successfull); //GeneralErr("Role removed Successfully !!!"); } catch (Exception exp) { GeneralErr(exp.Message); } }
//Get All Role Data #region [Get All Role Data] public void GetAllRoleData() { try { if (DDL_Role.SelectedItem.Text == "Select") { GrdAssinedRole.DataSource = EmptyGridView(); GrdAssinedRole.DataBind(); GrdEmployee.DataSource = EmptyGridView(); GrdEmployee.DataBind(); } else { objEWA = new EWA_Role(); objEWA.UserType = DDL_Role.SelectedItem.Text; objEWA.OrganizationId = Convert.ToInt32(Session["OrgId"].ToString()); objEWA.IsActive = true; DataSet ds = new DataSet(); ds = objBL.GetRole_BL(objEWA); BindGrids(ds); } } catch (Exception exp) { GeneralErr(exp.Message); } }
//Bind Grids #region [Bind Grids] public void BindGrids(DataSet ds) { GrdAssinedRole.DataSource = ds.Tables[0]; GrdAssinedRole.DataBind(); GrdEmployee.DataSource = ds.Tables[1]; GrdEmployee.DataBind(); }
void clear() { GrdEmployee.DataSource = ""; GrdEmployee.DataBind(); //GrdParent.DataSource = ""; //GrdParent.DataBind(); GrdStudent.DataSource = ""; GrdStudent.DataBind(); txtMessage.Text = ""; }
//Emp Page Index Change #region [Emp Page Index Change] protected void GrdEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { GrdEmployee.PageIndex = e.NewPageIndex; GrdEmployee.DataSource = dsGrdEmployee; GrdEmployee.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public void getEmployee(string searchPar) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("sp_GetEmployeesByName", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter par = cmd.Parameters.AddWithValue("@empName", searchPar ?? string.Empty); GrdEmployee.DataSource = cmd.ExecuteReader(); GrdEmployee.DataBind(); con.Close(); }
private void GrdEmployeeBind() { try { objEWA.Action = "SearchEmployee"; objEWA.OrgId = Convert.ToInt32(Session["OrgId"].ToString()); objEWA.SearchValue = txtName.Text; DataSet ds = objBL.EmployeeGridBind_BL(objEWA); GrdEmployee.DataSource = ds; GrdEmployee.DataBind(); } catch (Exception exp) { throw exp; } }
// Bind Student Grid Data //#region StudentGrid //private void BindStudentGridData() //{ // EWA_Common objEWA = new EWA_Common(); // BL_Common objBL = new BL_Common(); // objEWA.OrgId = Session["OrgId"].ToString(); // objEWA.CourseId = ddlCourse.SelectedValue.ToString(); // objEWA.BranchId = ddlBranch.SelectedValue.ToString(); // objEWA.ClassId = ddlClass.SelectedValue.ToString(); // objEWA.DivisionId = ddlDivision.SelectedValue.ToString(); // DataSet ds = objBL.BindStudentData_BL(objEWA); // if (ds.Tables[0].Rows.Count != 0) // { // GrdStudent.DataSource = ds; // GrdStudent.DataBind(); // } // else // { // DataTable dt = new DataTable(); // dt.Clear(); // dt.Columns.Add("StudentId"); // dt.Columns.Add("StudentName"); // dt.Columns.Add("Mobile"); // dt.Rows.Add(dt.NewRow()); // GrdStudent.DataSource = dt; // GrdStudent.DataBind(); // int totalcolums = GrdStudent.Rows[0].Cells.Count; // GrdStudent.Rows[0].Cells.Clear(); // GrdStudent.Rows[0].Cells.Add(new TableCell()); // GrdStudent.Rows[0].Cells[0].ColumnSpan = totalcolums; // GrdStudent.Rows[0].Cells[0].Text = "No Data Found"; // } //} //// For Student Empty Grid //private void ShowEmptyGridView(GridView grid) //{ // DataTable dt = new DataTable(); // dt.Columns.Add(grid.Columns[0].HeaderText); // dt.Columns.Add(grid.Columns[1].HeaderText); // dt.Columns.Add(grid.Columns[2].HeaderText); // dt.Columns.Add(grid.Columns[3].HeaderText); // DataRow dr = dt.NewRow(); // dt.Rows.Add(dr); // grid.DataSource = dt; // grid.DataBind(); // grid.Columns[0].Visible = true; // grid.Rows[0].Cells[1].ColumnSpan = 3; // foreach (GridViewRow row in grid.Rows) // { // row.Cells[2].Visible = false; // row.Cells[3].Visible = false; // } // grid.Rows[0].Cells[1].Text = "No Record found"; //} //#endregion //Employee Grid Bind #region [Employee Grid Bind] private void GrdEmployeeBind() { try { objEWA.OrgId = Convert.ToString(Session["OrgId"]); objEWA.DepartmentId = ddlDepartment.SelectedValue.ToString(); objEWA.DesignationTypeId = rbtlDesType.SelectedValue.ToString(); DataSet ds = objBL.EmployeeGridBind_BL(objEWA); GrdEmployee.DataSource = ds; GrdEmployee.DataBind(); } catch (Exception exp) { throw exp; } }
protected void ddlDesignation_SelectedIndexChanged(object sender, EventArgs e) { try { if (ddlDesignation.SelectedItem.Text.Equals("Select")) { GrdEmployee.DataSource = null; GrdEmployee.DataBind(); } else { //GrdViewEmployeeBind(); GrdEmployeeBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Page Load #region [Page Load] protected void Page_Load(object sender, EventArgs e) { orgId = Convert.ToInt32(Session["OrgID"]); if (orgId == 0) { Response.Redirect("~/CMSHome.aspx"); } if (!IsPostBack) { //GetRoleData(); GrdAssinedRole.DataSource = EmptyGridView(); GrdAssinedRole.DataBind(); GrdEmployee.DataSource = EmptyGridView(); GrdEmployee.DataBind(); //ShowEmptyGridView(ds); } }