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(); } }