public bool RegisterUser(string name, string password, string confirmPassword, string amount) { DBTransaction register = new DBTransaction(); string query1 = "insert into bank_master values('" + name + "','" + password + "'," + amount + ")"; string query2 = "insert into bank_transaction values('" + name + "', " + amount + ", 'D', GETDATE())"; if (register.Transaction(query1, query2, name, password) == true) { return(true); } return(false); }
public bool DoTransaction(string name, string amount, string transactionType) { if (transactionType.Equals("Withdraw")) { query1 = "insert into bank_transaction values (@Name, @Amount, 'W', GETDATE());"; query2 = "update bank_master set balance = balance - @Amount where name = @Name;"; } if (transactionType.Equals("Deposit")) { query1 = "insert into bank_transaction values (@Name, @Amount, 'D', GETDATE());"; query2 = "update bank_master set balance = balance+ @Amount where name = @Name;"; } if (transact.Transaction(query1, query2, name, amount) == true) { return(true); } return(false); }