//Добавление нового издательства, жанра или автора private void btnAddNew_Click(object sender, EventArgs e) { string type = tbAddNew.Text; string sqlQuery; switch (cbAddNew.SelectedIndex) { case 0: { sqlQuery = @"INSERT INTO [Author] (shortName, fullName) VALUES ('" + type + "', '" + type + "')"; ClassAddInfo.AddInfo(type, sqlQuery, cbAuthor); FillAuthors(); }; break; case 1: { sqlQuery = @"INSERT INTO [Genre] (genre) VALUES ('" + type + "')"; ClassAddInfo.AddInfo(type, sqlQuery, cbGenre); FillGenres(); }; break; case 2: { sqlQuery = @"INSERT INTO [Publishing] (namePublishing) VALUES ('" + type + "')"; ClassAddInfo.AddInfo(type, sqlQuery, cbPublishing); FillPublishing(); }; break; } }
//Удаление private void btnDelete_Click(object sender, EventArgs e) { string sqlQueryDel; switch (hat) { case "genres": { sqlQueryDel = @"DELETE [Genre] WHERE idGenre = @Param"; ClassAddInfo.DeleteInfo(sqlQueryDel, tableInfo); FillGenres(); }; break; case "publishing": { sqlQueryDel = @"DELETE [Publishing] WHERE idPublishing = @Param"; ClassAddInfo.DeleteInfo(sqlQueryDel, tableInfo); FillPublishing(); }; break; case "authors": { sqlQueryDel = @"DELETE [Author] WHERE idAuthor = @Param"; ClassAddInfo.DeleteInfo(sqlQueryDel, tableInfo); FillAuthors(); }; break; } }