public BookmarkNews AddBookmark([FromBody] BookmarkNews _bookmarkNews) { Dse.ISession session = SessionManager.GetSession(); BookmarkNews bookMark = new BookmarkNews(); if (session == null) { StatusCode(204); return(null); } session.Execute("insert into \"BookmarkNews\" (\"username\", \"newsID\", title, imageURL, description, journalist, date_of_publication) values " + "('" + _bookmarkNews.username + "', '" + _bookmarkNews.newsID + "', '" + _bookmarkNews.title + "', '" + _bookmarkNews.imageURL + "', '" + _bookmarkNews.description + "', '" + _bookmarkNews.journalist + "', '" + _bookmarkNews.dateOfPublication + "')"); var data = session.Execute("select * from \"BookmarkNews\" where \"username\"='" + _bookmarkNews.username + "' and \"newsID\"='" + _bookmarkNews.newsID + "'"); foreach (var bookmarkedNewsData in data) { bookMark.username = bookmarkedNewsData["username"] != null ? bookmarkedNewsData["username"].ToString() : string.Empty; bookMark.newsID = bookmarkedNewsData["newsID"] != null ? bookmarkedNewsData["newsID"].ToString() : string.Empty; bookMark.title = bookmarkedNewsData["title"] != null ? bookmarkedNewsData["title"].ToString() : string.Empty; bookMark.imageURL = bookmarkedNewsData["imageurl"] != null ? bookmarkedNewsData["imageurl"].ToString() : string.Empty; bookMark.description = bookmarkedNewsData["description"] != null ? bookmarkedNewsData["description"].ToString() : string.Empty; bookMark.dateOfPublication = bookmarkedNewsData["date_of_publication"] != null ? bookmarkedNewsData["date_of_publication"].ToString() : string.Empty; bookMark.journalist = bookmarkedNewsData["journalist"] != null ? bookmarkedNewsData["journalist"].ToString() : string.Empty; } StatusCode(200); return(bookMark); }
public List <BookmarkNews> GetNewsByTag(string username) { Dse.ISession session = SessionManager.GetSession(); List <BookmarkNews> listOfTagedNews = new List <BookmarkNews>(); if (session == null) { return(null); } string query = "select * from \"BookmarkNews\" where \"username\"=\'" + username + "\'"; var allRows = session.Execute(query); if (allRows != null) { foreach (var BookmarkNewsData in allRows) { BookmarkNews news = new BookmarkNews(); news.newsID = BookmarkNewsData["newsID"] != null ? BookmarkNewsData["newsID"].ToString() : string.Empty; news.username = BookmarkNewsData["username"] != null ? BookmarkNewsData["username"].ToString() : string.Empty; news.title = BookmarkNewsData["title"] != null ? BookmarkNewsData["title"].ToString() : string.Empty; news.imageURL = BookmarkNewsData["imageurl"] != null ? BookmarkNewsData["imageurl"].ToString() : string.Empty; news.description = BookmarkNewsData["description"] != null ? BookmarkNewsData["description"].ToString() : string.Empty; news.dateOfPublication = BookmarkNewsData["date_of_publication"] != null ? BookmarkNewsData["date_of_publication"].ToString() : string.Empty; news.journalist = BookmarkNewsData["journalist"] != null ? BookmarkNewsData["journalist"].ToString() : string.Empty; listOfTagedNews.Add(news); } } return(listOfTagedNews); }