private void ConvertToPurchaseOrderEntity(PODETAIL item, Entity.PurchaseProcessDetail ppDetail) { ppDetail.Item = new Entity.Item() { ItemCode = item.ITEM.ITCODE, ItemDescription = item.ITEM.ITDESC, ItemRate = item.ITEM.ITRATE }; ppDetail.PurchaseOrderDetail = new Entity.PODetail() { Quantity = item.QTY }; ppDetail.PurchaseOrderMaster = new Entity.POMaster() { PurchaseOrderDate = item.POMASTER.PODATE, PurchaseOrderNo = item.PONO }; ppDetail.Supplier = new Entity.Supplier() { SupplierAddress = item.POMASTER.SUPPLIER.SUPLADDR, SupplierName = item.POMASTER.SUPPLIER.SUPLNAME, SupplierNo = item.POMASTER.SUPPLIER.SUPLNO }; }
public bool processUpdatePurchaseOrderDAC(Entity.PurchaseProcessDetail purchaseProcessDetail) { var PPDetail = new Entity.PurchaseProcessDetail(); using (var purchaseDetail = new Entities()) { // PPDetail.Item = new Item(); var Item = (from p in purchaseDetail.PODETAIL join pm in purchaseDetail.POMASTER on p.PONO equals pm.PONO join t in purchaseDetail.ITEM on p.ITCODE equals t.ITCODE join s in purchaseDetail.SUPPLIER on pm.SUPLNO equals s.SUPLNO where p.PONO == purchaseProcessDetail.PurchaseOrderDetail.PurchaseOrderNo select p).FirstOrDefault(); MapforUpdateItems(Item, purchaseProcessDetail); rowAffected = purchaseDetail.SaveChanges(); } if (rowAffected > 0) { return(true); } else { return(false); } }
private void MapforUpdateItems(PODETAIL item, Entity.PurchaseProcessDetail purchaseProcessDetail) { if (purchaseProcessDetail.Item != null) { //if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Item.ItemCode)) //{ // item.ITEM.ITCODE = purchaseProcessDetail.Item.ItemCode; //} if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Item.ItemDescription)) { item.ITEM.ITDESC = purchaseProcessDetail.Item.ItemDescription; } if (purchaseProcessDetail.Item.ItemRate != null) { item.ITEM.ITRATE = purchaseProcessDetail.Item.ItemRate; } } if (purchaseProcessDetail.PurchaseOrderDetail != null) { if (purchaseProcessDetail.PurchaseOrderDetail.Quantity != null) { item.QTY = purchaseProcessDetail.PurchaseOrderDetail.Quantity; } } if (purchaseProcessDetail.PurchaseOrderMaster != null) { if (purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderDate != null) { item.POMASTER.PODATE = purchaseProcessDetail.PurchaseOrderMaster.PurchaseOrderDate; } } if (purchaseProcessDetail.Supplier != null) { if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Supplier.SupplierName)) { item.POMASTER.SUPPLIER.SUPLNAME = purchaseProcessDetail.Supplier.SupplierName; } if (!string.IsNullOrWhiteSpace(purchaseProcessDetail.Supplier.SupplierAddress)) { item.POMASTER.SUPPLIER.SUPLADDR = purchaseProcessDetail.Supplier.SupplierAddress; } } }
public Entity.PurchaseProcessDetail RetrievePurchaseOrderDAC(string purchaseOrderNo) { var PPDetail = new Entity.PurchaseProcessDetail(); using (var purchaseDetail = new Entities()) { // PPDetail.Item = new Item(); var Item = (from p in purchaseDetail.PODETAIL join pm in purchaseDetail.POMASTER on p.PONO equals pm.PONO join t in purchaseDetail.ITEM on p.ITCODE equals t.ITCODE join s in purchaseDetail.SUPPLIER on pm.SUPLNO equals s.SUPLNO where p.PONO == purchaseOrderNo select p).FirstOrDefault(); ConvertToPurchaseOrderEntity(Item, PPDetail); } return(PPDetail); }
public bool processUpdatePurchaseOrder(Entity.PurchaseProcessDetail purchaseProcessDetail) { var result = purchaseOrderDAC.processUpdatePurchaseOrderDAC(purchaseProcessDetail); return(result); }