private void btnSave_Click(object sender, EventArgs e) { try { using (mCoyoteDBEntities1 context = new mCoyoteDBEntities1()) { Product product = new Product() { prodName = txtProdName.Text, prodCode = txtProdCode.Text, prodPrice = decimal.Parse(txtProdPrice.Text) }; context.Products.Add(product); context.SaveChanges(); this.Close(); } } catch (Exception) { MessageBox.Show("You must enter a value for each item"); } }
private void btnSearchProducts_Click(object sender, EventArgs e) { if (txtSearchProducts.Text != "") { using (mCoyoteDBEntities1 context = new mCoyoteDBEntities1()) { Product product = new Product(); string userSelected = txtSearchProducts.Text; var data = from b in context.Products where b.prodName.Contains(userSelected) select b; dtgProducts.DataSource = data.ToList(); } } }
private void btnEditProducts_Click(object sender, EventArgs e) { using (mCoyoteDBEntities1 context = new mCoyoteDBEntities1()) { Product product = new Product(); foreach (DataGridViewRow row in this.dtgProducts.SelectedRows) { Product prod = row.DataBoundItem as Product; if (prod != null) { frmEditProduct editProd = new frmEditProduct(prod.Id); editProd.ShowDialog(); } } loadProductDatagrid(); } }
private void btnDeleteProduct_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Are you sure you want to delete this product?", "Delete product", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { using (mCoyoteDBEntities1 context = new mCoyoteDBEntities1()) { Product product = new Product(); foreach (DataGridViewRow row in this.dtgProducts.SelectedRows) { Product prod = row.DataBoundItem as Product; if (prod != null) { Product prod_to_delete = context.Products.Single(c => c.Id == prod.Id); context.Products.Remove(prod_to_delete); } } context.SaveChanges(); loadProductDatagrid(); } } }