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