private void btnUpdate_Click(object sender, EventArgs e) { var title = txtTitleUpdate.Text; if (string.IsNullOrEmpty(txtID.Text) || string.IsNullOrEmpty(title)) { MessageBox.Show("ID or Title cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var query = $"UPDATE {TableConstants.LibraryType} SET {TableConstants.LibraryTypeTitleStr} = '{title}'," + $" {TableConstants.LibraryTypeSKUStr} = '{txtSKUUpdate.Text}'," + $" {TableConstants.LibraryTypePriceStr} = '{txtPriceUpdate.Text}'," + $" {TableConstants.LibraryTypeQuantityStr} = '{txtQuantityUpdate.Text}'," + $" {TableConstants.LibraryTypeQuantityBrokenStr} = '{txtQuantityBrokenUpdate.Text}'," + $" {TableConstants.LibraryTypeISBNCodeStr} = '{txtISBNCodeUpdate.Text}'," + $" {TableConstants.LibraryTypePublishDateStr} = TO_DATE('{dtpPublishDateUpdate.Value.ToString(formatDateTime)}', '{formatDateTime}')," + $" {TableConstants.LibraryTypePublisherIDStr} = '{cbxPublisherUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeEditionIDStr} = '{cbxEditionUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeEditorIDStr} = '{cbxEditorUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeFormatIDStr} = '{cbxFormatUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeLanguageIDStr} = '{cbxLanguageUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeCategoryIDStr} = '{cbxCategoryUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeCopyrightIDStr} = '{cbxCopyrightUpdate.SelectedValue}'," + $" {TableConstants.LibraryTypeAuthorIDStr} = '{cbxAuthorUpdate.SelectedValue}', " + $" {TableConstants.LibraryTypeStatusIDStr} = '{cbxStatusUpdate.SelectedValue}' " + $" WHERE {TableConstants.LibraryTypeIDStr} = '{txtID.Text}'"; HandlingDataHelper.UpdateData(null, null, title, "Library Type Title", query, "LibraryType", false); // Load Search tab to search the update book by the updated Title LoadSearchTab(title); }
private void btnUpdateAuthor_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeAuthor SET LibraryTypeAuthorName = '{txtAuthorNameUpdate.Text}', LibraryTypeAuthorEmail = '{txtAuthorEmailUpdate.Text}', LibraryTypeAuthorCountry = '{txtAuthorCountryUpdate.Text}' WHERE LibraryTypeAuthorID = {txtAuthorID.Text}"; HandlingDataHelper.UpdateData(dgvAuthor, DataGridViewHeader.listOfColumnsAuthor, txtAuthorID.Text, "Author ID", query, "LibraryTypeAuthor"); }
private void btnUpdateCopyright_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeCopyright SET LibraryTypeCopyrightName = '{txtCopyrightNameUpdate.Text}' WHERE LibraryTypeCopyrightID = {txtCopyrightID.Text}"; HandlingDataHelper.UpdateData(dgvCopyright, DataGridViewHeader.listOfColumnsCopyright, txtCopyrightID.Text, "Copyright ID", query, "LibraryTypeCopyright"); }
private void btnUpdateCategory_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeCategory SET LibraryTypeCategoryName = '{txtCategoryNameUpdate.Text}' WHERE LibraryTypeCategoryID = {txtCategoryID.Text}"; HandlingDataHelper.UpdateData(dgvCategory, DataGridViewHeader.listOfColumnsCategory, txtCategoryID.Text, "Language ID", query, "LibraryTypeCategory"); }
private void btnUpdateLanguage_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeLanguage SET LibraryTypeLanguageShortCode = '{txtLanguageShortCodeUpdate.Text}', LibraryTypeLanguageLongCode = '{txtLanguageLongCodeUpdate.Text}' WHERE LibraryTypeLanguageID = {txtLanguageID.Text}"; HandlingDataHelper.UpdateData(dgvLanguage, DataGridViewHeader.listOfColumnsLanguage, txtLanguageID.Text, "Language ID", query, "LibraryTypeLanguage"); }
private void btnUpdateFormat_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeFormat SET LibraryTypeFormatType = '{txtFormatTypeUpdate.Text}' WHERE LibraryTypeFormatID = {txtFormatID.Text}"; HandlingDataHelper.UpdateData(dgvFormat, DataGridViewHeader.listOfColumnsFormat, txtFormatID.Text, "Format ID", query, "LibraryTypeFormat"); }
private void btnUpdateEditor_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeEditor SET LibraryTypeEditorName = '{txtEditorNameUpdate.Text}', LibraryTypeEditorEmail = '{txtEditorEmailUpdate.Text}', LibraryTypeEditorLocation = '{txtEditorLocationUpdate.Text}' WHERE LibraryTypeEditorID = {txtEditorID.Text}"; HandlingDataHelper.UpdateData(dgvEditor, DataGridViewHeader.listOfColumnsEditor, txtEditorID.Text, "Editor ID", query, "LibraryTypeEditor"); }
private void btnUpdateEdition_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypeEdition SET LibraryTypeEditionNumber = '{txtEditionNumberUpdate.Text}', LibraryTypeEditionDate = TO_DATE('{dtpEditionDateUpdate.Value.ToString(formatDateTime)}', '{formatDateTime}') WHERE LibraryTypeEditionID = {txtEditionID.Text}"; HandlingDataHelper.UpdateData(dgvEdition, DataGridViewHeader.listOfColumnsEdition, txtEditionID.Text, "Edition ID", query, "LibraryTypeEdition"); }
private void btnUpdatePublisher_Click(object sender, EventArgs e) { var query = $"UPDATE LibraryTypePublisher SET LibraryTypePublisherName = '{txtPublisherNameUpdate.Text}', LibraryTypePublisherLocation = '{txtPublisherLocationUpdate.Text}' WHERE LibraryTypePublisherID = {txtPublisherID.Text}"; HandlingDataHelper.UpdateData(dgvPublisher, DataGridViewHeader.listOfColumnsPublisher, txtPublisherID.Text, "Publisher ID", query, "LibraryTypePublisher"); }