public void CreateEvent(string name, DateTime startingDate, DateTime endingDate, DateTime startingHour, DateTime endingHour, string description, List <User> participantsList, int minParticipants, int maxParticipants, string locationAddress) { EventC crtEvent = new EventC(Statics.GetMaxId(TabeleDB.Events), name, startingDate, endingDate, startingHour, endingHour, description, participantsList, minParticipants, maxParticipants, locationAddress); this.CreatedEventsList.Add(crtEvent); SqlCommand addEventDb = new SqlCommand { Connection = Statics.conn, CommandText = "INSERT INTO Event VALUES(@id, @name, @stDate, @endDate, @stHour, @endHour, @desc, " + "@partic, @minP, @maxP, @addr)" }; addEventDb.Parameters.AddWithValue("@id", crtEvent.GetId()); addEventDb.Parameters.AddWithValue("@name", crtEvent.GetName()); addEventDb.Parameters.AddWithValue("@stDate", crtEvent.GetStartingDate()); addEventDb.Parameters.AddWithValue("@endDate", crtEvent.GetEndingDate()); addEventDb.Parameters.AddWithValue("@stHour", crtEvent.GetStartingHour()); addEventDb.Parameters.AddWithValue("@endHour", crtEvent.GetEndingDate()); addEventDb.Parameters.AddWithValue("@desc", crtEvent.GetDescription()); addEventDb.Parameters.AddWithValue("@partic", crtEvent.GetParticipantsList()); addEventDb.Parameters.AddWithValue("@minP", crtEvent.GetMinParticipants()); addEventDb.Parameters.AddWithValue("@maxP", crtEvent.GetMinParticipants()); addEventDb.Parameters.AddWithValue("@addr", crtEvent.GetLocationAddress()); addEventDb.ExecuteNonQuery(); UpdateUserCreatedEvents(); }
private void JoinEvent(EventC crtEvent, bool join) { if (join == true) { crtEvent.GetParticipantsList().Add(this); } else { crtEvent.GetParticipantsList().Remove(this); } SqlCommand updateEvent = new SqlCommand { Connection = Statics.conn, CommandText = "UPDATE Event SET ParticipantsList = @list WHERE Id = @id" }; updateEvent.Parameters.AddWithValue("@list", Statics.SerializeObject(crtEvent.GetParticipantsList())); updateEvent.Parameters.AddWithValue("@id", crtEvent.GetId()); updateEvent.ExecuteNonQuery(); }