// <summary>
/// Thêm 1 cuốn sách
/// </summary>
/// <param name="book"></param>
/// <param name="imageURL"></param>
/// <returns>trả về ID của cuốn sách được thêm</returns>
public int Insert(Book book, string imageURL, string Authors, string Category)
{
//db.Books.Add(book);
var imageBool = new ImageBool();
var image = db.ImageBools.Add(imageBool);
//string qrInsertImage = "insert into Images values (" + image.ImageBoolID + ", N'" + imageURL + "')";
//db.Database.ExecuteSqlCommand(qrInsertImage);
string InsertBook = "insert into Books values (N'" + book.Name + "'," + book.PublisherID + ",N'" + book.PublicationDate + "',N'1',N'" + book.Overview + "',N'" + book.Details + "',N'" + book.Price + "',N'" + book.TotalQuantity + "',N'" + book.ViewCount + "',0,N'" + book.TotalQuantity + "')";
db.Database.ExecuteSqlCommand(InsertBook);
db.SaveChanges();
string qrAuthorBook = "insert into AuthorsBooks (AuthorID, BookID) values (" + Authors + ", (SELECT IDENT_CURRENT('Books') as LastID))";
db.Database.ExecuteSqlCommand(qrAuthorBook);
string qrCategoryBook = "insert into CategoriesBooks (BookID, CategoryID) values ( (SELECT IDENT_CURRENT('Books') as LastID) , " + Category + ")";
db.Database.ExecuteSqlCommand(qrCategoryBook);
db.SaveChanges();
string qrInsertImage = "insert into Images values (" + image.ImageBoolID + ", N'" + imageURL + "');";
string updateBookImage = "update Books set ImageBoolID = " + image.ImageBoolID + " where BookID = (SELECT IDENT_CURRENT('Books') as LastID)";
db.Database.ExecuteSqlCommand(qrInsertImage);
db.Database.ExecuteSqlCommand(updateBookImage);
db.SaveChanges();
return(book.BookID);
}
// <summary>
/// Thêm 1 cuốn sách
/// </summary>
/// <param name="book"></param>
/// <param name="imageURL"></param>
/// <returns>trả về ID của cuốn sách được thêm</returns>
public int Insert(Book book, string imageURL)
{
db.Books.Add(book);
var imageBool = new ImageBool();
var image = db.ImageBools.Add(imageBool);
db.SaveChanges();
string qrInsertImage = "insert into Images values (" + image.ImageBoolID + ", N'" + imageURL + "');";
string updateBookImage = "update Books set ImageBoolID = " + image.ImageBoolID + " where BookID = " + book.BookID;
db.Database.ExecuteSqlCommand(qrInsertImage);
db.Database.ExecuteSqlCommand(updateBookImage);
db.SaveChanges();
return(book.BookID);
}
/// <summary>
/// Thêm vào 1 tác giả dựa trên ID
/// </summary>
/// <param name="author"></param>
/// <returns>trả về ID của tác giả được chọn</returns>
public int Insert(Author author, string imageURL)
{
db.Authors.Add(author);
//tạo mới 1 imagebool
var imageBool = new ImageBool();
var image = db.ImageBools.Add(imageBool);
db.SaveChanges();
//câu lệnh thêm URL của 1 tác giả trên SQL
string qrInsertImage = "insert into Images values (" + image.ImageBoolID + ", N'" + imageURL + "');";
//câu lệnh sửa imageboolID của 1 tác giả
string updateAuthorImage = "update Authors set ImageBoolID = " + image.ImageBoolID + " where AuthorID = " + author.AuthorID;
db.Database.ExecuteSqlCommand(qrInsertImage);
db.Database.ExecuteSqlCommand(updateAuthorImage);
db.SaveChanges();
return(author.AuthorID);
}
