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