private void btnUpdate_Click(object sender, EventArgs e) { try { if (listView1.SelectedItems.Count != 1) { MessageBox.Show("Make sure a record is selected"); return; } else if(txtItName.Text == "" || numPrice.Value == 0 || cmbCats.SelectedIndex == -1) { MessageBox.Show("Invalid Data! Make sure everything is inserted and category is selected"); return; } App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); myItAd.UpdateItemsQuery(txtItName.Text, Convert.ToInt32(cmbCats.SelectedValue.ToString()), Convert.ToInt32(numPrice.Value), Convert.ToInt32(cmbIDs.Items[listView1.FocusedItem.Index].ToString())); MessageBox.Show("Record Updated Successfully"); WriteListView(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void fillItems() { cmbItemIds.Items.Clear(); cmbItems.Items.Clear(); App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); App_Data.POSDataSet.ItemsDataTable myItTbl = new App_Data.POSDataSet.ItemsDataTable(); myItAd.FillItemViaCatBy(myItTbl, Convert.ToInt32(cmbCatIDs.SelectedValue)); foreach (DataRow myRow in myItTbl.Rows) { cmbItems.Items.Add(myRow["item_name"].ToString()); cmbItemIds.Items.Add(myRow["item_price"].ToString()); } if (cmbItems.Items.Count > 0) { cmbItems.SelectedIndex = 0; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (txtItemName.Text == "" || numPrice.Value == 0 || cmbCategories.SelectedIndex == -1) { MessageBox.Show("Invalid input make sure everything is specified!"); return; } App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); myItAd.InsertItemQuery(txtItemName.Text, Convert.ToInt32(cmbCategories.SelectedValue), Convert.ToInt32(numPrice.Value)); MessageBox.Show("New Item Added"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (listView1.SelectedItems.Count != 1) { MessageBox.Show("Make sure a record is selected"); return; } App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); myItAd.DeleteItemsQuery(Convert.ToInt32(cmbIDs.Items[listView1.FocusedItem.Index].ToString())); MessageBox.Show("Record Deleted Successfully"); WriteListView(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (listView1.SelectedItems.Count != 1) { MessageBox.Show("Make sure a record is selected"); return; } else if (txtItName.Text == "" || numPrice.Value == 0 || cmbCats.SelectedIndex == -1) { MessageBox.Show("Invalid Data! Make sure everything is inserted and category is selected"); return; } App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); myItAd.UpdateItemsQuery(txtItName.Text, Convert.ToInt32(cmbCats.SelectedValue.ToString()), Convert.ToInt32(numPrice.Value), Convert.ToInt32(cmbIDs.Items[listView1.FocusedItem.Index].ToString())); MessageBox.Show("Record Updated Successfully"); WriteListView(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void fillItems() { cmbItemIds.Items.Clear(); cmbItems.Items.Clear(); App_Data.POSDataSetTableAdapters.ItemsTableAdapter myItAd = new App_Data.POSDataSetTableAdapters.ItemsTableAdapter(); App_Data.POSDataSet.ItemsDataTable myItTbl = new App_Data.POSDataSet.ItemsDataTable(); myItAd.FillItemViaCatBy(myItTbl, Convert.ToInt32(cmbCatIDs.SelectedValue)); foreach (DataRow myRow in myItTbl.Rows) { cmbItems.Items.Add(myRow["item_name"].ToString()); cmbItemIds.Items.Add(myRow["item_price"].ToString()); } if(cmbItems.Items.Count>0) cmbItems.SelectedIndex = 0; }