private void btnSearchProduct_Click(object sender, EventArgs e) { lstProduct.Columns[0].ListView.Font = new Font(lstProduct.Columns[0].ListView.Font, FontStyle.Bold); //Bold lstProduct.Items.Clear(); List <ProductClass> searchProduct = new List <ProductClass>(); searchProduct = ProductDB_Class.SearchProduct(txtSearchProduct.Text); foreach (ProductClass product in searchProduct) { string[] row = { product.nameProduct, product.descriptionProduct, product.createdProduct.ToString("d"), product.updatedProduct.ToString("d"), product.costProduct.ToString(), statusName, statusID.ToString(), product.idProduct.ToString() }; ListViewItem listProduct = new ListViewItem(row); listProduct.Font = new Font(lstProduct.Font, FontStyle.Regular); lstProduct.Items.Add(listProduct); } }
private void btnDeleteProduct_Click(object sender, EventArgs e) { if (lstProduct.SelectedItems.Count > 0) { DialogResult result1 = MessageBox.Show("Delete " + "Product" + "?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { ListViewItem item = lstProduct.SelectedItems[0]; int idProduct = Convert.ToInt32(item.SubItems[7].Text); bool result = ProductDB_Class.DeleteProduct(idProduct); if (result) { FillListViewProduct(); MessageBox.Show("Product deleted"); } else { MessageBox.Show("Error"); } } } else { MessageBox.Show("Please select a product "); } }
private void FillListViewAddedOrder() { lstAddedOrder.Items.Clear(); List <ProductClass> products = new List <ProductClass>(); products = ProductDB_Class.GetProducts(); List <ProductStatusClass> statuses = new List <ProductStatusClass>(); statuses = Product_statusDBClass.GetProduct_status(); foreach (ProductClass product in products) { string statusName = ""; int statusID = 0; foreach (ProductStatusClass status in statuses) { if (product.idStatusProduct == status.id) { statusID = status.id; statusName = status.status; } } lstAddedOrder.Columns[0].ListView.Font = new Font(lstAddedOrder.Columns[0].ListView.Font, FontStyle.Bold); string[] row = { product.nameProduct, product.descriptionProduct, product.createdProduct.ToString("d"), product.updatedProduct.ToString("d"), product.costProduct.ToString(), statusName, statusID.ToString(), product.idProduct.ToString() }; ListViewItem listProduct1 = new ListViewItem(row); listProduct1.Font = new Font(listProduct1.Font, FontStyle.Regular); lstAddedOrder.Items.Add(listProduct1); } }
private void btnAddProduct_Click(object sender, EventArgs e) { ProductClass modifyProduct = new ProductClass(); String x = "AddProduct"; AddProduct addProductClick = new AddProduct(x, modifyProduct); var result = addProductClick.ShowDialog(); if (result == DialogResult.OK) { ProductClass AddProducts = addProductClick.added; bool returnedResult = ProductDB_Class.AddProduct(AddProducts); if (returnedResult) { FillListViewProduct(); MessageBox.Show("Product added"); } else { MessageBox.Show("Error"); } } }
private void btnModifyProduct_Click(object sender, EventArgs e) { ProductClass modifyProduct = new ProductClass(); if (lstProduct.SelectedItems.Count > 0) { ListViewItem item = lstProduct.SelectedItems[0]; modifyProduct.nameProduct = item.SubItems[0].Text; modifyProduct.descriptionProduct = item.SubItems[1].Text; modifyProduct.createdProduct = Convert.ToDateTime(item.SubItems[2].Text); modifyProduct.updatedProduct = Convert.ToDateTime(item.SubItems[3].Text); modifyProduct.costProduct = Convert.ToDouble(item.SubItems[4].Text); modifyProduct.idStatusProduct = Convert.ToInt32(item.SubItems[6].Text); modifyProduct.idProduct = Convert.ToInt32(item.SubItems[7].Text); String x = "ModifyProduct"; AddProduct modifyProductClick = new AddProduct(x, modifyProduct); var result = modifyProductClick.ShowDialog(); if (result == DialogResult.OK) { ProductClass modifyingProduct = modifyProductClick.modifiedProduct; bool returnedResult = ProductDB_Class.ModifyProduct(modifyingProduct); if (returnedResult) { FillListViewProduct(); MessageBox.Show("Product changed"); } else { MessageBox.Show("Error"); } } } else { MessageBox.Show("Please select a product "); } }