public Double checkbalance(String acno) { BankDataSetTableAdapters.AccountsTableAdapter adp2 = new BankDataSetTableAdapters.AccountsTableAdapter(); double bal = (double)adp2.getbalnce(acno); return bal; }
public void deposit(String acno, Double amount, string description, String type) { BankDataSetTableAdapters.transactionsTableAdapter tadp = new BankDataSetTableAdapters.transactionsTableAdapter(); DateTime n1 = new DateTime(); String am = "" + amount; tadp.Insert(acno, am, description, type, DateTime.Today); BankDataSetTableAdapters.AccountsTableAdapter adp2 = new BankDataSetTableAdapters.AccountsTableAdapter(); double bal = (double)adp2.getbalnce(acno); double newbalance = (double)(bal + amount); adp2.updatebalance((decimal)newbalance, acno); //return "Hello World"; }
public String trasnfer(String fromacno, String toacno, Double amount, String type) { String am = "" + amount; String description = "Trnasfer from " + fromacno; BankDataSetTableAdapters.transactionsTableAdapter adp = new BankDataSetTableAdapters.transactionsTableAdapter(); adp.Insert(toacno, am, description, type, DateTime.Today); adp.Insert(fromacno, am, ("Transfered to : " + toacno), type, DateTime.Today); BankDataSetTableAdapters.AccountsTableAdapter adp2 = new BankDataSetTableAdapters.AccountsTableAdapter(); double bal2 = (double)adp2.getbalnce(fromacno); double bal = (double)adp2.getbalnce(toacno); if (bal2 >= amount) { adp2.updatebalance(((decimal)(bal + amount)), toacno); adp2.updatebalance((decimal)(bal2 - amount), fromacno); } else { return "Insufficient balance in the Account"; } return "Transaction completed Successfully"; }