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 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 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;
}
