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(); }