コード例 #1
0
        protected void btnGo_Click(object sender, EventArgs e)
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId    = ddlorganization.SelectedValue;//Session["OrgId"].ToString();
                objEWA.BranchId = ddlBranch.SelectedValue.ToString();
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();
                objEWA.ClassId  = ddlClass.SelectedValue.ToString();
                objEWA.date     = txtDate.Text; // Convert.ToDateTime((Convert.ToDateTime(txtDate.Text.ToString()).ToShortDateString())).ToString("dd/MM/yyyy");

                DataSet ds = objBL.BindStudentAttendance_BL(objEWA);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    grdStudentAtten.DataSource = ds;
                    grdStudentAtten.DataBind();
                    //grdStudentAtten.ControlStyle.Width  = 90;
                    //grdStudentAtten.CellPadding = 20;
                }
                else
                {
                    grdStudentAtten.DataSource = ds;
                    grdStudentAtten.DataBind();
                    GeneralErr("No Record Present...!");
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #2
0
        //Bind Division
        #region [Bind Division]

        private void BindDivision()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.ClassId = ddlClass.SelectedValue.ToString();
                if (!objEWA.ClassId.Equals("Select"))
                {
                    DataSet ds = objBL.BindDivision_BL(objEWA);

                    ddlDivision.DataSource     = ds;
                    ddlDivision.DataTextField  = "DivisionName";
                    ddlDivision.DataValueField = "DivisionId";
                    ddlDivision.DataBind();
                }
                else
                {
                    ddlDivision.Items.Clear();
                }
                ddlDivision.Items.Insert(0, new ListItem("Select", "Select"));
                ShowEmptyGridView(GrdSender);
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #3
0
        private void BindClass()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.BranchId = ddlBranch.SelectedValue.ToString();
                if (!objEWA.BranchId.Equals("Select"))
                {
                    DataSet ds = objBL.BindClass_BL(objEWA);

                    ddlClass.DataSource = ds;
                    if (ds.Tables[0].Rows.Count != 0)
                    {
                        ddlClass.DataTextField  = "ClassName";
                        ddlClass.DataValueField = "ClassId";
                        ddlClass.DataBind();
                    }
                    else
                    {
                        ddlClass.Items.Clear();
                    }
                }
                else
                {
                    ddlClass.Items.Clear();
                }
                ddlClass.Items.Insert(0, new ListItem("Select", "0"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #4
0
        //Bind Branch
        #region [Bind Branch]

        private void BindBranch()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();
                if (!objEWA.CourseId.Equals("Select"))
                {
                    DataSet ds = objBL.BindBranch_BL(objEWA);

                    ddlBranch.DataSource     = ds;
                    ddlBranch.DataTextField  = "BranchName";
                    ddlBranch.DataValueField = "BranchId";
                    ddlBranch.DataBind();
                }
                else
                {
                    ddlBranch.Items.Clear();
                }
                ddlBranch.Items.Insert(0, new ListItem("Select", "Select"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #5
0
        //Bind Student Grid Data
        #region [Bind Student Grid Data]

        private void BindStudentGridData()
        {
            try
            {
                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)
                {
                    GrdSender.DataSource = ds;
                    GrdSender.DataBind();
                    GrdSender.Columns[2].Visible = true;
                    dsGrdSender = ds.Copy();
                }
                else
                {
                    ShowEmptyGridView(GrdSender);
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #6
0
        private void BindCourse()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId = Session["OrgId"].ToString();
                DataSet ds = objBL.BindCourses_BL(objEWA);

                ddlCourse.DataSource     = ds;
                ddlCourse.DataTextField  = "CourseName";
                ddlCourse.DataValueField = "CourseId";
                ddlCourse.DataBind();
                ddlCourse.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));

                ddlBranch.Items.Clear();
                ddlClass.Items.Clear();
                ddlBranch.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
                ddlClass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #7
0
        //Class Changed
        #region [Class Changed]

        protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                EWA_Common ObjEWA = new EWA_Common();
                BL_Common  ObjBL  = new BL_Common();

                ObjEWA.OrgId    = Session["OrgId"].ToString();
                ObjEWA.CourseId = ddlCourse.SelectedValue.ToString();
                ObjEWA.ClassId  = ddlClass.SelectedValue.ToString();

                DataSet ds = ObjBL.BindSubject_BL(ObjEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    ddlSubject.DataSource     = ds;
                    ddlSubject.DataTextField  = "SubjectName";
                    ddlSubject.DataValueField = "SubjectId";
                    ddlSubject.DataBind();
                }
                else
                {
                    ddlSubject.Items.Clear();
                }

                ddlSubject.Items.Insert(0, "Select");
                ddlSubject.SelectedIndex = 0;

                ShowEmptyGridView(GrdEmployee);
                ShowEmptyGridView(GrdViewEmployee);
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #8
0
        public DataSet BindAssigned_Subject_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "Fetch_Assigned_Subject";
                prmList[2]  = "@OrgId";
                prmList[3]  = ObjEWA.OrgId;
                prmList[4]  = "@UserCode";
                prmList[5]  = ObjEWA.UserCode;
                prmList[6]  = "@CourseId";
                prmList[7]  = ObjEWA.CourseId;
                prmList[8]  = "@BranchId";
                prmList[9]  = ObjEWA.BranchId;
                prmList[10] = "@ClassId";
                prmList[11] = ObjEWA.ClassId;

                ds = ObjHelper.FillControl(prmList, "SP_Common");
            }
            catch (Exception exp)
            {
                //throw exp;
            } return(ds);
        }
コード例 #9
0
        // Bind Designation BindDesignation_DL
        #region [Bind Designation Region]

        public DataSet BindDesignation_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "FetchDesignation";
                prmList[2] = "@DesignationTypeId";
                prmList[3] = ObjEWA.DesignationTypeId;
                prmList[4] = "@DepartmentId";
                prmList[5] = ObjEWA.DepartmentId;

                ds = ObjHelper.FillControl(prmList, "SP_Common");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #10
0
        public DataSet Bind_AdmissionCompleted_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "FetchAdmission_Completed";
                prmList[2]  = "@OrgId";
                prmList[3]  = ObjEWA.OrgId.ToString();
                prmList[4]  = "@CourseId";
                prmList[5]  = ObjEWA.CourseId.ToString();
                prmList[6]  = "@BranchId";
                prmList[7]  = ObjEWA.BranchId.ToString();
                prmList[8]  = "@ClassId";
                prmList[9]  = ObjEWA.ClassId.ToString();
                prmList[10] = "@Status";
                prmList[11] = ObjEWA.Status;
                ds          = ObjHelper.FillControl(prmList, "SP_Common");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #11
0
        // Bind Grid of StudentData_DL
        #region [Bind Student Data Region]

        public DataSet BindStudentData_DL(EWA_Common objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[10];
                prmList[0] = "@Action";
                prmList[1] = "FetchStudent";
                prmList[2] = "@CourseId";
                prmList[3] = objEWA.CourseId;
                prmList[4] = "@ClassId";
                prmList[5] = objEWA.ClassId;
                prmList[6] = "@OrgId";
                prmList[7] = objEWA.OrgId;
                prmList[8] = "@BranchId";
                prmList[9] = objEWA.BranchId;
                // prmList[10] = "@DivisionId";
                //prmList[11] = objEWA.DivisionId;

                ds = ObjHelper.FillControl(prmList, "SP_Common");
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #12
0
        //Added by ashwini 23-Oct-2020
        public DataSet GetStudentListFilterWise(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[6];
                prmList[0] = "@Criteria";
                prmList[1] = ObjEWA.Criteria;
                prmList[2] = "@CriteriaValue";
                prmList[3] = ObjEWA.CriteriaValue;
                prmList[4] = "@Action";
                prmList[5] = "GetStudentListFilterWise";
                ds         = ObjHelper.FillControl(prmList, "SP_GetAdmissionStatusByStudent");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #13
0
        //Bind Subject
        #region [Bind Subjects]

        private void BindSubject()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.CourseId = ddlCourses.SelectedValue;
                objEWA.BranchId = ddlBranches.SelectedValue;
                objEWA.ClassId  = ddlClasses.SelectedValue;
                objEWA.OrgId    = Session["OrgId"].ToString();
                objEWA.UserCode = Session["Username"].ToString();

                DataSet ds = objBL.BindAssigned_Subject_BL(objEWA);

                ddlSelectSubject.DataSource = ds;

                ddlSelectSubject.DataTextField  = "SubjectName";
                ddlSelectSubject.DataValueField = "SubjectId";
                ddlSelectSubject.DataBind();
                ddlSelectSubject.Items.Insert(0, new ListItem("Select", "0"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #14
0
        //Bind Class
        #region [Bind Class]

        private void BindClass(DropDownList ddlBranch, DropDownList ddlClass)
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.BranchId = ddlBranch.SelectedValue.ToString();
                if (!objEWA.BranchId.Equals("-1"))
                {
                    objEWA.OrgId = Session["OrgId"].ToString();// Session["OrgId"].ToString();
                    DataSet ds = objBL.BindClass_BL(objEWA);

                    ddlClass.DataSource     = ds;
                    ddlClass.DataTextField  = "ClassName";
                    ddlClass.DataValueField = "ClassId";
                    ddlClass.DataBind();
                    ddlClass.Items.Insert(0, new ListItem("Select", "-1"));
                }
                else
                {
                    ddlClass.Items.Clear();
                    ddlClass.Items.Insert(0, new ListItem("Select", "-1"));
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #15
0
        private void BindDesignation()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();

                objEWA.OrgId             = Session["OrgId"].ToString();
                objEWA.DepartmentId      = DDL_Department.SelectedValue.ToString();
                objEWA.DesignationTypeId = rbtnFacultyType.SelectedItem.Value;

                //RadioButtonList rbtnList = Page.FindControl("rbtnFacultyType") as RadioButtonList;

                //string str= rbtnList.SelectedValue;

                DataSet ds = objBL.BindDesignation_BL(objEWA);

                DDL_Designation.DataSource     = ds;
                DDL_Designation.DataTextField  = "DesignationName";
                DDL_Designation.DataValueField = "DesignationId";
                DDL_Designation.DataBind();
                DDL_Designation.Items.Insert(0, "Select");
                DDL_Designation.SelectedIndex = 0;
                DDL_Designation.DataSource    = null;
                DDL_Designation.DataBind();
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #16
0
        public DataSet BindTimeTable_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "GetTimeTable_HomeWork";
                prmList[2]  = "@OrgId";
                prmList[3]  = ObjEWA.OrgId;
                prmList[4]  = "@CourseId";
                prmList[5]  = ObjEWA.CourseId;
                prmList[6]  = "@BranchId";
                prmList[7]  = ObjEWA.BranchId;
                prmList[8]  = "@ClassId";
                prmList[9]  = ObjEWA.ClassId;
                prmList[10] = "@Date";
                prmList[11] = ObjEWA.date;
                ds          = ObjHelper.FillControl(prmList, "SP_TimeTableCreationAction");
                if (ds.Tables[0].Rows.Count > 0 || ds.Tables[1].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #17
0
        private void BindBranch()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                DL_Common  objDL  = new DL_Common();
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();

                DataSet ds = objDL.BindBranch_DL(objEWA);

                ddlBranch.DataSource     = ds;
                ddlBranch.DataTextField  = "BranchName";
                ddlBranch.DataValueField = "BranchId";
                ddlBranch.DataBind();

                ddlBranch.Items.Insert(0, new ListItem("Select", "0"));

                ddlClass.Items.Clear();
                ddlClass.Items.Insert(0, new ListItem("---Select---", "0"));

                ddlDivision.Items.Clear();
                ddlDivision.Items.Insert(0, new ListItem("---Select---", "0"));
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #18
0
        public DataSet BindStudentAttendance_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "CountAttendace";
                prmList[2]  = "@OrgId";
                prmList[3]  = ObjEWA.OrgId;
                prmList[4]  = "@CourseId";
                prmList[5]  = ObjEWA.CourseId;
                prmList[6]  = "@BranchId";
                prmList[7]  = ObjEWA.BranchId;
                prmList[8]  = "@ClassId";
                prmList[9]  = ObjEWA.ClassId;
                prmList[10] = "@AttendanceDate";
                prmList[11] = ObjEWA.date;
                ds          = ObjHelper.FillControl(prmList, "SP_StudentAttendance");

                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #19
0
        private void bindData()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId = Session["OrgId"].ToString();
                DataSet ds = objBL.BindFeeStructure(objEWA);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    GRDFee.DataSource = ds;
                    GRDFee.DataBind();
                }
                else
                {
                    GRDFee.DataSource = null;
                    GRDFee.DataBind();
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #20
0
        public DataSet BindResultFormat_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[10];
                prmList[0] = "@Action";
                prmList[1] = "FetchResultFormat";
                prmList[2] = "@OrgId";
                prmList[3] = ObjEWA.OrgId;
                prmList[4] = "@CourseId";
                prmList[5] = ObjEWA.CourseId;
                prmList[6] = "@BranchId";
                prmList[7] = ObjEWA.BranchId;
                prmList[8] = "@ClassId";
                prmList[9] = ObjEWA.ClassId;
                //prmList[10] = "@SemesterId";
                //prmList[11] = ObjEWA.SemesterId;
                ds = ObjHelper.FillControl(prmList, "SP_Common");

                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #21
0
        private void BindSemester()
        {
            try
            {
                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();
                DataSet ds = objBL.BindSemester_BL(objEWA);

                ddlSemester.DataSource = ds;
                if (ds.Tables[0].Rows.Count != 0)
                {
                    ddlSemester.DataTextField  = "SemesterName";
                    ddlSemester.DataValueField = "SemesterId";
                    ddlSemester.DataBind();
                }
                else
                {
                    ddlSemester.Items.Clear();
                }

                ddlSemester.Items.Insert(0, new ListItem("Select", "0"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #22
0
        //Fetch Staff with Filters
        #region [Fetch Staff with FiltersRegion]
        public DataSet DL_BindFacultyName(EWA_Common objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[10];
                prmList[0] = "@Action";
                prmList[1] = "GetFacultyName";
                prmList[2] = "@DesignationId";
                prmList[3] = objEWA.DesignationId;
                prmList[4] = "@DepartmentId";
                prmList[5] = objEWA.DepartmentId;
                prmList[6] = "@DesignationTypeId";
                prmList[7] = objEWA.DesignationTypeId;
                prmList[8] = "@OrgId";
                prmList[9] = objEWA.OrgId;


                ds = ObjHelper.FillControl(prmList, "SP_Common");
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #23
0
        //protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    string senderType=rbtnSender.SelectedValue.ToString();
        //    if (senderType.Equals("Student"))
        //    {
        //        BindStudentGridData();
        //    }

        //}

        //Bind Staff Grid Data
        #region [Bind Staff Grid Data]

        private void BindStaffGridData()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();

                objEWA.OrgId         = Session["OrgId"].ToString();
                objEWA.UserCode      = Session["UserCode"].ToString();
                objEWA.DesignationId = ddlDesignation.SelectedValue.ToString();
                objEWA.DepartmentId  = ddlDepartment.SelectedValue.ToString();
                DataSet ds = objBL.BindFacultyData_BL(objEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    GrdFacultySender.DataSource = ds;

                    GrdFacultySender.DataBind();
                    GrdFacultySender.Columns[2].Visible = true;
                    dsGrdFacultySender = ds.Copy();
                }
                else
                {
                    ShowEmptyGridView(GrdFacultySender);
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #24
0
        //Added by Ashwini 25-sep-2020
        public DataSet GetAllFeesData(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[8];
                prmList[0] = "@OrgId";
                prmList[1] = ObjEWA.OrgId.ToString();
                prmList[2] = "@addmissionId";
                prmList[3] = ObjEWA.addmissionId.ToString();
                prmList[4] = "@StudId";
                prmList[5] = ObjEWA.StudId.ToString();
                prmList[6] = "@Course";
                prmList[7] = ObjEWA.course.ToString();
                ds         = ObjHelper.FillControl(prmList, "SP_GetAllDataAboutFeesForUpgradeStudent");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #25
0
        //Bind Designation
        #region [Bind Designation]

        private void BindDesignation(String strFacultyType)
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();

                objEWA.OrgId             = Session["OrgId"].ToString();
                objEWA.DepartmentId      = ddlDepartment.SelectedValue.ToString();
                objEWA.DesignationTypeId = strFacultyType;

                DataSet ds = objBL.BindDesignation_BL(objEWA);

                ddlDesignation.DataSource     = ds;
                ddlDesignation.DataTextField  = "DesignationName";
                ddlDesignation.DataValueField = "DesignationId";
                ddlDesignation.DataBind();
                ddlDesignation.Items.Insert(0, "Select");
                ddlDesignation.SelectedIndex = 0;
                GrdFacultySender.DataSource  = null;
                GrdFacultySender.DataBind();
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #26
0
        // Bind Courses BindCourses_DL
        #region [Bind Course Region]

        public DataSet BindCourses_DL(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[4];
                prmList[0] = "@Action";
                prmList[1] = "FetchCourses";
                prmList[2] = "@OrgId";
                prmList[3] = ObjEWA.OrgId.ToString();
                //prmList[4] = "@CourseId";
                //prmList[5] = ObjEWA.CourseId.ToString();

                ds = ObjHelper.FillControl(prmList, "SP_Common");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #27
0
        private void BindBranch()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                DL_Common  objDL  = new DL_Common();
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();

                DataSet ds = objDL.BindBranch_DL(objEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    ddlBranch.DataSource     = ds;
                    ddlBranch.DataTextField  = "BranchName";
                    ddlBranch.DataValueField = "BranchId";
                    ddlBranch.DataBind();
                }
                else
                {
                    ddlBranch.Items.Clear();
                }
                ddlBranch.Items.Insert(0, new ListItem("Select", "0"));
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #28
0
        //

        //Added by Ashwini 26-sep-2020
        public DataSet GetBusFeesDetails(EWA_Common ObjEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[10];
                prmList[0] = "@StudId";
                prmList[1] = ObjEWA.StudId.ToString();
                prmList[2] = "@CourseId";
                prmList[3] = ObjEWA.CourseId.ToString();
                prmList[4] = "@ClassId";
                prmList[5] = ObjEWA.ClassId.ToString();
                prmList[6] = "@BranchId";
                prmList[7] = ObjEWA.BranchId.ToString();
                prmList[8] = "@AcademicYear";
                prmList[9] = ObjEWA.AcademicYear.ToString();
                ds         = ObjHelper.FillControl(prmList, "SP_GetAllDataAboutBusFeesForUpgradeStudent");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
コード例 #29
0
        protected void btnGo_Click(object sender, EventArgs e)
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId    = ddlorganization.SelectedValue;//Session["OrgId"].ToString();
                objEWA.BranchId = ddlBranch.SelectedValue.ToString();
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();
                objEWA.ClassId  = ddlClass.SelectedValue.ToString();
                objEWA.date     = Convert.ToDateTime(txtDate.Text.ToString()).ToShortDateString();

                DataSet ds = objBL.BindTimeTable_BL(objEWA);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    bindGridView(ds);
                }
                else
                {
                    msgBox.ShowMessage("Record not found", "Information", UserControls.MessageBox.MessageStyle.Critical);
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
コード例 #30
0
        private void BindSubject()
        {
            try
            {
                EWA_Common ObjEWA = new EWA_Common();
                BL_Common  ObjBL  = new BL_Common();

                ObjEWA.OrgId    = Session["OrgId"].ToString();
                ObjEWA.CourseId = ddlCourse.SelectedValue.ToString();
                ObjEWA.ClassId  = ddlClass.SelectedValue.ToString();

                DataSet ds = ObjBL.BindSubject_BL(ObjEWA);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    ddlSubject.DataSource     = ds;
                    ddlSubject.DataTextField  = "SubjectName";
                    ddlSubject.DataValueField = "SubjectId";
                    ddlSubject.DataBind();
                }
                else
                {
                    ddlSubject.Items.Clear();
                }

                ddlSubject.Items.Insert(0, new ListItem("Select", "0"));
                ddlSubject.Items.Insert(1, new ListItem("Break", "501"));
                ddlSubject.SelectedIndex = 0;
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }