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