private void tsbDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } if (MessageBox.Show("Delete the selected customer/vendor will also delete its related BOM/Offer", "Warning", MessageBoxButtons.OKCancel) == DialogResult.Cancel) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenIdSelected = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferList = entity.publicbomoffer.Where(bomOffer => bomOffer.BomCustVendId == custVenIdSelected); foreach (var bomOffer in bomOfferList) { entity.DeleteObject(bomOffer); } entity.DeleteObject(entity.publiccustven.Where(cv => cv.custVenId == custVenIdSelected).First()); entity.SaveChanges(); } BomOfferCustVendor_Load(this, null); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { return; } if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferItem = entity.publicbomoffer.First(item => item.BomCustVendId == bomOfferId); entity.DeleteObject(bomOfferItem); entity.SaveChanges(); } BomOfferList_Load(this, null); }
private void tsbDeleteItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; if (MessageBox.Show("Delete the selected item?", "Delete", MessageBoxButtons.YesNo) == DialogResult.No) { return; } DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int bomOfferId = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferItem = entity.publicbomoffer.First(item => item.BomCustVendId == bomOfferId); entity.DeleteObject(bomOfferItem); entity.SaveChanges(); } BomOfferList_Load(this,null); }
private void tsbDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) return; if (MessageBox.Show("Delete the selected customer/vendor will also delete its related BOM/Offer", "Warning", MessageBoxButtons.OKCancel) == DialogResult.Cancel) return; DataGridViewRow dgvr = dataGridView1.SelectedRows[0]; int custVenIdSelected = Convert.ToInt32(dgvr.Cells["Id"].Value); using (BomOfferEntities entity = new BomOfferEntities()) { var bomOfferList = entity.publicbomoffer.Where(bomOffer => bomOffer.BomCustVendId == custVenIdSelected); foreach (var bomOffer in bomOfferList) { entity.DeleteObject(bomOffer); } entity.DeleteObject(entity.publiccustven.Where(cv => cv.custVenId == custVenIdSelected).First()); entity.SaveChanges(); } BomOfferCustVendor_Load(this, null); }