protected void btnSearch_Click(object sender, EventArgs e)
{
LoadFeesHead();
txtTotalAmt.Text = "0.00";
BusinessLayer.Accounts.StudentOpeningBal objOpeningBal = new BusinessLayer.Accounts.StudentOpeningBal();
Entity.Accounts.StudentOpeningBal OpBal = new Entity.Accounts.StudentOpeningBal();
OpBal.StudentId = int.Parse(ddlMember.SelectedValue);
DataSet ds = new DataSet();
ds = objOpeningBal.StudentOpeningBalance_GetById(OpBal);
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
decimal dramt = Convert.ToDecimal(ds.Tables[0].Rows[0]["AmountDr"].ToString());
decimal cramt = Convert.ToDecimal(ds.Tables[0].Rows[0]["AmountCr"].ToString());
txtTotalAmt.Text = (dramt > cramt) ? Convert.ToString(dramt) : Convert.ToString((cramt * -1));
}
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
foreach (GridViewRow gvr in dgvFeesHead.Rows)
{
TextBox txtAmount = (TextBox)gvr.FindControl("txtAmount");
DropDownList ddlDrCr = (DropDownList)gvr.FindControl("ddlDrCr");
int FeesHeadId = int.Parse(dgvFeesHead.DataKeys[gvr.RowIndex].Values[0].ToString());
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (FeesHeadId == int.Parse(dr["FeesHeadId"].ToString()))
{
decimal AmtDr = Convert.ToDecimal(dr["AmountDr"].ToString());
decimal AmtCr = Convert.ToDecimal(dr["AmountCr"].ToString());
txtAmount.Text = (AmtDr > AmtCr) ? Convert.ToString(AmtDr) : Convert.ToString(AmtCr);
ddlDrCr.SelectedValue = (AmtDr > AmtCr) ? "DR" : "CR";
}
}
}
ViewState["BillId"] = ds.Tables[0].Rows[0]["BillId"].ToString();
btnSave.Text = "Update";
}
}
