public static List <QuerySettings> GetBooksQuerySettingsOrPrintErrorMessage(string bookName, string fioAutor, string category,
string picture, bool isPictureNeedToEdit, int yearOfIssue, bool isYearOfIssueNeedToEdit)
{
List <QuerySettings> querySettings = new List <QuerySettings>();
string errorMessage = "";
if (!string.IsNullOrEmpty(bookName))
{
if (DatabaseSelectorSomeInformation.IsBookExists(bookName))
{
errorMessage += "\n" + "Книга с таким названием уже существует";
}
querySettings.Add(new QuerySettings("nameBook", bookName));
}
if (!string.IsNullOrEmpty(fioAutor))
{
int idAutor = DatabaseSelectorSomeInformation.GetIdAutor(fioAutor);
querySettings.Add(new QuerySettings("idAutor", idAutor.ToString()));
}
if (!string.IsNullOrEmpty(category))
{
querySettings.Add(new QuerySettings("category", category));
}
if (!string.IsNullOrEmpty(picture) && isPictureNeedToEdit)
{
querySettings.Add(new QuerySettings("picture", picture));
}
if (isYearOfIssueNeedToEdit)
{
querySettings.Add(new QuerySettings("yearOfIssue", yearOfIssue.ToString()));
}
if (!string.IsNullOrEmpty(errorMessage))
{
PrintMessage.WarningMessage(errorMessage, "Перед редактированием устраните следующие ошибки:");
return(null);
}
else
{
return(querySettings);
}
}
public static void InsertIntoBooks(Book book)
{
int idAutor = DatabaseSelectorSomeInformation.GetIdAutor(book.FioAutor);
string query = "Insert into Books values(default," +
"'" + book.NameBook + "'," +
"" + idAutor + "," +
"" + "0," +
"'" + book.Category + "'," +
"'" + book.Picture + "'," +
"" + book.YearOfIssue + ")";
Connection.Open();
MySqlCommand command = new MySqlCommand(query, Connection);
command.ExecuteNonQuery();
command.Dispose();
Connection.Close();
}
