public override void RunScene(float framesPerSecond)
{
try
{
MySqlHelper.ConnectToMySql();
}
catch (MySqlException e)
{
Console.WriteLine("MySQL Failed Connection in CreatAccountScene.RunScene()");
throw;
}
//Can only create table once, or exception is thrown. Catch to avoid error / crash
try
{
MySqlConnection sql = MySqlHelper.GetConnection();
string command = "create table customer_accounts " +
"(id int unsigned auto_increment," +
"balance decimal(17,2)," +
"account_status varchar(255)," +
"pin varchar(4)," +
"username varchar(255)," +
"password varchar(255)," +
"first_name varchar(255)," +
"last_name varchar(255)," +
"street_address varchar(255)," +
"city varchar(255)," +
"state varchar(2)," +
"zip varchar(5)," +
"primary_phone varchar(14)," +
"secondary_phone varchar(14)," +
"email varchar(255)," +
"primary key (id));";
MySqlCommand cmd = new MySqlCommand(command, sql);
cmd.ExecuteNonQuery();
}
catch (MySqlException e)
{
//Error code 1050 means the table already exists. Ignore if this is the error
if (e.Number != 1050)
{
Console.WriteLine(e.Message);
throw (e);
}
}
MySqlDataReader reader = null;
try
{
MySqlConnection sql = MySqlHelper.GetConnection();
string command = "select distinct username from customer_accounts;";
MySqlCommand cmd = new MySqlCommand(command, sql);
reader = cmd.ExecuteReader();
}
catch (MySqlException e)
{
Console.WriteLine("MySQL failed to exectute command in CreateAccountScene.cs. Error: " + e.Message);
throw;
}
List <string> takenUsernames = new List <string> {
};
//Get all usernames in the customer_account table to make sure chosen username isn't already taken
while (reader.Read())
{
takenUsernames.Add(reader.GetString("username"));
}
reader.Close();
string firstName;
string lastName;
string streetAddress;
string city;
string state;
string zip;
string email;
string primaryPhone;
string secondaryPhone;
char[] password = new char[10];
char[] pin = new char[4];
Console.WriteLine(GetXmlText("enter_username"));
bool usernameTaken = false;
bool isUsernameValid = false;
do
{
isUsernameValid = GetStringInput(out username);
//Reset before checking
usernameTaken = false;
//User left field blank
if (!isUsernameValid)
{
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_username"));
}
else if (takenUsernames.Contains(username))
{
usernameTaken = true;
Console.WriteLine();
Console.WriteLine(GetXmlText("username_taken"));
}
}while (!isUsernameValid || usernameTaken);
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_first_name"));
while (!GetStringInput(out firstName))
{
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_first_name"));
}
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_last_name"));
while (!GetStringInput(out lastName))
{
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_last_name"));
}
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_street_address"));
while (!GetStringInput(out streetAddress))
{
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_street_address"));
}
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_city"));
while (!GetStringInput(out city))
{
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_city"));
}
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_state"));
while (!GetStringInput(out state) || !stateAbbreviations.Contains(state.ToUpper()))
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_state"));
}
//After getting valid state abbreviation, we want all state abbreviations to be uppercase
state = state.ToUpper();
bool isZipValid = false;
do
{
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_zip"));
GetStringInput(out zip);
int intCheck;
//Make sure phone number is 5 numerical digits
if (zip.Length == 5)
{
if (int.TryParse(zip, out intCheck))
{
isZipValid = true;
}
else
{
isZipValid = false;
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_zip"));
}
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_zip"));
}
}while (!isZipValid);
bool isEmailValid = false;
do
{
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_email"));
GetStringInput(out email);
//Logically, for email to be valid
//1. It must contain both "@" and ".com"
//2. There must be characters before "@".
//3. There must be characters between "@" and ".com"
//4. It must end with ".com"
if (email.Contains("@") && email.Contains(".com"))
{
bool charactersBeforeAt = false;
bool charactersBetweenAtandDotCom = false;
bool endsWithDotCom = false;
int positionOfAt = email.IndexOf('@');
int positionOfDotCom = email.IndexOf(".com");
if (positionOfAt > 0)
{
charactersBeforeAt = true;
}
if (positionOfDotCom - positionOfAt > 1)
{
charactersBetweenAtandDotCom = true;
}
endsWithDotCom = email.EndsWith(".com");
if (charactersBeforeAt && charactersBetweenAtandDotCom && endsWithDotCom)
{
isEmailValid = true;
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_email"));
}
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_email"));
}
}while (!isEmailValid);
bool isPhoneNumberValid = false;
//Use to find only numeric values in phone number
Regex regexNumerals = new Regex(@"[0-9]");
do
{
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_primary_phone"));
GetStringInput(out primaryPhone);
//Gets only characters included in the match pattern
MatchCollection validChars = regexNumerals.Matches(primaryPhone);
//First add all valid characters to beginning of string...
for (int iii = 0; iii < validChars.Count; iii++)
{
primaryPhone = primaryPhone.Insert(iii, validChars[iii].Value);
}
//Now get rid of whatever the original string was to get string of validChars
if (primaryPhone.Length > validChars.Count)
{
primaryPhone = primaryPhone.Remove(validChars.Count);
}
//Make sure phone number is 10 numerical digits
if (primaryPhone.Length == 10)
{
//Make sure "555" isn't in area code or first 3 digits of phone number
char[] areaCodeCheck = new char[3];
char[] digitCheck = new char[3];
primaryPhone.CopyTo(0, areaCodeCheck, 0, 3);
primaryPhone.CopyTo(3, digitCheck, 0, 3);
if (!new string(areaCodeCheck).Contains("555") && !new string(digitCheck).Contains("555"))
{
isPhoneNumberValid = true;
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_phone"));
}
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_phone"));
}
}while (!isPhoneNumberValid);
//Convert to (555)-555-5555 format
primaryPhone = primaryPhone.Insert(6, @"-");
primaryPhone = primaryPhone.Insert(3, @")-");
primaryPhone = primaryPhone.Insert(0, @"(");
//Reset for next phonenumber validation
isPhoneNumberValid = false;
do
{
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_secondary_phone"));
GetStringInput(out secondaryPhone);
//No input is a valid input because a secondary phone number is optional
if (secondaryPhone.Length == 0)
{
isPhoneNumberValid = true;
}
else if (secondaryPhone.Length > 0)
{
//Gets only characters included in the match pattern
MatchCollection validChars = regexNumerals.Matches(secondaryPhone);
//First add all valid characters to beginning of string...
for (int iii = 0; iii < validChars.Count; iii++)
{
secondaryPhone = secondaryPhone.Insert(iii, validChars[iii].Value);
}
//Now get rid of whatever the original string was to get string of validChars
if (secondaryPhone.Length > validChars.Count)
{
secondaryPhone = secondaryPhone.Remove(validChars.Count);
}
//Make sure phone number is 10 numerical digits or was left empty
if (secondaryPhone.Length == 10)
{
//Make sure "555" isn't in area code or first 3 digits of phone number
char[] areaCodeCheck = new char[3];
char[] digitCheck = new char[3];
secondaryPhone.CopyTo(0, areaCodeCheck, 0, 3);
secondaryPhone.CopyTo(3, digitCheck, 0, 3);
if (!new string(areaCodeCheck).Contains("555") && !new string(digitCheck).Contains("555"))
{
isPhoneNumberValid = true;
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_phone"));
}
}
else
{
Console.WriteLine();
Console.WriteLine(GetXmlText("invalid_phone"));
}
}
}while (!isPhoneNumberValid);
//Convert to (555)-555-5555 format
if (secondaryPhone.Length == 10)
{
secondaryPhone = secondaryPhone.Insert(6, @"-");
secondaryPhone = secondaryPhone.Insert(3, @")-");
secondaryPhone = secondaryPhone.Insert(0, @"(");
}
System.Random rand = new System.Random();
//Create a random, 10 digit password
for (int iii = 0; iii < password.Length; iii++)
{
int toggle = rand.Next(0, 2);
//Assign character
if (toggle == 0)
{
//Convert int to unicode string. Convert unicode string to char array. Get first element of array (the character).
char nextCharacter = char.ConvertFromUtf32(rand.Next(65, 90)).ToCharArray(0, 1)[0]; //Characters for A to Z
toggle = rand.Next(0, 2);
//Decide if upper or lower case
if (toggle == 0)
{
password[iii] = nextCharacter;
}
else if (toggle == 1)
{
//Convert character into its unicode integer. Add 32 to uppercase it.
int characterAsInt = char.ConvertToUtf32(nextCharacter.ToString(), 0) + 32;
//Convert uppercased integer unicode value back into character.
nextCharacter = char.ConvertFromUtf32(characterAsInt).ToCharArray(0, 1)[0];
password[iii] = nextCharacter;
}
}
//Assign number
else if (toggle == 1)
{
password[iii] = (rand.Next(0, 9)).ToString().ToCharArray()[0];
}
}
//Assign random PIN number when creating new account. Customer can change later.
//Make sure Customer PIN number intializes to 4 digits when creating new account.
//Ensure the PIN number digits are between 0 and 9
for (int iii = 0; iii < 4; iii++)
{
pin[iii] = (char)(rand.Next(0, 10)).ToString().ToCharArray()[0];
}
//Bring this back and move to AFTER Sql statements once email has been implemented
/*
* SmtpClient mailObject = new SmtpClient();
* mailObject.Host = "smtp.mail.yahoo.com";
* mailObject.EnableSsl = true;
* mailObject.Timeout = 10000;
* mailObject.DeliveryMethod = SmtpDeliveryMethod.Network;
* mailObject.UseDefaultCredentials = false;
*
* string smtpUsername = GetXmlText("../../system_info.xml", "system_info/smtp_username");
* string smtpPassword = GetXmlText("../../system_info.xml", "system_info/smtp_password");
*
* mailObject.Credentials = new System.Net.NetworkCredential(smtpUsername, smtpPassword);
* mailObject.Port = 465;
*
* try
* {
* mailObject.Send(
* from: "*****@*****.**",
* recipients: email,
* subject: firstName + " " + lastName + ": Your new Bank of C# account has been created",
* body: firstName + ",\n\nThank you for choosing Bank of C#\n\nYou have successfully created a new account. " +
* "Your login details and PIN are below\n\n" + "username:\n" + username +
* "\n\npassword:\n" + password.ToString() + "\n\nPIN:\n" + pin.ToString() + "\n\nThank you for your business!"
* );
* }
* catch(Exception e)
* {
* Console.WriteLine("E-mail failure in CreateAccountScene.RunScene(). " + e);
* throw;
* }
*/
//Email the user their password and PIN number
Console.WriteLine();
Console.WriteLine(
"Your new Bank of C# account has been created!" +
"\nThank you for choosing Bank of C#" +
"\n\nYour PIN: " + new string(pin) +
"\nUsername: "******"\nPassword: "******"\nThis information has been saved to C:\\BankProgram\\account_info.txt" +
"\n\nThank you for your business!");
Console.WriteLine();
if (!System.IO.Directory.Exists(@"C:\BankProgram"))
{
System.IO.Directory.CreateDirectory(@"C:\BankProgram");
}
System.IO.StreamWriter writer = new System.IO.StreamWriter(@"C:\BankProgram\account_info.txt", true);
writer.WriteLine("Username: "******"PIN: " + new string(pin));
writer.WriteLine("Password: "******"insert into customer_accounts ",
"(username, password, pin, balance, account_status, first_name, last_name, ",
"street_address, city, state, zip, email, primary_phone, secondary_phone) ",
"values(@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13);"
};
MySqlHelper.ExecuteNonQueryCommand(instructions, new string[] {
username, new string(password), new string(pin),
0.00f.ToString(), "ACTIVE", firstName, lastName, streetAddress,
city, state, zip, email, primaryPhone, secondaryPhone
});
//Bring this back once e-mail is set up correctly
/*
* Console.WriteLine();
* Console.WriteLine(GetXmlText("account_created" + email));
*/
Director.GetInstance().ChangeScene(new WelcomeScene());
return;
}
public override void RunScene(float framesPerSecond)
{
MySqlHelper.ConnectToMySql();
MySqlDataReader reader = null;
int id;
decimal currentBalance = 0.00M;
int dollarsToDeposit = 0;
int centsToDeposit = 0;
decimal amountToDeposit = 0.00M;
decimal newBalance = 0.00M;
string dollarsString;
string centsString;
if (!isLoggedIn)
{
do
{
Console.WriteLine(GetXmlText(@"general/enter_username"));
username = Console.ReadLine();
Console.WriteLine();
reader = MySqlHelper.ExecuteQueryCommand("select * from customer_accounts where username = @0;", new string[] { username });
//Make sure there is data for this username. No rows = no data.
if (!reader.HasRows)
{
reader.Close();
Console.WriteLine(GetXmlText(@"general/invalid_username") + "'{0}'", username);
Console.WriteLine();
}
}while (!reader.HasRows);
}
else
{
reader = MySqlHelper.ExecuteQueryCommand("select * from customer_accounts where username = @0;", new string[] { username });
}
//Get first (and only) record to get data from
reader.Read();
id = reader.GetInt32("id");
string pin = reader.GetString("pin");
currentBalance = reader.GetDecimal("balance");
reader.Close();
//CHECK PIN IF NOT LOGGED IN
if (!isLoggedIn)
{
bool isPINValid = CheckPIN(validPin: pin, attemptsAllowed: 5);
//EXIT TO WELCOME SCENE IF ATTEMPTS EXCEED LIMIT
if (!isPINValid)
{
Console.WriteLine(GetXmlText("general/attempts_exceeded"));
Console.WriteLine();
Director.GetInstance().ChangeScene(new WelcomeScene());
return;
}
}
bool isInputValid = false;
//Get dollars to deposit
do
{
Console.WriteLine(GetXmlText(@"deposit/deposit_dollars"));
dollarsString = Console.ReadLine();
Console.WriteLine();
if (dollarsString == "" || int.TryParse(dollarsString, out dollarsToDeposit))
{
//Can't deposit negative dollars
if (dollarsToDeposit >= 0)
{
isInputValid = true;
}
}
else
{
Console.WriteLine(GetXmlText(@"deposit/invalid_dollars"));
Console.WriteLine();
}
}while (!isInputValid);
//Reset switch for next check
isInputValid = false;
//Get cents to deposit
do
{
Console.WriteLine(GetXmlText(@"deposit/deposit_cents"));
centsString = Console.ReadLine();
Console.WriteLine();
if (centsString == "" || (int.TryParse(centsString, out centsToDeposit) && centsToDeposit >= 0 && centsToDeposit <= 99))
{
isInputValid = true;
}
else
{
Console.WriteLine(GetXmlText(@"deposit/invalid_cents"));
Console.WriteLine();
}
}while (!isInputValid);
amountToDeposit = dollarsToDeposit + centsToDeposit / 100.00M;
newBalance = currentBalance + amountToDeposit;
MySqlHelper.ExecuteNonQueryCommand("update customer_accounts set balance=@0 where id=@1;", new string[] { newBalance.ToString(), id.ToString() });
//CONFIRMATION
Console.WriteLine(GetXmlText("deposit/success") + GetXmlText("general/new_balance") + string.Format("${0:0.00}", newBalance));
Console.WriteLine();
Director.GetInstance().ChangeScene(new WelcomeScene());
return;
}
override public void RunScene(float framesPerSecond)
{
MySqlHelper.ConnectToMySql();
MySqlDataReader reader = null;
int id;
decimal currentBalance = 0.00M;
if (!isLoggedIn)
{
do
{
Console.WriteLine(GetXmlText(@"../../strings.xml", @"prompts/general/enter_username"));
username = Console.ReadLine();
Console.WriteLine();
reader = MySqlHelper.ExecuteQueryCommand("select * from customer_accounts where username = @0;", new string[] { username });
//Make sure there is data for this username. No rows = no data.
if (!reader.HasRows)
{
reader.Close();
Console.WriteLine(GetXmlText(@"../../strings.xml", @"prompts/general/invalid_username") + "'{0}'", username);
Console.WriteLine();
}
}while (!reader.HasRows);
}
else
{
reader = MySqlHelper.ExecuteQueryCommand("select * from customer_accounts where username = @0;", new string[] { username });
}
//Get first (and only) record to get data from
reader.Read();
id = reader.GetInt32("id");
string pin = reader.GetString("pin");
currentBalance = reader.GetDecimal("balance");
reader.Close();
//CHECK PIN IF NOT LOGGED IN
if (!isLoggedIn)
{
bool isPINValid = CheckPIN(validPin: pin, attemptsAllowed: 5);
//EXIT TO WELCOME SCENE IF ATTEMPTS EXCEED LIMIT
if (!isPINValid)
{
Console.WriteLine(GetXmlText(@"../../strings.xml", @"prompts/general/attempts_exceeded"));
Console.WriteLine();
Director.GetInstance().ChangeScene(new WelcomeScene());
return;
}
}
Console.WriteLine(GetXmlText("balance") + currentBalance.ToString());
Console.WriteLine();
Director.GetInstance().ChangeScene(new WelcomeScene());
return;
}
public override void RunScene(float framesPerSecond)
{
string selectionString;
int? selection = null;
Console.WriteLine(GetXmlText("greeting"));
Console.WriteLine(GetXmlText("assist"));
Console.WriteLine();
Console.WriteLine(GetXmlText("main_menu"));
Console.WriteLine();
Console.WriteLine(GetXmlText("enter_number"));
bool isSelectionValid = false;
do
{
//User didn't enter blank
if (GetStringInput(out selectionString))
{
//Assume true, will set to false if all cases fail
isSelectionValid = true;
//Check if user typed in phrase, or number along with phrase, or number + '.'
switch (selectionString[0])
{
//DEPOSIT FUNDS
case '1':
case 'd':
case 'D':
selection = 1;
break;
//WITHDRAW FUNDS
case '2':
case 'w':
case 'W':
selection = 2;
break;
//GET BALANCE STATEMENT
case '3':
case 'g':
case 'G':
case 'b':
case 'B':
case 's':
case 'S':
selection = 3;
break;
//CREATE NEW ACCOUNT
case '4':
case 'c':
case 'C':
case 'n':
case 'N':
case 'a':
case 'A':
selection = 4;
break;
//INVALID INPUT
default:
isSelectionValid = false;
Console.WriteLine();
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("assist"));
Console.WriteLine();
Console.WriteLine(GetXmlText("main_menu"));
Console.WriteLine();
break;
}
}
//User entered blank
else
{
Console.WriteLine(GetXmlText("error"));
Console.WriteLine();
Console.WriteLine(GetXmlText("assist"));
Console.WriteLine();
Console.WriteLine(GetXmlText("main_menu"));
Console.WriteLine();
}
}while (!isSelectionValid);
//Lower selection by one so it matches up to enumerated types
if (selection != null)
{
selection--;
}
Director director = Director.GetInstance();
switch (selection)
{
case (int)(SELECTION.DEPOSIT):
director.ChangeScene(new DepositScene());
break;
case (int)(SELECTION.WITHDRAW):
director.ChangeScene(new WithdrawScene());
break;
case (int)(SELECTION.STATEMENT):
director.ChangeScene(new StatementScene());
break;
case (int)(SELECTION.NEW):
director.ChangeScene(new CreateAccountScene());
break;
}
Console.WriteLine();
return;
}
