protected void StudentData()
        {
            bindvariable();
            EWA_PayFees objEWA = new EWA_PayFees();
            BL_PayFees  objBL  = new BL_PayFees();

            lblStudentCode.Text  = txtStudentNameId.Text;
            objEWA.StudentCode   = studentId;
            objEWA.CourseId      = CourseId;
            objEWA.ClassId       = ClassId;
            objEWA.BranchId      = BranchId;
            objEWA.AcadmicYearId = Convert.ToInt32(AcademicId);
            DataSet DsFeesPaidData = objBL.GetDataStudent(objEWA);

            if (DsFeesPaidData.Tables.Count >= 0)
            {
                if (DsFeesPaidData.Tables[0].Rows.Count != 0)
                {
                    lblStudentNameevalue.Text = DsFeesPaidData.Tables[0].Rows[0]["StudentName"].ToString();
                    lblTotalAmountvalue.Text  = DsFeesPaidData.Tables[0].Rows[0]["TotalAmount"].ToString();
                    lblPaidAmountValue.Text   = DsFeesPaidData.Tables[0].Rows[0]["PaidAmount"].ToString();
                    decimal TotalAmt = Convert.ToDecimal(lblTotalAmountvalue.Text);
                    decimal paidAmt  = Convert.ToDecimal(lblPaidAmountValue.Text);
                    LblPendingAmtvalue.Text = (TotalAmt - paidAmt).ToString();
                }
            }
        }
        private void BindFeesPaidDetailsGrid()
        {
            try
            {
                EWA_PayFees objEWA   = new EWA_PayFees();
                BL_PayFees  objBL    = new BL_PayFees();
                string      strValue = txtStudentId.Text;
                txtStudentId.Text = strValue;


                objEWA.StudentCode = strValue;

                DataSet ds = objBL.BindStudentFeesPaidDetails_BL(objEWA);
                if (ds.Tables[0].Rows.Count == 0 || ds == null)
                {
                    ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
                    grdFees.DataSource = ds;
                    grdFees.DataBind();
                    int columncount = grdFees.Rows[0].Cells.Count;
                    grdFees.Rows[0].Cells.Clear();
                    grdFees.Rows[0].Cells.Add(new TableCell());
                    grdFees.Rows[0].Cells[0].ColumnSpan = columncount;
                    grdFees.Rows[0].Cells[0].Text       = "No Records Found";
                }
                else
                {
                    grdFees.DataSource = ds;
                    grdFees.DataBind();
                }
            }
            catch (Exception exp)
            {
            }
        }
        //StudentFeesPaidDetails
        #region [Fee Paid Details]

        private void BindFeesPaidDetailsGrid()
        {
            try
            {
                EWA_PayFees objEWA = new EWA_PayFees();
                BL_PayFees  objBL  = new BL_PayFees();

                objEWA.StudentCode = Session["UserCode"].ToString();

                DataSet ds = objBL.BindStudentFeesPaidDetails_BL(objEWA);
                if (ds.Tables[0].Rows.Count == 0 || ds == null)
                {
                    ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
                    GrdFeesPaidDetails.DataSource = ds;
                    GrdFeesPaidDetails.DataBind();
                    int columncount = GrdFeesPaidDetails.Rows[0].Cells.Count;
                    GrdFeesPaidDetails.Rows[0].Cells.Clear();
                    GrdFeesPaidDetails.Rows[0].Cells.Add(new TableCell());
                    GrdFeesPaidDetails.Rows[0].Cells[0].ColumnSpan = columncount;
                    GrdFeesPaidDetails.Rows[0].Cells[0].Text       = "No Records Found";
                }
                else
                {
                    DataView dv = ds.Tables[0].DefaultView;
                    dv.Sort = "ReceiptNo desc";
                    GrdFeesPaidDetails.DataSource = dv;
                    GrdFeesPaidDetails.DataBind();
                }
            }
            catch (Exception exp)
            {
                GeneralErr(exp.Message.ToString());
            }
        }
Ejemplo n.º 4
0
        // Bind Grid of StudentData_DL
        #region [Bind Student Data Region]
        public DataSet BindStudentData_DL(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[8];
                prmList[0] = "@Action";
                prmList[1] = "FetchStudentToPayFees";
                prmList[2] = "@AdmissionId";
                prmList[3] = objEWA.AdmissionId;
                prmList[4] = "@OrgId";
                prmList[5] = Convert.ToString(objEWA.OrgId);
                prmList[6] = "@AcademicId";
                prmList[7] = objEWA.AcadmicYearId.ToString();


                //prmList[7] = HttpContext.Current.Session["AcademicYearId"].ToString();

                ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Ejemplo n.º 5
0
        public DataSet BindGetstudentData(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "FetchStudentData";
                prmList[2]  = "@UserCode";
                prmList[3]  = objEWA.StudentCode;
                prmList[4]  = "@CourseId";
                prmList[5]  = objEWA.CourseId;
                prmList[6]  = "@BranchId";
                prmList[7]  = objEWA.BranchId;
                prmList[8]  = "@ClassId";
                prmList[9]  = objEWA.ClassId;
                prmList[10] = "@AcademicId";
                prmList[11] = objEWA.AcadmicYearId.ToString();
                //
                ds = ObjHelper.FillControl(prmList, "SP_GetPreviousYearFeesData");
                return(ds);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 6
0
        // Bind Grid of StudentFeesInstallmentToPay_DL
        #region [Bind Student Data Region]
        public DataSet BindStudentFeesPending_DL(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                //Commented By Ashwini 6-oct-2020
                //    prmList = new string[4];
                //    prmList[0] = "@Action";
                //    prmList[1] = "PayPendingFees";
                //    prmList[2] = "@UserCode";
                //    prmList[3] = objEWA.StudentCode;

                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "PayPendingFees";
                prmList[2]  = "@UserCode";
                prmList[3]  = objEWA.StudentCode;
                prmList[4]  = "@CourseId";
                prmList[5]  = objEWA.CourseId;
                prmList[6]  = "@ClassId";
                prmList[7]  = objEWA.ClassId;
                prmList[8]  = "@BranchId";
                prmList[9]  = objEWA.BranchId;
                prmList[10] = "@AcademicId";
                prmList[11] = objEWA.AcadmicYearId.ToString();
                ds          = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 7
0
        // To Pay Fees Installments
        #region [ Pay Fees Installments]
        public int PayFeesInstallmentsAction_DL(EWA_PayFees objEWA, DataTable dtFees, DataTable dtFees_Bus)
        {
            try
            {
                //Save PayFeesInstallments data in StudentFeesPaid Table
                cmd             = new SqlCommand("SP_PayFees", con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@Action", objEWA.Action);
                cmd.Parameters.AddWithValue("@UserCode", objEWA.StudentCode);
                cmd.Parameters.AddWithValue("@FeesId", objEWA.FeesId);
                cmd.Parameters.AddWithValue("@FeesDetailsId", objEWA.FeesDetailsId);
                cmd.Parameters.AddWithValue("@TotalAmount", objEWA.TotalAmount);
                cmd.Parameters.AddWithValue("@PaidAmount", objEWA.TotalPaidAmount);
                cmd.Parameters.AddWithValue("@PendingAmount", objEWA.TotalPendingAmount);
                cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
                cmd.Parameters.AddWithValue("@Paymentmode", objEWA.Paymentmode);
                cmd.Parameters.AddWithValue("@remark", objEWA.remark);
                cmd.Parameters.AddWithValue("@TransDate", objEWA.TransactionDate);
                cmd.Parameters.AddWithValue("@StudentFeesPaid", dtFees);
                cmd.Parameters.AddWithValue("@StudentBusFeesPaid", dtFees_Bus);


                con.Open();
                var flag = cmd.ExecuteScalar();
                con.Close();
                return(Convert.ToInt32(flag));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 8
0
        //Bind Grid of StudentFeesPendingDetails_BL to Pay
        #region [Student Fees Pending Details]

        public DataSet BindStudentFeesPendingDetails_BL(EWA_PayFees objEWA)
        {
            try
            {
                DL_PayFees objDL = new DL_PayFees();
                DataSet    ds    = objDL.BindStudentFeesPending_DL(objEWA);
                return(ds);
            }
            catch (Exception)
            {
                throw;
            }
        }
Ejemplo n.º 9
0
 public DataSet GetDataStudent(EWA_PayFees objEWA)
 {
     try
     {
         DL_PayFees objDL = new DL_PayFees();
         DataSet    ds    = objDL.BindGetstudentData(objEWA);
         return(ds);
     }
     catch (Exception)
     {
         throw;
     }
 }
Ejemplo n.º 10
0
 public DataSet GetDataStudentFeesPaid(EWA_PayFees objEWA)
 {
     try
     {
         DL_PayFees objDL = new DL_PayFees();
         DataSet    ds    = objDL.BindPreviousFeeRecord(objEWA);
         return(ds);
     }
     catch (Exception)
     {
         throw;
     }
 }
Ejemplo n.º 11
0
        //Bind Grid of StudentData_BL to confirm Admission
        #region [Bind Student Data Region]

        public DataSet BindStudentData_BL(EWA_PayFees objEWA)
        {
            try
            {
                DL_PayFees objDL = new DL_PayFees();
                DataSet    ds    = objDL.BindStudentData_DL(objEWA);
                return(ds);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Ejemplo n.º 12
0
        //To Pay Fees Installments
        // Save Student Registration
        #region [Save Student]

        public int PayFeesInstallmentsAction_BL(EWA_PayFees objEWA, DataTable dtFees, DataTable dtFees_Bus)
        {
            try
            {
                DL_PayFees objDL = new DL_PayFees();
                int        flag  = objDL.PayFeesInstallmentsAction_DL(objEWA, dtFees, dtFees_Bus);
                return(flag);
            }
            catch (Exception)
            {
                throw;
            }
        }
Ejemplo n.º 13
0
        private void GetReportData()
        {
            crFeesReceipt crt      = new crFeesReceipt();
            EWA_PayFees   objEWA   = new EWA_PayFees();
            DL_PayFees    objDL    = new DL_PayFees();
            String        StudCode = Session["StudentReceiptCode"].ToString();

            objEWA.StudentCode = StudCode;
            DataSet ds = objDL.BindPaidReceiptReport(objEWA);

            crt.SetDataSource(ds.Tables[0]);
            crvPrintfeesReceipt.ReportSource = crt;
            crvPrintfeesReceipt.RefreshReport();
            Session.Add("CR_Session", crt);  //Add Report into Session CR_Session
        }
Ejemplo n.º 14
0
        // Bind Grid of StudentFeesPaidDetails_DL
        #region [Bind Student Data Region]
        public DataSet BindStudentFeesPaidDetails_DL(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                //    //    //Commnented by Ashwini More 5 - Oct - 2020
                //    prmList = new string[4];
                //    prmList[0] = "@Action";
                //    prmList[1] = "FetchStudFeesPaidDetails";
                //    prmList[2] = "@UserCode";
                //    prmList[3] = objEWA.StudentCode;
                //    ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                //    return ds;
                //}
                //catch (Exception ex)
                //{
                //    throw ex;
                //}
                //  Added by Ashwini 5 - Oct - 2020
                prmList     = new string[12];
                prmList[0]  = "@Action";
                prmList[1]  = "FetchStudFeesPaidDetails";
                prmList[2]  = "@UserCode";
                prmList[3]  = objEWA.StudentCode;
                prmList[4]  = "@CourseId";
                prmList[5]  = objEWA.CourseId;
                prmList[6]  = "@BranchId";
                prmList[7]  = objEWA.BranchId;
                prmList[8]  = "@ClassId";
                prmList[9]  = objEWA.ClassId;
                prmList[10] = "@AcademicId";
                prmList[11] = objEWA.AcadmicYearId.ToString();
                //
                ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 15
0
        // Bind Paid Receipt Report
        #region [Paid Receipt Report]
        public DataSet BindPaidReceiptReport(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[4];
                prmList[0] = "@Action";
                prmList[1] = "PrintReceipt";
                prmList[2] = "@UserCode";
                prmList[3] = objEWA.StudentCode;

                ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 16
0
        // Bind Grid of StudentData_DL To Pay Fees Installment
        #region [Bind Student Details Region]
        public DataSet BindStudentDetails_DL(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "FetchStudToPayInstallment";
                prmList[2] = "@UserCode";
                prmList[3] = objEWA.StudentCode;
                prmList[4] = "@OrgId";
                prmList[5] = Convert.ToString(objEWA.OrgId);

                ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception)
            {
                throw;
            }
        }
        protected void GetPaidPreviousFee()
        {
            EWA_PayFees objEWA = new EWA_PayFees();
            BL_PayFees  objBL  = new BL_PayFees();

            bindvariable();
            lblStudentCode.Text  = txtStudentNameId.Text;
            objEWA.StudentCode   = studentId;
            objEWA.CourseId      = CourseId;
            objEWA.ClassId       = ClassId;
            objEWA.BranchId      = BranchId;
            objEWA.AcadmicYearId = Convert.ToInt32(AcademicId);
            DataSet DsFeesPaidData = objBL.GetDataStudentFeesPaid(objEWA);

            if (DsFeesPaidData.Tables.Count >= 0)
            {
                if (DsFeesPaidData.Tables[0].Rows.Count != 0)
                {
                    GrdFeesPaidDetails.DataSource = DsFeesPaidData.Tables[0];
                    GrdFeesPaidDetails.DataBind();
                }
            }
        }
Ejemplo n.º 18
0
        // Bind Grid of StudentFeesDetails_DL
        #region [Bind Student Data Region]
        public DataSet BindStudentFeesDetails_DL(EWA_PayFees objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[8];
                prmList[0] = "@Action";
                prmList[1] = "FetchStudentFeesDetails";
                prmList[2] = "@FeesId";
                prmList[3] = objEWA.FeesId;
                prmList[4] = "@AdmissionId";
                prmList[5] = objEWA.AdmissionId;
                prmList[6] = "@AcademicId";
                prmList[7] = objEWA.AcadmicYearId.ToString();

                ds = ObjHelper.FillControl(prmList, "SP_PayFees");
                return(ds);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }