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 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!"); } }
//methods public void BgaDeposit( double amt) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; dt = dao.GetData("Select AccountBalance from BankGeneralAccount where AccountID=1000", connectionstring); bgaBalance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); bgaBalance = bgaBalance + amt; string myQuery = "Update BankGeneralAccount set AccountBalance=" + bgaBalance + " where AccountID= 1000"; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); }
//methods public void BgaDeposit(double amt) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; dt = dao.GetData("Select AccountBalance from BankGeneralAccount where AccountID=1000", connectionstring); bgaBalance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); bgaBalance = bgaBalance + amt; string myQuery = "Update BankGeneralAccount set AccountBalance=" + bgaBalance + " where AccountID= 1000"; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); }
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 static void Reopen(int accId,double reopeningBalance) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); BankGeneralAccount bg = new BankGeneralAccount(); string queryString = "Select * from Account where AccountID=" + accId; try { dao.InsertData(@"use ApteanEdgeBank update Account set DateOfClosing=null where AccountID =" + accId, UserDAO.connectionString); dao.UpdateData("update Account set AccountBalance=" + reopeningBalance + "where AccountID=" + accId, UserDAO.connectionString); bg.BgaDeposit(reopeningBalance); } catch (InvalidOperationException e) { MessageBox.Show("Account reopen failed!"); } }
public void BgaWithdraw(double amt) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; dt = dao.GetData("Select AccountBalance from BankGeneralAccount where AccountID=1000", connectionstring); bgaBalance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); bgaBalance = bgaBalance - amt; if (bgaBalance > 0) { string myQuery = "Update BankGeneralAccount set AccountBalance=" + bgaBalance + " where AccountID= 1000"; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); } //string myQuery="up else System.Windows.Forms.MessageBox.Show("Insufficient Balance in Bank General Account"); }
public void Withdraw(double amount, int accID) { BankGeneralAccount bg = new BankGeneralAccount(); UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1550PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; 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(); dao.UpdateData(myQuery, connectionstring); bg.BgaWithdraw(amount); } //string myQuery="up else System.Windows.Forms.MessageBox.Show("Your balance is too low!"); }
public void BgaWithdraw(double amt) { UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1553PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; dt = dao.GetData("Select AccountBalance from BankGeneralAccount where AccountID=1000", connectionstring); bgaBalance = Convert.ToDouble(dt.Rows[0]["AccountBalance"]); bgaBalance = bgaBalance - amt; if (bgaBalance > 0) { string myQuery = "Update BankGeneralAccount set AccountBalance=" + bgaBalance + " where AccountID= 1000"; //UserDAO dao = new UserDAO(); dao.UpdateData(myQuery, connectionstring); } //string myQuery="up else { System.Windows.Forms.MessageBox.Show("Insufficient Balance in Bank General Account"); } }
public static void Close(int accId) { UserDAO dao=new UserDAO(); DataTable dt=new DataTable(); BankGeneralAccount bg = new BankGeneralAccount(); string queryString="Select * from Account where AccountID="+accId; try { /*Balance = 0; dateClosed = DateTime.Now; Console.WriteLine("Account closed on {0}", dateClosed.ToShortDateString());*/ dt = dao.GetData(queryString, UserDAO.connectionString); if (Convert.ToDouble(dt.Rows[0]["AccountBalance"]) != 0.0) { DialogResult result= MessageBox.Show("Your account balance is greater than 0! The balance must be 0 to close an account. Would you like to clear your account balance?","Account Balance is not 0!",MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { //set closing date for the account. Deduct the remaining balance from bank general account and set the current balance to 0 dao.InsertData(@"use ApteanEdgeBank update Account set DateOfClosing= cast(getdate() as date) where AccountID =" + accId, UserDAO.connectionString); bg.BgaWithdraw(Convert.ToDouble(dt.Rows[0]["AccountBalance"])); dao.UpdateData("update Account set AccountBalance=0 where AccountID=" + accId, UserDAO.connectionString); } } else { dao.InsertData(@"use ApteanEdgeBank update Account set DateOfClosing= cast(getdate() as date) where AccountID =" + accId, UserDAO.connectionString); } } catch (InvalidOperationException e) { MessageBox.Show("Account closure failed!"); } }
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) { BankGeneralAccount bg = new BankGeneralAccount(); UserDAO dao = new UserDAO(); DataTable dt = new DataTable(); string connectionstring = "Data Source=WS003LT1550PRD;Initial Catalog=ApteanEdgeBank;User=sa;Password=abc-123"; 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); } else { System.Windows.Forms.MessageBox.Show("Balance greater than limit!"); } }