protected void gvGovtSaving_ItemCommand(object source, GridCommandEventArgs e) { if (e.CommandName == RadGrid.UpdateCommandName) { bool isUpdated = false; string relationCode = string.Empty; GridEditableItem gridEditableItem = (GridEditableItem)e.Item; e.Canceled = true; //gridEditableItem.OwnerTableView.IsItemInserted = false; GovtSavingNPId = int.Parse(gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CGSNP_GovtSavingNPId"].ToString()); Button btnGovtSubmit = (Button)e.Item.FindControl("btnGovtSubmit"); DropDownList ddlDebtIssuerCode = (DropDownList)e.Item.FindControl("ddlDebtIssuerCode"); TextBox txtCurrentValue = (TextBox)e.Item.FindControl("txtCurrentValue"); TextBox txtDepositDate = (TextBox)e.Item.FindControl("txtDepositDate"); TextBox txtMaturityValue = (TextBox)e.Item.FindControl("txtMaturityValue"); TextBox txtMaturityDate = (TextBox)e.Item.FindControl("txtMaturityDate"); TextBox txtDepositAmount = (TextBox)e.Item.FindControl("txtDepositAmount"); TextBox txtInterstRate = (TextBox)e.Item.FindControl("txtInterstRate"); DropDownList ddlInterestBasis = (DropDownList)e.Item.FindControl("ddlInterestBasis"); DropDownList ddlSimpleInterestFC = (DropDownList)e.Item.FindControl("ddlSimpleInterestFC"); DropDownList ddlCompoundInterestFC = (DropDownList)e.Item.FindControl("ddlCompoundInterestFC"); TextBox txtInterestAmtCredited = (TextBox)e.Item.FindControl("txtInterestAmtCredited"); TextBox txtAssetParticulars = (TextBox)e.Item.FindControl("txtAssetParticulars"); RadioButton rbtnAccumulated = (RadioButton)e.Item.FindControl("rbtnAccumulated"); TextBox txtSubsqntDepositAmount = (TextBox)e.Item.FindControl("txtSubsqntDepositAmount"); TextBox txtSubsqntDepositDate = (TextBox)e.Item.FindControl("txtSubsqntDepositDate"); DropDownList ddlDepositFrequency = (DropDownList)e.Item.FindControl("ddlDepositFrequency"); TextBox txtRemarks = (TextBox)e.Item.FindControl("txtRemarks"); TextBox txtAccOpenDate = (TextBox)e.Item.FindControl("txtAccOpenDate"); TextBox txtAccountWith = (TextBox)e.Item.FindControl("txtAccountWith"); TextBox txtAccountNumber = (TextBox)e.Item.FindControl("txtAccountNumber"); Button btnAcctInsert = (Button)e.Item.FindControl("btnAcctInsert"); CustomerAccountsVo newAccountVo = new CustomerAccountsVo(); if (btnGovtSubmit.Visible == true) { customerAccountsVo = (CustomerAccountsVo)Session["customerAccountVo"]; Session["govtSavingsVo"] = govtSavingsBo.GetGovtSavingsDetails(GovtSavingNPId); govtSavingsVo = (GovtSavingsVo)Session["govtSavingsVo"]; govtSavingsVo.PortfolioId = govtSavingsVo.GoveSavingsPortfolioId; if (ddlDebtIssuerCode != null && ddlDebtIssuerCode.SelectedItem.Value != string.Empty) { govtSavingsVo.DebtIssuerCode = ddlDebtIssuerCode.SelectedItem.Value.ToString(); } govtSavingsVo.Name = txtAssetParticulars.Text; if (txtCurrentValue != null && txtCurrentValue.Text != "") { govtSavingsVo.CurrentValue = float.Parse(txtCurrentValue.Text); } if (txtDepositDate != null && txtDepositDate.Text != "") { govtSavingsVo.PurchaseDate = DateTime.Parse(txtDepositDate.Text.ToString()); } if (txtMaturityValue != null && txtMaturityValue.Text != "") { govtSavingsVo.MaturityValue = float.Parse(txtMaturityValue.Text); } if (txtMaturityDate != null && txtMaturityDate.Text != "") { govtSavingsVo.MaturityDate = DateTime.Parse(txtMaturityDate.Text.ToString()); } if (txtDepositAmount != null && txtDepositAmount.Text != "") { govtSavingsVo.DepositAmt = float.Parse(txtDepositAmount.Text); } if (txtInterstRate != null && txtInterstRate.Text != "") { govtSavingsVo.InterestRate = float.Parse(txtInterstRate.Text); } if (ddlInterestBasis != null) { govtSavingsVo.InterestBasisCode = ddlInterestBasis.SelectedItem.Value.ToString(); } if (govtSavingsVo.InterestBasisCode == "SI") { govtSavingsVo.InterestPayableFrequencyCode = ddlSimpleInterestFC.SelectedItem.Value.ToString(); govtSavingsVo.CompoundInterestFrequencyCode = "NA"; } else if (govtSavingsVo.InterestBasisCode == "CI") { govtSavingsVo.InterestPayableFrequencyCode = "NA"; govtSavingsVo.CompoundInterestFrequencyCode = ddlCompoundInterestFC.SelectedItem.Value.ToString(); } else { govtSavingsVo.InterestBasisCode = null; } if (rbtnAccumulated.Checked) { govtSavingsVo.IsInterestAccumalated = 1; if (txtInterestAmtCredited != null && txtInterestAmtCredited.Text != string.Empty) { govtSavingsVo.InterestAmtAccumalated = float.Parse(txtInterestAmtCredited.Text); } govtSavingsVo.InterestAmtPaidOut = 0; } else { govtSavingsVo.IsInterestAccumalated = 0; if (txtInterestAmtCredited != null && txtInterestAmtCredited.Text != string.Empty) { govtSavingsVo.InterestAmtPaidOut = float.Parse(txtInterestAmtCredited.Text); } govtSavingsVo.InterestAmtAccumalated = 0; } //Post Office Recurring Deposit Account- Subsequent deposit details if (govtSavingsVo.AssetInstrumentCategoryCode != null && govtSavingsVo.AssetInstrumentCategoryCode.ToString().Trim() == "GSRD") { if (txtSubsqntDepositAmount != null && txtSubsqntDepositAmount.Text != string.Empty) { govtSavingsVo.SubsqntDepositAmount = float.Parse(txtSubsqntDepositAmount.Text.Trim()); } if (txtSubsqntDepositDate != null && txtSubsqntDepositDate.Text != string.Empty) { govtSavingsVo.SubsqntDepositDate = Convert.ToDateTime(txtSubsqntDepositDate.Text); } if (ddlDepositFrequency != null && ddlDepositFrequency.SelectedValue != string.Empty) { govtSavingsVo.DepositFrequencyCode = ddlDepositFrequency.SelectedValue; } } govtSavingsVo.Remarks = txtRemarks.Text; govtSavingsBo.UpdateGovtSavingsNP(govtSavingsVo, userVo.UserId); } else if (btnAcctInsert.Visible == true) { } } if (e.CommandName == RadGrid.PerformInsertCommandName) { int i = 0; bool blResult = false; GridEditableItem gridEditableItem = (GridEditableItem)e.Item; Button btnAcctInsert = (Button)e.Item.FindControl("btnAcctInsert"); //gridEditableItem.OwnerTableView.IsItemInserted = false; if (hdnCondition.Value != "1") { gvGovtSaving.MasterTableView.IsItemInserted = true; e.Item.Edit = true; e.Canceled = true; hdnCondition.Value = "1"; } else { gvGovtSaving.MasterTableView.IsItemInserted = false; e.Item.Edit = false; e.Canceled = false; hdnCondition.Value = "0"; } //Account details control defined........ TextBox txtAccountNumber = (TextBox)e.Item.FindControl("txtAccountNumber"); DropDownList ddlCategory = (DropDownList)e.Item.FindControl("ddlCategory"); RadioButton rbtnNo = (RadioButton)e.Item.FindControl("rbtnNo"); RadioButton rbtnYes = (RadioButton)e.Item.FindControl("rbtnYes"); DropDownList ddlModeOfHolding = (DropDownList)e.Item.FindControl("ddlModeOfHolding"); TextBox txtAccountSource = (TextBox)e.Item.FindControl("txtAccountSource"); RadGrid gvJointHoldersList = (RadGrid)e.Item.FindControl("gvJointHoldersList"); TextBox txtAccOpenDate = (TextBox)e.Item.FindControl("txtAccOpenDate"); TextBox txtAccountId = (TextBox)e.Item.FindControl("txtAccountId"); TextBox txtAccountWith = (TextBox)e.Item.FindControl("txtAccountWith"); Label lblInstrumentCategory = (Label)e.Item.FindControl("lblInstrumentCategory"); //Govt saving control defined........ Button btnGovtSubmit = (Button)e.Item.FindControl("btnGovtSubmit"); DropDownList ddlDebtIssuerCode = (DropDownList)e.Item.FindControl("ddlDebtIssuerCode"); TextBox txtCurrentValue = (TextBox)e.Item.FindControl("txtCurrentValue"); TextBox txtDepositDate = (TextBox)e.Item.FindControl("txtDepositDate"); TextBox txtMaturityValue = (TextBox)e.Item.FindControl("txtMaturityValue"); TextBox txtMaturityDate = (TextBox)e.Item.FindControl("txtMaturityDate"); TextBox txtDepositAmount = (TextBox)e.Item.FindControl("txtDepositAmount"); TextBox txtInterstRate = (TextBox)e.Item.FindControl("txtInterstRate"); DropDownList ddlInterestBasis = (DropDownList)e.Item.FindControl("ddlInterestBasis"); DropDownList ddlSimpleInterestFC = (DropDownList)e.Item.FindControl("ddlSimpleInterestFC"); DropDownList ddlCompoundInterestFC = (DropDownList)e.Item.FindControl("ddlCompoundInterestFC"); TextBox txtInterestAmtCredited = (TextBox)e.Item.FindControl("txtInterestAmtCredited"); TextBox txtAssetParticulars = (TextBox)e.Item.FindControl("txtAssetParticulars"); RadioButton rbtnAccumulated = (RadioButton)e.Item.FindControl("rbtnAccumulated"); TextBox txtSubsqntDepositAmount = (TextBox)e.Item.FindControl("txtSubsqntDepositAmount"); TextBox txtSubsqntDepositDate = (TextBox)e.Item.FindControl("txtSubsqntDepositDate"); DropDownList ddlDepositFrequency = (DropDownList)e.Item.FindControl("ddlDepositFrequency"); TextBox txtRemarks = (TextBox)e.Item.FindControl("txtRemarks"); HtmlGenericControl divGovtSavings = (HtmlGenericControl)e.Item.FindControl("divGovtSavings"); DropDownList ddlgovtModeofHoldings = (DropDownList)e.Item.FindControl("ddlgovtModeofHoldings"); CustomerAccountsVo customerAccountsVo = new CustomerAccountsVo(); //divGovtSavings.Visible = true; HtmlGenericControl divAccout = (HtmlGenericControl)e.Item.FindControl("divAccout"); if (btnAcctInsert.Visible == true) { customerAccountsVo.AssetClass = "GS"; customerAccountsVo.AccountNum = txtAccountNumber.Text; customerAccountsVo.AssetCategory = ddlCategory.SelectedItem.Value.ToString(); customerAccountsVo.CustomerId = customerVo.CustomerId; customerAccountsVo.PortfolioId = int.Parse(ddlPortfolio.SelectedItem.Value.ToString());; if (rbtnNo.Checked) { customerAccountsVo.IsJointHolding = 0; } if (rbtnYes.Checked) { customerAccountsVo.IsJointHolding = 1; } customerAccountsVo.ModeOfHolding = ddlModeOfHolding.SelectedItem.Value.ToString(); customerAccountsVo.AccountSource = txtAccountSource.Text; accountId = customerAccountBo.CreateCustomerGovtSavingAccount(customerAccountsVo, userVo.UserId); customerAccountsVo.AccountId = accountId; customerAccountAssociationVo.AccountId = accountId; customerAccountAssociationVo.CustomerId = customerVo.CustomerId; foreach (GridDataItem gvRow in gvJointHoldersList.Items) { CheckBox chk = (CheckBox)gvRow.FindControl("cbRecons"); if (chk.Checked) { i++; } } if (i != 0) { // ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select a record!');", true); //} //else //{ foreach (GridDataItem gdi in gvJointHoldersList.Items) { if (((CheckBox)gdi.FindControl("cbRecons")).Checked == true) { int selectedRow = gdi.ItemIndex + 1; customerAccountAssociationVo.AssociationId = Convert.ToInt32(gvJointHoldersList.MasterTableView.DataKeyValues[selectedRow - 1]["AssociationId"].ToString()); customerAccountAssociationVo.AssociationType = "Joint Holder"; customerAccountBo.CreateGovtSavingsAccountAssociation(customerAccountAssociationVo, userVo.UserId); } } } if (blResult) { Session["customerAccountVo"] = customerAccountsVo; } if (customerAccountsVo.AccountOpeningDate != DateTime.MinValue) { txtAccOpenDate.Text = customerAccountsVo.AccountOpeningDate.ToShortDateString(); } txtAccountId.Text = customerAccountsVo.AccountNum.ToString(); if (customerAccountsVo.AccountSource != null) { txtAccountWith.Text = customerAccountsVo.AccountSource.ToString(); } if (customerAccountsVo.AssetCategory != null) { lblInstrumentCategory.Text = customerAccountsVo.AssetCategory.ToString(); } ddlModeOfHolding.SelectedValue = customerAccountsVo.ModeOfHolding.Trim(); ddlgovtModeofHoldings.SelectedValue = customerAccountsVo.ModeOfHolding.Trim(); Session["customerAccountVo"] = customerAccountsVo; divGovtSavings.Visible = true; btnAcctInsert.Visible = false; btnGovtSubmit.Visible = true; } else if (btnGovtSubmit.Visible == true) { customerAccountsVo = (CustomerAccountsVo)Session["customerAccountVo"]; customerAccountsVo.AccountId = customerAccountsVo.AccountId;//Convert.ToInt32(txtAccountId.Text); if (txtAccOpenDate != null && txtAccOpenDate.Text != string.Empty) { customerAccountsVo.AccountOpeningDate = Convert.ToDateTime(txtAccOpenDate.Text); } customerAccountsVo.AccountSource = txtAccountWith.Text; govtSavingsVo.PortfolioId = customerAccountsVo.PortfolioId; govtSavingsVo.AccountId = customerAccountsVo.AccountId; govtSavingsVo.AssetGroupCode = customerAccountsVo.AssetClass; govtSavingsVo.AssetInstrumentCategoryCode = customerAccountsVo.AssetCategory; if (ddlDebtIssuerCode != null && ddlDebtIssuerCode.SelectedItem.Value != string.Empty) { govtSavingsVo.DebtIssuerCode = ddlDebtIssuerCode.SelectedItem.Value.ToString(); } govtSavingsVo.Name = txtAssetParticulars.Text; if (txtCurrentValue != null && txtCurrentValue.Text != "") { govtSavingsVo.CurrentValue = float.Parse(txtCurrentValue.Text); } if (txtDepositDate != null && txtDepositDate.Text != "") { govtSavingsVo.PurchaseDate = DateTime.Parse(txtDepositDate.Text.ToString()); } if (txtMaturityValue != null && txtMaturityValue.Text != "") { govtSavingsVo.MaturityValue = float.Parse(txtMaturityValue.Text); } if (txtMaturityDate != null && txtMaturityDate.Text != "") { govtSavingsVo.MaturityDate = DateTime.Parse(txtMaturityDate.Text.ToString()); } if (txtDepositAmount != null && txtDepositAmount.Text != "") { govtSavingsVo.DepositAmt = float.Parse(txtDepositAmount.Text); } if (txtInterstRate != null && txtInterstRate.Text != "") { govtSavingsVo.InterestRate = float.Parse(txtInterstRate.Text); } if (ddlInterestBasis != null) { govtSavingsVo.InterestBasisCode = ddlInterestBasis.SelectedItem.Value.ToString(); } if (govtSavingsVo.InterestBasisCode == "SI") { govtSavingsVo.InterestPayableFrequencyCode = ddlSimpleInterestFC.SelectedItem.Value.ToString(); govtSavingsVo.CompoundInterestFrequencyCode = "NA"; } else if (govtSavingsVo.InterestBasisCode == "CI") { govtSavingsVo.InterestPayableFrequencyCode = "NA"; govtSavingsVo.CompoundInterestFrequencyCode = ddlCompoundInterestFC.SelectedItem.Value.ToString(); } else { govtSavingsVo.InterestBasisCode = null; } if (rbtnAccumulated.Checked) { govtSavingsVo.IsInterestAccumalated = 1; if (txtInterestAmtCredited != null && txtInterestAmtCredited.Text != string.Empty) { govtSavingsVo.InterestAmtAccumalated = float.Parse(txtInterestAmtCredited.Text); } govtSavingsVo.InterestAmtPaidOut = 0; } else { govtSavingsVo.IsInterestAccumalated = 0; if (txtInterestAmtCredited != null && txtInterestAmtCredited.Text != string.Empty) { govtSavingsVo.InterestAmtPaidOut = float.Parse(txtInterestAmtCredited.Text); } govtSavingsVo.InterestAmtAccumalated = 0; } //Post Office Recurring Deposit Account- Subsequent deposit details if (customerAccountsVo.AssetCategory != null && customerAccountsVo.AssetCategory.ToString().Trim() == "GSRD") { if (txtSubsqntDepositAmount != null && txtSubsqntDepositAmount.Text != string.Empty) { govtSavingsVo.SubsqntDepositAmount = float.Parse(txtSubsqntDepositAmount.Text.Trim()); } if (txtSubsqntDepositDate != null && txtSubsqntDepositDate.Text != string.Empty) { govtSavingsVo.SubsqntDepositDate = Convert.ToDateTime(txtSubsqntDepositDate.Text); } if (ddlDepositFrequency != null && ddlDepositFrequency.SelectedValue != string.Empty) { govtSavingsVo.DepositFrequencyCode = ddlDepositFrequency.SelectedValue; } } govtSavingsVo.Remarks = txtRemarks.Text; bool bResult = govtSavingsBo.CreateGovtSavingsNP(govtSavingsVo, userVo.UserId); //btnAcctInsert.Visible = true; //btnGovtSubmit.Visible = false; BindGovtSavingGrid(); } divAccout.Visible = false; //gridEditableItem.OwnerTableView.IsItemInserted = false; divGovtSavings.Visible = true; } if (e.CommandName == "Delete") { GovtSavingNPId = int.Parse(gvGovtSaving.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CGSNP_GovtSavingNPId"].ToString()); govtSavingsBo.DeleteGovtSavingsPortfolio(GovtSavingNPId); BindGovtSavingGrid(); } // BindGovtSavingGrid(); }