public registerForm()
{
regClient = new DBClient();
cryptSvc = new Crypto();
newCustomer = new Customer();
newAddress = new BillingAddress();
InitializeComponent();
}
public Customer getCustomer(String uName)
{
Customer customer = new Customer();
customer.setFirstName(this.getCustomerFirstName(uName));
customer.setMiddleName(this.getCustomerMiddleName(uName));
customer.setLastName(this.getCustomerLastName(uName));
customer.setUserName(uName);
customer.setSuffix(this.getCustomerSuffix(uName));
customer.setGender(this.getCustomerGender(uName));
customer.setEmailAddress(this.getCustomerEMailAddress(uName));
return customer;
}
public Dashboard(String uName)
{
Username = uName;
loginClient = new DBClient();
user = new Customer();
player = new Player();
user = this.loginClient.getCustomer(uName);
player = this.loginClient.getPlayer(uName);
InitializeComponent();
this.usernameLbl.Text = user.getUserName();
this.HealthLbl.Text = player.getVitality().ToString();
this.DefenseLbl.Text = player.getDefense().ToString();
this.SpeedLbl.Text = player.getSpeed().ToString();
this.EXPLbl.Text = player.getExp().ToString();
this.TotalPlayTimeLbl.Text = player.getPlaytime().ToString();
this.ServerLbl.Text = player.getLastServer();
this.TotalKillLbl.Text = player.getTotalKills().ToString();
this.TotalDeathsLbl.Text = player.getTotalDeaths().ToString();
this.WelcomeLbl.Text = String.Concat(this.WelcomeLbl.Text, user.getFullName() + '!');
}
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;
}
