private void deleteItemBtn_Click(object sender, EventArgs e) { string curName, reCurName, query; try { ItemDataAccess ob = new ItemDataAccess(); curName = deleteItemCinTbox.Text.ToString().ToUpper(); reCurName = deleteItemRcinTbox.Text.ToString().ToUpper(); if (curName.CompareTo("") != 0 && reCurName.CompareTo("") != 0) { if (curName.CompareTo(reCurName) == 0) { query = "Delete From Item Where Name='" + curName + "'"; int rowCount = ob.editItem(query); if (rowCount > 0) { MetroFramework.MetroMessageBox.Show(this, "Item Deleted Successfully"); itemCategoryComboboxFill(); itemListCategoryComboboxDefaultSelect(); autoCompleteItemCategoryTbox(); autoCompleteItemNameTbox(); } else { MetroFramework.MetroMessageBox.Show(this, "Current Item Name Not Found "); } } else { MetroFramework.MetroMessageBox.Show(this, "Wrong Input: Both Names Are Not Same.\nType Both Names Again."); } } else { MetroFramework.MetroMessageBox.Show(this, "Error: Input Can't be Blank"); } deleteItemCinTbox.Text = ""; deleteItemRcinTbox.Text = ""; } catch (FormatException) { MetroFramework.MetroMessageBox.Show(this, "Error: Wrong Input"); } catch (Exception exc) { MetroFramework.MetroMessageBox.Show(this, exc.ToString()); } }
private void editItemPriceBtn_Click(object sender, EventArgs e) { string curName, query; double newPrice; try { ItemDataAccess ob = new ItemDataAccess(); curName = editItemPriceCin.Text.ToString().ToUpper(); if (curName.CompareTo("") != 0 && editItemPriceNip.Text.ToString().CompareTo("") != 0) { newPrice = Convert.ToDouble(editItemPriceNip.Text.ToString()); query = "UPDATE ITEM Set Price=" + newPrice + " WHERE Name='" + curName + "'"; int rowCount = ob.editItem(query); if (rowCount > 0) { MetroFramework.MetroMessageBox.Show(this, "Item Price Edited Successfully"); itemCategoryComboboxFill(); itemListCategoryComboboxDefaultSelect(); } else { MetroFramework.MetroMessageBox.Show(this, "Current Item Name Not Found "); } } else { MetroFramework.MetroMessageBox.Show(this, "Error: Input Can't be Blank"); } editItemPriceCin.Text = ""; editItemPriceNip.Text = ""; } catch (FormatException) { MetroFramework.MetroMessageBox.Show(this, "Error: Wrong Input"); } catch (Exception exc) { MetroFramework.MetroMessageBox.Show(this, exc.ToString()); } }
private void editCategoryNameBtn_Click(object sender, EventArgs e) { string curName, newCategory, query; try { ItemDataAccess ob = new ItemDataAccess(); curName = editCategoryNameCin.Text.ToString().ToUpper(); newCategory = editCategoryNameNcn.Text.ToString().ToUpper(); if (curName.CompareTo("") != 0 && newCategory.CompareTo("") != 0) { query = "UPDATE ITEM Set Category='" + newCategory + "' WHERE Name='" + curName + "'"; int rowCount = ob.editItem(query); if (rowCount > 0) { MetroFramework.MetroMessageBox.Show(this, "Item Category Edited Successfully"); itemCategoryComboboxFill(); itemListCategoryComboboxDefaultSelect(); autoCompleteItemCategoryTbox(); } else { MetroFramework.MetroMessageBox.Show(this, "Current Item Name Not Found "); } } else { MetroFramework.MetroMessageBox.Show(this, "Error: Input Can't be Blank"); } editCategoryNameCin.Text = ""; editCategoryNameNcn.Text = ""; } catch (FormatException) { MetroFramework.MetroMessageBox.Show(this, "Error: Wrong Input"); } catch (Exception exc) { MetroFramework.MetroMessageBox.Show(this, exc.ToString()); } }