private List <BookRatings> GetBookRatings(string safeSql) { List <BookRatings> list = new List <BookRatings>(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, CommandType.Text, safeSql); if (ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; foreach (DataRow row in dt.Rows) { BookRatings brating = new BookRatings(); brating.Id = (int)row["Id"]; brating.BookId = (int)row["BookId"]; brating.Rating = (int)row["Rating"]; int userId = (int)row["userid"]; brating.User = new UserService().GetUserById(userId); brating.Comment = (string)row["Comment"]; brating.CreatedTime = (DateTime)row["CreatedTime"]; list.Add(brating); } } return(list); }
public bool AddBookRating(BookRatings bookrating) { string sql = "INSERT BookRatings (BookId,UserId,Rating,Comment)" + "VALUES (@BookId, @UserId, @Rating, @Comment)"; sql += " ; SELECT @@IDENTITY"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BookId", bookrating.BookId), new SqlParameter("@UserId", bookrating.User.Id), new SqlParameter("@Rating", bookrating.Rating), new SqlParameter("@Comment", bookrating.Comment) }; bookrating.Id = Convert.ToInt32(SqlHelper.ExecuteScalar(this.connection, CommandType.Text, sql, para)); return(bookrating.Id > 0); }
public bool AddBookRating(BookRatings bookrating) { return(new BooksRatingService().AddBookRating(bookrating)); }