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