//Добавление нового издательства, жанра или автора
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;
}
}
