/// <summary> /// Handles the delete item button being clicked /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdDeleteItem_Click(object sender, RoutedEventArgs e) { try { if (listItems.SelectedItem != null) { int total = 0; int itemCost = 0; clsItem item = (clsItem)listItems.SelectedItem; if (listItems.Items.Count == 1) { listItems.Items.Clear(); } else { listItems.Items.Remove(item); } Int32.TryParse(txtCost.Text, out total); Int32.TryParse(item.Cost, out itemCost); total -= itemCost; txtCost.Text = total.ToString(); } } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
DataSet ds; // Dataset to hold the returned data from queries /// <summary> /// Returns the full list of jewelry items from the database /// </summary> /// <returns></returns> public ObservableCollection<clsItem> itemsCollection() { try { db = new clsDataAccess(); ObservableCollection<clsItem> col_Items = new ObservableCollection<clsItem>(); string sSQL; //Holds an SQL statement int iRet = 0; //Number of return values ds = new DataSet(); //Holds the return values clsItem items; //Used to load the return values into the combo box sSQL = "SELECT ItemCode, ItemDesc, Cost " + "FROM ItemDesc"; ds = db.ExecuteSQLStatement(sSQL, ref iRet); //Creates item objects based on the data pulled from the query than adds the object to a list for (int i = 0; i < iRet; i++) { items = new clsItem(); items.ItemCode = ds.Tables[0].Rows[i][0].ToString(); items.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString(); items.Cost = ds.Tables[0].Rows[i]["Cost"].ToString(); col_Items.Add(items); } return col_Items; } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
public ObservableCollection<clsItem> itemsCollection() { clsDataAccess db; ObservableCollection<clsItem> col_Items; db = new clsDataAccess(); string sSQL; //Holds an SQL statement int iRet = 0; //Number of return values DataSet ds = new DataSet(); //Holds the return values clsItem items; //Used to load the return values into the combo box sSQL = "SELECT ItemCode, ItemDesc, Cost " + "FROM ItemDesc"; col_Items = new ObservableCollection<clsItem>(); ds = db.ExecuteSQLStatement(sSQL, ref iRet); //Creates Flight objects based on the data pulled from the query than adds the object to a list for (int i = 0; i < iRet; i++) { items = new clsItem(); items.ItemCode = ds.Tables[0].Rows[i][0].ToString(); items.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString(); items.Cost = ds.Tables[0].Rows[i]["Cost"].ToString(); col_Items.Add(items); } return col_Items; }
private void cmdDeleteItem_Click(object sender, RoutedEventArgs e) { try { if (boxListItem.SelectedItem != null) { clsItem currentItem = (clsItem)boxListItem.SelectedItem; String sItemCode = currentItem.ItemCode; clsLineItem line; DataSet ds = new DataSet(); int iRet = 0; String sSQLCheck = "SELECT * FROM LineItems WHERE ItemCode = '" + sItemCode + "'"; ds = db.ExecuteSQLStatement(sSQLCheck, ref iRet); if (iRet == 0) { String sSQL = "Delete FROM ItemDesc " + "Where ItemCode = '" + sItemCode + "'"; db.ExecuteNonQuery(sSQL); boxListItem.Items.Clear(); UpdateBox(); txtName.Text = ""; txtDesc.Text = ""; txtCost.Text = ""; } else { //Following LineItem info added by JD //DISPLAY THE INVOICES THAT THIS ITEM IS A PART OF line = new clsLineItem(); //StatusLabel statusLabel.Content = "That item can't be deleted because it is on the following invoices: "; for (int i = 0; i < iRet; i++) { //Get the InvoiceNum and add it on to StatusLabel based on the ItemCode line.InvoiceNum = ds.Tables[0].Rows[i][0].ToString(); //statusLabel.Content + InvoiceNum statusLabelInvoice.Content = statusLabelInvoice.Content + " " + line.InvoiceNum; } } } else { statusLabel.Content = "Please select an item to delete"; } } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
private void selectedItemChanged(object sender, SelectionChangedEventArgs e) { clsItem item = new clsItem(); item = (clsItem)boxListItem.SelectedItem; if (item != null) { txtName.Text = item.ItemCode; txtDesc.Text = item.ItemDesc; txtCost.Text = item.Cost; statusLabel.Content = ""; } }
/// <summary> /// Handles the add item button being clicked /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdAdd_Click(object sender, RoutedEventArgs e) { try { if (selectItem.SelectedItem != null) { int total = 0; int itemCost = 0; clsItem item = (clsItem)selectItem.SelectedItem; listItems.Items.Add(item); Int32.TryParse(txtCost.Text, out total); Int32.TryParse(item.Cost, out itemCost); total += itemCost; txtCost.Text = total.ToString(); } } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }
public void UpdateBox() { string sSQL; //Holds an SQL statement int iRet = 0; //Number of return values DataSet ds = new DataSet(); clsItem item; sSQL = "SELECT ItemCode, ItemDesc, Cost " + "FROM ItemDesc"; ds = db.ExecuteSQLStatement(sSQL, ref iRet); for (int i = 0; i < iRet; i++) { item = new clsItem(); item.ItemCode = ds.Tables[0].Rows[i][0].ToString(); item.ItemDesc = ds.Tables[0].Rows[i]["ItemDesc"].ToString(); item.Cost = ds.Tables[0].Rows[i]["Cost"].ToString(); boxListItem.Items.Add(item); } }
/// <summary> /// Returns the collection of items from a certain invoice /// </summary> /// <param name="invoiceNumber"></param> /// <returns></returns> public ObservableCollection<clsItem> invoiceItems(string invoiceNumber) { try { db = new clsDataAccess(); ObservableCollection<clsItem> col_Items = new ObservableCollection<clsItem>(); List<string> itemCode = new List<string>(); string sSQL; //Holds an SQL statement int iRet = 0; //Number of return values ds = new DataSet(); //Holds the return values clsItem items; //Used to load the return values into the combo box sSQL = "SELECT ItemCode FROM LineItems " + "WHERE InvoiceNum = " + invoiceNumber; ds = db.ExecuteSQLStatement(sSQL, ref iRet); // adds all of the different item codes on the invoice to a list for (int i = 0; i < iRet; i++) { itemCode.Add(ds.Tables[0].Rows[i]["ItemCode"].ToString()); } if (itemCode.Count > 0) { foreach (string code in itemCode) { sSQL = "SELECT ItemCode, ItemDesc, Cost FROM ItemDesc " + "WHERE ItemCode = '" + code + "'"; ds = db.ExecuteSQLStatement(sSQL, ref iRet); items = new clsItem(); items.ItemCode = ds.Tables[0].Rows[0][0].ToString(); items.ItemDesc = ds.Tables[0].Rows[0]["ItemDesc"].ToString(); items.Cost = ds.Tables[0].Rows[0]["Cost"].ToString(); col_Items.Add(items); } } return col_Items; } catch (Exception ex) { throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message); } }