/// <summary> /// Deletes a seminar host /// </summary> /// <param name="host"></param> public static void deleteHost(SeminarHost host) { 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 cmdDeleteHost = new SqlCommand("DELETE FROM Person WHERE ID = @hostId;"); using (cmdDeleteHost) { cmdDeleteHost.Parameters.AddWithValue("@hostId", host.ID); cmdDeleteHost.Connection = conn; //Execute query cmdDeleteHost.ExecuteNonQuery(); } } }
/// <summary> /// Adds a seminar host /// </summary> /// <param name="seminarHost"></param> public static void addHost(SeminarHost seminarHost) { 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, 1, 0, 0, 0);"); using (cmdAddOrganiser) { //Adds parameter values for above statement cmdAddOrganiser.Parameters.AddWithValue("@name", seminarHost.Name); cmdAddOrganiser.Parameters.AddWithValue("@email", seminarHost.Email); cmdAddOrganiser.Parameters.AddWithValue("@phoneNumber", seminarHost.PhoneNumber); cmdAddOrganiser.Connection = conn; //Execute query cmdAddOrganiser.ExecuteNonQuery(); } } }