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 string Create(Adaptations adaptation)
{
var number = _adaptationsDao.Create(adaptation);
return(number > 0 ? $"Добавление успешно" : $"Ошибка при добавлении адаптации");
}
