private void AddLoc() { Add win = new PostgreSQL_APP.Add("location"); authorDt = pgsql.OutTable("get_author()"); win.comboBox1.ItemsSource = authorDt.DefaultView; win.comboBox1.DisplayMemberPath = "name"; win.comboBox1.SelectedValuePath = "id"; bookDt = pgsql.OutTable("get_book()"); win.comboBox2.ItemsSource = bookDt.DefaultView; win.comboBox2.DisplayMemberPath = "name"; win.comboBox2.SelectedValuePath = "id"; shelfDt = pgsql.OutTable("get_shelf()"); win.comboBox3.ItemsSource = shelfDt.DefaultView; win.comboBox3.DisplayMemberPath = "name"; win.comboBox3.SelectedValuePath = "id"; win.ShowDialog(); if (win.ok) { Location l = win.Location(); pgsql.SetParamsLocation(l.GetProcName, l.AuthorId, l.BookId, l.ShelfId, l.BooksCount); pgsql.Query(); MessageBox.Show("Успешно добавлено"); } }
private void AddPub() { Add win = new PostgreSQL_APP.Add("pub"); win.ShowDialog(); if (win.ok) { Publishing p = win.Publishing(); pgsql.SetParamsPublishing(p.GetProcName, p.PublishingName, p.PublishingCity); pgsql.Query(); MessageBox.Show("Успешно добавлено"); } }
private void AddAuthor() { Add win = new PostgreSQL_APP.Add("author"); win.ShowDialog(); if (win.ok) { Author a = win.Author(); pgsql.SetParamsAuthor(a.GetProcName, a.AuthorFirstName, a.AuthorName, a.AuthorPatronymic, a.AuthorCity); pgsql.Query(); MessageBox.Show("Успешно добавлено"); } }
private void AddShelf() { Add win = new PostgreSQL_APP.Add("shelf"); win.ShowDialog(); if (win.ok) { BookShelf bs = win.BookShelf(); pgsql.SetParamsBookShelf(bs.GetProcName, bs.ShelfName, bs.ShelfPosition); pgsql.Query(); MessageBox.Show("Успешно добавлено"); } }
private void AddBook() { Add win = new PostgreSQL_APP.Add("book"); pubDt = pgsql.OutTable("get_pub()"); win.comboBox2.ItemsSource = pubDt.DefaultView; win.comboBox2.DisplayMemberPath = "name"; win.comboBox2.SelectedValuePath = "id"; win.ShowDialog(); if (win.ok) { Book b = win.Book(); pgsql.SetParamsBook(b.GetProcName, b.BookName, b.BookPublishing, b.PublishingDate, b.PagesCount); pgsql.Query(); MessageBox.Show("Успешно добавлено"); } }