private void dgvAttendees_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
{
// Ask the user for confirmation before deleting a row
if (MessageBox.Show(string.Format("Should {0} be removed from the Attendee List?", e.Row.Cells["Name"].Value),
"Delete Attendee", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
e.Cancel = true;
}
else
{
SeminarAttendee attendeeToDelete = null;
int attendeeId = (int)dgvAttendees.Rows[dgvAttendees.CurrentCell.RowIndex].Cells[1].Value;
foreach (User user in seminar.Attendees)
{
if (user.ID == attendeeId)
{
attendeeToDelete = (SeminarAttendee)user;
break;
}
}
if (attendeeToDelete != null)
{
DataInstance.deleteSeminarAttendee(seminar, attendeeToDelete);
}
else
{
MessageBox.Show("Error: Could not find selected attendee to delete");
}
}
}
/// <summary>
/// Adds attendee to DB
/// </summary>
public static void addAttendee(SeminarAttendee attendee)
{
using (SqlConnection conn = new SqlConnection())
{
//instantiate and open new connection using DB Connection string
conn.ConnectionString = _connectionString;
conn.Open();
//Create sql command to insert new seminar into db
SqlCommand cmdAddAttendee = new SqlCommand("INSERT INTO Person(Name, Email, PhoneNumber, IsAdmin, IsHost, IsAttendee, IsSpeaker, IsOrganiser) VALUES(@name, @email, @phoneNumber, 0, 0, 1, 0, 0);");
using (cmdAddAttendee)
{
//Adds parameter values for above statement
cmdAddAttendee.Parameters.AddWithValue("@name", attendee.Name);
cmdAddAttendee.Parameters.AddWithValue("@email", attendee.Email);
cmdAddAttendee.Parameters.AddWithValue("@phoneNumber", attendee.PhoneNumber);
cmdAddAttendee.Connection = conn;
//Execute query
cmdAddAttendee.ExecuteNonQuery();
}
}
attendee.Role = Authentication.GetRoleFromName(Role.Names.Attendee);
users.Add(attendee);
}
private void createAttendee()
{
int newAttendeesId = DataInstance.attendeeList.Last().ID + 1;
var newAttendee = new SeminarAttendee(newAttendeesId,
tbName.Text,
tbEmail.Text,
tbPhoneNumber.Text,
cbStatus.Text);
DataInstance.addAttendee(newAttendee);
seminarReference.Attendees.Add(newAttendee);
DataInstance.addSeminarAttendees(seminarReference, DataInstance.getAttendeeByEmail(newAttendee.Email), newAttendee.Status);
MessageBox.Show(newAttendee.Name + " has been registered to " + seminarReference.Title, "Successfully Registered", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (this.AttendeeRegistered != null)
{
this.AttendeeRegistered(this, new EventArgs());
}
}
/// <summary>
/// Deletes an attendee
/// </summary>
/// <param name="attendee"></param>
public static void deleteAttendee(SeminarAttendee attendee)
{
using (SqlConnection conn = new SqlConnection())
{
//instantiate and open new connection using DB Connection string
conn.ConnectionString = _connectionString;
conn.Open();
//Create sql command to insert new seminar into db
SqlCommand cmdDeleteAttendee = new SqlCommand("DELETE FROM Person WHERE ID = @attendeeId;");
using (cmdDeleteAttendee)
{
cmdDeleteAttendee.Parameters.AddWithValue("@attendeeId", attendee.ID);
cmdDeleteAttendee.Connection = conn;
//Execute query
cmdDeleteAttendee.ExecuteNonQuery();
}
}
}
public static void addSeminarAttendees(Seminar seminar, SeminarAttendee attendee, string status)
{
using (SqlConnection conn = new SqlConnection())
{
//instantiate and open new connection using DB Connection string
conn.ConnectionString = _connectionString;
conn.Open();
//Create sql command to insert new seminar into db
SqlCommand cmdAddSeminarAttendee = new SqlCommand("insert into SeminarAttendees(SeminarID, AttendeePersonID, Status) values(@seminarId, @attendeeId, @attendeeStatus); ");
using (cmdAddSeminarAttendee)
{
//Adds parameter values for above statement
cmdAddSeminarAttendee.Parameters.AddWithValue("@seminarId", seminar.ID);
cmdAddSeminarAttendee.Parameters.AddWithValue("@attendeeId", attendee.ID);
cmdAddSeminarAttendee.Parameters.AddWithValue("@attendeeStatus", status);
cmdAddSeminarAttendee.Connection = conn;
//Execute query
cmdAddSeminarAttendee.ExecuteNonQuery();
}
}
}
