public bool addComment(Int64 eventId, string userName, string commentBody)
{
SqlParameter[] commentParams = new SqlParameter[3];
EventData eventDetails = new EventData();
commentParams[0] = new SqlParameter("@EventId", eventId);
commentParams[1] = new SqlParameter("@UserName", userName);
commentParams[2] = new SqlParameter("@CommentBody", commentBody);
return this.ExecuteNonQuery("Comments_Insert", CommandType.StoredProcedure, commentParams);
}
public bool checkUserIsAlreadyParticipant(Int64 EventId, string userName)
{
SqlParameter[] eventIdParams = new SqlParameter[2];
EventData eventDetails = new EventData();
string userId = this.getUserIdFromUserName(userName);
eventIdParams[0] = new SqlParameter("@EventId", EventId);
eventIdParams[1] = new SqlParameter("@UserId", userId);
return (this.ExecuteParamerizedSelectCommand("Participants_GetEventParticipant", CommandType.StoredProcedure, eventIdParams).Rows.Count != 0);
}
public bool removeEvent(Int64 EventId)
{
SqlParameter[] eventIdParams = new SqlParameter[1];
EventData eventDetails = new EventData();
eventIdParams[0] = new SqlParameter("@EventId", EventId);
return this.ExecuteNonQuery("Events_DeleteEvents", CommandType.StoredProcedure, eventIdParams);
}
public EventData retrieveEventDetailsFromId(Int64 EventId)
{
SqlParameter[] eventIdParams = new SqlParameter[1];
EventData eventDetails = new EventData();
DataTable data;
eventIdParams[0] = new SqlParameter("@EventId", EventId);
data = this.ExecuteParamerizedSelectCommand(GetEventFromId, CommandType.StoredProcedure, eventIdParams);
eventDetails.EventName = data.Rows[0]["EventName"].ToString();
eventDetails.Location = data.Rows[0]["Location"].ToString();
eventDetails.StartDateTime = data.Rows[0]["StartDateTime"].ToString();
eventDetails.EndDateTime = data.Rows[0]["EndDateTime"].ToString();
eventDetails.Description = data.Rows[0]["Description"].ToString();
eventDetails.MaxParticipants = Int32.Parse(data.Rows[0]["MaxParticipants"].ToString());
eventDetails.MinParticipants = Int32.Parse(data.Rows[0]["MinParticipants"].ToString());
eventDetails.OwnerId = data.Rows[0]["OwnerId"].ToString();
return eventDetails;
}
public bool leaveEvent(Int64 EventId, string userName)
{
SqlParameter[] eventIdParams = new SqlParameter[2];
EventData eventDetails = new EventData();
string userId = this.getUserIdFromUserName(userName);
eventIdParams[0] = new SqlParameter("@EventId", EventId);
eventIdParams[1] = new SqlParameter("@UserId", userId);
return this.ExecuteNonQuery("Events_LeaveEvent", CommandType.StoredProcedure, eventIdParams);
}
