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()); } }
// 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; } }
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; } }
// 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; } }
// 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; } }
//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; } }
public DataSet GetDataStudent(EWA_PayFees objEWA) { try { DL_PayFees objDL = new DL_PayFees(); DataSet ds = objDL.BindGetstudentData(objEWA); return(ds); } catch (Exception) { throw; } }
public DataSet GetDataStudentFeesPaid(EWA_PayFees objEWA) { try { DL_PayFees objDL = new DL_PayFees(); DataSet ds = objDL.BindPreviousFeeRecord(objEWA); return(ds); } catch (Exception) { throw; } }
//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; } }
//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; } }
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 }
// 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; } }
// 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; } }
// 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(); } } }
// 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; } }