Exemple #1
0
        //Bind  Parent Grid
        #region Bind Parent Grid

        //Student Grid Bind
        #region [Student Grid Bind]

        private void GrdStudentBind()
        {
            try
            {
                objEWA.OrgId    = Convert.ToString(Session["OrgId"]);
                objEWA.CourseId = ddlCourse.SelectedValue.ToString();
                objEWA.BranchId = ddlBranch.SelectedValue.ToString();
                objEWA.ClassId  = ddlClass.SelectedValue.ToString();
                DataSet ds = objBL.StudentGridBind_BL(objEWA);

                if (ds.Tables[0].Rows.Count == 0 || ds == null)
                {
                    msgBox.ShowMessage("No Record Found !!!", "Saved", UserControls.MessageBox.MessageStyle.Information);
                }
                else
                {
                    GrdStudent.DataSource = ds;
                    GrdStudent.DataBind();
                }
            }

            catch (Exception)
            {
                throw;
            }
        }
        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);

                ViewState["dvBranch"]      = ds.Tables[2];
                ViewState["dvClass"]       = ds.Tables[3];
                ViewState["dvDivision"]    = ds.Tables[4];
                ViewState["dvStudentData"] = ds.Tables[5];

                ddlCourse.DataSource     = ds.Tables[0];
                ddlCourse.DataTextField  = "CourseName";
                ddlCourse.DataValueField = "CourseId";
                ddlCourse.DataBind();
                ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));



                ddlCasteCategory.DataSource     = ds.Tables[1];
                ddlCasteCategory.DataTextField  = "CasteCategoryName";
                ddlCasteCategory.DataValueField = "CasteCategoryId";
                ddlCasteCategory.DataBind();
                ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0"));

                DDLAcademicYear.DataSource     = ds.Tables[7];
                DDLAcademicYear.DataTextField  = "AcademicYear";
                DDLAcademicYear.DataValueField = "AcademicYearId";
                DDLAcademicYear.DataBind();
                DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));



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

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



                if (IsPostBack)
                {
                    GrdStudent.DataSource = ds.Tables[5];
                    GrdStudent.DataBind();
                    gvPrint.DataSource = ds.Tables[5];
                    gvPrint.DataBind();
                    ViewState["PrintData"] = ds.Tables[5];
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemple #3
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);

                ViewState["dvcast"]   = ds.Tables[1];
                ViewState["dvBranch"] = ds.Tables[2];
                ViewState["dvClass"]  = ds.Tables[3];
                //ViewState["dvDivision"] = ds.Tables[4];
                ViewState["dvStudentData"] = ds.Tables[5];

                ddlCourse.DataSource     = ds.Tables[0];
                ddlCourse.DataTextField  = "CourseName";
                ddlCourse.DataValueField = "CourseId";
                ddlCourse.DataBind();
                ddlCourse.Items.Insert(0, new ListItem("---Select---", "0"));

                ddlCasteCategory.DataSource     = ds.Tables[1];
                ddlCasteCategory.DataTextField  = "CasteCategoryName";
                ddlCasteCategory.DataValueField = "CasteCategoryId";
                ddlCasteCategory.DataBind();
                ddlCasteCategory.Items.Insert(0, new ListItem("---Select---", "0"));

                DDLAcademicYear.DataSource     = ds.Tables[7];
                DDLAcademicYear.DataTextField  = "AcademicYear";
                DDLAcademicYear.DataValueField = "AcademicYearId";
                DDLAcademicYear.DataBind();
                DDLAcademicYear.Items.Insert(0, new ListItem("---Select---", "0"));

                ddlBranch.Items.Clear();
                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"));

                GrdStudent.DataSource = ds.Tables[5];
                GrdStudent.DataBind();

                //GrdStudent.DataSource = db.Displaygrid("SELECT        tblStudent.UserCode, tblAdmissionDetails.FirstName, tblAdmissionDetails.MiddleName, tblAdmissionDetails.LastName, tblCourse.CourseName,  tblBranch.BranchName, tblClass.ClassName, tblAdmissionDetails.AdmissionYear FROM            tblAdmissionDetails INNER JOIN tblStudent ON tblAdmissionDetails.AdmissionID = tblStudent.AdmissionId INNER JOIN tblCourse ON tblAdmissionDetails.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblAdmissionDetails.BranchId = tblBranch.BranchId INNER JOIN tblClass ON tblAdmissionDetails.ClassId = tblClass.ClassId where tblAdmissionDetails.OrgID='" + Convert.ToInt32(Session["OrgId"]) + "'");
                //GrdStudent.DataBind();

                gvPrint.DataSource = ds.Tables[5];
                gvPrint.DataBind();
                ViewState["PrintData"] = ds.Tables[5];
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemple #4
0
 void clear()
 {
     GrdEmployee.DataSource = "";
     GrdEmployee.DataBind();
     //GrdParent.DataSource = "";
     //GrdParent.DataBind();
     GrdStudent.DataSource = "";
     GrdStudent.DataBind();
     txtMessage.Text = "";
 }
        //Added by Ashwini 23-Oct-2020
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            EWA_Common objEWA = new EWA_Common();
            BL_Common  objBL  = new BL_Common();

            objEWA.student = txtSearchStudname.Text;
            DataSet ds = objBL.GetStudentWiseData(objEWA);

            GrdStudent.DataSource = ds;
            GrdStudent.DataBind();
        }
Exemple #6
0
        //Student Chnaging
        #region [Student Changing]

        protected void GrdStudent_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            try
            {
                GrdStudent.PageIndex  = e.NewPageIndex;
                GrdStudent.DataSource = dsGrdStudent;
                GrdStudent.DataBind();
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
        public void BindStudentList(string rblStatus)
        {
            EWA_Common objEWA = new EWA_Common();
            BL_Common  objBL  = new BL_Common();

            objEWA.OrgId = Session["OrgId"].ToString();
            DataSet ds = objBL.BindCourses_BL(objEWA);

            ViewState["dvStudentData"] = ds.Tables[6];
            dvStudentData           = new DataView(ViewState["dvStudentData"] as DataTable);
            dvStudentData.RowFilter = "[Status] = '" + rblStatus + "'";
            GrdStudent.DataSource   = dvStudentData;
            GrdStudent.DataBind();
            gvPrint.DataSource = dvStudentData;
            gvPrint.DataBind();
        }
        private void GetStudentData()
        {
            string strQuery = null;

            if (rblStatus.SelectedValue == "Admission Completed")
            {
                dvStudentData          = new DataView(ViewState["dvStudentData_Completed"] as DataTable);
                ViewState["PrintData"] = dvStudentData;
            }
            else
            {
                dvStudentData          = new DataView(ViewState["dvStudentData"] as DataTable);
                ViewState["PrintData"] = dvStudentData;
            }
            if (rblStatus.SelectedItem != null)
            {
                strQuery = "[Status] = '" + rblStatus.SelectedValue + "'";
            }
            if (ddlCourse.SelectedValue != "0")
            {
                if (rblStatus.SelectedItem != null)
                {
                    strQuery = "[CourseId] = " + ddlCourse.SelectedValue + " And [Status] = '" + rblStatus.SelectedValue + "'";
                }
                else
                {
                    strQuery = "[CourseId] = " + ddlCourse.SelectedValue + "";
                }
            }
            if (ddlBranch.SelectedValue != "0")
            {
                strQuery = strQuery + " And [BranchId] = " + ddlBranch.SelectedValue + "";
            }
            if (ddlClass.SelectedValue != "0")
            {
                strQuery = strQuery + " And [ClassId] = " + ddlClass.SelectedValue + "";
            }

            dvStudentData.RowFilter = strQuery;
            GrdStudent.DataSource   = dvStudentData;
            GrdStudent.DataBind();


            gvPrint.DataSource = dvStudentData;
            gvPrint.DataBind();
            ViewState["PrintableData"] = strQuery;
        }
        protected void btnGo_Click(object sender, EventArgs e)
        {
            try
            {
                //GetStudentData();

                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId    = Session["OrgId"].ToString();
                objEWA.CourseId = ddlCourse.SelectedValue;
                objEWA.BranchId = ddlBranch.SelectedValue;
                objEWA.ClassId  = ddlClass.SelectedValue;
                objEWA.Status   = rblStatus.SelectedValue;
                DataSet ds = objBL.Bind_AdmissionCompleted_BL(objEWA);
                GrdStudent.DataSource = ds.Tables[0];
                GrdStudent.DataBind();
                gvPrint.DataSource = ds.Tables[0];
                gvPrint.DataBind();
                //ViewState["PrintData"]= ds.Tables[0];
            }
            catch (Exception ex) { }
        }
        private void BindStudent()
        {
            try
            {
                EWA_Common objEWA = new EWA_Common();
                BL_Common  objBL  = new BL_Common();
                objEWA.OrgId = Session["OrgId"].ToString();
                DataSet ds = objBL.BindCourses_BL(objEWA);


                ViewState["dvStudentData"] = ds.Tables[5];

                GrdStudent.DataSource = ds.Tables[5];
                GrdStudent.DataBind();
                gvPrint.DataSource = ds.Tables[5];
                gvPrint.DataBind();
                ViewState["PrintData"] = ds.Tables[5];
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Exemple #11
0
        private void GetStudentData()
        {
            string strQuery = null;

            dvStudentData = new DataView(ViewState["dvStudentData"] as DataTable);

            ///////////////////////////////////////////////////////
            if (ddlCourse.SelectedValue != "0")
            {
                if (ddlCasteCategory.SelectedValue == "0" && txtStudName.Text.Length == 0 && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (ddlCasteCategory.SelectedValue != "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (txtStudName.Text.Length != 0)
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (ddlCasteCategory.SelectedValue != "0" && txtStudName.Text.Length != 0)
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "' And [StudentName] like '"
                               + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (ddlCasteCategory.SelectedValue != "0" && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "' And [CourseId] = " + ddlCourse.SelectedValue + " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
                if (txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue +
                               " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
                if (ddlCasteCategory.SelectedValue != "0" && txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "' And [StudentName] like '"
                               + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            else if (ddlCasteCategory.SelectedValue != "0")
            {
                if (ddlCourse.SelectedValue == "0" && txtStudName.Text.Length == 0 && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "'";
                }
                if (txtStudName.Text.Length != 0)
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "'";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "'";
                }
                if (txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CasteCategoryId] = '" + ddlCasteCategory.SelectedValue + "' And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            else if (txtStudName.Text.Length != 0)
            {
                if (ddlCourse.SelectedValue == "0" && ddlCasteCategory.SelectedValue == "0" && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%'";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [StudentName] like '" + txtStudName.Text + "%'";
                }
            }
            else if (DDLAcademicYear.SelectedValue != "0")
            {
                if (ddlCourse.SelectedValue == "0" && ddlCasteCategory.SelectedValue == "0" && txtStudName.Text.Length == 0)
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            /////////////////////////////////////////////////////
            if (ddlBranch.SelectedValue != "0")
            {
                strQuery = strQuery + " And [BranchId] = " + ddlBranch.SelectedValue + "";
            }
            if (ddlClass.SelectedValue != "0")
            {
                strQuery = strQuery + " And [ClassId] = " + ddlClass.SelectedValue + "";
            }
            if (ddlDivision.SelectedValue != "0")
            {
                strQuery = strQuery + " And [DivisionId] = " + ddlDivision.SelectedValue + "";
            }
            dvStudentData.RowFilter = strQuery;
            GrdStudent.DataSource   = dvStudentData;
            // GrdStudent.DataSource = db.Displaygrid("SELECT        tblStudent.UserCode, tblAdmissionDetails.FirstName, tblAdmissionDetails.MiddleName, tblAdmissionDetails.LastName, tblCourse.CourseName,  tblBranch.BranchName, tblClass.ClassName, tblAdmissionDetails.AdmissionYear FROM            tblAdmissionDetails INNER JOIN tblStudent ON tblAdmissionDetails.AdmissionID = tblStudent.AdmissionId INNER JOIN tblCourse ON tblAdmissionDetails.CourseId = tblCourse.CourseId INNER JOIN tblBranch ON tblAdmissionDetails.BranchId = tblBranch.BranchId INNER JOIN tblClass ON tblAdmissionDetails.ClassId = tblClass.ClassId where tblAdmissionDetails.OrgID='" + Convert.ToInt32(Session["OrgId"]) + "' AND tblAdmissionDetails.CourseId='"+ddlCourse.Text+"'");
            GrdStudent.DataBind();
            ViewState["PrintData"]         =
                ViewState["PrintableData"] = strQuery;
            //ViewState["PrintableData"] = dvStudentData;
        }
        private void GetStudentData()
        {
            string strQuery = null;

            dvStudentData = new DataView(ViewState["dvStudentData"] as DataTable);

            ///////////////////////////////////////////////////////
            if (ddlCourse.SelectedValue != "0")
            {
                if (ddlCasteCategory.SelectedValue == "0" && txtStudName.Text.Length == 0 && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (ddlCasteCategory.SelectedValue != "0")
                {
                    strQuery = "[Caste] = '" + ddlCasteCategory.SelectedItem.Text + "' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (txtStudName.Text.Length != 0)
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [CourseId] = " + ddlCourse.SelectedValue + "";
                }


                if (ddlCasteCategory.SelectedValue != "0" && txtStudName.Text.Length != 0)
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "' And [StudentName] like '"
                               + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + "";
                }
                if (ddlCasteCategory.SelectedValue != "0" && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "' And [CourseId] = " + ddlCourse.SelectedValue + " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
                if (txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue +
                               " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
                if (ddlCasteCategory.SelectedValue != "0" && txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "' And [StudentName] like '"
                               + txtStudName.Text + "%' And [CourseId] = " + ddlCourse.SelectedValue + " And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            else if (ddlCasteCategory.SelectedValue != "0")
            {
                if (ddlCourse.SelectedValue == "0" && txtStudName.Text.Length == 0 && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "'";
                }
                if (txtStudName.Text.Length != 0)
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "'";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "'";
                }
                if (txtStudName.Text.Length != 0 && DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%' And [CasteCategoryId] = '" + ddlCasteCategory.SelectedItem.Text + "' And [AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            else if (txtStudName.Text.Length != 0)
            {
                if (ddlCourse.SelectedValue == "0" && ddlCasteCategory.SelectedValue == "0" && DDLAcademicYear.SelectedValue == "0")
                {
                    strQuery = "[StudentName] like '" + txtStudName.Text + "%'";
                }
                if (DDLAcademicYear.SelectedValue != "0")
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue + " And [StudentName] like '" + txtStudName.Text + "%'";
                }
            }
            else if (DDLAcademicYear.SelectedValue != "0")
            {
                if (ddlCourse.SelectedValue == "0" && ddlCasteCategory.SelectedValue == "0" && txtStudName.Text.Length == 0)
                {
                    strQuery = "[AcademicYearId] = " + DDLAcademicYear.SelectedValue;
                }
            }
            /////////////////////////////////////////////////////
            if (ddlBranch.SelectedValue != "0")
            {
                strQuery = strQuery + " And [BranchId] = " + ddlBranch.SelectedValue + "";
            }
            if (ddlClass.SelectedValue != "0")
            {
                strQuery = strQuery + " And [ClassId] = " + ddlClass.SelectedValue + "";
            }

            dvStudentData.RowFilter = strQuery;
            GrdStudent.DataSource   = dvStudentData;
            GrdStudent.DataBind();
            ViewState["PrintData"]         =
                ViewState["PrintableData"] = strQuery;


            //ViewState["PrintableData"] = dvStudentData;
        }
        private void UpgradeAcademicyear(string strAction)
        {
            try
            {
                EWA_Admission objEWA      = new EWA_Admission();
                BL_Admission  objBAL      = new BL_Admission();
                int           Userid      = Convert.ToInt32(Session["UserCode"]);
                var           count       = GrdStudent.Rows.Count;
                string[]      AdmissionID = new string[count];
                int           i           = 0;
                int           oldOrgId    = Convert.ToInt32(Session["OrgId"].ToString());
                foreach (GridViewRow gvrow in GrdStudent.Rows)
                {
                    CheckBox chk = (CheckBox)gvrow.FindControl("chkbox");
                    if (chk != null && chk.Checked)
                    {
                        Label  addmissionId    = (Label)gvrow.FindControl("lbladdmissionid");
                        Label  UserCode        = (Label)gvrow.FindControl("lblUserCode");
                        Label  Branch          = (Label)gvrow.FindControl("lblBranch");
                        Label  Class           = (Label)gvrow.FindControl("LblClass");
                        Label  AcademicYear    = (Label)gvrow.FindControl("LblAcademicID");
                        string _drpcourse      = drpcourse.SelectedValue;
                        string _drpbranch      = drpbranch.SelectedValue;
                        string _drpclass       = drpclass.SelectedValue;
                        float  castcatergoryid = db.getDb_Value(" select feescategory FROM  tbladmissiondetails WHERE   admissionid='" + addmissionId.Text + "' and OrgID='" + oldOrgId + "' ");
                        float  AcademicYearId  = db.getDb_Value("SELECT AcademicYearId FROM tblStudent WHERE (UserCode = '" + UserCode.Text + "') and OrgID='" + oldOrgId + "' ");

                        float    fessid        = 0;
                        float    FeesDetailsid = 0;
                        string   FeesParticular;
                        float    TotalAmt    = 0;
                        DateTime currentDate = System.DateTime.Now.Date;
                        fessid = db.getDb_Value("SELECT  top(1) dbo.tblFeesDetails.FeesId FROM  dbo.tblFees INNER JOIN  dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId  where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and  BranchId='" + _drpbranch + "' and  ClassId='" + _drpclass + "' and CasteCategoryId='" + castcatergoryid.ToString() + "' ");

                        FeesDetailsid = db.getDb_Value("SELECT top(1) dbo.tblFeesDetails.FeesDetailsId FROM  dbo.tblFees INNER JOIN  dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId  where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and  BranchId='" + _drpbranch + "' and  ClassId='" + _drpclass + "' and CasteCategoryId='" + castcatergoryid.ToString() + "' ");
                        if (fessid > 0)
                        {
                            DataTable dt = new DataTable();
                            cn.Close();
                            cn.Open();
                            using (SqlCommand cmd = new SqlCommand("SELECT top(1) dbo.tblFeesDetails.Particular FROM  dbo.tblFees INNER JOIN  dbo.tblFeesDetails ON dbo.tblFees.FeesId = dbo.tblFeesDetails.FeesId  where AcademicYearId='" + drpacedemicyear1.SelectedValue + "' and CourseId='" + _drpcourse + "' and  BranchId='" + _drpbranch + "' and  ClassId='" + _drpclass + "'  and CasteCategoryId='" + castcatergoryid.ToString() + "'", cn))
                            {
                                cmd.CommandType = CommandType.Text;
                                cmd.Connection  = cn;
                                SqlDataReader dr = cmd.ExecuteReader();
                                dt.Load(dr);
                                FeesParticular = dt.Rows[0]["Particular"].ToString();
                            }

                            TotalAmt           = db.getDb_Value("select sum(Amount) as TotalAmount from tblFeesDetails where FeesId='" + Convert.ToInt32(fessid) + "' ");
                            Shwmsg.Visible     = false;
                            BtnAddFees.Visible = false;
                        }
                        else
                        {
                            Shwmsg.Visible     = true;
                            Shwmsg.Text        = "Please Add Fees For This Class";
                            BtnAddFees.Visible = true;
                            return;
                        }
                        float reciptno = db.getDb_Value("SELECT Max(ReceiptNo)  FROM tblStudentFeesPaid where StudentId='" + UserCode.Text + "'");
                        db.insert("update tblAdmissionDetails set CourseId='" + _drpcourse + "', BranchId='" + _drpbranch + "', ClassId='" + _drpclass + "' where AdmissionID='" + addmissionId.Text + "' ");
                        db.insert("update tblStudent_Details set AcademicYearId=" + drpacedemicyear1.SelectedValue + " where AdmissionID='" + addmissionId.Text + "' ");
                        db.insert("update  [dbo].[tblStudentFeesPaid] set StudentId='" + UserCode.Text + "',FeesId='" + Convert.ToInt32(fessid) + "',TotalAmount='" + Convert.ToInt32(TotalAmt) + "',PaidAmount=0,PendingAmount='" + Convert.ToInt32(TotalAmt) + "',UserId= '" + Convert.ToInt32(Userid) + "',TransDate= '" + currentDate + "',remark= '" + FeesParticular.ToString() + "',FeesDetailsId= '" + Convert.ToInt32(FeesDetailsid) + "' where  StudentId	='" + UserCode.Text + "' and GroupReceiptNo=0 ");
                        objEWA.OrgID          = Convert.ToInt32(Session["OrgId"].ToString());
                        objEWA.student_Code   = UserCode.Text;
                        objEWA.CourseId       = ddlCourse.SelectedValue;
                        objEWA.Branch_ID      = Convert.ToInt32(Branch.Text);
                        objEWA.ClassId        = Class.Text;
                        objEWA.AcademicYearID = AcademicYear.Text;
                        objEWA.PinCode1       = Convert.ToInt32(Userid);
                        string StatusSave = objBAL.SaveStudentFeesHistrory(objEWA);
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Student Promoted Successfully ..!!');window.location='NextAcademicYearSpecial.aspx';", true);
                    }
                }

                dvBranch              = null;
                dvClass               = null;
                dvStudentData         = null;
                dvdrpBranch           = null;
                dvdrpClass            = null;
                dvdrpStudentData      = null;
                GrdStudent.DataSource = null;
                GrdStudent.DataBind();
                BindCourse();
                GetStudentData();
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('SomeThing Is Wrong..!!');window.location='NextAcademicYearSpecial.aspx';", true);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #14
0
 void MainWindow_Loaded(object sender, RoutedEventArgs e)
 {
     var errorsAdding = GrdStudent.GetValue(Validation.ErrorsProperty);
     //  var errorsUpdating = UpdStudent.GetValue(Validation.ErrorsProperty);
 }