private void BindSelectedProjects()
{
try
{
if (ddlProjFilter.SelectedIndex != 0)
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
//txtGrantee.Text = dtProjects.Rows[0]["Applicantname"].ToString();
BindGranteeByProject();
DataTable dtTrans = FinancialTransactions.GetBoardCommitmentTrans(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()), "Board Decommitment");
if (dtTrans.Rows.Count > 0)
{
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
txtTransDate.Text = Convert.ToDateTime(dtTrans.Rows[0]["Date"].ToString()).ToShortDateString();
txtTotAmt.Text = dtTrans.Rows[0]["TransAmt"].ToString();
ddlStatus.SelectedValue = dtTrans.Rows[0]["lkStatus"].ToString();
if (dtTrans.Rows.Count == 1)
{
BindFundDetails(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()));
}
else
{
gvBCommit.DataSource = null;
gvBCommit.DataBind();
}
}
else
{
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
ddlStatus.SelectedIndex = 1;
gvPTrans.DataSource = null;
gvPTrans.DataBind();
gvBCommit.DataSource = null;
gvBCommit.DataBind();
}
}
else
{
lblErrorMsg.Text = "Select a project to proceed";
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
protected void gvPTrans_Sorting(object sender, GridViewSortEventArgs e)
{
SortExpression = e.SortExpression;
DataTable dtTrans = new DataTable();
if (ddlProjFilter.SelectedIndex != 0)
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
// txtGrantee.Text = dtProjects.Rows[0]["Applicantname"].ToString();
BindGranteeByProject();
dtTrans = FinancialTransactions.GetBoardCommitmentTrans(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()), "Board Decommitment");
if (dtTrans.Rows.Count > 0)
{
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
}
}
SortDireaction = CommonHelper.GridSorting(gvBCommit, dtTrans, SortExpression, SortDireaction);
}