protected void ViewMemberAccount(string username)
{
var connect = new DataClassDataContext();
var menuList = new List <string>();
var menuQuery = from d in connect.users
where d.username != username
select d.username;
menuList.AddRange(menuQuery.Distinct());
short currentItem = 0, c;
ConsoleKeyInfo key;
do
{
Console.Clear();
for (c = 0; c < menuList.Count; c++)
{
if (currentItem == c)
{
Console.BackgroundColor = ConsoleColor.Blue;
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(menuList[c]);
Console.ResetColor();
}
else
{
Console.WriteLine(menuList[c]);
}
}
key = Console.ReadKey(true);
if (key.Key.ToString() == "DownArrow")
{
currentItem++;
if (currentItem > menuList.Count - 1)
{
currentItem = 0;
}
}
else if (key.Key.ToString() == "UpArrow")
{
currentItem--;
if (currentItem < 0)
{
currentItem = Convert.ToInt16(menuList.Count - 1);
}
}
} while (key.KeyChar != 13);
int userId = (from l in connect.users where (l.username == menuList[currentItem]) select l.id).First();
var userAmount = (from k in connect.accounts
where k.user_id == userId
select k.amount).First();
Console.Clear();
Console.WriteLine("The amount of user " + menuList[currentItem] + " is: " + userAmount);
Console.WriteLine("Press enter to go back");
Console.ReadLine();
}
protected void ViewYourAccount(string username)
{
var connect = new DataClassDataContext();
int userId = (from l in connect.users where (l.username == username) select l.id).First();
var userAmount = (from k in connect.accounts
where k.user_id == userId
select k.amount).First();
Console.Clear();
Console.WriteLine("Your amount is: " + userAmount);
Console.WriteLine("Press enter to go back");
Console.ReadLine();
}
protected void DepositAdminAccount(string username)
{
Console.Clear();
var connect = new DataClassDataContext();
int userId = (from l in connect.users where (l.username == "admin") select l.id).First();
var userAmount = (from k in connect.accounts
where k.user_id == userId
select k.amount).First();
Console.Clear();
Console.WriteLine("Please enter the amount you want to Deposit:");
decimal deposition = 0;
bool isDecimal = false;
do
{
string input = Console.ReadLine();
if (decimal.TryParse(input, out deposition))
{
Console.Clear();
break;
}
else
{
Console.Clear();
Console.WriteLine("Please enter a decimal");
isDecimal = true;
}
} while (isDecimal);
int currentUserId = (from l in connect.users where l.username == username select l.id).First();
var balance = (from k in connect.accounts
where k.user_id == currentUserId
select k.amount).First();
while (deposition > balance)
{
Console.Clear();
Console.WriteLine("Your balance is: " + balance);
Console.WriteLine("Please choose a smaller number!");
deposition = Convert.ToDecimal(Console.ReadLine());
}
var Transfer = new BankAccount("admin", username, deposition, "deposit");
Transfer.Transaction();
Console.Clear();
}
public void Transaction()
{
var connect = new DataClassDataContext();
int userId = (from l in connect.users where (l.username == DepositedUser) select l.id).First();
var userAmount = from k in connect.accounts
where k.user_id == userId
select k;
foreach (var k in userAmount)
{
k.amount = k.amount + TransactionAmount;
}
try
{
connect.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
userId = (from l in connect.users where (l.username == WithdrawlUser) select l.id).First();
userAmount = from k in connect.accounts
where k.user_id == userId
select k;
foreach (var k in userAmount)
{
k.amount = k.amount - TransactionAmount;
}
try
{
connect.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.Clear();
Console.WriteLine(ToString());
Console.WriteLine("Press enter to go back");
Console.ReadLine();
}
public string CredentialInput()
{
Console.WriteLine(@"
__ ________ _ _____ ____ __ __ ______ _______ ____
\ \ / / ____| | / ____/ __ \| \/ | ____| |__ __/ __ \
\ \ /\ / /| |__ | | | | | | | | \ / | |__ | | | | | |
\ \/ \/ / | __| | | | | | | | | |\/| | __| | | | | | |
\ /\ / | |____| |___| |___| |__| | | | | |____ | | | |__| |
\/ \/ |______|______\_____\____/|_| |_|______|____|_| \____/
| _ \ / __ \ / ____|__ __|/\ | \ | |_ _|
| |_) | | | | (___ | | / \ | \| | | |
| _ <| | | |\___ \ | | / /\ \ | . ` | | |
| |_) | |__| |____) | | |/ ____ \| |\ |_| |_
_____ _ _ _____|____/_\____/|_____/ _ |_/_/ \_\_| \_|_____| _ _ _ __
|_ _| \ | |__ __| ____| __ \| \ | | /\ | | | _ \ /\ | \ | | |/ /
| | | \| | | | | |__ | |__) | \| | / \ | | | |_) | / \ | \| | ' /
| | | . ` | | | | __| | _ /| . ` | / /\ \ | | | _ < / /\ \ | . ` | <
_| |_| |\ | | | | |____| | \ \| |\ |/ ____ \| |____ | |_) / ____ \| |\ | . \
|_____|_| \_| |_| |______|_| \_\_| \_/_/ \_\______| |____/_/ \_\_| \_|_|\_\
");
System.Threading.Thread.Sleep(3000);
var connectionQuery = new DataClassDataContext();
try
{
var checkConnectivity = (from k in connectionQuery.users
select k).Count();
if (checkConnectivity > 0)
{
Console.WriteLine("Database Connected");
System.Threading.Thread.Sleep(1000);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.Clear();
string username = String.Empty;
bool successBoolLogon = false;
try
{
int counter = 3;
do
{
var credentialQuery = new DataClassDataContext();
Console.WriteLine("Please insert your username");
username = Console.ReadLine();
Console.WriteLine("Please insert your password");
string password = String.Empty;
ConsoleKeyInfo info = Console.ReadKey(true);
//Replaces keys on screen with *
while (info.Key != ConsoleKey.Enter)
{
if (info.Key != ConsoleKey.Backspace)
{
Console.Write("*");
password += info.KeyChar;
}
else if (info.Key == ConsoleKey.Backspace)
{
if (!string.IsNullOrEmpty(password))
{
password = password.Substring(0, password.Length - 1);
int pos = Console.CursorLeft;
Console.SetCursorPosition(pos - 1, Console.CursorTop);
Console.Write(" ");
Console.SetCursorPosition(pos - 1, Console.CursorTop);
}
}
info = Console.ReadKey(true);
}
Console.WriteLine();
password = GenerateSHA256String(password);
//Checks credentials to database for validity
var checkCredentials = (from k in credentialQuery.users
where (k.username == username) && (k.password == password)
select k).Count();
if (checkCredentials > 0)
{
Console.WriteLine("Successfull Login");
successBoolLogon = true;
}
else
{
Console.Clear();
Console.WriteLine("Unsuccessfull Login - " + (counter - 1) + " more tries");
}
counter--;
} while ((successBoolLogon == false) && (counter > 0));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Console.Clear();
}
if (successBoolLogon == false)
{
Console.WriteLine("Unsuccessfull Login - BYE!!!");
username = String.Empty;
Environment.Exit(0);
}
return(username);
}
protected void DepositMemberAccount(string username)
{
Console.WriteLine("Please Choose the Member account you want to deposit:");
//gets the list of the members and their according balance
var connect = new DataClassDataContext();
var menuList = new List <string>();
var menuQuery = from d in connect.users
where d.username != username
select d.username;
menuList.AddRange(menuQuery.Distinct());
short currentItem = 0, c;
ConsoleKeyInfo key;
do
{
Console.Clear();
for (c = 0; c < menuList.Count; c++)
{
if (currentItem == c)
{
Console.BackgroundColor = ConsoleColor.Blue;
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(menuList[c]);
Console.ResetColor();
}
else
{
Console.WriteLine(menuList[c]);
}
}
key = Console.ReadKey(true);
if (key.Key.ToString() == "DownArrow")
{
currentItem++;
if (currentItem > menuList.Count - 1)
{
currentItem = 0;
}
}
else if (key.Key.ToString() == "UpArrow")
{
currentItem--;
if (currentItem < 0)
{
currentItem = Convert.ToInt16(menuList.Count - 1);
}
}
} while (key.KeyChar != 13);
int userId = (from l in connect.users where (l.username == menuList[currentItem]) select l.id).First();
var userAmount = (from k in connect.accounts
where k.user_id == userId
select k.amount).First();
Console.Clear();
Console.WriteLine("Please enter the amount you want to Deposit:");
decimal deposition = 0;
bool isDecimal = false;
do
{
string input = Console.ReadLine();
if (decimal.TryParse(input, out deposition))
{
Console.Clear();
break;
}
else
{
Console.Clear();
Console.WriteLine("Please enter a decimal");
isDecimal = true;
}
} while (isDecimal);
int currentUserId = (from l in connect.users where l.username == username select l.id).First();
var balance = (from k in connect.accounts
where k.user_id == currentUserId
select k.amount).First();
while (deposition > balance)
{
Console.Clear();
Console.WriteLine("Your balance is: " + balance);
Console.WriteLine("Please choose a smaller number!");
isDecimal = false;
do
{
string input = Console.ReadLine();
if (decimal.TryParse(input, out deposition))
{
Console.Clear();
break;
}
else
{
Console.Clear();
Console.WriteLine("Please enter a decimal");
isDecimal = true;
}
} while (isDecimal);
}
var Transfer = new BankAccount(menuList[currentItem], username, deposition, "deposit");
Transfer.Transaction();
Console.Clear();
}
public User(string Username)
{
username = Username;
var amountQuery = new DataClassDataContext();
}