// modify in 3/11
public void selectGenerate(string supplierName, List<ReorderItem> list, List<ReorderItem> Orglist)
{
purchaseOrder po = new purchaseOrder();
po.purchaseOrderId = "PO" + supplierFacede.getCodeGeneratorValue_Lingna("PO");
po.supplierId = supplierFacede.getSupplier_Lingna(supplierName).supplierId;
DateTime date = DateTime.Now;
po.orderDate = date;
po.status = "Pending";
supplierFacede.createPurchaseOrder_Lingna(po);
foreach(ReorderItem r in Orglist)
{
supplierFacede.updateReorderItemStatus_Lingna(r.ReorderItemId, "Completed");
}
foreach (ReorderItem n in list)
{
purchaseOrderDetail pod = new purchaseOrderDetail();
pod.purchaseOrderId = po.purchaseOrderId;
string itemName = ConvertName(n.ItemName);
pod.itemId = catalogueFacade.getItem_Lingna(itemName).itemId;
pod.qty = n.QtyToOrder;
pod.amount = n.Amount;
supplierFacede.insertPurchaseOrderDetails_Lingna(po.purchaseOrderId, pod);
}
supplierFacede.updateCodeGeneratorValue_Lingna("PO");
}
//insertPurchaseOrderDetails_Lingna( )
public void insertPurchaseOrderDetails_Lingna(string poId, purchaseOrderDetail pod)
{
try
{
//purchaseOrder po = ctx.purchaseOrders.FirstOrDefault(o => o.purchaseOrderId == poId);
//po.purchaseOrderDetails.Add(pod);
ctx.purchaseOrderDetails.Add(pod);
ctx.SaveChanges();
}
catch (Exception)
{
throw;
}
}
