///<summary>
///get the book information from it's ID
///</summary>
///<param name="bookid">ID of the book</param>
///<returns>Book information</returns>
public static Book getBookById(int bookid)
{
SqlHelper db = new SqlHelper();
string sql = "select * from Book where BookId=@id";
DbCommand command = db.GetSqlStringCommond(sql);
db.AddInParameter(command, "@id", System.Data.DbType.Int32, bookid);
using (DbDataReader reader = db.ExecuteReader(command))
{
if (!reader.Read())
{
return(null);
}
Book book = new Book();
book.id = bookid;
book.title = reader["BookTitle"].ToString();
book.author1 = Convert.ToString(reader["Author1"]);
book.author2 = Convert.ToString(reader["Author2"]);
book.author3 = Convert.ToString(reader["Author3"]);
book.price = Convert.ToDouble(reader["Price"]);
book.discount = Convert.ToDouble(reader["Discount"]);
book.realPrice = Convert.ToDouble(reader["RealPrice"]);
book.publisherID = Convert.ToInt32(reader["PublisherID"]);
book.publisherName = Convert.ToString(reader["PublisherName"]);
book.smallImage = Convert.ToString(reader["SmallImage"]);
book.bigImage = Convert.ToString(reader["BigImage"]);
book.saleSum = Convert.ToInt32(reader["SaleSum"]);
book.saleSum = Convert.ToInt32(reader["SaleSum"]);
book.clickCount = Convert.ToInt32(reader["ClickCount"]);
book.content = Convert.ToString(reader["Contents"]);
book.description = Convert.ToString(reader["Description"]);
book.publishDate = Convert.ToDateTime(reader["PublishDate"]);
reader.Close();
return(book);
}
}
