private void ButtonAddPublisher_Click(object sender, EventArgs e) { if (!IsReadyForAdd()) { return; } string publisherName = textBoxPublisherName.Text.Trim(); string address = textBoxAddress.Text.Trim(); string phone = textBoxPhone.Text.Trim(); string fax = textBoxFax.Text.Trim(); string email = textBoxEmail.Text.Trim(); Publisher publisher = new Publisher() { PublisherName = publisherName, Address = address, Phone = phone, Fax = fax, Email = email }; int publisherID = PublisherDAO.AddNewPublisher(publisher); MessageBox.Show("Publisher Added Successful!"); if (containerForm is AddBookForm addBookForm) { addBookForm.UpdateComboBoxPublishers(publisherID); addBookForm.ClearAddNewPanel(); } else if (containerForm is EditBookForm editBookForm) { editBookForm.UpdateComboBoxPublishers(publisherID); editBookForm.ClearAddNewPanel(); } }
public AddBookForm(Employee e, FrmMenu menuForm) { this.EMPLOYEE = e; this.menuForm = menuForm; InitializeComponent(); publishers = PublisherDAO.SelectAllPublishers(); categories = CategoryDAO.SelectAllCategories(); }
public EditBookForm(int bookID, FrmMenu frmMenu, Employee e) { InitializeComponent(); this.bookID = bookID; this.frmMenu = frmMenu; EMPLOYEE = e; authors = AuthorDAO.SelectAllAuthors(); publishers = PublisherDAO.SelectAllPublishers(); categories = CategoryDAO.SelectAllCategories(); }
public void UpdateComboBoxPublishers(int publisherID) { comboBoxPublishers.Items.Clear(); publishers = PublisherDAO.SelectAllPublishers(); for (int index = 0; index < publishers.Count; index++) { Publisher publisher = publishers[index]; comboBoxPublishers.Items.Add(publisher.PublisherName); if (publisher.PublisherID == publisherID) { comboBoxPublishers.SelectedIndex = index; } } }
private void TextBoxPublisherName_TextChanged(object sender, EventArgs e) { string publisherName = textBoxPublisherName.Text.Trim(); if (publisherName.Length == 0) { labelPublisherNameMessage.ForeColor = Color.Red; labelPublisherNameMessage.Text = "Publisher Name is required"; return; } List <Publisher> publishers = PublisherDAO.SelectAllPublishers(); foreach (Publisher publisher in publishers) { if (publisher.PublisherName.Equals(publisherName)) { labelPublisherNameMessage.ForeColor = Color.Red; labelPublisherNameMessage.Text = "Publisher Name already existed"; return; } } labelPublisherNameMessage.ForeColor = Color.Green; labelPublisherNameMessage.Text = "Publisher Name is OK"; }
public SearchBookPanel(Form containerForm) { this.containerForm = containerForm; authors = AuthorDAO.SelectAllAuthors(); publishers = PublisherDAO.SelectAllPublishers(); categories = CategoryDAO.SelectAllCategories(); Size = new Size(1205, 265); groupBox = new GroupBox() { Text = "Search Book", Location = new Point(12, 12), Size = new Size(1190, 250) }; labelTitle = new Label() { Text = "Title", AutoSize = true, Location = new Point(6, 23), Size = new Size(27, 13) }; textBoxTitle = new TextBox() { Location = new Point(69, 19), Size = new Size(175, 20) }; labelAuthor = new Label() { Text = "Author", AutoSize = true, Location = new Point(6, 49), Size = new Size(38, 13) }; comboBoxAuthors = new ComboBox() { Location = new Point(69, 46), Size = new Size(175, 21) }; labelPublisher = new Label() { Text = "Publisher", AutoSize = true, Location = new Point(6, 76), Size = new Size(30, 13) }; comboBoxPublishers = new ComboBox() { Location = new Point(69, 73), Size = new Size(175, 21) }; labelCategories = new Label() { Text = "Categories", AutoSize = true, Location = new Point(6, 103), Size = new Size(57, 13) }; checkedListBoxCategories = new CheckedListBox() { ScrollAlwaysVisible = true, Location = new Point(69, 103), Size = new Size(175, 94) }; labelPublicationDate = new Label() { Text = "Publication Date", AutoSize = true, Location = new Point(6, 204), Size = new Size(85, 13) }; comboBoxPublicationDate = new ComboBox() { Location = new Point(9, 221), Size = new Size(82, 21) }; labelMonth = new Label() { Text = "Month", AutoSize = true, Location = new Point(97, 204), Size = new Size(37, 13) }; comboBoxMonth = new ComboBox() { Location = new Point(97, 221), Size = new Size(72, 21) }; labelYear = new Label() { Text = "Year", AutoSize = true, Location = new Point(172, 204), Size = new Size(29, 13) }; numericUpDownYear = new NumericUpDown() { Location = new Point(175, 222), Size = new Size(69, 20) }; labelSearchResult = new Label() { Text = "Search Result", AutoSize = true, Location = new Point(250, 16), Size = new Size(74, 13) }; dataGridViewSearchResult = new DataGridView() { AllowUserToAddRows = false, AllowUserToDeleteRows = false, AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells, Location = new Point(253, 32), Size = new Size(600, 210) }; AddControls(); AddItemsToComboBoxAuthors(); AddItemsToComboBoxPublishers(); AddItemsToCheckedListBoxCategories(); AddItemsToComboBoxPublicationDate(); AddItemsToComboBoxMonth(); AddItemsToNumericUpDownYear(); AddEventsToControls(); UpdateDataGridViewSearchResult(); }