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 InviteFriends(List <User> friends, EventC crtEvent) { string title = this.Username + " invited you at an event!"; Notification notification = new Notification(Statics.GetMaxId(TabeleDB.Notifications), title, crtEvent.GetDescription(), crtEvent.GetEndingDate(), friends); SqlCommand insertNotification = new SqlCommand { Connection = Statics.conn, CommandText = "INSERT INTO Notification VALUES(@id, @title, @description, @endingDate, @friends" }; insertNotification.Parameters.AddWithValue("@id", notification.GetId()); insertNotification.Parameters.AddWithValue("@title", notification.GetTitle()); insertNotification.Parameters.AddWithValue("@description", notification.GetDescription()); insertNotification.Parameters.AddWithValue("@endingDate", notification.GetExpireDate()); insertNotification.Parameters.AddWithValue("@friends", Statics.SerializeObject(notification.GetUsersToAppear())); insertNotification.ExecuteNonQuery(); }