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