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