private List <FHJuiceProductModel> getProductsOrderedConso(string strOrderID) { List <FHJuiceProductModel> lstProds = new List <FHJuiceProductModel>(); queryString = "SELECT dbjuiceacct.tblproductsorderedconso.ID, orderID, productID, qty, " + "price, productname, remarks FROM (dbjuiceacct.tblproductsorderedconso INNER JOIN " + "dbjuiceacct.tblproducts ON tblproductsorderedconso.productID = dbjuiceacct.tblproducts.ID) " + "WHERE dbjuiceacct.tblproductsorderedconso.isDeleted = 0 AND orderID = ?"; FHJuiceProductModel pMdl = new FHJuiceProductModel(); parameters = new List <string>(); parameters.Add(strOrderID); MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { pMdl.RecordID = reader["ID"].ToString(); pMdl.OrderID = reader["orderID"].ToString(); pMdl.ID = reader["productID"].ToString(); pMdl.Qty = reader["qty"].ToString(); pMdl.Price = reader["price"].ToString(); pMdl.Total = (Convert.ToDouble(pMdl.Qty) * Convert.ToDouble(pMdl.Price)).ToString(); pMdl.Remarks = reader["remarks"].ToString(); pMdl.ProductName = reader["productname"].ToString(); lstProds.Add(pMdl); pMdl = new FHJuiceProductModel(); } conDB.closeConnection(); return(lstProds); }
private List <FHJuiceProductModel> loadProductsStocksLowerWarehouse() { conDB = new ConnectionDB(); List <FHJuiceProductModel> lstJuiceIn = new List <FHJuiceProductModel>(); FHJuiceProductModel juiceIn = new FHJuiceProductModel(); queryString = "SELECT dbjuiceacct.tbllowerwarehouse.ID, productID, productname, description, " + "stockdate, sum(qty) as qty FROM(dbjuiceacct.tbllowerwarehouse INNER JOIN dbjuiceacct.tblproducts ON " + "dbjuiceacct.tbllowerwarehouse.productID = dbjuiceacct.tblproducts.ID) WHERE " + "dbjuiceacct.tbllowerwarehouse.isDeleted = 0 AND dbjuiceacct.tblproducts.isDeleted = 0 GROUP BY productID"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { juiceIn.RecordID = reader["ID"].ToString(); juiceIn.ID = reader["productID"].ToString(); juiceIn.ProductName = reader["productname"].ToString(); DateTime pdate = DateTime.Parse(reader["stockdate"].ToString()); juiceIn.StockDate = pdate.ToShortDateString(); juiceIn.Qty = reader["qty"].ToString(); lstJuiceIn.Add(juiceIn); juiceIn = new FHJuiceProductModel(); } conDB.closeConnection(); return(lstJuiceIn); }
private async void button_Click(object sender, RoutedEventArgs e) { bool x = await checkFields(); if (x) { FHJuiceProductModel prod = new FHJuiceProductModel(); FHJuiceProductModel selectedProd = cmbProducts.SelectedItem as FHJuiceProductModel; prod.ProductName = selectedProd.ProductName; prod.ID = selectedProd.ID; prod.Price = txtPrice.Text; prod.Qty = txtQty.Text; prod.Remarks = txtRemarks.Text; prod.Total = (Convert.ToDouble(prod.Price) * Convert.ToDouble(txtQty.Text)).ToString(); if (!ifUpdate) { prod.NewlyAdded = false; lstFHproducts.Add(prod); prod = new FHJuiceProductModel(); } else { prod.NewlyAdded = true; lstFHproducts.Add(prod); prod = new FHJuiceProductModel(); } } dgvProductsOrdered.Items.Refresh(); dgvProductsOrdered.ItemsSource = lstFHproducts; }
private void btnRemove_Click(object sender, RoutedEventArgs e) { FHJuiceProductModel p = dgvProductsOrdered.SelectedItem as FHJuiceProductModel; if (p != null) { lstFHproducts.Remove(p); dgvProductsOrdered.ItemsSource = lstFHproducts; dgvProductsOrdered.Items.Refresh(); } }
private void btnUpdate_Click(object sender, RoutedEventArgs e) { FHJuiceProductModel slctCmb = cmbProducts.SelectedItem as FHJuiceProductModel; foreach (FHJuiceProductModel pp in lstFHproducts) { if (productToUpdate.ID.Equals(pp.ID)) { pp.ID = slctCmb.ID; pp.ProductName = slctCmb.ProductName; pp.Qty = txtQty.Text; pp.Price = txtPrice.Text; pp.Remarks = txtRemarks.Text; pp.Total = (Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtPrice.Text)).ToString(); } } dgvProductsOrdered.ItemsSource = lstFHproducts; dgvProductsOrdered.Items.Refresh(); }
private void loadProductsOnCombo() { conDB = new ConnectionDB(); FHJuiceProductModel prod = new FHJuiceProductModel(); queryString = "SELECT ID, productname, description FROM dbjuiceacct.tblproducts WHERE isDeleted = 0"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { prod.ID = reader["ID"].ToString(); prod.ProductName = reader["productname"].ToString(); prod.Description = reader["description"].ToString(); cmbProducts.Items.Add(prod); prod = new FHJuiceProductModel(); } conDB.closeConnection(); }
private void EditProduct_Click(object sender, RoutedEventArgs e) { productToUpdate = dgvProductsOrdered.SelectedItem as FHJuiceProductModel; if (productToUpdate != null) { foreach (ProductModel pp in cmbProducts.Items) { if (productToUpdate.ID.Equals(pp.ID)) { cmbProducts.SelectedItem = pp; break; } } txtPrice.Text = productToUpdate.Price; txtQty.Text = productToUpdate.Qty; txtRemarks.Text = productToUpdate.Remarks; button.Visibility = Visibility.Hidden; btnUpdate.Visibility = Visibility.Visible; } }