public int Create(Book book)
{
try
{
const string sqlExpression =
"INSERT INTO Book (Title, YearOfWriting, PublishingHouseID, LanguageBook) VALUES (@Title, @YearOfWriting, @PublishingHouseID, @LanguageBook)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var titleParam = new SqlParameter("@Title", book.BookTitle);
command.Parameters.Add(titleParam);
var yearOfWritingParam = new SqlParameter("@YearOfWriting", book.YearOfWriting);
command.Parameters.Add(yearOfWritingParam);
var publishingHouseIdParam = new SqlParameter("@PublishingHouseID", book.PublishingHouseID);
command.Parameters.Add(publishingHouseIdParam);
var languageBookIdParam = new SqlParameter("@LanguageBook", book.LanguageBook);
command.Parameters.Add(languageBookIdParam);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public int Create(Adaptations adaptation)
{
try
{
var sqlExpression = "INSERT INTO Adaptations (BookID, TypeAdaptation, Year_, Country) VALUES (@BookID, @TypeAdaptation, @Year_, @Country)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var bookIdParam = new SqlParameter("@BookID", adaptation.BookID);
command.Parameters.Add(bookIdParam);
var typeParam = new SqlParameter("@TypeAdaptation", adaptation.AdaptationType);
command.Parameters.Add(typeParam);
var yearParam = new SqlParameter("@Year_", adaptation.AdaptationYear);
command.Parameters.Add(yearParam);
var countryParam = new SqlParameter("@Country", adaptation.AdaptationCountry);
command.Parameters.Add(countryParam);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <Book> GetAll()
{
var listBook = new List <Book>();
const string sqlExpression = "SELECT * FROM Book";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listBook.Add(new Book(
(int)(dataReader["ID"]),
(string)(dataReader["Title"]),
(int)(dataReader["YearOfWriting"]),
(int)(dataReader["PublishingHouseID"]),
(string)(dataReader["LanguageBook"])));
}
}
}
return(listBook.AsEnumerable());
}
public int Create(Author author)
{
try
{
var sqlExpression = "INSERT INTO Author (FullName, DateOfBirth, PlaceOfBirth) VALUES (@FullName, @DateOfBirth, @PlaceOfBirth)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var fullNameParam = new SqlParameter("@FullName", author.AuthorFullName);
command.Parameters.Add(fullNameParam);
var dateParam = new SqlParameter("@DateOfBirth", author.AuthorDateOfBirth);
command.Parameters.Add(dateParam);
var placeParam = new SqlParameter("@PlaceOfBirth", author.AuthorPlaceOfBirth);
command.Parameters.Add(placeParam);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <BookIssuance> GetAll()
{
var listBookIssuance = new List <BookIssuance>();
const string sqlExpression = "SELECT * FROM BookIssuance";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listBookIssuance.Add(new BookIssuance(
(int)(dataReader["ID"]),
(DateTime)(dataReader["DateOfIssue"]),
(DateTime)(dataReader["DateOfCompletion"]),
(int)(dataReader["LibraryCard"]),
(int)(dataReader["BookCopyID"])));
}
}
}
return(listBookIssuance.AsEnumerable());
}
public int Create(Readers readers)
{
try
{
const string sqlExpression =
"INSERT INTO Readers (FullName, Age, AddressReader) VALUES (@FullName, @Age, @AddressReader)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var param2 = new SqlParameter("@FullName", readers.ReaderFullName);
command.Parameters.Add(param2);
var param3 = new SqlParameter("@Age", readers.ReaderAge);
command.Parameters.Add(param3);
var param4 = new SqlParameter("@AddressReader", readers.ReaderAddress);
command.Parameters.Add(param4);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public int Delete(int idGenre)
{
try
{
const string sqlExpression = "DELETE FROM Genre WHERE ID = @id";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var idParam = new SqlParameter("@id", idGenre);
command.Parameters.Add(idParam);
return(command.ExecuteNonQuery());
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public int Create(Fine fine)
{
try
{
const string sqlExpression = "INSERT INTO Fine (BookIssuanceID, Amount) VALUES (@BookIssuanceID, @Amount)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@BookIssuanceID", fine.BookIssuanceID);
command.Parameters.AddWithValue("@Amount", fine.FineAmount);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <Genre> GetAll()
{
var listGenre = new List <Genre>();
const string sqlExpression = "SELECT * FROM Genre";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listGenre.Add(new Genre(
(int)(dataReader["ID"]),
(string)(dataReader["Title"])));
}
}
}
return(listGenre.AsEnumerable());
}
public Readers GetById(int id)
{
const string sqlExpression =
"SELECT ID, FullName, Age, AddressReader FROM Readers where ID = @id";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@id", id);
using (var dataReader = command.ExecuteReader())
{
dataReader.Read();
return(new Readers(
(int)(dataReader["ID"]),
(string)(dataReader["FullName"]),
(int)(dataReader["Age"]),
(string)(dataReader["AddressReader"])));
}
}
}
public int Create(BookCopy bookCopy)
{
try
{
const string sqlExpression = "INSERT INTO BookCopy (BookID) VALUES (@BookID)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var idBookParam = new SqlParameter("@BookID", bookCopy.BookID);
command.Parameters.Add(idBookParam);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <BookCopy> GetAll()
{
var listBookCopy = new List <BookCopy>();
const string sqlExpression = "SELECT * FROM BookCopy";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listBookCopy.Add(new BookCopy(
(int)(dataReader["ID"]),
(int)(dataReader["BookID"])));
}
}
}
return(listBookCopy.AsEnumerable());
}
public int Create(Genre genre)
{
try
{
const string sqlExpression = "INSERT INTO Genre (Title) VALUES (@Title)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var param2 = new SqlParameter("@Title", genre.GenreTitle);
command.Parameters.Add(param2);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <Fine> GetAll()
{
var listFine = new List <Fine>();
const string sqlExpression = "SELECT * FROM Fine";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listFine.Add(new Fine(
(int)(dataReader["ID"]),
(int)(dataReader["BookIssuanceID"]),
(int)(dataReader["Amount"])));
}
}
}
return(listFine.AsEnumerable());
}
public IEnumerable <AuthorsAndBooks> GetAll()
{
var listAuthorsAndBooks = new List <AuthorsAndBooks>();
const string sqlExpression = "SELECT * FROM AuthorsAndBooks";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listAuthorsAndBooks.Add(new AuthorsAndBooks(
(int)(dataReader["ID"]),
(int)(dataReader["AuthorID"]),
(int)(dataReader["BookID"])));
}
}
}
return(listAuthorsAndBooks.AsEnumerable());
}
public BookIssuance GetById(int id)
{
const string sqlExpression =
"SELECT ID, DateOfIssue, DateOfCompletion, LibraryCard, BookCopyID FROM BookIssuance where ID = @id";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@id", id);
using (var dataReader = command.ExecuteReader())
{
dataReader.Read();
return(new BookIssuance(
(int)(dataReader["ID"]),
(DateTime)(dataReader["DateOfIssue"]),
(DateTime)(dataReader["DateOfCompletion"]),
(int)(dataReader["LibraryCard"]),
(int)(dataReader["BookCopyID"])));
}
}
}
public Book GetById(int id)
{
const string sqlExpression =
"SELECT ID, Title, YearOfWriting, PublishingHouseID, LanguageBook FROM Book where ID = @id";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@id", id);
using (var dataReader = command.ExecuteReader())
{
dataReader.Read();
return(new Book(
(int)(dataReader["ID"]),
(string)(dataReader["Title"]),
(int)(dataReader["YearOfWriting"]),
(int)(dataReader["PublishingHouseID"]),
(string)(dataReader["LanguageBook"])));
}
}
}
public IEnumerable <Author> GetAll()
{
var listAuthor = new List <Author>();
const string sqlExpression = "SELECT * FROM Author";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listAuthor.Add(new Author(
(int)(dataReader["ID"]),
(string)(dataReader["FullName"]),
(DateTime)(dataReader["DateOfBirth"]),
(string)(dataReader["PlaceOfBirth"])));
}
}
}
return(listAuthor.AsEnumerable());
}
public int Create(ListGenre listGenre)
{
try
{
const string sqlExpression = "INSERT INTO ListGenre (BookID, GenreID) VALUES (@BookID, @GenreID)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var param2 = new SqlParameter("@BookID", listGenre.BookID);
command.Parameters.Add(param2);
var param3 = new SqlParameter("@GenreID", listGenre.GenreID);
command.Parameters.Add(param3);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public int Create(PublishingHouse publishingHouse)
{
try
{
const string sqlExpression = "INSERT INTO PublishingHouse (Title, DateOfEstablishment) VALUES (@Title, @DateOfEstablishment)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
var param2 = new SqlParameter("@Title", publishingHouse.PublishingHouseTitle);
command.Parameters.Add(param2);
var param3 = new SqlParameter("@DateOfEstablishment", publishingHouse.DateOfEstablishment);
command.Parameters.Add(param3);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
public IEnumerable <Adaptations> GetAll()
{
var listAdaptations = new List <Adaptations>();
const string sqlExpression = "SELECT * FROM Adaptations";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listAdaptations.Add(new Adaptations(
(int)(dataReader["ID"]),
(int)(dataReader["BookID"]),
(string)(dataReader["TypeAdaptation"]),
(int)(dataReader["Year_"]),
(string)(dataReader["Country"])));
}
}
}
return(listAdaptations.AsEnumerable());
}
public IEnumerable <Readers> GetAll()
{
var listReaders = new List <Readers>();
const string sqlExpression = "SELECT * FROM Readers";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
using (var dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
listReaders.Add(new Readers(
(int)(dataReader["ID"]),
(string)(dataReader["FullName"]),
(int)(dataReader["Age"]),
(string)(dataReader["AddressReader"])));
}
}
}
return(listReaders.AsEnumerable());
}
public int Create(BookIssuance bookIssuance)
{
try
{
const string sqlExpression =
"INSERT INTO BookIssuance (DateOfIssue, DateOfCompletion, LibraryCard, BookCopyID) VALUES (@DateOfIssue, @DateOfCompletion, @LibraryCard, @BookCopyID)";
using (var connection = Dbsql.GetDbConnection())
{
connection.Open();
var command = new SqlCommand(sqlExpression, connection);
command.Parameters.AddWithValue("@DateOfIssue", bookIssuance.DateOfIssue);
command.Parameters.AddWithValue("@DateOfCompletion", bookIssuance.DateOfCompletion);
command.Parameters.AddWithValue("@LibraryCard", bookIssuance.LibraryCard);
command.Parameters.AddWithValue("@BookCopyID", bookIssuance.BookCopyID);
var number = command.ExecuteNonQuery();
return(number);
}
}
catch (SqlException e)
{
Console.WriteLine(e);
return(-1);
}
}
