private void loadClubData()
{
President p = new President();
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select * from dbo.Club where president_id = " + p.getPresidentID(session);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
Club club = new Club();
club.setClubName(reader.GetString(2));
club.setClubFees(reader.GetDecimal(3));
club.setClubDescription(reader.GetString(4));
// show value for edit
societyName.Text = club.getClubName();
societyFees.Text = club.getClubFees();
beautifyDescription();
societyDescription.Text = club.getClubDescription();
// automate value on textfield
societyNameTextbox.Text = club.getClubName();
feesLabel.Text = club.getClubFees();
societyDescriptionTextbox.Text = club.getClubDescription();
// close connection
connect.close();
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("error " + ex);
}
}
private void updateClubDatabase(string session, string clubname)
{
if (clubname == "")
{
return;
}
else
{
President p = new President();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update dbo.club set president_id = " + p.getPresidentID(session) +
" where club_name = '" + clubname + "'";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
}
}
private void updateButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertData)
{
President p = new President();
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update dbo.President set president_name = '" + updateNameTextbox.Text + "', president_email = '" + updateEmailTextbox.Text +
"', president_gender = '" + genderCombobox.Text + "', president_password = '******' where president_id = " + p.getPresidentID(session);
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
// register updated name for session on data retrieval
p.setPresidentName(updateNameTextbox.Text);
this.session = p.getPresidentName();
MessageBox.Show("Your account details had update successfully! ");
openView();
}
catch (Exception ex)
{
MessageBox.Show("error" + ex);
}
openView();
loadPresidentData();
}
else
{
MessageBox.Show("Update action is INVALID \n because some field is empty or wrong. ");
}
}
private void registerButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertPresidentData)
{
President pred = new President();
pred.setPresidentName(nameTextbox.Text);
pred.setPresidentEmail(emailTextbox.Text);
pred.setPresidentGender(genderCombobox.Text);
pred.setPresidentPassword(pwTextbox.Text, retypepwTextbox.Text);
if (pred.getPasswordBoolean() == false)
{
MessageBox.Show("Your password does not match, please retype again.");
}
else
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.President values ('" + getClubID(posCombobox.Text) +
"','" + pred.getPresidentName() + "','" + pred.getPresidentEmail() + "','"
+ pred.getPresidentGender() + "','" + pred.getPresidentPassword() + "');";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
MessageBox.Show("Your account had been created successfully! ");
Dashboard dashboard = new Dashboard(pred.getPresidentName(), posCombobox.Text);
this.Hide();
dashboard.ShowDialog();
}
}
}
public int getClubIDFromPresident(string presidentName)
{
President pres = new President();
int presidentID = pres.getPresidentID(presidentName);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select club_id from dbo.Club where president_id = " + presidentID;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
clubID = Convert.ToInt32(reader["club_id"].ToString());
}
reader.Close();
connect.close();
return(clubID);
}
public string getClubNameDisplay(string presidentName)
{
President pres = new President();
int presidentID = pres.getPresidentID(presidentName);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select club_name from dbo.Club where president_id = " + presidentID;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
clubName_display = reader["club_name"].ToString();
}
reader.Close();
connect.close();
return(clubName_display);
}