private void updateSoldItemsStatus()
{
try
{
foreach (DataGridViewRow x in dgvOrder.Rows)
{
int n = x.Index;
modelno = dgvOrder.Rows[n].Cells["Col1"].Value.ToString();
prodId = ctx.Products.FirstOrDefault(p => p.ModelNo == modelno).Id;
// updating each products
Product product = ctx.Products.FirstOrDefault(p => p.Id == prodId);
product.Quantity -= int.Parse(dgvOrder.Rows[n].Cells["Col4"].Value.ToString());
// updating each sold item status ...
SoldItem sitem = ctx.SoldItems.FirstOrDefault(s => s.SalesId == Id && s.Status == 0);
sitem.Status = 1;
ctx.SaveChanges();
}
}
catch (Exception)
{
label6.Text = "Database error has occurred!";
label6.ForeColor = Color.Yellow;
}
}
private void saveSoldItems()
{
try
{
foreach (DataGridViewRow x in dgvOrder.Rows)
{
int n = x.Index;
modelno = dgvOrder.Rows[n].Cells["modelNo1"].Value.ToString();
prodId = ctx.Products.FirstOrDefault(p => p.ModelNo == modelno).Id;
// adding each item sold in the salesitem table
SoldItem item = new SoldItem()
{
SalesId = lastSalesID,
ProductId = prodId,
Quantity = int.Parse(dgvOrder.Rows[n].Cells["quantity"].Value.ToString()),
Status = (total == decimal.Parse(txtTendered.Text) ? 1 : 0)
};
ctx.SoldItems.Add(item);
// updating each products
if (total == decimal.Parse(txtTendered.Text))
{
Product product = ctx.Products.FirstOrDefault(p => p.Id == prodId);
product.Quantity -= int.Parse(dgvOrder.Rows[n].Cells["quantity"].Value.ToString());
}
ctx.SaveChanges();
}
}
catch (Exception)
{
label6.Text = "Database error has occurred!";
label6.ForeColor = Color.Yellow;
}
}
