private void displayDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == 6) { DataGridViewRow row = displayDataGridView.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(purchaseInvoiceComboBox.SelectedValue.ToString()), Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString()), retrival.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(grossLabel.Text) - Convert.ToSingle(row.Cells["totalGV"].Value.ToString()); grossLabel.Text = tot.ToString(); d.delete(Convert.ToInt64(row.Cells["mPIDgv"].Value.ToString()), "sp_deleteProductFromPID", "@mPID"); displayDataGridView.Rows.Remove(row); } sc.Complete(); } } } } }
public override void saveButton_Click(object sender, EventArgs e) { if (displayDataGridView.Rows.Count > 0) { Int64 purchaseInvoiceID; insertion i = new insertion(); updation u = new updation(); using (TransactionScope sc = new TransactionScope()) { purchaseInvoiceID = i.insertPurchaseInvoice(DateTime.Today, retrival.USER_ID, Convert.ToInt32(supplierComboBox.SelectedValue)); foreach (DataGridViewRow row in displayDataGridView.Rows) { co += i.insertPurchaseInvoiceDetails(purchaseInvoiceID, Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString()), Convert.ToSingle(row.Cells["totalGV"].Value.ToString())); if (r.checkProductPriceExistance(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()))) { u.updateProductPrice(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToSingle(row.Cells["pupGV"].Value.ToString())); } else { i.insertProductPrice(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToSingle(row.Cells["pupGV"].Value.ToString())); } int q; 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); } else { i.insertStock(Convert.ToInt32(row.Cells["proIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["quantGV"].Value.ToString())); } } if (co > 0) { MainClass.ShowMsg("Purchase Invoice Created Successfully.", "Success", "Success"); } else { MainClass.ShowMsg("Unable to create purchase invoice.", "Error", "Error"); } sc.Complete(); } } }