public List <UserModel> Finduser(string accountNumber) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.accountnumber == accountNumber select user; List <UserModel> users = new List <UserModel>(); foreach (var u in query) { users.Add(new UserModel { status = u.status, password = u.password, name = u.name, email = u.email, city = u.city, accountnumber = u.accountnumber, balance = u.balance }); } return(users); }
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 bool ValidateLogin(string email, string password) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.email == email && user.password.ToString() == password && user.status == "active" select user; List<User> users = new List<User>(); foreach (var u in query) { users.Add(u); } return (users.Count > 0) ? true : false; }
public List <string> AllUsers() { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.status == "active" select user; List <string> accountNumbers = new List <string>(); foreach (var u in query) { accountNumbers.Add(u.accountnumber); } return(accountNumbers); }
public bool ValidateLogin(string email, string password) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.email == email && user.password.ToString() == password && user.status == "active" select user; List <User> users = new List <User>(); foreach (var u in query) { users.Add(u); } return((users.Count > 0) ? true : false); }
public UserModel GetUserByLogin(string email, string password) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.email == email && user.password.ToString() == password && user.status == "active" select user; UserModel loginUser = new UserModel(); foreach (var u in query) { loginUser.accountnumber = u.accountnumber; loginUser.balance = u.balance; loginUser.city = u.city; loginUser.email = u.email; loginUser.name = u.name; loginUser.password = u.password; } return loginUser; }
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 UserModel GetUserByLogin(string email, string password) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.email == email && user.password.ToString() == password && user.status == "active" select user; UserModel loginUser = new UserModel(); foreach (var u in query) { loginUser.accountnumber = u.accountnumber; loginUser.balance = u.balance; loginUser.city = u.city; loginUser.email = u.email; loginUser.name = u.name; loginUser.password = u.password; } return(loginUser); }
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 List <TransactionModel> TransactionsPerReceiver(string receiver) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from transaction in context.transactions where transaction.receiver == receiver && transaction.transactiontype == "transfer" select transaction; List <TransactionModel> transactions = new List <TransactionModel>(); foreach (var t in query) { transactions.Add(new TransactionModel { transactiontype = t.transactiontype, date = t.date.ToString(), sender = t.sender, receiver = t.receiver, amount = Convert.ToDouble(t.amount) }); } return(transactions); }
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 List<TransactionModel> TransactionsPerReceiver(string receiver) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from transaction in context.transactions where transaction.receiver == receiver && transaction.transactiontype == "transfer" select transaction; List<TransactionModel> transactions = new List<TransactionModel>(); foreach (var t in query) { transactions.Add(new TransactionModel { transactiontype = t.transactiontype, date = t.date.ToString(), sender = t.sender, receiver = t.receiver, amount = Convert.ToDouble(t.amount) }); } return transactions; }
public List<UserModel> Finduser(string accountNumber) { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.accountnumber == accountNumber select user; List<UserModel> users = new List<UserModel>(); foreach (var u in query) { users.Add(new UserModel { status = u.status, password = u.password, name = u.name, email = u.email, city = u.city, accountnumber = u.accountnumber, balance = u.balance }); } return users; }
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 List<string> AllUsers() { databaseforassignmentEntities1 context = new databaseforassignmentEntities1(); var query = from user in context.Users where user.status == "active" select user; List<string> accountNumbers = new List<string>(); foreach (var u in query) { accountNumbers.Add(u.accountnumber); } return accountNumbers; }