public void Update(BooksStaroseletsEV book)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "UPDATE Books SET Name = @name, Publisher = @publisher, Anotation = @anotation, Binding = @binding, Year = @year, Count = @count, Author = @author, Ganres = @ganres " +
"WHERE idBooks = @id";
db.Execute(sqlQuery, book);
}
}
public void Create(BooksStaroseletsEV book)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var sqlQuery = "INSERT INTO Books (Name, Publisher, Anotation, Binding, Year, Author, Ganres, Count) " +
"VALUES(@name, @publisher, @anotation, @binding, @year, @author, @ganres, @count)";
db.Execute(sqlQuery, book);
}
}
