private void LinkLabelSignup_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Enabled = false;
this.Hide();
formSignUp = new FormSignUp();
formSignUp.FormClosed += new System.Windows.Forms.FormClosedEventHandler(this.OtherForms_FormClosed);
formSignUp.buttonSignUp.Click += new System.EventHandler(this.FormSignUp_buttonSignUp_Click);
formSignUp.Show();
}
/// <summary>
/// Proceeds to the Account Settings Module.
/// </summary>
private void ButtonAccountSettings_Click(object sender, EventArgs e)
{
((Form)this.TopLevelControl).Enabled = false;
((Form)this.TopLevelControl).Hide();
formSignUp = new FormSignUp();
formSignUp.Text = "Account Settings";
formSignUp.textBoxUsername.Text = this.username;
formSignUp.textBoxUsername.Enabled = false;
formSignUp.FormClosed += new System.Windows.Forms.FormClosedEventHandler(this.FormSignUp_FormClosed);
formSignUp.buttonSignUp.Text = "Submit";
formSignUp.buttonSignUp.Click += new System.EventHandler(this.FormSignUp_buttonSignUp_Click);
using (SQLiteConnection database = new SQLiteConnection("Data Source = Database.sqlite; Version = 3;"))
{
database.Open();
sql = "SELECT Forename, Surname, DateOfBirth, Email, School "
+ "FROM " + accountType + "S "
+ "WHERE " + accountType + "S.AccountID = @AccountID;";
using (SQLiteCommand command = new SQLiteCommand(sql, database))
{
command.Parameters.Add(new SQLiteParameter("@AccountID", DbType.Int32)
{
Value = accountID
});
using (SQLiteDataReader reader = command.ExecuteReader())
{
reader.Read();
switch (accountType)
{
case "TEACHER":
formSignUp.radioButtonTeacher.Checked = true;
formSignUp.radioButtonStudent.Checked = false;
break;
case "STUDENT":
formSignUp.radioButtonTeacher.Checked = false;
formSignUp.radioButtonStudent.Checked = true;
break;
}
formSignUp.labelAccountType.Enabled = false;
formSignUp.labelRequiredFieldAccountType.Enabled = false;
formSignUp.radioButtonTeacher.Enabled = false;
formSignUp.radioButtonStudent.Enabled = false;
formSignUp.textBoxForename.Text = reader["Forename"].ToString();
formSignUp.textBoxSurname.Text = reader["Surname"].ToString();
formSignUp.textBoxDateOfBirth.Text = reader["DateOfBirth"].ToString();
formSignUp.textBoxEmail.Text = reader["Email"].ToString();
formSignUp.textBoxSchool.Text = reader["School"].ToString();
}
}
}
formSignUp.Show();
}
