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();
}
public static List <EventC> LoadEvents(EventType type, User user)
{
List <EventC> list = new List <EventC>();
SqlCommand getEvents = new SqlCommand
{
Connection = Statics.conn,
CommandText = "SELECT * FROM Event"
};
SqlDataReader reader = getEvents.ExecuteReader();
while (reader.Read())
{
EventC crtEvent = new EventC(reader);
crtEvent.GetEventType(user);
list.Add(crtEvent);
}
reader.Close();
return(list);
}
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();
}
