private void EditPub() { Edit win = new PostgreSQL_APP.Edit("pub"); int num = PubTable.SelectedIndex; if (num == -1) { throw new Exception("Не выбрана строка для изменения!"); } int id = (int)pubDt.Rows[num][0]; win.textBox.Text = (string)pubDt.Rows[num][1]; win.textBox1.Text = (string)pubDt.Rows[num][2]; win.ShowDialog(); if (win.ok) { Publishing p = win.Publishing(); pgsql.SetParamsPublishing(p.GetEditProcName, p.PublishingName, p.PublishingCity, id); pgsql.Query(); MessageBox.Show("Успешно изменено\nОбновите таблицу"); } }
private void EditShelf() { Edit win = new PostgreSQL_APP.Edit("shelf"); int num = ShelfTable.SelectedIndex; if (num == -1) { throw new Exception("Не выбрана строка для изменения!"); } int id = (int)shelfDt.Rows[num][0]; win.textBox.Text = (string)shelfDt.Rows[num][1]; win.textBox1.Text = (string)shelfDt.Rows[num][2]; win.ShowDialog(); if (win.ok) { BookShelf bs = win.BookShelf(); pgsql.SetParamsBookShelf(bs.GetEditProcName, bs.ShelfName, bs.ShelfPosition, id); pgsql.Query(); MessageBox.Show("Успешно изменено\nОбновите таблицу"); } }
private void EditAuthor() { try { Edit win = new PostgreSQL_APP.Edit("author"); int num = AuthorTable.SelectedIndex; if (num == -1) { throw new Exception("Не выбрана строка для изменения!"); } int id = (int)authorDt.Rows[num][0]; //pgsql.StartTransaction(id); win.textBox.Text = (string)authorDt.Rows[num][1]; win.textBox1.Text = (string)authorDt.Rows[num][2]; win.textBox2.Text = (string)authorDt.Rows[num][3]; win.textBox3.Text = authorDt.Rows[num][4].ToString(); int version = Convert.ToInt32(pgsql.GetEditRecord("select version from \"Author\" where id=@id", id).Rows[0][0]); win.ShowDialog(); if (win.ok) { Author a = win.Author(); if (Convert.ToInt32(pgsql.GetEditRecord("select version from \"Author\" where id=@id", id).Rows[0][0]) != version) { throw new Exception("Запись была изменена\nПожалуйста, измените запись снова"); } pgsql.SetParamsAuthor(a.GetEditProcName, a.AuthorFirstName, a.AuthorName, a.AuthorPatronymic, a.AuthorCity, id); pgsql.Query(); pgsql.EditVersionOfRecord(id); MessageBox.Show("Успешно изменено\nОбновите таблицу"); } //pgsql.CompleteTransaction(); } catch (Exception q) { //pgsql.RollBackTransaction(); throw new Exception(q.Message); } }
private void EditLoc() { Edit win = new PostgreSQL_APP.Edit("location"); int num = LocationTable.SelectedIndex; if (num == -1) { throw new Exception("Не выбрана строка для изменения!"); } int id = (int)locationDt.Rows[num][0]; authorDt = pgsql.OutTable("get_author()"); win.comboBox.ItemsSource = authorDt.DefaultView; win.comboBox.DisplayMemberPath = "name"; win.comboBox.SelectedValuePath = "id"; bookDt = pgsql.OutTable("get_book()"); win.comboBox1.ItemsSource = bookDt.DefaultView; win.comboBox1.DisplayMemberPath = "name"; win.comboBox1.SelectedValuePath = "id"; shelfDt = pgsql.OutTable("get_shelf()"); win.comboBox2.ItemsSource = shelfDt.DefaultView; win.comboBox2.DisplayMemberPath = "name"; win.comboBox2.SelectedValuePath = "id"; win.comboBox.Text = locationDt.Rows[num][1].ToString(); win.comboBox1.Text = locationDt.Rows[num][2].ToString(); win.comboBox2.Text = locationDt.Rows[num][3].ToString(); win.textBox3.Text = locationDt.Rows[num][4].ToString(); win.ShowDialog(); if (win.ok) { Location l = win.Location(); pgsql.SetParamsLocation(l.GetEditProcName, l.AuthorId, l.BookId, l.ShelfId, l.BooksCount, id); pgsql.Query(); MessageBox.Show("Успешно изменено\nОбновите таблицу"); } }
private void EditBook() { try { // pgsql.StartTransaction(); Edit win = new PostgreSQL_APP.Edit("book"); int num = BookTable.SelectedIndex; if (num == -1) { throw new Exception("Не выбрана строка для изменения!"); } int id = (int)bookDt.Rows[num][0]; pubDt = pgsql.OutTable("get_pub()"); win.comboBox1.ItemsSource = pubDt.DefaultView; win.comboBox1.DisplayMemberPath = "name"; win.comboBox1.SelectedValuePath = "id"; win.textBox.Text = (string)bookDt.Rows[num][1]; win.comboBox1.Text = (string)bookDt.Rows[num][2]; win.textBox2.Text = (string)bookDt.Rows[num][3]; win.textBox3.Text = bookDt.Rows[num][4].ToString(); win.ShowDialog(); if (win.ok) { Book b = win.Book(); pgsql.SetParamsBook(b.GetEditProcName, b.BookName, b.BookPublishing, b.PublishingDate, b.PagesCount, id); pgsql.Query(); MessageBox.Show("Успешно изменено\nОбновите таблицу"); //pgsql.CompleteTransaction(); } } catch (Exception q) { //pgsql.RollBackTransaction(); throw new Exception(q.Message); } }