private InventoryLines createdInventory(DeliveryOrder transactionApi, int i)
{
InventoryLines inventory = new InventoryLines();
inventory.WarehouseId = transactionApi.warehouseTo;
inventory.Qty = 0;
inventory.ItemId = transactionApi.deliveryOrderLines[i].articleIdFk;
_context.Add(inventory);
_context.SaveChanges();
return(inventory);
}
private void insertAndCalculateDO(DeliveryOrder transactionApi)
{
for (int i = 0; i < transactionApi.deliveryOrderLines.Count; i++)
{
try
{
InventoryLines inventoryLines = new InventoryLines();
bool exist = _context.InventoryLines.Any(c => c.WarehouseId == transactionApi.warehouseTo && c.ItemId == transactionApi.deliveryOrderLines[i].articleIdFk);
if (exist)
{
inventoryLines = _context.InventoryLines.Where(c => c.WarehouseId == transactionApi.warehouseTo && c.ItemId == transactionApi.deliveryOrderLines[i].articleIdFk).First();
}
else
{
inventoryLines = this.createdInventory(transactionApi, i);
}
//Remark sementara
//InventoryTransactionLines transaction = new InventoryTransactionLines();
//transaction.TransactionTypeId = RetailEnum.DeliveryOrder;
//transaction.TransactionTypeName = "DeliveryOrder";
//transaction.TransRefId = transactionApi.deliveryOrderId;
//transaction.Qty = transactionApi.deliveryOrderLines[i].qtyReceive;
//transaction.TransactionLinesId = inventoryLines.Id;
//transaction.TransactionDate = DateTime.Now;//DateTime.ParseExact(transactionApi.date, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
//_context.Add(transaction);
//_context.SaveChanges();
////update qty
//inventoryLines.Qty = _context.InventoryTransactionLines.
// Where(c => c.InventoryTransactionId == inventoryLines.Id)
// .Select(c => c.Qty)
// .DefaultIfEmpty()
// .Sum();
//_context.InventoryLines.Update(inventoryLines);
//_context.SaveChanges();
}
catch (Exception ex)
{
}
}
}
private async Task inventory(WebAPIModel.Transaction transactionApi)
{
//transactionApi.storeCode = "AAB";
for (int i = 0; i < transactionApi.transactionLines.Count; i++)
{
InventoryLines inventoryLines = _context.InventoryLines.Where(c => c.WarehouseId == transactionApi.storeCode && c.ItemId == transactionApi.transactionLines[i].article.id).First();
if (inventoryLines != null)
{
//Remark Sementara
//InventoryLinesTransaction transaction = new InventoryLinesTransaction();
//transaction.TransactionTypeId = RetailEnum.SalesTransaction;
//transaction.TransactionTypeName = "SalesTransaction";
//transaction.TransRefId = transactionApi.transactionId;
//transaction.Qty = -1 * transactionApi.transactionLines[i].quantity;
//transaction.TransactionLinesId = inventoryLines.Id;
//try
//{
// transaction.TransactionDate = DateTime.ParseExact(transactionApi.timeStamp, "MMM dd, yyyy h:mm:ss tt", CultureInfo.InvariantCulture);
//}
//catch
//{
// // transaction.TransactionDate = DateTime.ParseExact(transactionApi.timeStamp, "dd/MM/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
// transaction.TransactionDate = DateTime.ParseExact(transactionApi.date + transactionApi.time, "yyyy-MM-dd" + "H:mm:ss", CultureInfo.InvariantCulture);
//}
//_context.Add(transaction);
//await _context.SaveChangesAsync();
////update qty
//inventoryLines.Qty = _context.InventoryLinesTransaction.
// Where(c => c.TransactionLinesId == inventoryLines.Id)
// .Select(c => c.Qty)
// .DefaultIfEmpty()
// .Sum();
//_context.InventoryLinesTransaction.Update(transaction);
//await _context.SaveChangesAsync();
}
}
}
