public IHttpActionResult ReturnAdjustedHistory([FromBody] BasicFourAttrsJsonObj obj)
{
var adjustedRecordList = new List <AdjustedRecord>();
var adjustmentRecords = _context.AdjustmentRecords
.Where(c => c.PurchaseOrder == obj.PurchaseOrder &&
c.Style == obj.Style &&
c.Color == obj.Color &&
c.Size == obj.Size)
.ToList();
foreach (var record in adjustmentRecords)
{
adjustedRecordList.Add(new AdjustedRecord {
AdjustedDate = record.AdjustDate,
AdjustedPcs = record.Adjustment,
Balance = record.Balance,
Memo = record.Memo
});
}
return(Created(Request.RequestUri
+ "/" + obj.PurchaseOrder
+ "&" + obj.Style
+ "&" + obj.Color
+ "&" + obj.Size, adjustedRecordList));
}
public IHttpActionResult ReturnOutboundHistoryRecords([FromBody] BasicFourAttrsJsonObj obj)
{
//var outboundHistoryList = new List<OutboundHistoryRecord>();
//var records = _context.PermanentLocIORecord
// .Where(c => c.PurchaseOrder == obj.PurchaseOrder
// && c.Style == obj.Style
// && c.Color == obj.Color
// && c.Size == obj.Size
// && c.FromLocation == "")
// .ToList();
//foreach (var record in records)
//{
// outboundHistoryList.Add(new OutboundHistoryRecord
// {
// OutboundDate = record.OperationDate,
// FromLocation = record.PermanentLoc,
// OutboundPcs = "-" + -record.InvChange,
// OrderPurchaseOrder = record.OrderPurchaseOrder
// });
//}
//return Created(Request.RequestUri
// + "/" + obj.PurchaseOrder
// + "&" + obj.Style
// + "&" + obj.Color
// + "&" + obj.Size, outboundHistoryList);
return(Ok());
}
public IHttpActionResult ReturnInboundHistory([FromBody] BasicFourAttrsJsonObj obj)
{
var inboundHistoryList = new List <InboundHistoryRecord>();
var inboundRecords = _context.ReplenishmentLocationDetails
.Include(x => x.GeneralLocationSummary)
.Where(c => c.PurchaseOrder == obj.PurchaseOrder &&
c.Style == obj.Style &&
c.Color == obj.Color &&
c.Size == obj.Size)
.ToList();
foreach (var record in inboundRecords)
{
if (record.GeneralLocationSummary != null)
{
inboundHistoryList.Add(new InboundHistoryRecord
{
FileName = record.GeneralLocationSummary.UploadedFileName,
Location = record.Location,
InboundPcs = "+" + record.Quantity.ToString(),
ResidualPcs = record.AvailablePcs
});
}
}
return(Ok(inboundHistoryList));
}
