//Linkbtn Event #region [LnkBtb Event] 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_EmpAssignSubject ObjEWA = new EWA_EmpAssignSubject(); BL_EmpAssignSubject ObjBL = new BL_EmpAssignSubject(); GridViewRow grdrow = (GridViewRow)((LinkButton)sender).NamingContainer; ObjEWA.Action = "Delete"; ObjEWA.UserCode = grdrow.Cells[0].Text; ObjEWA.CourseId = ddlCourse.SelectedValue.ToString(); ObjEWA.ClassId = ddlClass.SelectedValue.ToString(); ObjEWA.SubjectId = ddlSubject.SelectedValue.ToString(); ObjEWA.OrgId = Session["OrgId"].ToString(); flag = ObjBL.EmpCourseClassAction_BL(ObjEWA); if (flag > 0) { msgBox.ShowMessage("deleted !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull); } GrdViewEmployeeBind(); GrdEmployeeBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Emp Data Bind #region [Emp Data Bind] protected void GrdEmployee_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowIndex > -1) { GridViewRow GrdRow = e.Row; EWA_EmpAssignSubject ObjEWA = new EWA_EmpAssignSubject(); BL_EmpAssignSubject ObjBL = new BL_EmpAssignSubject(); ObjEWA.Action = "FetchSubject"; ObjEWA.UserCode = GrdRow.Cells[0].Text; ObjEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = ObjBL.FetchSubject_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()); } }
//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()); } }