public bool TransferMoney(int amountOfBitCoins, string receiverAccountNumber, string senderAccountNumber)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var resultSender = context.Users.SingleOrDefault(a => a.accountnumber == senderAccountNumber);
var resultReceiver = context.Users.SingleOrDefault(a => a.accountnumber == receiverAccountNumber);
if (resultSender == null || resultReceiver == null)
{
return(false);
}
if ((resultSender.balance - amountOfBitCoins) <= 0)
{
return(false);
}
resultSender.balance = resultSender.balance - amountOfBitCoins;
resultReceiver.balance = resultReceiver.balance + amountOfBitCoins;
context.transactions.Add(new transaction
{
transactiontype = "transfer",
date = DateTime.Now,
sender = senderAccountNumber,
receiver = receiverAccountNumber,
amount = amountOfBitCoins
});
context.SaveChanges();
return(true);
}
public void DeleteUser(string userAccountnumber)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var user = context.Users.SingleOrDefault(a => a.accountnumber == userAccountnumber);
user.status = "inactive";
context.SaveChanges();
}
public void MakeDepositWIthdrawal(string accountNumber, double amount, bool deposit)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var user = context.Users.SingleOrDefault(u => u.accountnumber == accountNumber);
if (deposit)
{
user.balance += amount;
context.transactions.Add(new transaction
{
transactiontype = "deposit",
date = DateTime.Now,
sender = accountNumber,
receiver = accountNumber,
amount = amount
});
context.SaveChanges();
}
else
{
if (user.balance - amount >= 0)
{
user.balance -= amount;
}
context.transactions.Add(new transaction
{
transactiontype = "withdrawing",
date = DateTime.Now,
sender = accountNumber,
receiver = accountNumber,
amount = amount
});
context.SaveChanges();
}
}
public void RegisterUser(UserModel user)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
User DBuser = new User();
if (context.Users.SingleOrDefault(u => u.email == user.email) == null)
{
DBuser.accountnumber = user.accountnumber;
DBuser.balance = 0;
DBuser.city = user.city;
DBuser.email = user.email;
DBuser.name = user.name;
DBuser.password = user.password;
DBuser.status = "active";
context.Users.Add(DBuser);
context.SaveChanges();
}
}
public void RegisterUser(UserModel user)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
User DBuser = new User();
if (context.Users.SingleOrDefault(u => u.email == user.email) == null)
{
DBuser.accountnumber = user.accountnumber;
DBuser.balance = 0;
DBuser.city = user.city;
DBuser.email = user.email;
DBuser.name = user.name;
DBuser.password = user.password;
DBuser.status = "active";
context.Users.Add(DBuser);
context.SaveChanges();
}
}
public void MakeDepositWIthdrawal(string accountNumber, double amount, bool deposit) {
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var user = context.Users.SingleOrDefault(u => u.accountnumber == accountNumber);
if (deposit)
{
user.balance += amount;
context.transactions.Add(new transaction
{
transactiontype = "deposit",
date = DateTime.Now,
sender = accountNumber,
receiver = accountNumber,
amount = amount
});
context.SaveChanges();
}
else
{
if (user.balance - amount >= 0)
user.balance -= amount;
context.transactions.Add(new transaction
{
transactiontype = "withdrawing",
date = DateTime.Now,
sender = accountNumber,
receiver = accountNumber,
amount = amount
});
context.SaveChanges();
}
}
public void DeleteUser(string userAccountnumber)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var user = context.Users.SingleOrDefault(a => a.accountnumber == userAccountnumber);
user.status = "inactive";
context.SaveChanges();
}
public bool TransferMoney(int amountOfBitCoins, string receiverAccountNumber, string senderAccountNumber)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
var resultSender = context.Users.SingleOrDefault(a => a.accountnumber == senderAccountNumber);
var resultReceiver = context.Users.SingleOrDefault(a => a.accountnumber == receiverAccountNumber);
if (resultSender == null || resultReceiver == null) return false;
if ((resultSender.balance - amountOfBitCoins) <= 0) return false;
resultSender.balance = resultSender.balance - amountOfBitCoins;
resultReceiver.balance = resultReceiver.balance + amountOfBitCoins;
context.transactions.Add(new transaction
{
transactiontype = "transfer",
date = DateTime.Now,
sender = senderAccountNumber,
receiver = receiverAccountNumber,
amount = amountOfBitCoins
});
context.SaveChanges();
return true;
}
