public static BookmarkDO BookmarkTableRowToDO(DataRow row) { BookmarkDO bookmarkDO = new BookmarkDO(); bookmarkDO.BookmarkID = int.Parse(row["BookmarkID"].ToString()); bookmarkDO.UserID = int.Parse(row["UserID"].ToString()); bookmarkDO.ReactorID = int.Parse(row["ReactorID"].ToString()); return(bookmarkDO); }
public static BookmarkDO BookmarkPOtoDO(BookmarkPO from) { BookmarkDO to = new BookmarkDO(); to.BookmarkID = from.BookmarkID; to.UserID = from.UserID; to.ReactorID = from.ReactorID; return(to); }
public List <BookmarkDO> ObtainBookmarksByUserID(int userID) { _logger.LogMessage("Info", "Obtain Bookmarks called", MethodBase.GetCurrentMethod().ToString(), "Request to obtain bookmarks for user with ID #" + userID + " received."); List <BookmarkDO> bookmarkList = new List <BookmarkDO>(); SqlConnection connectionToSql = null; SqlCommand obtainUserBookmarks = null; SqlDataAdapter adapter = null; DataTable bookmarkTable = new DataTable(); try { connectionToSql = new SqlConnection(_connectionString); obtainUserBookmarks = new SqlCommand("OBTAIN_USER_BOOKMARKS", connectionToSql); obtainUserBookmarks.CommandType = CommandType.StoredProcedure; obtainUserBookmarks.Parameters.AddWithValue("@UserID", userID); connectionToSql.Open(); adapter = new SqlDataAdapter(obtainUserBookmarks); adapter.Fill(bookmarkTable); foreach (DataRow row in bookmarkTable.Rows) { BookmarkDO bookmarkDO = Mapping.Mapper.BookmarkTableRowToDO(row); bookmarkList.Add(bookmarkDO); } if (bookmarkList.Count > 0) { _logger.LogMessage("BookmarkDO list obtained."); } else { _logger.LogMessage("No bookmarks found."); } } catch (Exception ex) { _logger.LogMessage(ex, "Fatal"); throw ex; } finally { if (connectionToSql != null) { connectionToSql.Close(); connectionToSql.Dispose(); } if (adapter != null) { adapter.Dispose(); } } return(bookmarkList); }