//Insert Update Delete operation on Branch Table #region [Action Performed] public int BranchAction_BL(EWA_ProgramExecutive objEWA) { DL_ProgramExecutive objDL = new DL_ProgramExecutive(); try { int flag = objDL.BranchAction_DL(objEWA); 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(); objDL = null; } }
//To Check Duplicate Data #region [Check Duplicate Course] public int CheckDuplicateCourse_BL(EWA_ProgramExecutive objEWA) { try { DL_ProgramExecutive objDL = new DL_ProgramExecutive(); int i = objDL.CheckDuplicateCourse_DL(objEWA); return(i); } catch (Exception) { throw; } }
//To Call Course Grid Bind #region [Course Grid Bind] public DataSet CourseGridBind_BL(EWA_ProgramExecutive objEWA) { try { DL_ProgramExecutive objDL = new DL_ProgramExecutive(); DataSet ds = objDL.BindCourseGrid_DL(objEWA); return(ds); } catch (Exception) { throw; } }
//Bind Classes #region [Bind Classes Region] public DataSet BindddlClasses_BL(EWA_ProgramExecutive objEWA) { try { DL_ProgramExecutive objDL = new DL_ProgramExecutive(); DataSet ds = objDL.BindddlClasses_DL(objEWA); return(ds); } catch (Exception) { throw; } }
//Insert Update Delete operaeion on Division Table #region [Action Performed] public int DivisionAction_BL(EWA_ProgramExecutive objEWA) { DL_ProgramExecutive objDL = new DL_ProgramExecutive(); try { int flag = objDL.DivisionAction_DL(objEWA); return(flag); } catch (Exception) { throw; } finally { objDL = null; } }