Beispiel #1
0
        /// <summary>
        /// to get the BankDetails()
        /// </summary>
        private void GetBankDetails()
        {
            PAP_BankBO objPAPBank = new PAP_BankBO();

            objPAPBank = (new PAP_BankBLL()).GetPAPBankByID(Convert.ToInt32(Session["HH_ID"]));
            if (objPAPBank != null)
            {
                chkHasBankAccount.Checked   = true;
                btnSaveBank.ValidationGroup = "Bank";
                txtAccountNo.Text           = objPAPBank.AccountNo;
                txtAccountName.Text         = objPAPBank.AccountHolderName;

                ddlBank.ClearSelection();
                if (ddlBank.Items.FindByValue(objPAPBank.BankID.ToString()) != null)
                {
                    ddlBank.Items.FindByValue(objPAPBank.BankID.ToString()).Selected = true;
                }

                BindBankBranches(Convert.ToInt32(ddlBank.SelectedItem.Value));
                ddlBranch.ClearSelection();
                if (ddlBranch.Items.FindByValue(objPAPBank.BranchID.ToString()) != null)
                {
                    ddlBranch.Items.FindByValue(objPAPBank.BranchID.ToString()).Selected = true;
                }

                EnableBankDetails(true);
            }
            else
            {
                chkHasBankAccount.Checked   = false;
                btnSaveBank.ValidationGroup = "";
                EnableBankDetails(false);
            }
        }
Beispiel #2
0
        /// <summary>
        /// to save the Bank Details to the database
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        protected void btnSaveBank_Click(object sender, EventArgs e)
        {
            if (chkHasBankAccount.Checked)
            {
                PAP_BankBO objPAPBank = new PAP_BankBO();
                objPAPBank.HouseHoldID       = Convert.ToInt32(Session["HH_ID"]);
                objPAPBank.BankID            = Convert.ToInt32(ddlBank.SelectedItem.Value);
                objPAPBank.BranchID          = Convert.ToInt32(ddlBranch.SelectedItem.Value);
                objPAPBank.AccountNo         = txtAccountNo.Text.Trim();
                objPAPBank.AccountHolderName = txtAccountName.Text.Trim();
                objPAPBank.CreatedBy         = Convert.ToInt32(Session["USER_ID"]);
                objPAPBank.UpdatedBy         = Convert.ToInt32(Session["USER_ID"]);

                (new PAP_BankBLL()).UpdatePAPBank(objPAPBank);
            }
            else
            {
                (new PAP_BankBLL()).DeletePAPBank(Convert.ToInt32(Session["HH_ID"]));
            }

            ChangeRequestStatusBank();
            projectFrozen();

            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "UpdatedBank", "alert('Data saved successfully');", true);
        }
Beispiel #3
0
        /// <summary>
        /// To Get PAP Bank By ID
        /// </summary>
        /// <param name="householdID"></param>
        /// <returns></returns>
        public PAP_BankBO GetPAPBankByID(int householdID)
        {
            proc = "USP_TRN_GET_PAPBANKBYID";
            cnn  = new OracleConnection(con);

            PAP_BankBO objPAPBank = null;

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("HOUSEHOLDID_", householdID);
            cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;

            try
            {
                cmd.Connection.Open();
                OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                while (dr.Read())
                {
                    objPAPBank = new PAP_BankBO();

                    if (!dr.IsDBNull(dr.GetOrdinal("BANKDETAILID")))
                    {
                        objPAPBank.BankDetailID = dr.GetInt32(dr.GetOrdinal("BANKDETAILID"));
                    }
                    if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
                    {
                        objPAPBank.HouseHoldID = dr.GetInt32(dr.GetOrdinal("HHID"));
                    }
                    if (!dr.IsDBNull(dr.GetOrdinal("BANKID")))
                    {
                        objPAPBank.BankID = dr.GetInt32(dr.GetOrdinal("BANKID"));
                    }
                    if (!dr.IsDBNull(dr.GetOrdinal("BRANCHID")))
                    {
                        objPAPBank.BranchID = dr.GetInt32(dr.GetOrdinal("BRANCHID"));
                    }
                    if (!dr.IsDBNull(dr.GetOrdinal("ACCOUNTNO")))
                    {
                        objPAPBank.AccountNo = dr.GetString(dr.GetOrdinal("ACCOUNTNO"));
                    }
                    if (!dr.IsDBNull(dr.GetOrdinal("ACCOUNTHOLDERNAME")))
                    {
                        objPAPBank.AccountHolderName = dr.GetString(dr.GetOrdinal("ACCOUNTHOLDERNAME"));
                    }
                }

                dr.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(objPAPBank);
        }
Beispiel #4
0
        /// <summary>
        /// To Update PAP Bank
        /// </summary>
        /// <param name="objPAPBank"></param>
        public void UpdatePAPBank(PAP_BankBO objPAPBank)
        {
            cnn = new OracleConnection(con);

            proc = "USP_TRN_UPD_PAPBANK";

            cmd             = new OracleCommand(proc, cnn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection.Open();

            cmd.Parameters.Add("BANKDETAILID_", objPAPBank.BankDetailID);
            cmd.Parameters.Add("HOUSEHOLDID_", objPAPBank.HouseHoldID);
            cmd.Parameters.Add("BANKID_", objPAPBank.BankID);
            cmd.Parameters.Add("BRANCH_", objPAPBank.BranchID);
            cmd.Parameters.Add("ACCOUNTNO_", objPAPBank.AccountNo);
            cmd.Parameters.Add("ACCOUNTHOLDERNAME_", objPAPBank.AccountHolderName);
            cmd.Parameters.Add("CREATEDBY_", objPAPBank.CreatedBy);
            cmd.Parameters.Add("UPDATEDBY_", objPAPBank.UpdatedBy);
            cmd.ExecuteNonQuery();
            cmd.Connection.Close();
        }
Beispiel #5
0
 /// <summary>
 /// To Update PAP Bank
 /// </summary>
 /// <param name="objPAPBank"></param>
 public void UpdatePAPBank(PAP_BankBO objPAPBank)
 {
     (new PAP_BankDAL()).UpdatePAPBank(objPAPBank);
 }