private void RetrieveStockInfo() { try { UpdateStock stock = new UpdateStock(); stock.Kwrd = txtSearch.Text; DataTable table = stock.dTable(); ListViewItem entry = null; listViewStockSearch.Items.Clear(); foreach (DataRow row in table.Rows) { entry = new ListViewItem(row["ProductID"].ToString()); entry.SubItems.Add(row["ProductName"].ToString()); entry.SubItems.Add(row["ProductDescription"].ToString()); entry.SubItems.Add(row["SupplierID"].ToString()); entry.SubItems.Add(row["CategoryID"].ToString()); entry.SubItems.Add(row["Quantity"].ToString()); entry.SubItems.Add(row["UnitPrice"].ToString()); listViewStockSearch.Items.Add(entry); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddToSell() { string product_name = null; try { if (string.IsNullOrEmpty(listViewSearch.FocusedItem.Text)) { } else { product_name = listViewSearch.FocusedItem.Text; UpdateStock getStocks = new UpdateStock(); getStocks.Kwrd = product_name; DataTable Table = getStocks.dTable(); foreach (DataRow row in Table.Rows) { txtbProd.Text = row["ProductName"].ToString(); txtbPrice.Text = row["UnitPrice"].ToString(); } txtbSearch.Text = null; listViewSearch.Items.Clear(); } } catch { Interaction.MsgBox("Please select record to add", MsgBoxStyle.Exclamation, "Add to Cart"); return; } }
double discount; // Sets discount value as well as return the value to zero when necessary. //public string AmountPaid; //public string getAmountToPay; //public string displayChange; private void RetrieveStock() { UpdateStock getStocks = new UpdateStock(); getStocks.Kwrd = txtbSearch.Text; DataTable Table = getStocks.dTable(); ListViewItem entry = null; listViewSearch.Items.Clear(); foreach (DataRow row in Table.Rows) { entry = new ListViewItem(row["ProductName"].ToString()); entry.SubItems.Add(row["ProductDescription"].ToString()); entry.SubItems.Add(row["UnitPrice"].ToString()); listViewSearch.Items.Add(entry); } }
public void UpdateStockWithQuantityAfterSale() { int Quantity, saleQuantity; string prodname; int availQuantity = 0; foreach (ListViewItem Item in listViewPurchase.Items) { prodname = Item.SubItems[0].Text; saleQuantity = Convert.ToInt32(Item.SubItems[1].Text); DataTable stocktable; UpdateStock stockupdate = new UpdateStock(); stockupdate.Kwrd = prodname; stocktable = stockupdate.dTable(); foreach (DataRow row in stocktable.Rows) { availQuantity = Convert.ToInt32(row["Quantity"]); } Quantity = availQuantity - saleQuantity; //MessageBox.Show(Convert.ToString(Quantity)); GetStockDetails update = new GetStockDetails(prodname, Quantity); } }