Пример #1
0
        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                e.SuppressKeyPress = true;
                e.Handled          = true;
                String          ProdID = "", ProdName = "", ProdDesc = "", Price = "";
                String          sqlprod       = String.Format(@"SELECT ProdID,ProdName,ProdDesc,Price FROM Products WHERE ProdID = '{0}'", txtBarcode2.Text);
                OleDbDataReader Addprodreader = null;
                crud.RetrieveRecords(sqlprod, ref Addprodreader);
                if (Addprodreader.HasRows)
                {
                    Addprodreader.Read();
                    ProdID   = Addprodreader[0].ToString();
                    ProdName = Addprodreader[1].ToString();
                    ProdDesc = Addprodreader[2].ToString();
                    Price    = Addprodreader[3].ToString();
                    crud.CloseConnection();
                    //MessageBox.Show(String.Format("{0}-{1}-{2}-{3}",ProdID,ProdName,ProdDesc,Price));
                    listProdName.Items.Add(ProdDesc);
                    Double quant = double.Parse(numupQuantity.Value.ToString());
                    listQTY.Items.Add(quant);
                    listPrice.Items.Add(Price);
                    Double ttprice = double.Parse(Price);
                    Double res     = ttprice * quant;
                    listTotal.Items.Add(res);
                    basket();
                    listProdName.SelectedIndex = listProdName.Items.Count - 1;

                    String   date      = "MM/dd/yyyy";
                    DateTime dateTime1 = DateTime.Now;
                    String   textDate  = dateTime1.ToString(date);

                    //String sqlInsertprod = String.Format(@"INSERT INTO PointOfSale
                    //VALUES('{0}','{1}','{2}','{3}','{4}','{5}','1')", lblTransaction.Text,
                    //ProdID, ProdName, ProdDesc, Price, textDate);
                }
                else
                {
                    MessageBox.Show("The product code is invalid!", "O.M.T | Cashier");
                    crud.CloseConnection();
                }
                txtBarcode2.Text = "";
                Panelquantity.Hide();
                txtBarcode.Enabled = true;
            }
        }
Пример #2
0
 private void bunifuFlatButton2_Click(object sender, EventArgs e)
 {
     Panelquantity.Hide();
     txtBarcode.Enabled = true;
 }