private void button1_Click(object sender, EventArgs e) { List <Form> forms = new List <Form>(); // All opened myForm instances foreach (Form f in Application.OpenForms) { if (f.Name == "Employees" || f.Name == "Stock_Suppliers" || f.Name == "Costumers_Orders" || f.Name == "CeoPrivatearea" || f.Name == "CashierWorkSchedule" || f.Name == "CeoAddWorker" || f.Name == "CeoDeleteWorker" || f.Name == "CeoEditWorker" || f.Name == "CeoPrivatearea" || f.Name == "Change_password" || f.Name == "Costumer_Order" || f.Name == "Employees_control_page" || f.Name == "ExitingCoustumer" || f.Name == "FindProduct" || f.Name == "GeneralPrivateArea" || f.Name == "GeneralWorkHours" || f.Name == "MyStockControlPage" || f.Name == "MySuplliersControlPage" || f.Name == "NewCostumer" || f.Name == "Orders_report" || f.Name == "Placingacostumer" || f.Name == "Remove_Customer" || f.Name == "Remove_Stock" || f.Name == "Remove_Supllier" || f.Name == "Show_Edit_Customer" || f.Name == "Show_Edit_Employees" || f.Name == "Show_Edit_Stock" || f.Name == "Show_edit_Supllier" || f.Name == "Stock_Suppliers" || f.Name == "Work_Hours" || f.Name == "Add_Supllier" || f.Name == "AddStock") { forms.Add(f); } } // Now let's close opened myForm instances foreach (Form f in forms) { f.Close(); } FindProduct mm = new FindProduct(); mm.Show(); }
private void Button2_Click(object sender, EventArgs e) { if (label4.Text == "" && label6.Text == "") { MessageBox.Show("You didn't place a costumer and Product!"); } else if (label4.Text == "") { MessageBox.Show("You didn't place a costumer!"); } else if (label6.Text == "") { MessageBox.Show("You didn't place a Product!"); } else { SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\PROJECT\TEAM5\TEAM5\TEAM5 PROJECT\DATABASE\STOREMANGE.MDF;Integrated Security=True;Connect Timeout=30"); SqlDataAdapter sda = new SqlDataAdapter("select Price from Inventory where Serialnumber ='" + FindProduct.Product + "'", conn); DataTable dt = new DataTable(); sda.Fill(dt); string New_price = dt.Rows[0]["Price"].ToString(); SqlCommand sda2 = new SqlCommand("INSERT INTO Orders (Product_Serial,Price,Quantity,Date,Seller_name,Buyer_Id) VALUES ('" + FindProduct.Product + "','" + FindProduct.int_Product_price + "','" + FindProduct.Quantity + "','" + Login.date + "','" + Login.UserID + "','" + ExitingCoustumer.Customer + "')", conn); SqlDataAdapter da = new SqlDataAdapter(sda2); DataTable dt1 = new DataTable(); da.Fill(dt1); try { SqlCommand sda4 = new SqlCommand(" update Inventory set Quantity = '" + FindProduct.int_Update_quaintity + " ' where Serialnumber ='" + FindProduct.Product + "'", conn); SqlDataAdapter da4 = new SqlDataAdapter(sda4); DataTable dt4 = new DataTable(); da4.Fill(dt4); MessageBox.Show("Inventory Updeated", "Ok", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (MessageBox.Show("Greetings, the product was successfully sold.Would you like to choose another product?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { FindProduct.Product = ""; FindProduct.Product_name = ""; FindProduct.Quantity = ""; this.Close(); FindProduct mm = new FindProduct(); mm.Show(); } else { FindProduct.Product = ""; FindProduct.Product_name = ""; FindProduct.Quantity = ""; ExitingCoustumer.Customer = ""; label4.Text = ""; this.Close(); Checkout mm = new Checkout(); mm.label4.Text = ""; mm.label9.Text = ""; mm.label6.Text = ""; mm.label3.Text = ""; mm.label11.Text = ""; mm.Show(); } } }