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!"); } }
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); }
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); }