//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()); } }
//Insert Update Delete operaeion on EmployeeDeptDes Table #region [ActionPerformed For EmployeeDeptDes] public int EmpCourseClassAction_BL(EWA_EmpAssignSubject objEWA) { try { int flag = objDL.EmpCourseClassAction_DL(objEWA); return(flag); } catch (Exception) { throw; } }
//To Bind EmployeeGrid #region [BindEmployeeGrid] public DataSet BindEmployeeGrid_DL(EWA_EmpAssignSubject objEWA) { DataSet ds = new DataSet(); try { prmList = new string[14]; prmList[0] = "@Action"; prmList[1] = objEWA.Action; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId.ToString(); prmList[4] = "@DesignationTypeId"; prmList[5] = objEWA.DesignationTypeId.ToString(); prmList[6] = "@CourseId"; prmList[7] = objEWA.CourseId; prmList[8] = "@ClassId"; prmList[9] = objEWA.ClassId; prmList[10] = "@SubjectId"; prmList[11] = objEWA.SubjectId; prmList[12] = "@BranchId"; prmList[13] = objEWA.BranchId; ds = ObjHelper.FillControl(prmList, "SP_EmpAssignSubject"); //if (ds.Tables[0].Rows.Count > 0) //{ // return ds; //} //else //{ // DataTable dt = new DataTable(); // dt.Columns.Add("UserCode"); // dt.Columns.Add("SubjectCode"); // dt.Columns.Add("SubjectName"); // dt.Rows.Add(); // dt.Rows.Add(); // dt.Rows.Add(); // //return dsCode; //} return(ds); } catch (Exception) { // GeneralErr(exp.Message.ToString()); throw; } }
//Fetch Subject #region [Fetch Subject] public DataSet FetchSubject_BL(EWA_EmpAssignSubject ObjEWA) { try { DL_EmpAssignSubject objDL = new DL_EmpAssignSubject(); DataSet ds = objDL.FetchSubject_DL(ObjEWA); return(ds); } catch (Exception) { throw; } finally { objDL = null; } }
//To Call EmployeeGridBind #region [EmployeeGridBind] public System.Data.DataSet EmployeeGridBind_BL(EWA_EmpAssignSubject objEWA) { try { DL_EmpAssignSubject objDL = new DL_EmpAssignSubject(); DataSet ds = objDL.BindEmployeeGrid_DL(objEWA); return(ds); } catch (Exception) { throw; } finally { objDL = null; } }
//Fetch Subject #region [Fetch Subject] public DataSet FetchSubject_DL(EWA_EmpAssignSubject ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[6]; prmList[0] = "@Action"; prmList[1] = ObjEWA.Action; prmList[2] = "@UserCode"; prmList[3] = ObjEWA.UserCode; prmList[4] = "@OrgId"; prmList[5] = ObjEWA.OrgId; ds = ObjHelper.FillControl(prmList, "SP_EmpAssignSubject"); return(ds); } catch (Exception e) { throw e; } }
//To Perform Insert,Update,Delete and Search Actions On EmpDeptDes Table #region [Perform Actions On Emp Dept Des] public int EmpCourseClassAction_DL(EWA_EmpAssignSubject objEWA) { try { cmd = new SqlCommand("SP_EmpAssignSubject", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", objEWA.Action); cmd.Parameters.AddWithValue("@UserCode", objEWA.UserCode); cmd.Parameters.AddWithValue("@CourseId", objEWA.CourseId); cmd.Parameters.AddWithValue("@ClassId", objEWA.ClassId); cmd.Parameters.AddWithValue("@SubjectId", objEWA.SubjectId); cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId); cmd.Parameters.AddWithValue("@UserId", objEWA.UserId); cmd.Parameters.AddWithValue("@BranchId", objEWA.BranchId); cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive); con.Open(); int flag = cmd.ExecuteNonQuery(); con.Close(); return(flag); } catch (Exception ex) { int err = ((System.Data.SqlClient.SqlException)(ex)).Number; if (err == 547 && objEWA.Action == "Delete") { throw new SystemException("Record is in use !!!"); } else { throw ex; } } //finally //{ // con.Close(); // cmd.Dispose(); //} }