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;
}
}
