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);
}
