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);
}
}
public string Create(BookIssuance bookIssuance)
{
var number = _bookIssuanceDao.Create(bookIssuance);
return(number > 0 ? $"Добавление успешно" : $"Ошибка при добавлении информации о выдаче книги");
}
