private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == 6) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; DialogResult dr = MessageBox.Show("Are you sure, you want to delete " + row.Cells["proGV"].Value.ToString() + " from purchase invoice?\n\t\t\tWARNING\nDELETION OF PRODUCT WILL EFFECT STOCK", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); int q; if (dr == DialogResult.Yes) { using (TransactionScope sc = new TransactionScope()) { i.insertDeletedItem(Convert.ToInt64(purDD.SelectedValue.ToString()), Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString()), retrieval.USER_ID, DateTime.Today); object ob = r.getProductQuantity(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString())); if (ob != null) { q = Convert.ToInt32(ob); q -= Convert.ToInt32(row.Cells["quantGV"].Value.ToString()); u.updateStock(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), q); float tot = Convert.ToSingle(grossTotLabel.Text) - Convert.ToSingle(row.Cells["TotGV"].Value.ToString()); grossTotLabel.Text = tot.ToString(); d.delete(Convert.ToInt64(row.Cells["mPIDgv"].Value.ToString()), "st_deleteProductFromPID", "@mPID"); dataGridView1.Rows.Remove(row); } sc.Complete(); } } } } }
public override void deleteBTN_Click(object sender, EventArgs e) { if (edit == 1) { DialogResult dr = MessageBox.Show("Are you sure , you want to delete record", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { deletion d = new deletion(); d.delete(catID, "st_deleteCategory", "@id"); r.showCategories(dataGridView1, catIDGV, NameGV, statusGV); } } }
public override void deleteBtn_Click(object sender, EventArgs e) { if (edit == 1) { DialogResult dr = MessageBox.Show("Are you sure , you want to delete record", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { deletion d = new deletion(); d.delete(SupplierID, "st_deleteSupplier", "@suppID"); r.showSuppliers(dataGridView1, suppIDGV, companyGV, personGV, phone1GV, phone2GV, addressGV, ntnGV, statusGV); } } }
public override void deleteBtn_Click(object sender, EventArgs e) { if (edit == 1) { DialogResult dr = MessageBox.Show("Are you sure , you want to delete record", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { deletion d = new deletion(); d.delete(prodID, "s_productDelete", "@proID"); r.showProducts(dataGridView1, proIDGV, proGV, expiryGV, catGV, priceGV, barcodeGV, catIDGV); } } }
public override void deleteBtn_Click(object sender, EventArgs e) { if (edit == 1) { DialogResult dr = MessageBox.Show("Are you sure , you want to delete record", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { deletion d = new deletion(); d.delete(userID, "st_deleteUser", "@id"); r.showUsers(dataGridView1, userIDGV, NameGV, USerNameGV, PassGV, EmailGV, PhoneGV, statusGV); } } }