public bool insertNewCustomer(Customer newCustomer)
{
bool customerSuccessful = false;
inputString = "INSERT INTO Customer(First_Name,Middle_Name,Last_Name,Suffix,Email_Address,Phone_Number,Username,Passwd_Hash,Gender) " +
"VALUES(\'" + newCustomer.getFirstName() + "\',\'" + newCustomer.getMiddleName() + "\',\'" + newCustomer.getLastName() + "\',\'" +
newCustomer.getSuffix() + "\',\'" + newCustomer.getEmailAddress() + "\',\'" + newCustomer.getPhone() + "\',\'" + newCustomer.getUserName() +
"\',\'" + "" + "\',\'" + newCustomer.getGender() + "\');";
sqlComm.CommandText = inputString;
try
{
sqlComm.ExecuteNonQuery();
customerSuccessful = true;
}
catch(MySqlException sqle)
{
MessageBox.Show("Error " + sqle.Number + " has occurred: " + sqle.Message + ".", "Registration Form", MessageBoxButtons.OK, MessageBoxIcon.Error);
customerSuccessful = false;
return false;
}
if(customerSuccessful == true)
{
insertNewAddress(newCustomer.getAddress(), newCustomer.getEmailAddress());
insertNewPlayer(newCustomer.getUserName());
insertNewCharacter(newCustomer.getUserName());
insertNewInventory(newCustomer.getUserName());
return true;
}
return false;
}
