private void updateButton_Click(object sender, EventArgs e)
{
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();
MessageBox.Show("Your account details had update successfully! ");
openView();
}
catch (Exception ex)
{
MessageBox.Show("error" + ex);
}
loadPresidentData();
openView();
}
private void createButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertClubData)
{
decimal societyFees = Convert.ToDecimal(societyFeesTextbox.Text);
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.Club values (NULL, '" + societyNameTextbox.Text + "'," + societyFees + ",'" + societyDescriptionTextbox.Text + "');";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
MessageBox.Show("Your society had created successfully, please click [Refresh] to display your society in the list. ");
this.Hide();
}
catch (Exception ex)
{
MessageBox.Show("error" + ex);
}
}
}
public int getMemberID()
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select student_id from dbo.Student where student_name = '" + getName()
+ "' and student_handphone = " + getHP()
+ " and student_email = '" + getEmail()
+ "' and student_gender = '" + getGender()
+ "' and student_intakecode = '" + getIntakeCode() + "'";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
memberID = Convert.ToInt32(reader["student_id"].ToString());
}
reader.Close();
connect.close();
return(memberID);
}
private void deleteButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertStudentData)
{
Member member = new Member(studentNameTextbox.Text, Convert.ToInt64(studenthpTextbox.Text), studentEmailTextbox.Text,
studentGenderCombobox.Text, intakeCodeTextbox.Text);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "delete from dbo.Register where student_id = " + studentID;
SqlDataReader reader = command.ExecuteReader();
deleteMemberFromStudent();
reader.Close();
connect.close();
displayAllField(); // display all the data
clearField(); // clear text field
// return success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Member information DELETE successfully ! ";
}
else
{
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "DELETE action is INVALID \n because you haven't select a member! ";
}
}
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();
}
public int getSecureMeetingID()
{
Club club = new Club();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select meeting_id from dbo.Meeting where meeting_name = '"
+ getMeetingName()
+ "' and meeting_location = '" + getMeetingLocation()
+ "' and meeting_description = '" + getMeetingDescription()
+ "' and meeting_starttime = '" + getStartTime()
+ "' and meeting_endtime = '" + getEndTime()
+ "' and club_id = " + club.getClubIDFromPresident(session);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
meetingID = Convert.ToInt32(reader["meeting_id"].ToString());
}
reader.Close();
connect.close();
return(meetingID);
}
private void updateSocietyButton_Click(object sender, EventArgs e)
{
President p = new President();
decimal societyFees = Convert.ToDecimal(societyFeesTextbox.Text);
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update dbo.Club set club_name = '" + societyNameTextbox.Text + "', club_fees = " + societyFees +
", club_description = '" + societyDescriptionTextbox.Text + "' where president_id = " + p.getPresidentID(session);
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
MessageBox.Show("Your society had update successfully! ");
showView();
}
catch (Exception ex)
{
MessageBox.Show("error" + ex);
}
loadClubData();
showView();
}
private void submitButton_Click(object sender, EventArgs e)
{
for (int i = attendanceList.Rows.Count - 1; i >= 0; i--)
{
bool attend = (bool)attendanceList.Rows[i].Cells[4].Value;
if (attend)
{
Member m = new Member();
Meeting mt = new Meeting(session);
mt.setName(meetingCombobox.Text);
President p = new President();
string name = attendanceList.Rows[i].Cells[0].Value.ToString();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.Attendance values (" + m.getMemberID(name) + ","
+ mt.getMeetingID() + "," + p.getPresidentID(session) + ",'1')";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
}
}
MessageBox.Show("Your attendance had updated! ");
navigation();
}
private void signInButton_Click(object sender, EventArgs e)
{
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select * from dbo.President where PRESIDENT_NAME = '" + usernameTextbox.Text + "' and PRESIDENT_PASSWORD = '******'";
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
reader.Close();
connect.close();
createDashboard(usernameTextbox.Text); // proceed to dashboard if login criteria is correct
}
else
{
MessageBox.Show("Incorrect username and password combination.");
reader.Close();
connect.close();
}
}
catch (Exception ex)
{
MessageBox.Show("error" + ex);
}
}
// delete Member from student table
private void deleteMemberFromStudent()
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "delete from dbo.Student where student_id = " + studentID;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
}
public void loadClubCombobox()
{
SqlConn conn = new SqlConn();
SqlDataAdapter sda = new SqlDataAdapter("select club_name from dbo.Club", conn.sqlConnection);
DataTable dt = new DataTable();
sda.Fill(dt);
posCombobox.Items.Clear();
foreach (DataRow item in dt.Rows)
{
posCombobox.Items.Add(item[0].ToString());
}
}
private void updateButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertMeetingData)
{
Meeting m = new Meeting(session);
m.setName(nameTextbox.Text);
m.setLocation(locationTextbox.Text);
m.setStartTime(datePicker.Value, startTimePicker.Value);
m.setEndTime(datePicker.Value, endTimePicker.Value);
m.setDescription(descriptionTextbox.Text);
m.calculateDuration();
Club club = new Club();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update dbo.meeting set meeting_name = '" + m.getMeetingName()
+ "', meeting_location = '" + m.getMeetingLocation()
+ "', meeting_description = '" + m.getMeetingDescription()
+ "', meeting_starttime = '" + m.getStartTime()
+ "', meeting_endtime = '" + m.getEndTime()
+ "', meeting_duration = " + m.getDuration() +
"where meeting_id = " + meetingID + " and club_id = " + club.getClubIDFromPresident(session);
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
// success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Update meeting details successful. ";
displayAllField();
clearField();
}
else
{
MessageBox.Show("Your UPDATE action is INVALID because some field is empty or wrong");
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "UPDATE action is INVALID \n because some field is empty or wrong ! ";
}
addButton.Visible = true;
}
public void loadClubCombobox()
{
Club club = new Club();
SqlConn sqlConn = new SqlConn();
SqlDataAdapter sda = new SqlDataAdapter("select meeting_name from dbo.meeting where club_id = " + club.getClubIDFromPresident(session), sqlConn.sqlConnection);
DataTable dt = new DataTable();
sda.Fill(dt);
meetingNameComboBox.Items.Clear();
foreach (DataRow item in dt.Rows)
{
meetingNameComboBox.Items.Add(item[0].ToString());
}
}
private void deleteExpiredMeeting()
{
string queryMeeting = identifyExpiredMeetingIDQuery();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = queryMeeting;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
}
private void updateButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertStudentData)
{
Member member = new Member(studentNameTextbox.Text, Convert.ToInt64(studenthpTextbox.Text), studentEmailTextbox.Text,
studentGenderCombobox.Text, intakeCodeTextbox.Text);
// get club id for register table
Club club = new Club();
int clubID = club.getClubIDFromPresident(session);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update s set s.student_name = '" + member.getName() +
"', s.student_handphone = " + member.getHP() +
", s.student_email = '" + member.getEmail() +
"', s.student_gender = '" + member.getGender() +
"', s.student_intakecode = '" + member.getIntakeCode() +
"' from student as s inner join register as r on s.student_id = r.student_id inner join club as c on r.club_id = c.club_id where r.student_id = " +
studentID + " and r.club_id = " + clubID;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
displayAllField(); // display all the data
clearField(); // clear text field
// return success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Member information UPDATE successfully ! ";
}
else
{
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "UPDATE action is INVALID \n because some field is empty or wrong ! ";
}
addButton.Visible = true;
}
private void loadPresidentData()
{
President p = new President();
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select * from dbo.President where president_id = " + p.getPresidentID(session);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
President pred = new President();
pred.setPresidentName(reader.GetString(2));
pred.setPresidentEmail(reader.GetString(3));
pred.setPresidentGender(reader.GetString(4));
pred.setPresidentPassword(reader.GetString(5), reader.GetString(5));
// show value for edit
name.Text = pred.getPresidentName();
email.Text = pred.getPresidentEmail();
gender.Text = pred.getPresidentGender();
pw.Text = pred.getPresidentPassword();
// automate value on textfield
updateNameTextbox.Text = pred.getPresidentName();
pwTextbox.Text = pred.getPresidentPassword();
genderCombobox.Text = pred.getPresidentGender();
updateEmailTextbox.Text = pred.getPresidentEmail();
// close connection
connect.close();
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("error " + ex);
}
}
private void updateButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertStudentData)
{
// calculate the fees even though without pressing the button
calculateFees();
// determine the paid status if the fees left is zero
Fee f = new Fee();
f.setFeesLeft(leftFees);
int paidStatus = f.calculatePaidStatus();
// get club id for register table
Club club = new Club();
int clubID = club.getClubIDFromPresident(session);
// get student id for register table
Member member = new Member();
member.setName(studNameLabel.Text);
int studentID = member.getMemberID(member.getName());
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "update r set r.member_fees = " + leftFees + ", member_paid = " + paidStatus + " from student as s inner join register as r on s.student_id = r.student_id inner join club as c on r.club_id = c.club_id where r.student_id = " +
studentID + " and r.club_id = " + clubID;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
displayFeeSummary(); // display all the fees summary
clearField(); // clear text field */
MessageBox.Show("The club fee had UPDATED successfully! ");
}
else
{
MessageBox.Show("UPDATE action is INVALID \nbecause some field is empty or wrong !");
}
}
private void addButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertMeetingData)
{
Meeting m = new Meeting(session);
m.setName(nameTextbox.Text);
m.setLocation(locationTextbox.Text);
m.setStartTime(datePicker.Value, startTimePicker.Value);
m.setEndTime(datePicker.Value, endTimePicker.Value);
m.setDescription(descriptionTextbox.Text);
m.calculateDuration();
Club club = new Club();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.meeting values (" + club.getClubIDFromPresident(session) +
",'" + m.getMeetingName() + "','" + m.getMeetingLocation() + "','" + m.getMeetingDescription() +
"','" + m.getStartTime() + "','" + m.getEndTime() + "'," + m.getDuration() + ")";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
// success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Create meeting successful. ";
displayAllField();
clearField();
}
else
{
MessageBox.Show("Your action is INVALID because some field is empty or wrong");
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "INSERT action is INVALID \n because some field is empty or wrong ! ";
}
}
// display data in datagridview base on query
private void displayData(string query)
{
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = query;
SqlDataAdapter storage = new SqlDataAdapter(command); //store the data get from database
DataTable datatable = new DataTable(); //put data into this table
storage.Fill(datatable);
attendanceList.DataSource = datatable; //datagridtable get data from the data table
connect.close();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
if (attendanceList.Columns.Contains("CheckBox"))
{
attendanceList.Columns.Remove("CheckBox");
}
chk.HeaderText = "Attendance";
chk.Name = "CheckBox";
chk.FalseValue = false;
attendanceList.Columns.Add(chk);
foreach (DataGridViewColumn dc in attendanceList.Columns)
{
dc.ReadOnly = (dc.Index.Equals(4)) ? false : true;
}
foreach (DataGridViewRow row in attendanceList.Rows)
{
row.Cells[4].Value = false;
}
}
private void loadDataIntoDetails()
{
Meeting m = new Meeting(session);
Club club = new Club();
m.setName(meetingNameComboBox.Text);
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select * from dbo.Meeting where meeting_name = '" + m.getMeetingName() + "' and club_id = " + club.getClubIDFromPresident(session);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
m.setName(reader.GetString(2));
m.setLocation(reader.GetString(3));
m.setDescription(reader.GetString(4));
m.setStartDate(reader.GetDateTime(5));
m.setEndDate(reader.GetDateTime(6));
// automate value on textfield
nameLabel.Text = m.getMeetingName();
locationLabel.Text = m.getMeetingLocation();
startTimeLabel.Text = m.getStartDate().ToString();
endTimeLabel.Text = m.getEndDate().ToString();
descriptionLabel.Text = m.getMeetingDescription().ToString();
durationLabel.Text = m.getReportDurationText().ToString();
// close connection
connect.close();
reader.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("error " + ex);
}
}
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 deleteButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertMeetingData)
{
Meeting m = new Meeting(session);
m.setName(nameTextbox.Text);
m.setLocation(locationTextbox.Text);
m.setStartTime(datePicker.Value, startTimePicker.Value);
m.setEndTime(datePicker.Value, endTimePicker.Value);
m.setDescription(descriptionTextbox.Text);
m.calculateDuration();
Club club = new Club();
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "delete dbo.meeting where meeting_id = " + meetingID + " and club_id = " + club.getClubIDFromPresident(session);
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
// success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Delete meeting details successful. ";
displayAllField();
clearField();
}
else
{
MessageBox.Show("Your Delete action is INVALID because you did not specifiy a meeting details");
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "Your Delete action is INVALID because you did not specifiy a meeting details";
}
}
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 displayAttendance(string query)
{
try
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = query;
SqlDataAdapter storage = new SqlDataAdapter(command); //store the data get from database
DataTable datatable = new DataTable(); //put data into this table
storage.Fill(datatable);
attendanceList1.DataSource = datatable; //datagridtable get data from the data table
connect.close();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
private int getClubID(string clubName)
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select club_id from dbo.Club where club_name = '" + clubName + "'";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
clubID = Convert.ToInt32(reader["club_id"].ToString());
}
reader.Close();
connect.close();
return(clubID);
}
// add button helps insert student data into database.
private void addButton_Click(object sender, EventArgs e)
{
validateEmptyField();
if (insertStudentData)
{
Member member = new Member(studentNameTextbox.Text, Convert.ToInt64(studenthpTextbox.Text), studentEmailTextbox.Text,
studentGenderCombobox.Text, intakeCodeTextbox.Text);
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "insert into dbo.Student values ('" + member.getName() + "'," + member.getHP() + ",'"
+ member.getEmail() + "','" + member.getGender() + "','" + member.getIntakeCode() + "')";
SqlDataReader reader = command.ExecuteReader();
reader.Close();
connect.close();
//execute another query insert into register table
addDataIntoRegister();
displayAllField(); // display all the data
clearField(); // clear text field
// return success message
messageText.ForeColor = System.Drawing.Color.Green;
messageText.Text = "Member information INSERT successfully ! ";
}
else
{
MessageBox.Show("Your action is INVALID because some field is empty or wrong");
// warning message
messageText.ForeColor = System.Drawing.Color.Red;
messageText.Text = "INSERT action is INVALID \n because some field is empty or wrong";
}
}
public int getPresidentID(string presidentName)
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select president_id from dbo.President where president_name = '" + presidentName + "'";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
pred_id = Convert.ToInt32(reader["president_id"].ToString());
}
reader.Close();
connect.close();
return(pred_id);
}
public decimal getClubFeesFromDb(int clubID)
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
command.CommandText = "select club_fees from dbo.Club where club_id = " + clubID;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
clubFees = Convert.ToDecimal(reader["club_fees"].ToString());
}
reader.Close();
connect.close();
return(clubFees);
}
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. ");
}
}
public int getMeetingID()
{
SqlConn connect = new SqlConn();
connect.open();
SqlCommand command = new SqlCommand();
command.Connection = connect.sqlConnection;
//command.CommandText = "select meeting_id from dbo.Meeting where club_name = " + clubName;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
meetingID = Convert.ToInt32(reader["meeting_id"].ToString());
}
reader.Close();
connect.close();
return(meetingID);
}