public Seminar(int id, SeminarOrganiser organiser, Room room, List <Speaker> speakers, BindingList <SeminarAttendee> attendees,
string title, string description, DateTime startDate, DateTime endDate)
{
this.Organiser = organiser;
this.Room = room;
this.Speakers = speakers;
this.Attendees = attendees;
this.Title = title;
this.Description = description;
this.StartDate = startDate;
this.EndDate = endDate;
this.ID = id;
}
/// <summary>
/// Deletes a seminar organiser
/// </summary>
/// <param name="organiser"></param>
public static void deleteOrganiser(SeminarOrganiser organiser)
{
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 cmdDeleteOrganiser = new SqlCommand("DELETE FROM Person WHERE ID = @organiserId;");
using (cmdDeleteOrganiser)
{
cmdDeleteOrganiser.Parameters.AddWithValue("@organiserId", organiser.ID);
cmdDeleteOrganiser.Connection = conn;
//Execute query
cmdDeleteOrganiser.ExecuteNonQuery();
}
}
}
/// <summary>
/// Adds a seminar organiser
/// </summary>
/// <param name="seminarOrganiser"></param>
public static void addOrganiser(SeminarOrganiser seminarOrganiser)
{
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 cmdAddOrganiser = new SqlCommand("INSERT INTO Person(Name, Email, PhoneNumber, IsAdmin, IsHost, IsAttendee, IsSpeaker, IsOrganiser) VALUES(@name, @email, @phoneNumber, 0, 0, 0, 0, 1);");
using (cmdAddOrganiser)
{
//Adds parameter values for above statement
cmdAddOrganiser.Parameters.AddWithValue("@name", seminarOrganiser.Name);
cmdAddOrganiser.Parameters.AddWithValue("@email", seminarOrganiser.Email);
cmdAddOrganiser.Parameters.AddWithValue("@phoneNumber", seminarOrganiser.PhoneNumber);
cmdAddOrganiser.Connection = conn;
//Execute query
cmdAddOrganiser.ExecuteNonQuery();
}
}
seminarOrganiser.Role = Authentication.GetRoleFromName(Role.Names.Organiser);
}
public void setOrganiser(SeminarOrganiser organiser)
{
cbOrganisers.SelectedIndex = Utils.GetAllOrganisers().IndexOf(organiser);//DataInstance.organisers.IndexOf(organiser);
}
