private void button1_Click(object sender, EventArgs e) { AccountActivityLedger Ledger = new AccountActivityLedger(); double accountBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(textBox1.Text)); label2.Text = label2.Text + Convert.ToString(accountBalance); }
public void Withdraw(double amount,int accID) { UserDAO dao=new UserDAO(); DataTable dt=new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt=dao.GetData("Select AccountBalance from Account where AccountID="+accID,connectionstring); Balance=Convert.ToDouble(dt.Rows[0]["AccountBalance"]); Balance = Balance - amount; if (Balance > 0) { string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accID; //UserDAO dao = new UserDAO(); bg.BgaWithdraw(amount); dao.UpdateData(myQuery, connectionstring); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accID, "Withdraw",amount, DateTime.Now); MessageBox.Show("Amount withdraw Successful!"); } //string myQuery="up else MessageBox.Show("Your balance is too low!"); }
public void Withdraw(double amount, int accID) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring); Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); Balance = Balance - amount; if (Balance > 0) { string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accID; //UserDAO dao = new UserDAO(); bg.BgaWithdraw(amount); dao.UpdateData(myQuery, connectionstring); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accID, "Withdraw", amount, DateTime.Now); MessageBox.Show("Amount withdraw Successful!"); } //string myQuery="up else { MessageBox.Show("Your balance is too low!"); } }
public override void Deposit(double amount, int accID) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring); Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); if ((Balance + amount) <= 5000) { Balance = Balance + amount; string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accID; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); bg.BgaDeposit(amount); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accID, "Deposit", amount, DateTime.Now); MessageBox.Show("Amount deposited successfully!"); } else { MessageBox.Show("Balance greater than limit!"); } }
private void button2_Click(object sender, EventArgs e) { var selectdAccountID = Convert.ToString(listBox1.SelectedItem); if (listBox1.SelectedItem == null) { MessageBox.Show("Please select the account in which to be Deposited"); } else { /*dataAccess.InsertData(@"use ApteanEdgeBank update Account * set AccountBalance=AccountBalance+"+Convert.ToString(textBox1.Text)+@"where AccountID =" + selectdAccountID, UserDAO.connectionString);*/ if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "CA") { Account A = new ChequingAccount(); A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID)); AccountActivityLedger Ledger = new AccountActivityLedger(); double newBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(selectdAccountID)); label4.Text = "Balance: $" + Convert.ToString(newBalance); MessageBox.Show("Amount deposited successfully!"); } else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS") { Account A = new TaxFreeSavingsAccount(); A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID)); //MessageBox.Show("Amount deposited successfully!"); } else { MessageBox.Show("Amount could not be deposited"); } } textBox1.Clear(); }
private void button1_Click(object sender, EventArgs e) { AccountActivityLedger Ledger = new AccountActivityLedger(); DataTable activityLog = new DataTable(); activityLog = Ledger.ReadAccountActivity(Convert.ToInt32(textBox1.Text)); dataGridView1.DataSource = bindingSource1; bindingSource1.DataSource = activityLog; if (activityLog.Rows.Count <= 0) { MessageBox.Show("No Records found!"); } }
private void button1_Click(object sender, EventArgs e) { AccountActivityLedger Ledger = new AccountActivityLedger(); DataTable activityLog = new DataTable(); activityLog = Ledger.ReadAccountActivity(Convert.ToInt32(textBox1.Text)); dataGridView1.DataSource = bindingSource1; bindingSource1.DataSource = activityLog; if (activityLog.Rows.Count <= 0) { MessageBox.Show("No Records found!"); } }
public override void Deposit(double amount, int accId) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accId, connectionstring); Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); Balance = Balance + amount; string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID=" + accId; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); bg.BgaDeposit(amount); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accId, "Deposit", amount, DateTime.Now); }
private void button1_Click(object sender, EventArgs e) { AccountActivityLedger Ledger = new AccountActivityLedger(); double accountBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(textBox1.Text)); label2.Text = label2.Text + Convert.ToString(accountBalance); }
private void button2_Click(object sender, EventArgs e) { var selectdAccountID = Convert.ToString(listBox1.SelectedItem); if (listBox1.SelectedItem == null) { MessageBox.Show("Please select the account in which to be Deposited"); } else { /*dataAccess.InsertData(@"use ApteanEdgeBank update Account set AccountBalance=AccountBalance+"+Convert.ToString(textBox1.Text)+@"where AccountID =" + selectdAccountID, UserDAO.connectionString);*/ if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "CA") { Account A = new ChequingAccount(); A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID)); AccountActivityLedger Ledger = new AccountActivityLedger(); double newBalance = Ledger.CalculateAccountBalance(Convert.ToInt32(selectdAccountID)); label4.Text = "Balance: $" + Convert.ToString(newBalance); MessageBox.Show("Amount deposited successfully!"); } else if (GetAccountType(Convert.ToInt32(selectdAccountID)) == "TFS") { Account A = new TaxFreeSavingsAccount(); A.Deposit(Convert.ToDouble(textBox1.Text), Convert.ToInt32(selectdAccountID)); //MessageBox.Show("Amount deposited successfully!"); } else { MessageBox.Show("Amount could not be deposited"); } } textBox1.Clear(); }
public override void Deposit(double amount,int accID) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt = dao.GetData("Select AccountBalance from Account where AccountID=" + accID, connectionstring); Balance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); if ((Balance + amount) <= 5000) { Balance = Balance + amount; string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accID; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); bg.BgaDeposit(amount); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accID, "Deposit", amount, DateTime.Now); MessageBox.Show("Amount deposited successfully!"); } else { MessageBox.Show("Balance greater than limit!"); } }
public override void Deposit(double amount,int accId) { UserDAO dao=new UserDAO(); DataTable dt=new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; BankGeneralAccount bg = new BankGeneralAccount(); dt=dao.GetData("Select AccountBalance from Account where AccountID="+accId,connectionstring); Balance=Convert.ToDouble(dt.Rows[0]["AccountBalance"]); Balance=Balance+amount; string myQuery = "Update Account set AccountBalance=" + Balance + " where AccountID="+accId; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); bg.BgaDeposit(amount); AccountActivityLedger Ledger = new AccountActivityLedger(); Ledger.AddAccountActivity(accId, "Deposit", amount, DateTime.Now); }