예제 #1
0
파일: BLLMngr.cs 프로젝트: joeLloyd/OOP_v3
 public void CreateTransfer(int credID, int debID, TransferModel transfer)
 {
     DALMngr dalMngr = new DALMngr();
     dalMngr.CreateTransfer(credID, debID, transfer);
 }
예제 #2
0
        private void btnProcessTransfer_Click(object sender, EventArgs e)
        {
            BLLMngr bllMngr = new BLLMngr();
            string type = "Transfer";

            // Creating debtor and creditor models and adding two transactions to DB
            TransactionModel debtor = new TransactionModel(DebtorID, Amount, type, Description);
            bllMngr.CreateTransaction(debtor);
            int debID = bllMngr.TransactionID; // Taking Id from debtor transaction

            TransactionModel creditor = new TransactionModel(CreditorID, Amount, type, Description);
            bllMngr.CreateTransaction(creditor);
            int credID = bllMngr.TransactionID; // Taking ID from creditor transaction

            TransferModel transfer = new TransferModel(debID, credID, CreditorSortCode, CreditorAccountNumber);

            CreditorBalance += Amount;
            DebtorBalance -= Amount;

            // Creating models so that balance may be updated in UpdateAccountBalance() below
            AccountModel credAcc = new AccountModel(CreditorID, CreditorBalance);
            AccountModel debAcc = new AccountModel(DebtorID, DebtorBalance);

            bllMngr.CreateTransfer(credID, debID, transfer);
            bllMngr.UpdateAccountBalance(debAcc);
            bllMngr.UpdateAccountBalance(credAcc);

            MessageBox.Show("Transfer Complete");

            this.Close();
        }
예제 #3
0
파일: DALMngr.cs 프로젝트: joeLloyd/OOP_v3
        public void CreateTransfer(int credID, int debID, TransferModel transfer)
        {
            // trying to get the account details to get customer details
            // AccountModel creditorsAccount = new AccountModel(credit.AccountID);
            // How to get the name based on account //

            using (SqlConnection cxn = new SqlConnection(cxnString))
            {
                SqlCommand cmdTransfer = new SqlCommand("spAddTransfer", cxn);
                cmdTransfer.CommandType = CommandType.StoredProcedure;

                SqlParameter transactionCreditIDParam = new SqlParameter("@TransactionCreditID", SqlDbType.Int);
                transactionCreditIDParam.Value = credID;

                SqlParameter transactionDebitIDParam = new SqlParameter("@TransactionDebitID", SqlDbType.Int);
                transactionDebitIDParam.Value = debID;

                SqlParameter DestinationSortCodeParam = new SqlParameter("@DestinationSortCode", SqlDbType.NVarChar, 50);
                DestinationSortCodeParam.Value = transfer.DestinationSortCode;

                SqlParameter DestinationAccountNumberParam = new SqlParameter("@DestinationAccountNumber", SqlDbType.Int);
                DestinationAccountNumberParam.Value = transfer.DestinationAccountNumber;

                SqlParameter TransferIDParam = new SqlParameter("@TransferID", SqlDbType.Int);
                TransferIDParam.Direction = ParameterDirection.Output;

                //ADD PARAMETERS//
                cmdTransfer.Parameters.Add(transactionCreditIDParam);
                cmdTransfer.Parameters.Add(transactionDebitIDParam);
                cmdTransfer.Parameters.Add(DestinationSortCodeParam);
                cmdTransfer.Parameters.Add(DestinationAccountNumberParam);
                cmdTransfer.Parameters.Add(TransferIDParam);

                cxn.Open();
                cmdTransfer.ExecuteNonQuery();
                cxn.Close();
            }
        }