Beispiel #1
0
        private void tsmMenuAdd_Click(object sender, EventArgs e)
        {
            cDining_Table table = lsvBill.Tag as cDining_Table;

            if (table == null)
            {
                MessageBox.Show("Hãy chọn bàn !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            fInput f = new fInput();

            f.ShowDialog();

            if (f.amount == 0)
            {
                return;
            }

            string id = string.Empty;

            if (DataProvider.ExecuteQuery("SELECT dbo.Products.id FROM dbo.Products WHERE dbo.Products.ProductName = N'" + lsvMenu.SelectedItems[0].Text + "'") != null)
            {
                foreach (DataRow dr in DataProvider.ExecuteQuery("SELECT dbo.Products.id FROM dbo.Products WHERE dbo.Products.ProductName = N'" + lsvMenu.SelectedItems[0].Text + "'").Rows)
                {
                    id = dr["id"].ToString();
                }
            }

            int idBill = cBill.GetUncheckBillIDByTableID(table.ID);

            int productID = int.Parse(id);

            int amount = f.amount;

            if (idBill == -1)
            {
                cBill.InsertBill(table.ID);
                cBillInfo.InsertBillInfo(cBill.GetMaxIDBill(), productID, amount);
            }
            else
            {
                cBillInfo.InsertBillInfo(idBill, productID, amount);
            }

            ShowBill(table.ID);
            loadFpnl(cDining_Table.LoadAllTableList());
            btnPayment.Enabled = true;
        }
Beispiel #2
0
        private void tsmBillDelete_Click(object sender, EventArgs e)
        {
            string a = string.Empty;
            string b = string.Empty;
            string c = string.Empty;

            if (DataProvider.ExecuteQuery("SELECT dbo.Products.id AS idProduct, Bill.id AS idBill, dbo.BillInfo.Amount AS Amount FROM dbo.Products, dbo.Bill, dbo.BillInfo WHERE dbo.Products.ProductName = N'" + lsvBill.SelectedItems[0].Text + "' AND dbo.Bill.id = dbo.BillInfo.idBill AND dbo.BillInfo.idProduct = dbo.Products.id AND dbo.Bill.BillStatus = N'Chưa thanh toán' AND dbo.Bill.idDiningTable = " + tableID) != null)
            {
                foreach (DataRow dr in DataProvider.ExecuteQuery("SELECT dbo.Products.id AS idProduct, Bill.id AS idBill, dbo.BillInfo.Amount AS Amount FROM dbo.Products, dbo.Bill, dbo.BillInfo WHERE dbo.Products.ProductName = N'" + lsvBill.SelectedItems[0].Text + "' AND dbo.Bill.id = dbo.BillInfo.idBill AND dbo.BillInfo.idProduct = dbo.Products.id AND dbo.Bill.BillStatus = N'Chưa thanh toán' AND dbo.Bill.idDiningTable = " + tableID).Rows)
                {
                    a = dr["idProduct"].ToString();
                    b = dr["idBill"].ToString();
                    c = dr["Amount"].ToString();
                }
            }

            int idProduct = int.Parse(a);
            int idBill    = int.Parse(b);
            int Amount    = int.Parse(c);

            fInput f = new fInput();

            f.ShowDialog();

            if (f.amount > Amount)
            {
                MessageBox.Show("Số lượng không phù hợp !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            else if (f.amount == Amount)
            {
                DataProvider.ExecuteQuery("DELETE FROM dbo.BillInfo WHERE idFood = " + idProduct + " AND idBill = " + idBill + " AND Amount = " + Amount);
            }
            else
            {
                DataProvider.ExecuteQuery("UPDATE dbo.BillInfo SET Amount = " + (Amount - f.amount) + " WHERE idProduct = " + idProduct + " AND idBill = " + idBill);
            }


            lsvBill.Items.RemoveAt(lsvBill.FocusedItem.Index);

            ShowBill(tableID);
        }