protected void ddlTransType_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dtAvailFunds = FinancialTransactions.GetAvailableFundsPerProjAcctFundtype(Convert.ToInt32(hfProjId.Value), ddlAcctNum.SelectedItem.Text, Convert.ToInt32(ddlTransType.SelectedValue.ToString()));
if (dtAvailFunds != null)
{
if (dtAvailFunds.Rows.Count > 0)
{
lblAvDetailFund.Text = CommonHelper.myDollarFormat(dtAvailFunds.Rows[0]["availFunds"].ToString());
}
}
}
protected void btnCashRefundSubmit_Click(object sender, EventArgs e)
{
try
{
btnNewTransaction.Visible = false;
lblErrorMsg.Text = "";
if (ddlAcctNum.Items.Count > 1 && ddlAcctNum.SelectedIndex == 0)
{
lblErrorMsg.Text = "Select Account to add new transaction detail";
ddlAcctNum.Focus();
return;
}
else if (ddlTransType.Items.Count > 1 && ddlTransType.SelectedIndex == 0)
{
lblErrorMsg.Text = "Select a Transaction type";
ddlTransType.Focus();
return;
}
else if (txtAmt.Text.Trim() == "")
{
lblErrorMsg.Text = "Select a valid transaction amount";
txtAmt.Focus();
return;
}
else if (txtAmt.Text.Trim() != "")
{
decimal n;
bool isNumeric = decimal.TryParse(txtAmt.Text.Trim(), out n);
if (!isNumeric || Convert.ToDecimal(txtAmt.Text) <= 0)
{
lblErrorMsg.Text = "Select a valid transaction amount";
txtAmt.Focus();
return;
}
}
DataTable dtAvailFunds = FinancialTransactions.GetAvailableFundsPerProjAcctFundtype(Convert.ToInt32(hfProjId.Value), ddlAcctNum.SelectedItem.Text, Convert.ToInt32(ddlTransType.SelectedValue.ToString()));
if (dtAvailFunds != null)
{
if (dtAvailFunds.Rows.Count > 0)
{
if (Convert.ToDecimal(txtAmt.Text) > Convert.ToDecimal(dtAvailFunds.Rows[0]["availFunds"].ToString()))
{
lblErrorMsg.Text = "Detail amount can not be more than available funds : " + CommonHelper.myDollarFormat(dtAvailFunds.Rows[0]["availFunds"].ToString()) + " for the selected Fund";
return;
}
}
}
decimal currentTranAmount = 0;
decimal currentTranFudAmount = 0;
decimal currentBalAmount = 0;
currentTranAmount = Convert.ToDecimal(hfTransAmt.Value);
currentTranFudAmount = Convert.ToDecimal(txtAmt.Text);
currentBalAmount = Convert.ToDecimal(hfBalAmt.Value);
hfTransId.Value = GetTransId().ToString();
if (hfTransId.Value != null)
{
int transId = Convert.ToInt32(hfTransId.Value);
if (currentBalAmount == 0 && gvBCommit.Rows.Count > 0)
{
lblErrorMsg.Text = "This transaction details are all set. No more funds allowed to add for the transaction.";
ClearTransactionDetailForm();
CommonHelper.DisableButton(btnCashRefundSubmit);
return;
}
else if (currentTranFudAmount > currentBalAmount)
{
//currentTranFudAmount = currentBalAmount;
//lblErrorMsg.Text = "Amount auto adjusted to available fund amount";
lblErrorMsg.Text = "Amount entered is more than the available balance amount. Please enter available funds.";
return;
}
if (FinancialTransactions.IsDuplicateFundDetailPerTransaction(transId, Convert.ToInt32(ddlAcctNum.SelectedValue.ToString()),
Convert.ToInt32(ddlTransType.SelectedValue.ToString())))
{
lblErrorMsg.Text = "Same fund and same transaction type is already submitted for this transaction. Please select different selection";
return;
}
if (ddlAcctNum.SelectedValue.ToString() == strLandUsePermit)
{
if (ddlUsePermit.Items.Count > 1 && ddlUsePermit.SelectedIndex == 0)
{
lblErrorMsg.Text = "Select Use Permit";
ddlUsePermit.Focus();
return;
}
FinancialTransactions.AddProjectFundDetails(transId, Convert.ToInt32(ddlAcctNum.SelectedValue.ToString()),
Convert.ToInt32(ddlTransType.SelectedValue.ToString()), currentTranFudAmount, ddlUsePermit.SelectedItem.Text);
}
else
{
FinancialTransactions.AddProjectFundDetails(transId, Convert.ToInt32(ddlAcctNum.SelectedValue.ToString()),
Convert.ToInt32(ddlTransType.SelectedValue.ToString()), currentTranFudAmount);
}
BindFundDetails(transId);
ClearTransactionDetailForm();
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message;
}
}
protected void ddlFundName_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dtable = new DataTable();
if (ddlFundName.SelectedIndex != 0)
{
dtable = FinancialTransactions.GetFundDetailsByFundId(Convert.ToInt32(ddlFundName.SelectedValue.ToString()));
lblFundName.Text = dtable.Rows[0]["name"].ToString();
ddlAcctNum.SelectedValue = ddlFundName.SelectedValue;
//if (lblFundName.Text.ToLower().Contains("hopwa"))
//{
// ddlTransType.DataSource = FinancialTransactions.GetDataTableByProcName("GetLKTransHopwa");
//}
//else
//{
// ddlTransType.DataSource = FinancialTransactions.GetDataTableByProcName("GetLKTransNonHopwa");
//}
ddlTransType.DataSource = FinancialTransactions.GetAvailableTransTypesPerProjAcct(Convert.ToInt32(hfProjId.Value), ddlAcctNum.SelectedItem.Text);
ddlTransType.DataValueField = "typeid";
ddlTransType.DataTextField = "fundtype";
ddlTransType.DataBind();
if (ddlTransType.Items.Count > 1)
{
ddlTransType.Items.Insert(0, new ListItem("Select", "NA"));
}
else
{
DataTable dtAvailFunds = FinancialTransactions.GetAvailableFundsPerProjAcctFundtype(Convert.ToInt32(hfProjId.Value), ddlAcctNum.SelectedItem.Text, Convert.ToInt32(ddlTransType.SelectedValue.ToString()));
if (dtAvailFunds != null)
{
if (dtAvailFunds.Rows.Count > 0)
{
lblAvDetailFund.Text = CommonHelper.myDollarFormat(dtAvailFunds.Rows[0]["availFunds"].ToString());
}
}
}
BindUsePermit(hfProjId.Value != "" ? Convert.ToInt32(hfProjId.Value) : 0);
if (ddlFundName.SelectedValue.ToString() == strLandUsePermit)
{
lblUsePermit.Visible = true;
ddlUsePermit.Visible = true;
}
else
{
lblUsePermit.Visible = false;
ddlUsePermit.Visible = false;
}
}
else
{
ddlTransType.Items.Clear();
ddlTransType.Items.Insert(0, new ListItem("Select", "NA"));
lblFundName.Text = "";
txtAmt.Text = "";
//ClearDetailSelection();
}
}