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); }