protected void hdnValue_ValueChanged(object sender, EventArgs e)
{
string projNum = ((HiddenField)sender).Value;
DataTable dt = new DataTable();
dt = Project.GetProjects("GetProjectIdByProjNum", projNum.ToString());
///populate the form based on retrieved data
if (dt.Rows.Count > 0)
{
lblProjNameText.Visible = true;
if (txtFromCommitedProjNum.Text.ToLower() == "all")
{
lblProjName.Text = "All";
}
else
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(dt.Rows[0][0].ToString()));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
hfProjId.Value = dt.Rows[0][0].ToString();
}
}
else
{
lblProjNameText.Visible = false;
lblProjName.Text = "";
}
}
protected void ddlProjFilter_SelectedIndexChanged(object sender, EventArgs e)
{
lblErrorMsg.Text = "";
gvTransactions.DataSource = null;
gvTransactions.DataBind();
pnlTranDetails.Visible = false;
if (ddlProjFilter.SelectedIndex != 0)
{
int ProjectNo = Convert.ToInt32(ddlProjFilter.SelectedValue.ToString());
lblProjNameText.Visible = true;
if (ProjectNo == -1)
{
lblProjName.Text = "All";
}
else
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(ProjectNo);
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
}
}
else
{
lblProjNameText.Visible = false;
lblProjName.Text = "";
}
}
protected void ddlProjFilter_SelectedIndexChanged(object sender, EventArgs e)
{
pnlTranDetails.Visible = false;
lblErrorMsg.Text = "";
gvPTrans.DataSource = null;
gvPTrans.DataBind();
ddlGrantee.Items.Clear();
ddlGrantee.Items.Insert(0, new ListItem("Select", "NA"));
ClearTransactionDetailForm();
if (ddlProjFilter.SelectedIndex != 0)
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()));
lblProjNameText.Visible = true;
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
BindGranteeByProject(); //Bind Grantee Drop Down
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
BindFundAccounts();
}
else
{
lblProjNameText.Visible = false;
lblProjName.Text = "";
}
}
private void getDetails(DataTable dt)
{
try
{
if (dt.Rows.Count != 0)
{
hfProjId.Value = dt.Rows[0][0].ToString();
pnlTranDetails.Visible = false;
lblErrorMsg.Text = "";
gvPTrans.DataSource = null;
gvPTrans.DataBind();
ClearTransactionDetailForm();
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(hfProjId.Value));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
dt = new DataTable();
dt = FinancialTransactions.GetGranteeByProject(Convert.ToInt32(hfProjId.Value));
if (dt.Rows.Count > 0)
{
lblGrantee.Text = dt.Rows[0]["Applicantname"].ToString();
hfGrantee.Value = dt.Rows[0]["applicantid"].ToString();
}
else
{
lblGrantee.Text = "";
hfGrantee.Value = "";
}
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
BindFundAccounts();
ifProjectNotes.Src = "ProjectNotes.aspx?ProjectId=" + hfProjId.Value;
if (rdBtnSelection.SelectedIndex == 1)
{
DataTable dtTrans = FinancialTransactions.GetFinancialTransByProjId(Convert.ToInt32(hfProjId.Value), ActiveOnly, BOARD_COMMITMENT);
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
CommonHelper.DisableButton(btnTransactionSubmit);
}
else if (rdBtnSelection.SelectedIndex == 0)
{
CommonHelper.EnableButton(btnTransactionSubmit);
}
}
else
{
lblProjName.Text = "";
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
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 ddlProjFilter_SelectedIndexChanged(object sender, EventArgs e)
{
pnlTranDetails.Visible = false;
lblErrorMsg.Text = "";
gvPTrans.DataSource = null;
gvPTrans.DataBind();
ddlGrantee.Items.Clear();
ddlGrantee.Items.Insert(0, new ListItem("Select", "NA"));
ClearTransactionDetailForm();
if (ddlProjFilter.SelectedIndex != 0)
{
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(ddlProjFilter.SelectedValue.ToString()));
lblProjNameText.Visible = true;
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
BindGranteeByProject(); //Bind Grantee Drop Down
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
BindFundAccounts();
ifProjectNotes.Src = "ProjectNotes.aspx?ProjectId=" + ddlProjFilter.SelectedValue.ToString();
if (rdBtnSelection.SelectedIndex == 1)
{
DataTable dtTrans = FinancialTransactions.GetFinancialTransByProjId(Convert.ToInt32(ddlProjFilter.SelectedValue), ActiveOnly, BOARD_COMMITMENT);
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
CommonHelper.DisableButton(btnTransactionSubmit);
}
else if (rdBtnSelection.SelectedIndex == 0)
{
CommonHelper.EnableButton(btnTransactionSubmit);
}
}
else
{
lblProjNameText.Visible = false;
lblProjName.Text = "";
}
}
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);
}
private void getDetails(DataTable dt)
{
try
{
lblAvailFund.Text = "";
lblAvailVisibleFund.Text = "";
if (dt.Rows.Count != 0)
{
hfProjId.Value = dt.Rows[0][0].ToString();
DataRow dr = ProjectCheckRequestData.GetAvailableFundsByProject(int.Parse(hfProjId.Value));
if (dr != null)
{
if (Convert.ToDecimal(dr["availFund"].ToString()) > 0)
{
lblAvailFund.Text = Convert.ToDecimal(dr["availFund"].ToString()).ToString("#.##");
lblAvailVisibleFund.Text = CommonHelper.myDollarFormat(Convert.ToDecimal(dr["availFund"].ToString()));
//.ToString("#.##");
}
else
{
lblAvailFund.Text = "0.00";
lblAvailVisibleFund.Text = "0.00";
}
}
pnlTranDetails.Visible = false;
lblErrorMsg.Text = "";
gvPTrans.DataSource = null;
gvPTrans.DataBind();
ClearTransactionDetailForm();
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(hfProjId.Value));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
dt = new DataTable();
dt = FinancialTransactions.GetGranteeByProject(Convert.ToInt32(hfProjId.Value));
if (dt.Rows.Count > 0)
{
lblGrantee.Text = dt.Rows[0]["Applicantname"].ToString();
hfGrantee.Value = dt.Rows[0]["applicantid"].ToString();
}
else
{
lblGrantee.Text = "";
hfGrantee.Value = "";
}
txtTransDate.Text = DateTime.Now.ToShortDateString();
txtTotAmt.Text = "";
BindFundAccounts();
ifProjectNotes.Src = "ProjectNotes.aspx?ProjectId=" + hfProjId.Value;
if (rdBtnSelection.SelectedIndex == 1)
{
DataTable dtTrans = FinancialTransactions.GetFinancialTransByProjId(Convert.ToInt32(hfProjId.Value), ActiveOnly, BOARD_REFUND);
gvPTrans.DataSource = dtTrans;
gvPTrans.DataBind();
CommonHelper.DisableButton(btnTransactionSubmit);
}
else if (rdBtnSelection.SelectedIndex == 0)
{
CommonHelper.EnableButton(btnTransactionSubmit);
}
}
else
{
lblProjName.Text = "";
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
protected void btnSubit_click(object sender, EventArgs e)
{
DateTime tranFromDate;
DateTime tranToDate;
#region Validation
//if (ddlProjFilter.Items.Count > 1 && ddlProjFilter.SelectedIndex == 0)
//{
// lblErrorMsg.Text = "Select Project";
// ddlProjFilter.Focus();
// return;
//}
// else
if (ddlFinancialTrans.Items.Count > 1 && ddlFinancialTrans.SelectedIndex == 0)
{
lblErrorMsg.Text = "Select financial transaction";
ddlFinancialTrans.Focus();
return;
}
else if (txtTransDateFrom.Text.Trim() == "")
{
lblErrorMsg.Text = "Select Transaction From Date";
txtTransDateFrom.Focus();
return;
}
else if (txtTransDateTo.Text.Trim() == "")
{
lblErrorMsg.Text = "Select Transaction End Date";
txtTransDateTo.Focus();
return;
}
else
{
if (!DateTime.TryParse(txtTransDateFrom.Text.Trim(), out tranFromDate))
{
lblErrorMsg.Text = "Select valid transaction From date";
txtTransDateFrom.Focus();
return;
}
if (!DateTime.TryParse(txtTransDateTo.Text.Trim(), out tranToDate))
{
lblErrorMsg.Text = "Select valid transaction To date";
txtTransDateTo.Focus();
return;
}
if (tranFromDate > DateTime.Today)
{
lblErrorMsg.Text = "From Transaction date should be less than or equal to today";
txtTransDateFrom.Focus();
return;
}
if (tranToDate > DateTime.Today)
{
lblErrorMsg.Text = "Transaction End date should be less than or equal to today";
txtTransDateTo.Focus();
return;
}
if (tranFromDate > tranToDate)
{
lblErrorMsg.Text = "From Transaction date should be less than End date";
txtTransDateFrom.Focus();
return;
}
}
#endregion
ViewState["FromDate"] = tranFromDate;
ViewState["EndDate"] = tranToDate;
lblProjNameText.Visible = true;
lblProjName.Text = "";
if (hfProjId.Value != "")
{
PopulateTransactions(Convert.ToInt32(hfProjId.Value), tranFromDate, tranToDate, Convert.ToInt32(ddlFinancialTrans.SelectedValue.ToString()));
DataTable dtProjects = FinancialTransactions.GetBoardCommitmentsByProject(Convert.ToInt32(hfProjId.Value));
lblProjName.Text = dtProjects.Rows[0]["Description"].ToString();
}
else
{
lblProjName.Text = "All";
PopulateTransactions(-1, tranFromDate, tranToDate, Convert.ToInt32(ddlFinancialTrans.SelectedValue.ToString()));
}
}