//Emp Data Bound #region [Emp Data Bound] protected void GrdViewEmployee_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowIndex > -1) { GridViewRow GrdRow = e.Row; EWA_AssignDeptDes ObjEWA = new EWA_AssignDeptDes(); BL_AssignDeptDes ObjBL = new BL_AssignDeptDes(); ObjEWA.Action = "FetchDepartment"; ObjEWA.UserCode = GrdRow.Cells[0].Text; DataSet ds = ObjBL.FetchDepartment_BL(ObjEWA); string joinstr = "No record found"; if (ds.Tables[0].Rows.Count != 0) { joinstr = ds.Tables[0].Rows[0][0].ToString(); for (int i = 1; i < ds.Tables[0].Rows.Count; i++) { joinstr += "," + ds.Tables[0].Rows[i][0].ToString(); } } GrdRow.Cells[2].Text = joinstr; } } 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()); } }
//Link Button #region [Link Button] protected void lnkbtn_Click(object sender, EventArgs e) { try { string[] confirmValue = Request.Form["confirm_value"].Split(','); if (confirmValue[confirmValue.Length - 1] == "Yes") { int flag; EWA_AssignDeptDes ObjEWA = new EWA_AssignDeptDes(); BL_AssignDeptDes ObjBL = new BL_AssignDeptDes(); GridViewRow grdrow = (GridViewRow)((LinkButton)sender).NamingContainer; ObjEWA.Action = "Delete"; ObjEWA.UserCode = grdrow.Cells[0].Text; ObjEWA.DepartmentId = ddlDepartment.SelectedValue.ToString(); ObjEWA.DesignationTypeId = rbtlDesType.SelectedValue.ToString(); ObjEWA.DesignationId = ddlDesignation.SelectedValue.ToString(); flag = ObjBL.EmpDeptDesAction_BL(ObjEWA); if (flag > 0) { msgBox.ShowMessage("deleted !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull); } else { msgBox.ShowMessage("Not Deleted. Atleast one department should be assigned !!!", "Not Deleted", UserControls.MessageBox.MessageStyle.Information); } GrdViewEmployeeBind(); GrdEmployeeBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }