Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            DBConnect edit = new DBConnect();
            int       barcode;

            if (!String.IsNullOrEmpty(IDfield.Text))
            {
                barcode = int.Parse(IDfield.Text);
                int qty = (int)qtyField.Value;
                int x;
                int i;
                for (i = 0; i < copy.Count && barcode != copy[i].barCode; i++)
                {
                }                                                                 //finds item in inventory copy
                if (i < copy.Count)
                {
                    for (x = listView1.Items.Count - 1; x >= 0 && listView1.Items[x].SubItems[1].Text != barcode.ToString(); x--)
                    {
                    }                                                                                                                //finds item in list view
                    if (x >= 0)
                    {
                        int    qtyDec   = int.Parse(listView1.Items[x].SubItems[2].Text);    //gets qty purchased
                        double priceDec = Double.Parse(listView1.Items[x].SubItems[3].Text); //gets total price of purchased item
                        String query    = "INSERT INTO purchaselog(itemID, purchaseDate, qty, transactionID,remark) VALUES(" + copy[i].ID + ", curdate(), " + qty + ", " + data.transID + ",'RETURNED')";
                        String query2   = "UPDATE product SET product_qty = product_qty + '" + qty + "'WHERE bar_code = '" + barcode + "'";
                        if (qtyDec - qty > 0)
                        {
                            qtyDec   -= qty;
                            priceDec -= (copy[i].price * qty);
                            listView1.Items[x].SubItems[2].Text = qtyDec.ToString();
                            listView1.Items[x].SubItems[3].Text = priceDec.ToString();
                            data.sum       -= (double)(copy[i].price * qty);
                            totalField.Text = data.sum.ToString();
                            edit.insertLog(query);
                            edit.insertLog(query2);
                            IDfield.Clear();
                            qtyField.Value = 1;
                            itemNamefield.Clear();
                        }
                        else if (qtyDec - qty == 0)
                        {
                            listView1.Items[x].Remove();
                            edit.insertLog(query);
                            data.sum       -= (copy[i].price * qty);
                            totalField.Text = data.sum.ToString();
                            edit.insertLog(query);
                            edit.insertLog(query2);
                            IDfield.Clear();
                            qtyField.Value = 1;
                            itemNamefield.Clear();
                        }
                        else
                        {
                            MessageBox.Show("Invalid Amount");
                        }
                    }
                    else
                    {
                        MessageBox.Show("Item not purchased");
                    }
                }
                else
                {
                    MessageBox.Show("Item not found");
                }
            }
            else
            {
                MessageBox.Show("Please enter barcode/name");
            }
        }