private void btnPOUpdate_Click_1(object sender, EventArgs e)
{
dgvPOL.Enabled = true;
loadPurcaseOrderLineResultBindingSource.DataSource = db.GetPOL(poid).ToList();
xPO = db.Client_Purchase_Order.Single(po => po.Client_Purchase_Id == poid);
if (dgvPOL != null)
{
i = dgvPOL.RowCount - 1;
}
else
{
i = 0;
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
var q1 = db.Client_Purchase_Order.Where(c => c.Supplier_Order_Id == null)
.Select(c => c.Client_Purchase_Id).ToList();
var q = db.Client_Purchase_Order_Line.OrderBy(c => c.Product_ID).GroupBy(c => c.Product_ID).
Select(s => new { Client_Purchase_Order_Line = s.Key, totalquantity = s.Sum(r => r.Quantity), }).ToList();
var q2 = db.GetTotalQty().ToList();
if (MessageBox.Show("Are you sure you want to place order?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (q2.FirstOrDefault() != null)
{
addNewSO();
foreach (var item in q2)
{
newSOL = new Supplier_Order_Line()
{
Supplier_Order_Id = newSO.Supplier_Order_Id,
Product_ID = item.Product_ID,
Quantity = Convert.ToInt32(item.Total_Quantity)
};
db.Supplier_Order_Line.Add(newSOL);
}
foreach (var item in q1)
{
Client_Purchase_Order xpo = db.Client_Purchase_Order.Single(po => po.Client_Purchase_Id == item);
xpo.Supplier_Order_Id = newSO.Supplier_Order_Id;
}
db.SaveChanges();
dataGridView1.DataSource = db.GetSOL(newSO.Supplier_Order_Id).ToList();
}
else
{
MessageBox.Show("There are no client orders to be added");
}
}
}
catch (Exception)
{
throw;
}
}
private void btnPOLSave_Click(object sender, EventArgs e)
{
if (add == true)
{
newPO.Gross_Amount = Convert.ToDecimal(db.GetPOL(newPO.Client_Purchase_Id).Sum(pol => pol.Subtotal));;
newPO.Purchase_Order_Status_ID = 1;
if (MessageBox.Show("Would you like to have your order delivered", "Message",
MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
newPO.Dispatch_Type_Id = 1;
}
else
{
newPO.Dispatch_Type_Id = 2;
}
db.Client_Purchase_Order.Add(newPO);
newPO = null;
}
else if (update == true)
{
xPO.Gross_Amount = Convert.ToDecimal(db.GetPOL(newPO.Client_Purchase_Id).Sum(pol => pol.Subtotal));;
//db.Client_Purchase_Order.Add(newPO);
xPO = null;
}
db.SaveChanges();
dgvPOL.Refresh();
dgvPO.Refresh();
//dgvPOL.DataSource = db.GetPOL(pol.Client_Purchase_Id).ToList();
CalculateSubtotal();
//CalculateGrossAmount();
}
