protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LoadDDLs(); if (CurrentStudentActive != 0) { //BindData(); DBLayer db = new DBLayer(); DataSet ds = new DataSet(); ds = db.GetFeesByStudentIDAndSchoolYear(CurrentStudentActive,Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); if (ds.Tables[0].Rows.Count > 0) { uiTextBoxRemainingFees.Text = ds.Tables[0].Rows[0]["RemainingFeesLastYear"].ToString(); uiTextBoxBooksFees.Text = ds.Tables[0].Rows[0]["BooksFees"].ToString(); uiTextBoxBusFees.Text = ds.Tables[0].Rows[0]["BusFees"].ToString(); uiTextBoxUniformFees.Text = ds.Tables[0].Rows[0]["UniformFees"].ToString(); uiTextBoxActFees.Text = ds.Tables[0].Rows[0]["ActivitiesFees"].ToString(); uiTextBoxOtherFees.Text = ds.Tables[0].Rows[0]["OtherFees"].ToString(); } uiPanelCurrentFees.Visible = false; uiPanelCurrent.Visible = true; } else { uiPanelCurrentFees.Visible = true; uiPanelCurrent.Visible = false; BindStudentsData(); } } }
private void BindData() { DBLayer db = new DBLayer(); DataSet Installments = new DataSet(); DataSet Fees = new DataSet(); Fees = db.GetFeesByStudentIDAndSchoolYear(Convert.ToInt32(Session["CurrentLoggedInStudent"].ToString()), Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); Installments = db.GetInstallmentsByStudentIDAndSchoolYearID(Convert.ToInt32(Session["CurrentLoggedInStudent"].ToString()), Convert.ToInt32(uiDropDownListSchoolYear.SelectedValue)); uiGridViewInstallments.DataSource = Installments; uiGridViewInstallments.DataBind(); float totalpaied = 0; float TotalFees = 0; float RemainingYearLastYear = 0; float BooksFees = 0; float BusFees = 0; float UniformFees = 0; float OtherFees = 0; float ActivitiesFees = 0; for (int i = 0; i < Installments.Tables[0].Rows.Count; i++) { totalpaied += float.Parse(Installments.Tables[0].Rows[i]["Quantity"].ToString()); } for (int i = 0; i < Fees.Tables[0].Rows.Count; i++) { RemainingYearLastYear += float.Parse(Fees.Tables[0].Rows[i]["RemainingFeesLastYear"].ToString()); BooksFees += float.Parse(Fees.Tables[0].Rows[i]["BooksFees"].ToString()); BusFees += float.Parse(Fees.Tables[0].Rows[i]["BusFees"].ToString()); UniformFees += float.Parse(Fees.Tables[0].Rows[i]["UniformFees"].ToString()); OtherFees += float.Parse(Fees.Tables[0].Rows[i]["OtherFees"].ToString()); ActivitiesFees += float.Parse(Fees.Tables[0].Rows[i]["ActivitiesFees"].ToString()); } TotalFees = RemainingYearLastYear + BooksFees + BusFees + UniformFees + OtherFees + ActivitiesFees; uiLabelRemaining.Text = RemainingYearLastYear.ToString(); uiLabelBooks.Text = BooksFees.ToString(); uiLabelBus.Text = BusFees.ToString(); uiLabelUniform.Text = UniformFees.ToString(); uiLabelOther.Text = OtherFees.ToString(); uiLabelAct.Text = ActivitiesFees.ToString(); uiLabelTotal.Text = TotalFees.ToString(); uiLabelTotalPaid.Text = totalpaied.ToString(); uiLabelInvoiceTotal.Text = (TotalFees - totalpaied).ToString(); }