public static bool addNewEvent(CalendarEvent e)
{
using (SqlConnection sqlConnection = new SqlConnection(CONNECTION_STRING))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO CalendarEvent (Name, Start, [End], CalendarId, Type) "+
"VALUES ('" + e.getName() + "','" + e.getStart().ToString() + "','" + e.getEnd().ToString() + "'," + e.getCalendarId() +
",'" + e.getType() + "')", sqlConnection))
{
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
sqlDataReader.Close();
}
}
sqlConnection.Close();
}
return true;
}
