private void button2_Click(object sender, EventArgs e)
{
try
{
newCR = new Credit_Return()
{
Credit_Return_Date = DateTime.Today,
Received_By = textBox3.Text,
Returned_By = textBox2.Text
};
db.Credit_Return.Add(newCR);
var q = db.Client_Purchase_Order.Where(po => po.PO_Number == PO).FirstOrDefault();
poid = Convert.ToInt32(q.Client_Purchase_Id);
dataGridView1.DataSource = db.GetPOL(poid).ToList();
}
catch (Exception)
{
}
}
private void btnPOLRemove_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to remove this item?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
try
{
db.Client_Purchase_Order_Line.
Remove(db.Client_Purchase_Order_Line.Where(pol => pol.Client_Purchase_Order_Line_ID == polid).
FirstOrDefault() as Client_Purchase_Order_Line);
db.SaveChanges();
loadPurcaseOrderLineResultBindingSource.DataSource = db.GetPOL(poid).ToList();
CalculateSubtotal();
//decimal sum = 0;
//xPO = db.Client_Purchase_Order.Single(p => p.Client_Purchase_Id == poid);
//foreach (DataGridViewRow ar in dgvPOL.Rows)
//{
// sum += (Convert.ToInt32(ar.Cells[dgvPOL.Columns["quantity"].Index].Value) *
//Convert.ToDecimal(ar.Cells[dgvPOL.Columns["order_price"].Index].Value));
//}
//xPO.Gross_Amount = sum;
if (r.IsNewRow == false)
{
decimal grossAmount = Convert.ToDecimal(db.GetPOL(newPO.Client_Purchase_Id).Sum(pol => pol.Subtotal));
}
//db.Client_Purchase_Order.a(xpo);
db.SaveChanges();
dgvPO.DataSource = db.Load_Purchase_Order().ToList();
//dgvPO.Refresh();
// btnPOLRemove.Enabled = false;
}
catch (Exception)
{
MessageBox.Show("Table is empty. There are no records to be removed.");
}
}
}
