private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { int q; if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == 6) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; DialogResult dr = MessageBox.Show("Are u sure,want to delete? " + row.Cells["proGV"].Value.ToString() + "from purchase invoice ?\nWARNING\t\nDELETION OF PRODUCT WILL EFFECT STOCK", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Information); 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()), 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()), "st_deleteProductFromPID", "@mPID"); dataGridView1.Rows.Remove(row); } sc.Complete(); } } } } }
public override void button3_Click(object sender, EventArgs e) { if (dataGridView1.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(supplierDD.SelectedValue)); foreach (DataGridViewRow row in dataGridView1.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.checkproductPriceExistence(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.showMG("Purchase Invoice Created Successfullly..", "success", "success"); } else { MainClass.showMG("error", "error", "error"); } sc.Complete(); } } }
private void barcodeTxt_Validating(object sender, CancelEventArgs e) { if (barcodeTxt.Text != "") { GrossTxt.Text = ""; TotalDiscountTxt.Text = ""; amountTxt.Text = ""; changeGiveTxt.Text = ""; int qCount = 0; int sQuant = 0; int nCount = 0; prodARR = r.getProductsWRTBarcode(barcodeTxt.Text); foreach (DataGridViewRow row in dataGridView1.Rows) { if (prodARR[0] == row.Cells["proIDGV"].Value.ToString()) { qCount = qCount + Convert.ToInt32(row.Cells["quantGV"].Value.ToString()); } } sQuant = Convert.ToInt32(r.getProductQuantity(Convert.ToInt64(prodARR[0]))); nCount = sQuant - qCount; if (nCount <= 0) { } else { if (dataGridView1.RowCount == 0) { dataGridView1.Rows.Add(Convert.ToInt32(prodARR[0]), prodARR[1], 1, Convert.ToSingle(prodARR[3]), prodARR[4], Convert.ToSingle(prodARR[5])); } else { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells["proIDGV"].Value.ToString() == prodARR[0]) { productCheck = true; break; } else { productCheck = false; } } if (productCheck == true) { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells["proIDGV"].Value.ToString() == prodARR[0]) { float disc = 0; row.Cells["quantGV"].Value = Convert.ToInt32(row.Cells["quantGV"].Value.ToString()) + 1; if (row.Cells["disGV"].Value.ToString() != null) { disc = Convert.ToSingle(row.Cells["disGV"].Value.ToString()) + Convert.ToSingle(row.Cells["disGV"].Value.ToString()); row.Cells["disGV"].Value = disc; } float tot = (Convert.ToSingle(row.Cells["pupGV"].Value.ToString()) * Convert.ToInt32(row.Cells["quantGV"].Value.ToString())) - Convert.ToSingle(row.Cells["disGV"].Value.ToString()); row.Cells["totalGV"].Value = tot; } } } else { dataGridView1.Rows.Add(Convert.ToInt32(prodARR[0]), prodARR[1], 1, Convert.ToSingle(prodARR[3]), prodARR[4], Convert.ToSingle(prodARR[5])); } } foreach (DataGridViewRow item in dataGridView1.Rows) { GROSS += Convert.ToSingle(item.Cells["totalGV"].Value.ToString()); } grossLabel.Text = GROSS.ToString(); GROSS = 0; barcodeTxt.Focus(); barcodeTxt.Clear(); } } }