public void PersistPO(List <PurchaseOrderUtil> newPOUlist, POBatch batch, LUUser user)
{
Dictionary <PurchaseOrder, List <PurchaseOrderItems> > poitemsList = new Dictionary <PurchaseOrder, List <PurchaseOrderItems> >();
foreach (PurchaseOrderUtil npo in newPOUlist)
{
PurchaseOrder po = new PurchaseOrder();
po.PuchaseOrderNo = npo.PoNumber;
po.OrderEmpID = user.UserID;
po.OrderDate = npo.OrderDate;
po.DeliveryAddress = "Store Address";
po.POStatus = PurchaseOrderStatus.Requested.ToString();
po.SupplierID = npo.Supplier.SupplierID;
po.DONumber = "";
po.PORemark = npo.Remark;
po.ExpectedDeliveryDate = Convert.ToDateTime(npo.ExpectedDeliveryDate);
po.POBatchID = batch.POBatchID;
PODao.db.PurchaseOrders.Add(po);
PODao.db.SaveChanges();
poitemsList.Add(po, npo.Items);
}
PersistPoItems(poitemsList, user);
}
public void SavePurchaseOrder(List <PurchaseOrderUtil> newPOUlist, LUUser user)
{
PurchaseOrderItemDao poitem = new PurchaseOrderItemDao();
try
{
POBatch batch = new POBatch();
batch.POBatchDate = DateTime.Now;
batch.Printed = false;
batch.GeneratedBy = user.UserID;
POBatchDao.db.POBatches.Add(batch);
POBatchDao.db.SaveChanges();
PersistPO(newPOUlist, batch, user);
}
catch (DbEntityValidationException ea)
{
foreach (var eve in ea.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public bool CreatePO(POBatch poBactch, PurchaseOrder Order)
{
bool result = false;
LogicUniStoreModel db = new LogicUniStoreModel();
db.POBatches.Add(poBactch);
db.SaveChanges();
Order.POBatchID = poBactch.POBatchID;
db.PurchaseOrders.Add(Order);
result = db.SaveChanges() > 0 ? true : false;
return(result);
}
