private void addDataIntoRegister()
{
Club club = new Club();
Member member = new Member();
// get student id for register table
member.setName(studentNameTextbox.Text);
studentID = member.getMemberID(member.getName());
// get club id for register table
string clubName = club.getClubNameDisplay(session);
int clubID = club.getClubIDFromPresident(session);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.register values(" + studentID + "," + clubID + ",CURRENT_TIMESTAMP, " + club.getClubFeesFromDb(clubID) + ", '0')";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
}
