public bool Delete(string documentNo, DbTransaction parentTransaction)
{
var goodsissuedetailItem = new GoodsIssueDetail {
DocumentNo = documentNo
};
return(Delete(goodsissuedetailItem, parentTransaction));
}
public async Task <IActionResult> Get(uint DocEntry)
{
SAPContext context = HttpContext.RequestServices.GetService(typeof(SAPContext)) as SAPContext;
SAPbobsCOM.Recordset oRecSet = (SAPbobsCOM.Recordset)context.oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
oRecSet.DoQuery($@"
SELECT
document.""DocEntry"",
document.""DocNum"",
to_char(to_date(SUBSTRING(document.""DocDate"", 0, 10), 'YYYY-MM-DD'), 'DD-MM-YYYY') as ""DocDate"",
(case when document.""CANCELED"" = 'Y' then 'Cancelado'
when document.""DocStatus"" = 'O' then 'Abierto'
when document.""DocStatus"" = 'C' then 'Cerrado'
else document.""DocStatus"" end) AS ""DocStatus"",
warehouse.""WhsName""
FROM OIGE document
LEFT JOIN NNM1 series ON series.""Series"" = document.""Series""
LEFT JOIN OWHS warehouse ON warehouse.""WhsCode"" = series.""SeriesName""
WHERE document.""DocEntry"" = '{DocEntry}';");
if (oRecSet.RecordCount == 0)
{
return(NoContent());
}
JToken temp = context.XMLTOJSON(oRecSet.GetAsXML())["OIGE"][0];
oRecSet.DoQuery($@"
Select
""ItemCode"",
""Dscription"",
""Quantity"",
""UomCode"",
""InvQty"",
""UomCode2""
From IGE1 Where ""DocEntry"" = '{DocEntry}';");
temp["Lines"] = context.XMLTOJSON(oRecSet.GetAsXML())["IGE1"];
GoodsIssueDetail output = temp.ToObject <GoodsIssueDetail>();
//Force Garbage Collector. Recommendation by InterLatin Dude. SDK Problem with memory.
GC.Collect();
GC.WaitForPendingFinalizers();
return(Ok(output));
}
public bool DeleteGoodsIssueDetail(GoodsIssueDetail item)
{
return(goodsissusdetailDAL.Delete(item));
}
public bool SaveGoodsIssueDetail(GoodsIssueDetail newItem)
{
return(goodsissusdetailDAL.Save(newItem));
}
