private void placeOrderPaymentMethodCardFinishBtn_Click(object sender, EventArgs e) { billprint(); if (placeOrderIdLabel.Text.ToString().CompareTo("") != 0) { try { if (placeOrderCardType.Text.ToString().CompareTo("") != 0 && placeOrderCardNo.Text.ToString().CompareTo("") != 0) { if (Convert.ToDouble(placeOrderCardNo.Text.ToString()) < 0) { MetroFramework.MetroMessageBox.Show(this, "Wrong Input: Negative Values Not Allowed"); } else { double cardNo = Convert.ToDouble(placeOrderCardNo.Text.ToString()); String cardType = placeOrderCardType.Text.ToString(); DateTime dtValue = DateTime.Now; string orderDate = dtValue.ToString("yyyy-MM-dd"); string orderTime = dtValue.ToString("HH:mm:ss"); OrderInfoDataAccess orderOb = new OrderInfoDataAccess(); double discountOrderTotal = orderTotal - discount; string query = "update orderinfo set orderdate='" + orderDate + "', ordertime='" + orderTime + "', ordertotal=" + discountOrderTotal + ", discount=" + discount + ", vattotal=" + vatTotal + ", nettotal=" + netTotal + ", paymentmethod='" + placeOrderPaymentMethodCbox.Text.ToString() + "', cardtype='" + cardType + "', cardnum=" + cardNo + ",status='TRUE' where id=" + Convert.ToInt32(placeOrderIdLabel.Text.ToString()); orderOb.addOrderDetails(query); MetroFramework.MetroMessageBox.Show(this, "Order Details Updated To Database Successfully"); placeOrderPaymentMethodCashFinishBtn.Hide(); placeOrderPaymentMethodCardFinishBtn.Hide(); placeOrderAddItemBtn.Hide(); placeOrderCancelResetBtn.Text = "New Order"; placeOrder_discountTbox.ReadOnly = true; placeOrderCashPaidTbox.ReadOnly = true; placeOrderCardNo.ReadOnly = true; placeOrderCardType.Enabled = false; placeOrderPaymentMethodCbox.Enabled = false; } } else { MetroFramework.MetroMessageBox.Show(this, "Error: Input Can't be Blank"); } } catch (FormatException) { MetroFramework.MetroMessageBox.Show(this, "Error: Wrong Input"); } catch (Exception exc) { MetroFramework.MetroMessageBox.Show(this, exc.ToString()); } } else { MetroFramework.MetroMessageBox.Show(this, "Error: No Item Is Ordered Yet"); } }
private void placeOrderAddItemBtn_Click(object sender, EventArgs e) { if (placeOrderItemNameCbox.Text.ToString().CompareTo("") != 0) { try { ItemDataAccess itemOb = new ItemDataAccess(); OrderInfoDataAccess orderOb = new OrderInfoDataAccess(); string itemName = placeOrderItemNameCbox.Text.ToString(); double itemUnitPrice = itemOb.getItemUnitPrice(itemName); int qty = Convert.ToInt32(placeOrderQtyUpDown.Value); int orderId; if (placeOrderIdLabel.Text.ToString().CompareTo("") == 0) { string sql = "Insert into ORDERINFO (ID,STATUS) VALUES(order_orderid_seq.NEXTVAL,'FALSE')"; orderOb.addOrderDetails(sql); orderId = orderOb.getCurrentOrderId(); placeOrderIdLabel.Text = Convert.ToString(orderId); placeOrder_orderTotal.Text = "0.0"; placeOrder_vatTotal.Text = "0.0"; placeOrder_netTotal.Text = "0.0"; placeOrder_discountTbox.Text = "0.0"; } orderId = Convert.ToInt32(placeOrderIdLabel.Text.ToString()); string addOrderdItemSql = "Insert into ORDEREDITEM VALUES(" + orderId + "," + qty + "," + itemUnitPrice + ",'" + itemName + "')"; orderOb.addOrderDetails(addOrderdItemSql); string connStr = "Data Source=localhost; User Id= Tokee; Password=12345"; OracleConnection conn = new OracleConnection(connStr); string orderedItemListSql = "select ITEMNAME, ITEMUNITPRICE, ITEMQTY from ORDEREDITEM where ORDERID =" + orderId + ""; OracleDataAdapter adapter = new OracleDataAdapter(orderedItemListSql, conn); DataTable dt = new DataTable(); adapter.Fill(dt); placeOrderItemList.DataSource = dt; orderTotal = orderTotal + (itemUnitPrice * qty); vatTotal = orderTotal * 0.15; netTotal = orderTotal + vatTotal; placeOrder_orderTotal.Text = Convert.ToString(orderTotal); placeOrder_vatTotal.Text = Convert.ToString(vatTotal); placeOrder_netTotal.Text = Convert.ToString(netTotal); placeOrderItemNameCbox.Items.Clear(); placeOrderItemCategoryCbox.Items.Clear(); itemCategoryComboboxFill(); itemListCategoryComboboxDefaultSelect(); placeOrderQtyUpDown.Value = placeOrderQtyUpDown.Minimum; } catch (Exception exc) { MetroFramework.MetroMessageBox.Show(this, exc.ToString()); } } else { MetroFramework.MetroMessageBox.Show(this, "No Item Selected"); } }