// IF PRESS ENTER private void txtQtyChange_KeyDown(object sender, KeyEventArgs e) { try { if (e.Key == Key.Return) { conn.Open(); string queryQty = "SELECT prodQty FROM datainventory WHERE prodItem = @salesItem"; conn.query(queryQty); conn.bind("@salesItem", salesItem); conn.cmd().Prepare(); MySqlDataReader dr = conn.read(); if (dr.HasRows) { while (dr.Read()) { prodQty = dr["prodQty"].ToString(); } } dr.Close(); dr.Dispose(); conn.Close(); // Check if Database Stock is Less Than users quantity if (int.Parse(prodQty) < int.Parse(txtQtyChange.Text)) { MessageBox.Show("Unable to proceed, You only have " + prodQty + " stocks in your database", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); } else { /* SALES QUANTITY * SET A NEW TOTAL QUANTITY */ conn.Open(); string query = "UPDATE datasalesinventory SET salesQty = @salesQty WHERE salesTransNo = @salesTransNo AND salesItem = @salesItem"; conn.query(query); conn.bind("@salesQty", txtQtyChange.Text.Trim()); conn.bind("@salesTransNo", win_pos.orderNo.Text); conn.bind("@salesItem", salesItem); conn.cmd().Prepare(); conn.execute(); conn.Close(); /* SALES TOTAL * SET A NEW TOTAL PRICE */ conn.Open(); string query2 = "UPDATE datasalesinventory SET salesTotal = (salesRP * salesQty) WHERE salesTransNo = '" + win_pos.orderNo.Text + "' AND salesItem = '" + salesItem + "' "; conn.query(query2); conn.execute(); conn.Close(); //MessageBox.Show("Quantity Changed", "Quantiy", MessageBoxButton.OK, MessageBoxImage.Information); win_pos.tbPrdName.Text = ""; // win_pos.holdOrder.IsEnabled = false; this.Close(); // Close win_pos.loadDatas(); win_pos.pay_total.Text = win_pos.sumOfSalesTotals(); // Update UI Total conn.Close(); win_pos.entrySearch.Focus(); win_pos.holdOrder.IsEnabled = false; } } } catch (Exception ex) { conn.Close(); MessageBox.Show("Error: " + ex.Message + ", Try again later", "Error", MessageBoxButton.OK, MessageBoxImage.Warning); } }
public void loadReport() { ReportDataSource rptDataSource; try { this.ReportViewerDemo.LocalReport.DataSources.Clear(); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "NavigationDrawerPopUpMenu2.Report1.rdlc"; DataSet1 ds = new DataSet1(); conn.Open(); string query = "SELECT * FROM datasalesinventory WHERE salesTransNo='" + win_pos.orderNo.Text + "' AND salesStatus = 'Pending'"; MySqlDataAdapter da = conn.DataAdapter(query); da.Fill(ds.Tables["dtSold"]); conn.Close(); // Parameters ReportParameter pStoreName = new ReportParameter("pStoreName", store.storeName(conn)); ReportParameter pStoreAddress = new ReportParameter("pStoreAddress", store.storeAddress(conn)); ReportParameter pTin = new ReportParameter("pTin", "Tin: " + store.storeTin(conn)); ReportParameter pSerialNumber = new ReportParameter("pSerialNumber", "Serial No.: " + store.storeSN(conn)); ReportParameter pMin = new ReportParameter("pMin", "Min: " + store.storeMin(conn)); ReportParameter pCashierName = new ReportParameter("pCashierName", "Cashier: " + win_pos.cashierName.Text); ReportParameter pTransNo = new ReportParameter("pTransNo", "Trans #: " + win_pos.orderNo.Text); ReportParameter pSubTotal = new ReportParameter("pSubTotal", win_pos.pay_subtotal.Text); ReportParameter pTotal = new ReportParameter("pTotal", win_pos.pay_total.Text); ReportParameter pCash = new ReportParameter("pCash", win_pos.pay_paid.Text); ReportParameter pChange = new ReportParameter("pChange", win_pos.pay_due.Text); ReportParameter pTax = new ReportParameter("pTax", win_pos.pay_tax.Text); ReportParameter pDiscount = new ReportParameter("pDiscount", win_pos.discount); ReportParameter pVatable = new ReportParameter("pVatable", win_pos.sumOfSalesTotals()); // Set Parameters ReportViewerDemo.LocalReport.SetParameters(pStoreName); ReportViewerDemo.LocalReport.SetParameters(pStoreAddress); ReportViewerDemo.LocalReport.SetParameters(pTin); ReportViewerDemo.LocalReport.SetParameters(pSerialNumber); ReportViewerDemo.LocalReport.SetParameters(pMin); ReportViewerDemo.LocalReport.SetParameters(pCashierName); ReportViewerDemo.LocalReport.SetParameters(pTransNo); ReportViewerDemo.LocalReport.SetParameters(pSubTotal); ReportViewerDemo.LocalReport.SetParameters(pTotal); ReportViewerDemo.LocalReport.SetParameters(pCash); ReportViewerDemo.LocalReport.SetParameters(pChange); ReportViewerDemo.LocalReport.SetParameters(pTax); ReportViewerDemo.LocalReport.SetParameters(pDiscount); ReportViewerDemo.LocalReport.SetParameters(pVatable); rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtSold"]); this.ReportViewerDemo.LocalReport.DataSources.Add(rptDataSource); ReportViewerDemo.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); ReportViewerDemo.ZoomMode = ZoomMode.Percent; ReportViewerDemo.ZoomPercent = 100; } catch (Exception ex) { conn.Close(); MessageBox.Show(ex.Message + ", Try again later", "Receipt Printing Failed", MessageBoxButton.OK, MessageBoxImage.Warning); } }