public static void DeleteAllOrder(ProductCL b) { try { SqlCommand cmd = new SqlCommand("Delete OrderDetails where ProductID = @ProductID", con); cmd.Parameters.AddWithValue("@ProductID", b.ProductID); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void productUpdate(ProductCL a) { try { string cm = "Update Products set ProductName = @ProductName,SupplierID = @SupplierID,UnitPrice = @UnitPrice " + "where ProductID = " + a.ProductID; SqlCommand cmd = new SqlCommand(cm, con); cmd.Parameters.AddWithValue("@ProductName", a.ProductName); cmd.Parameters.AddWithValue("@SupplierID", a.SupplierId); cmd.Parameters.AddWithValue("@UnitPrice", a.Price); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }
public static List<ProductCL> getAllProductSell() { List<ProductCL> ware = new List<ProductCL>(); try { SqlCommand cmd = new SqlCommand("select Products.ProductID,Products.ProductName,Suppliers.CompanyName,Products.UnitPrice from Products, Suppliers where Products.SupplierID = Suppliers.SupplierID", con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (!dr.HasRows) { ware = null; } else { while (dr.Read()) { int id = int.Parse(dr[0].ToString()); string name = dr[1].ToString(); string supName = dr[2].ToString(); double price = double.Parse(dr[3].ToString()); ProductCL pro = new ProductCL(id, name, supName, price); ware.Add(pro); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return ware; }
private void button6_Click(object sender, EventArgs e) { if (button6.Text.Equals("Add")) { button6.Text = "Save"; button5.Text = "Cancel"; button4.Enabled = false; textBox10.Text = "" + (SelectDA.GetMax("ProductID", "Products") + 1); textBox9.Enabled = true; comboBox2.Enabled = true; textBox8.Enabled = true; return; } if (button6.Text.Equals("Save")) { ProductCL a = new ProductCL(); a.ProductID = SelectDA.GetMax("ProductID", "Products") + 1; a.ProductName = textBox9.Text; SelectDA.ComboboxItem selectedCar = (SelectDA.ComboboxItem)comboBox2.SelectedItem; int selecteVal = Convert.ToInt32(selectedCar.Value); a.SupplierId = selecteVal; try { a.Price = int.Parse(textBox8.Text); } catch (Exception) { MessageBox.Show("Wrong input for Unit Price !"); } InsertDA.insertProduct(a); DataSet ds = SelectDA.SelectDS("SELECT ProductID,ProductName,CompanyName,UnitPrice FROM Products,Suppliers WHERE Products.SupplierID = Suppliers.SupplierID"); DataView dv = new DataView(ds.Tables[0]); dataGridView3.DataSource = dv; textBox10.Enabled = false; textBox9.Enabled = false; comboBox2.Enabled = false; textBox8.Enabled = false; button6.Text = "Add"; button5.Text = "Edit"; button4.Enabled = true; textBox10.Text = ""; textBox9.Text = ""; textBox8.Text = ""; comboBox2.SelectedIndex = 0; return; } }
private void button5_Click(object sender, EventArgs e) { if (button5.Text.Equals("Cancel")) { textBox10.Text = ""; textBox9.Text = ""; textBox8.Text = ""; comboBox2.SelectedIndex = 0; textBox10.Enabled = false; textBox9.Enabled = false; comboBox2.Enabled = false; textBox8.Enabled = false; button6.Text = "Add"; button5.Text = "Edit"; button4.Enabled = true; return; } if (button5.Text.Equals("Edit")) { try { textBox10.Text = "" + int.Parse(dataGridView3.SelectedRows[0].Cells["ProductID"].Value.ToString()); textBox9.Text = dataGridView3.SelectedRows[0].Cells["ProductName"].Value.ToString(); //comboBox2.SelectedIndex = comboBox2.Items.IndexOf(int.Parse(dataGridView1.SelectedRows[0].Cells["SupplierID"].Value.ToString())); comboBox2.Text = dataGridView3.SelectedRows[0].Cells["CompanyName"].Value.ToString(); textBox8.Text = "" + int.Parse(dataGridView3.SelectedRows[0].Cells["UnitPrice"].Value.ToString()); } catch (Exception) { MessageBox.Show("You must select a Product !"); return; } button6.Enabled = false; button5.Text = "Save"; button4.Text = "Cancel"; textBox9.Enabled = true; comboBox2.Enabled = true; textBox8.Enabled = true; dataGridView3.Enabled = false; return; } if (button5.Text.Equals("Save")) { ProductCL a = new ProductCL(); a.ProductID = int.Parse(textBox10.Text); a.ProductName = textBox9.Text; SelectDA.ComboboxItem selectedCar = (SelectDA.ComboboxItem)comboBox2.SelectedItem; int selecteVal = Convert.ToInt32(selectedCar.Value); a.SupplierId = selecteVal; try { a.Price = int.Parse(textBox8.Text); } catch (Exception) { MessageBox.Show("Wrong input for Unit Price !"); } UpdateDA.productUpdate(a); DataSet ds = SelectDA.SelectDS("SELECT ProductID,ProductName,CompanyName,UnitPrice FROM Products,Suppliers WHERE Products.SupplierID = Suppliers.SupplierID"); DataView dv = new DataView(ds.Tables[0]); dataGridView3.DataSource = dv; textBox10.Enabled = false; textBox9.Enabled = false; comboBox2.Enabled = false; textBox8.Enabled = false; textBox10.Text = ""; textBox9.Text = ""; textBox8.Text = ""; comboBox2.SelectedIndex = 0; button4.Text = "Delete"; button5.Text = "Edit"; button6.Enabled = true; dataGridView3.Enabled = true; return; } }
private void button4_Click(object sender, EventArgs e) { if (button4.Text.Equals("Cancel")) { textBox10.Text = ""; textBox9.Text = ""; textBox8.Text = ""; comboBox2.SelectedIndex = 0; textBox10.Enabled = false; textBox9.Enabled = false; comboBox2.Enabled = false; textBox8.Enabled = false; button6.Text = "Add"; button5.Text = "Edit"; button4.Text = "Delete"; button6.Enabled = true; dataGridView3.Enabled = true; return; } if (button4.Text.Equals("Delete")) { ProductCL a = new ProductCL(); try { a.ProductID = int.Parse(dataGridView3.SelectedRows[0].Cells["ProductID"].Value.ToString()); } catch (Exception) { MessageBox.Show("You must select a Product !"); return; } DialogResult result = MessageBox.Show("Do you want to DELETE this product ?", "Confirm", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { DeleteDA.DeleteAllOrder(a); DeleteDA.DeleteProduct(a); DataSet ds = SelectDA.SelectDS("SELECT ProductID,ProductName,CompanyName,UnitPrice FROM Products,Suppliers WHERE Products.SupplierID = Suppliers.SupplierID"); DataView dv = new DataView(ds.Tables[0]); dataGridView3.DataSource = dv; } else { return; } } }
public static void insertProduct(ProductCL a) { try { SqlCommand cmd = new SqlCommand("SET IDENTITY_INSERT Products ON Insert into Products(ProductID,ProductName,SupplierID,UnitPrice) " + "values(@ProductID,@ProductName,@SupplierID,@UnitPrice)", con); cmd.Parameters.AddWithValue("@ProductID", a.ProductID); cmd.Parameters.AddWithValue("@ProductName", a.ProductName); cmd.Parameters.AddWithValue("@SupplierID", a.SupplierId); cmd.Parameters.AddWithValue("@UnitPrice", a.Price); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } }