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();
}
}
}