public async Task <IActionResult> GetCRMID(string id)
{
SAPContext context = HttpContext.RequestServices.GetService(typeof(SAPContext)) as SAPContext;
SAPbobsCOM.BusinessPartners items = (SAPbobsCOM.BusinessPartners)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners);
SAPbobsCOM.SalesPersons seller = (SAPbobsCOM.SalesPersons)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oSalesPersons);
SAPbobsCOM.PaymentTermsTypes payment = (SAPbobsCOM.PaymentTermsTypes)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oPaymentTermsTypes);
SAPbobsCOM.UserTable sboTable = (SAPbobsCOM.UserTable)context.oCompany.UserTables.Item("SO1_01FORMAPAGO");
JToken pagos = context.XMLTOJSON(sboTable.GetAsXML())["OCRD"];
if (items.GetByKey(id))
{
JToken temp = context.XMLTOJSON(items.GetAsXML());
temp["OCRD"] = temp["OCRD"][0];
if (seller.GetByKey(temp["OCRD"]["SlpCode"].ToObject <int>()))
{
JToken temp2 = context.XMLTOJSON(seller.GetAsXML());
temp["OSLP"] = temp2["OSLP"][0];
}
if (payment.GetByKey(temp["OCRD"]["GroupNum"].ToObject <int>()))
{
JToken temp3 = context.XMLTOJSON(payment.GetAsXML());
temp["OCTG"] = temp3["OCTG"][0];
}
temp["PAGO"] = pagos;
return(Ok(temp));
}
return(NotFound("No Existe Contacto"));
}
public async Task<IActionResult> Get() {
SAPContext context = HttpContext.RequestServices.GetService(typeof(SAPContext)) as SAPContext;
SAPbobsCOM.PaymentTermsTypes payment = (SAPbobsCOM.PaymentTermsTypes)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oPaymentTermsTypes);
SAPbobsCOM.Recordset oRecSet = (SAPbobsCOM.Recordset)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
List<Object> list = new List<Object>();
JToken temp;
oRecSet.DoQuery("Select * From OCTG");
payment.Browser.Recordset = oRecSet;
payment.Browser.MoveFirst();
while (payment.Browser.EoF == false) {
temp = context.XMLTOJSON(payment.GetAsXML());
temp = temp["OCTG"][0];
list.Add(temp);
payment.Browser.MoveNext();
}
return Ok(list);
}