public int updateEvent() { eventDao dao = new eventDao(); int result = dao.updateEvent(this); return(result); }
public int findBookmark(int userId, int eventId) { eventDao dao = new eventDao(); int result = dao.insertBookmarkEvent(userId, eventId); return(result); }
public int AddEvent() { eventDao dao = new eventDao(); int result = dao.Insert(this); return(result); }
public int getMaxEventId() { eventDao dao = new eventDao(); int result = dao.queryCreatedEventId(); return(result); }
public int removeEvent(int eventId) { eventDao dao = new eventDao(); int result = dao.DeleteEvent(eventId); return(result); }
public int RemoveParticipant(int userId, int eventId) { eventDao dao = new eventDao(); int result = dao.DeleteParticipant(userId, eventId); return(result); }
public int removeBookmark(int userId, int eventId) { eventDao dao = new eventDao(); int result = dao.DeleteBookmark(userId, eventId); return(result); }
public int AddParticipant(int userId, int eventId, string userName) { int result = -1; eventDao dao = new eventDao(); var currentEvent = getEventDetails(eventId); var AttendingList = GetAllAttendingEventsByUserId(userId); bool sameTime = false; foreach (var evnt in AttendingList) { if (evnt.Date == currentEvent.Date) { string startTimeNumber = ""; string eventStartTime = evnt.StartTime.ToString(); string startFrontdigits = eventStartTime.Substring(0, 2); string startBackdigits = eventStartTime.Substring(3, 2); string endTimeNumber = ""; string eventEndTime = evnt.EndTime.ToString(); string endFrontdigits = eventEndTime.Substring(0, 2); string endBackdigits = eventEndTime.Substring(3, 2); string startTimeOfCurrentE = ""; string startTimeCurrent = currentEvent.StartTime.ToString(); string startFrontdigitsCurrent = startTimeCurrent.Substring(0, 2); string startEnddigitsCurrent = startTimeCurrent.Substring(3, 2); string EndTimeOfCurrentE = ""; string EndTimeCurrent = currentEvent.EndTime.ToString(); string EndFrontdigitsCurrent = EndTimeCurrent.Substring(0, 2); string EndBackdigitsCurrent = EndTimeCurrent.Substring(3, 2); startTimeNumber = startFrontdigits + startBackdigits; endTimeNumber = endFrontdigits + endBackdigits; startTimeOfCurrentE = startFrontdigitsCurrent + startEnddigitsCurrent; EndTimeOfCurrentE = EndFrontdigitsCurrent + EndBackdigitsCurrent; if (!(int.Parse(EndTimeOfCurrentE) <= int.Parse(startTimeNumber) || int.Parse(startTimeOfCurrentE) >= int.Parse(endTimeNumber))) { sameTime = true; break; } } } if (!sameTime) { result = dao.InsertParticipant(userId, eventId, userName); } return(result); }
public bool VerifyIfUserIsAttendingEvent(int UserId, int eventId) { eventDao ev = new eventDao(); return(ev.CheckIfAttending(UserId, eventId)); }
public List <Events> GetAllEvents() { eventDao ev = new eventDao(); return(ev.SelectAllEvents()); }
public int updateAvgRatingByEventId(int eventId, int avgRating) { eventDao dao = new eventDao(); return(dao.updateAvgRatingByEventId(eventId, avgRating)); }
public List <int> getAllParticipants(int eventId) { eventDao ev = new eventDao(); return(ev.SelectAllParticipants(eventId)); }
public List <Events> GetAllEventsByEDate(DateTime date) { eventDao ev = new eventDao(); return(ev.SelectAllByDate(date)); }
public bool VerifyIfEventIsBookmarked(int UserId, int eventId) { eventDao ev = new eventDao(); return(ev.CheckIfEventIsBookedmarked(UserId, eventId)); }
public List <Events> GetAllBookedmarkedEventsById(int UserId) { eventDao ev = new eventDao(); return(ev.SelectAllBookmarkedEvents(UserId)); }
public List <Events> GetAllEventsCreatedByUser(int UserId) // i am using for pprating -azim { eventDao ev = new eventDao(); return(ev.SelectAllEventsCreatedByUser(UserId)); }
public List <Events> GetAllAttendingEventsByUserId(int UserId) // i am using for ppgallery -azim { eventDao ev = new eventDao(); return(ev.SelectAllAttendingEventsByUserId(UserId)); }
public string GetAllUserNameByUserId(int userId) { eventDao ev = new eventDao(); return(ev.SelectUserNameByUserId(userId)); }
public Events getEventDetails(int eventId) { eventDao ev = new eventDao(); return(ev.getEventDetails(eventId)); }