public List <usp_GetPurchaseOrderList_Result> GetList()
{
PurchaseOrderList.Clear();
using (var context = new SupplierEDI_Entities())
{
var tranDT = new ObjectParameter("tranDT", typeof(DateTime?));
var result = new ObjectParameter("result", typeof(int?));
var debugMsg = new ObjectParameter("debugMsg", typeof(string));
var resultSet = context.usp_GetPurchaseOrderList(tranDT, result, 0, debugMsg);
PurchaseOrderList.AddRange(resultSet.ToList());
}
return(PurchaseOrderList);
}
public string GetPreview(Int32 purchaseOrderNumber)
{
using (var context = new SupplierEDI_Entities())
{
var tradingPartnerCode = context.PurchaseOrders
.First(po => po.PurchaseOrderNumber == purchaseOrderNumber).TradingPartnerCode;
var xml830 = new ObjectParameter("xml830", typeof(string));
var tranDT = new ObjectParameter("tranDT", typeof(DateTime?));
var result = new ObjectParameter("result", typeof(int?));
var debugMsg = new ObjectParameter("debugMsg", typeof(string));
context.usp_Get830XML(tradingPartnerCode, purchaseOrderNumber.ToString(), null, "05", false, xml830, result,
tranDT, 0, debugMsg);
if (xml830.Value is System.DBNull)
{
return("<xml>Invalid map or no map defined.</xml>");
}
return((string)xml830.Value);
}
}
