private async void button1_Click(object sender, EventArgs e) { if (((customer_name_textbox.Text != "") && customer_phoneno_textbox.Text != "")) { Connect.exec("UPDATE Invoice SET Invoice_Date = Now() WHERE Invoice_No = " + getVar.invoice_no + ";"); Connect.exec("UPDATE Invoice SET Customer_ID = '1' WHERE Invoice_No = " + getVar.invoice_no + ";"); Connect.exec("UPDATE Invoice SET Customer_Name = '" + customer_name_textbox.Text + "' WHERE Invoice_No = " + getVar.invoice_no + ";"); Connect.exec("UPDATE Invoice SET Total_amount = " + total_textbox.Text + " WHERE Invoice_No = " + getVar.invoice_no + ";"); Connect.exec("UPDATE Invoice SET Cus_Phoneno = '" + customer_phoneno_textbox.Text + "' WHERE Invoice_No = " + getVar.invoice_no + ";"); Connect.exec("UPDATE Invoice SET Pay_Status = True WHERE Invoice_No = " + getVar.invoice_no + ";"); paystatus.Text = "Contacting to the card company"; progressBar1.Value = 50; await Task.Delay(2000); paystatus.Text = "Payment complete"; progressBar1.Value = 100; Invoice report = new Invoice(); report.Show(); } else { MessageBox.Show("Please fill in all the information!"); } }
private void button1_Click(object sender, EventArgs e) { if (Product_name.Text == "" || price.Text == "" || dimension.Text == "" || reorderinglevel.Text == "" || shelf_loc.Text == "" || discount_tb.Text == "" || quantity.Text == "" || category.Text == "" || description.Text == "" || subCategory.Text == "") { MessageBox.Show("Please input all field!"); } else { String catID = ""; Table = Connect.query("SELECT Category_ID from Category WHERE Category_Name = '" + category.Text + "'"); catID = Table.Rows[0][0].ToString(); Connect.exec("INSERT INTO Product( Product_ID, Product_Name,Product_Price,Discounts ) VALUES ('" + product_id.Text + "','" + Product_name.Text + "','" + price.Text + "','" + discount_tb.Text + "')"); Connect.exec("INSERT INTO Stock(Product_ID, Category_ID,Quantity,Reordering_level,Shelf_location,Description,Dimension) VALUES ('" + product_id.Text + "','" + catID + "','" + quantity.Text + "', '" + reorderinglevel.Text + "','" + shelf_loc.Text + "', '" + description.Text + "', '" + dimension.Text + "')"); MessageBox.Show("Add successful"); Product_name.Text = ""; price.Text = ""; dimension.Text = ""; reorderinglevel.Text = ""; shelf_loc.Text = ""; discount_tb.Text = ""; quantity.Text = ""; description.Text = ""; Table = Connect.query("SELECT max(Product_ID)+1 from Product WHERE Deleted = False;"); product_id.Text = Table.Rows[0][0].ToString(); } }
private void delete_button_Click(object sender, EventArgs e) { DialogResult result1 = MessageBox.Show("Are you sure you want to delete this item?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result1 == DialogResult.Yes) { Connect.exec("UPDATE Product SET Deleted=True WHERE Product.Product_ID = " + product_IDTextBox.Text + ";"); Close(); } }
private void confirm_button_Click(object sender, EventArgs e) { Connect.exec("UPDATE Product SET Product_Name='" + product_NameTextBox.Text + "' ,Discounts= '" + discountsTextBox.Text + "',Product_Price= '" + product_PriceTextBox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "',Reordering_level= '" + reordering_levelTextBox.Text + "',Shelf_location = '" + shelf_locationTextBox.Text + "',Description= '" + descriptionRichTextBox.Text + "',Dimension= '" + dimensionTextBox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Update Success!"); }
private void button3_Click(object sender, EventArgs e) { if (orderqty_textbox.Text != "" && quantity_textbox.Text != "" && (Int32.Parse(quantity_textbox.Text) >= Int32.Parse(orderqty_textbox.Text))) { Table_Temp = Connect.query("SELECT max(Invoice_No) FROM Invoice WHERE (Pay_Status=False AND Using_Status=True);"); getVar.invoice_no = Table_Temp.Rows[0][0].ToString(); Table_Temp = Connect.query("SELECT max(Invoice_No)+1 FROM Invoice WHERE (Pay_Status=True AND Using_Status=True);"); string old_invoice_no = Table_Temp.Rows[0][0].ToString(); if (getVar.invoice_no == "" && old_invoice_no == "") { getVar.invoice_no = "1"; quantity_textbox.Text = (Int32.Parse(quantity_textbox.Text) - Int32.Parse(orderqty_textbox.Text)).ToString(); Connect.exec("INSERT INTO Invoice(Invoice_No,Store_ID,Using_Status) VALUES ('" + getVar.invoice_no.ToString() + "','" + getVar.storeID.ToString() + "',True)"); Connect.exec("INSERT INTO Product_Invoice( Invoice_No,Product_ID,Quantity,Deposit ) VALUES ('" + getVar.invoice_no.ToString() + "','" + product_IDTextBox.Text + "','" + orderqty_textbox.Text + "','" + product_PriceTextBox.Text + "')"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } else if ((old_invoice_no.ToString() == "") && (getVar.invoice_no == "1")) { quantity_textbox.Text = (Int32.Parse(quantity_textbox.Text) - Int32.Parse(orderqty_textbox.Text)).ToString(); Table_Temp = Connect.query("SELECT Quantity FROM Product_Invoice WHERE (Invoice_No = " + getVar.invoice_no.ToString() + " AND Product_ID= " + product_IDTextBox.Text + ");"); if (!(Table_Temp.Rows.Count == 0)) { int temp = Int32.Parse(Table_Temp.Rows[0][0].ToString()) + Int32.Parse(orderqty_textbox.Value.ToString()); Connect.exec("UPDATE Product_invoice SET Quantity='" + temp + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } else { //duplocate Connect.exec("INSERT INTO Product_invoice(Quantity,Product_ID,Invoice_No,Deposit) VALUES('" + orderqty_textbox.Value.ToString() + "','" + product_IDTextBox.Text + "','" + getVar.invoice_no.ToString() + "','" + product_PriceTextBox.Text + "')"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } } else if ((getVar.invoice_no != "") && (old_invoice_no.ToString() != "")) { Table_Temp = Connect.query("SELECT Quantity FROM Product_Invoice WHERE (Invoice_No = " + getVar.invoice_no.ToString() + " AND Product_ID= " + product_IDTextBox.Text + ");"); if (!(Table_Temp.Rows.Count == 0)) { int temp = Int32.Parse(Table_Temp.Rows[0][0].ToString()) + Int32.Parse(orderqty_textbox.Value.ToString()); Connect.exec("UPDATE Product_invoice SET Quantity='" + temp + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } else { Connect.exec("INSERT INTO Product_invoice(Quantity,Product_ID,Invoice_No,Deposit) VALUES('" + orderqty_textbox.Value.ToString() + "','" + product_IDTextBox.Text + "','" + old_invoice_no.ToString() + "','" + product_PriceTextBox.Text + "')"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } } else { Connect.exec("INSERT INTO Invoice(Invoice_No,Store_ID,Using_Status) VALUES ('" + old_invoice_no + "','" + getVar.storeID.ToString() + "',True)"); Connect.exec("INSERT INTO Product_Invoice( Product_ID,Quantity,Deposit,Invoice_No ) VALUES ('" + product_IDTextBox.Text + "','" + orderqty_textbox.Text + "','" + product_PriceTextBox.Text + "','" + old_invoice_no.ToString() + "')"); Connect.exec("UPDATE Stock SET Quantity='" + quantity_textbox.Text + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); Table_Temp = Connect.query("SELECT Quantity FROM Product_Invoice WHERE (Invoice_No = " + old_invoice_no.ToString() + " AND Product_ID= " + product_IDTextBox.Text + ");"); int temp = Int32.Parse(Table_Temp.Rows[0][0].ToString()) + Int32.Parse(orderqty_textbox.Value.ToString()); Connect.exec("UPDATE Product_invoice SET Quantity='" + temp + "' WHERE Product_ID = " + product_IDTextBox.Text + ";"); MessageBox.Show("Add order complete!"); } } else if ((Int32.Parse(orderqty_textbox.Text) < 0)) { MessageBox.Show("Please input postive number!"); } else if (quantity_textbox.Text.ToString() == "") { MessageBox.Show("Please select item"); } else if ((Int32.Parse(quantity_textbox.Text) < Int32.Parse(orderqty_textbox.Text))) { MessageBox.Show("Not enough stock!"); } Table = Connect.query("SELECT Product.Product_ID AS [Product ID], Product.Product_Name AS [Product Name], Product.Product_Price AS [Price], Product.Discounts AS [Discount], Stock.Category_ID AS [Category], Stock.Quantity AS [Quantity], Stock.Reordering_level AS [Reordering level], Stock.Shelf_location AS [Shelf Location], Stock.Description, Stock.Dimension from Product left join Stock on Product.Product_ID = Stock.Product_ID WHERE Deleted = False;"); dataGridView1.DataSource = Table; }