public List<Event_Types> GetEventTypes()
        {
            Event_Types ev = new Event_Types();
            List<Event_Types> eventList = new List<Event_Types>();

            string selectString = "SELECT * FROM EventTypes ";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(selectString, conn);
                SqlDataReader reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        ev.Description = reader.GetString(reader.GetOrdinal("Name"));
                        ev.Id = reader.GetInt32(reader.GetOrdinal("id"));
                        eventList.Add(ev);
                    }
                }

                conn.Close();
            }

            return eventList;
        }
        public void DeleteEventTypes(Event_Types ev)
        {
            string deleteString = "DELETE FROM EventTypes WHERE id = '" + ev.Id + "'";
            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();

                SqlCommand command = new SqlCommand(deleteString, conn);
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
        public void InsertEventTypes(Event_Types ev)
        {
            string insertString = "INSERT INTO EventTypes(Description) values(@description)";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(insertString, conn);

                command.Parameters.Add("@description", ev.Description);
                command.CommandType = CommandType.Text;
                command.ExecuteNonQuery();

                conn.Close();
            }
        }
        public Event_Types SearchEventTypes(int evID)
        {
            Event_Types ev = new Event_Types();
            ev.Id = evID;

            string searchString = "SELECT * FROM EventTypes where id = " + ev.Id;

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();
                SqlCommand command = new SqlCommand(searchString, conn);
                SqlDataReader reader = command.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        ev.Description = reader.GetString(reader.GetOrdinal("Description"));
                    }
                }

                conn.Close();
            }

            return ev;
        }
        public void UpdateEventTypes(Event_Types ev)
        {
            string updateString = "UPDATE EventTypes SET Description = @description WHERE event.id = '" + ev.Id + "'";

            using (conn = new SqlConnection(connectionString))
            {
                conn.Open();

                SqlCommand command = new SqlCommand(updateString, conn);
                command.Parameters.Add("@description", ev.Description);
                command.ExecuteNonQuery();

                conn.Close();
            }
        }