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));
}
