public int getStockCountOfItem(string itemId)
{
StockCountItem item = context.StockCountItems.First(i => i.ItemID == itemId);
context.Entry <StockCountItem>(item).Reload();
return((int)item.QtyInStock);
}
public StockVoucherPayload(StockCountItem sci, IStockManagementService stockManagementService)
{
ItemID = sci.ItemID;
ItemName = sci.ItemName;
UnitOfMeasure = sci.UnitOfMeasure;
QtyInStock = sci.QtyInStock;
UnitCost = stockManagementService.getUnitCostOfItem(ItemID);
}
private void AddItem(StockCountItem item)
{
DataRow[] rows = entryTable.Select(string.Format("ITEMNUMBER = '{0}'", item.ItemNumber));
bool isItemVarinatExists = false;
DataRow selectedRow = GetCurrentRow();
if (isEdit && selectedRow != null)
{
// Edit Quantity of an existing row
selectedRow[DataAccessConstants.Quantity] = item.Quantity;
selectedRow[DataAccessConstants.JournalId] = this.SelectedJournalId;
}
else
{
if (rows != null && rows.Length > 0)
{
foreach (DataRow row in rows)
{
if (row[DataAccessConstants.InventSizeId].ToString() == (saleLineItem.Dimension.SizeId ?? string.Empty) &&
row[DataAccessConstants.InventColorId].ToString() == (saleLineItem.Dimension.ColorId ?? string.Empty) &&
row[DataAccessConstants.InventStyleId].ToString() == (saleLineItem.Dimension.StyleId ?? string.Empty) &&
row[DataAccessConstants.ConfigId].ToString() == (saleLineItem.Dimension.ConfigId ?? string.Empty))
{
row[DataAccessConstants.JournalId] = this.SelectedJournalId;
// Increment Quantity of an existing row
decimal oldQuantity = (decimal)row[DataAccessConstants.Quantity];
row[DataAccessConstants.Quantity] = oldQuantity + item.Quantity;
row[DataAccessConstants.UserId] = ApplicationSettings.Terminal.TerminalOperator.OperatorId;
row[DataAccessConstants.TerminalId] = ApplicationSettings.Terminal.TerminalId;
row[DataAccessConstants.CountDate] = DateTime.Now;
row[DataAccessConstants.InventSizeId] = saleLineItem.Dimension.SizeId ?? string.Empty;
row[DataAccessConstants.InventColorId] = saleLineItem.Dimension.ColorId ?? string.Empty;
row[DataAccessConstants.InventStyleId] = saleLineItem.Dimension.StyleId ?? string.Empty;
row[DataAccessConstants.ConfigId] = saleLineItem.Dimension.ConfigId ?? string.Empty;
isItemVarinatExists = true;
break;
}
}
if (!isItemVarinatExists)
{
AddNewRow(item);
}
}
else
{
AddNewRow(item);
}
}
ResetNumpad();
}
private void AddNewRow(StockCountItem item)
{
// add a new row
DataRow row = entryTable.NewRow();
row[DataAccessConstants.JournalId] = this.SelectedJournalId;
row[DataAccessConstants.OperationType] = 0;
row[DataAccessConstants.ItemNumber] = item.ItemNumber;
row[DataAccessConstants.ItemName] = item.ItemName;
row[DataAccessConstants.Counted] = 0;
row[DataAccessConstants.Quantity] = item.Quantity;
row[DataAccessConstants.Unit] = item.Unit;
row[DataAccessConstants.UserId] = ApplicationSettings.Terminal.TerminalOperator.OperatorId;
row[DataAccessConstants.TerminalId] = ApplicationSettings.Terminal.TerminalId;
row[DataAccessConstants.CountDate] = DateTime.Now;
row[DataAccessConstants.Status] = (int)StockCountStatus.Pending;
row[DataAccessConstants.InventSizeId] = saleLineItem.Dimension.SizeId ?? string.Empty;
row[DataAccessConstants.InventColorId] = saleLineItem.Dimension.ColorId ?? string.Empty;
row[DataAccessConstants.InventStyleId] = saleLineItem.Dimension.StyleId ?? string.Empty;
row[DataAccessConstants.ConfigId] = saleLineItem.Dimension.ConfigId ?? string.Empty;
row["COMMENT"] = ColorSizeStyleConfig(saleLineItem);
try
{
entryTable.Rows.Add(row);
}
catch (ArgumentException ex)
{
LSRetailPosis.ApplicationExceptionHandler.HandleException(this.ToString(), ex);
}
catch (NoNullAllowedException ex)
{
LSRetailPosis.ApplicationExceptionHandler.HandleException(this.ToString(), ex);
}
catch (ConstraintException ex)
{
LSRetailPosis.ApplicationExceptionHandler.HandleException(this.ToString(), ex);
}
}
public async Task <IActionResult> OnPostInsert([FromBody] StockCountItem obj)
{
if (obj != null)
{
try
{
_context.Add(obj);
await _context.SaveChangesAsync();
int id = obj.StockCountItemID; // Yes it's here
return(new JsonResult(id));
}
catch (DbUpdateException d)
{
return(new JsonResult("Stock Item Not Added." + d.InnerException.Message));
}
}
else
{
return(new JsonResult("Stock Item not Loaded"));
}
}
private void InventoryLookup(string barcode)
{
if (inputMode == NumPadMode.Barcode)
{
if (GetItemInfo(barcode))
{
// set mode to quantity
SetInputMode(NumPadMode.Quantity);
}
else
{
// clear the current item so the user can try again
ResetNumpad();
}
}
else if ((inputMode == NumPadMode.Quantity) && (saleLineItem != null) && !string.IsNullOrEmpty(numPad1.EnteredValue))
{
// add to list
StockCountItem item = new StockCountItem();
item.ItemNumber = this.saleLineItem.ItemId;
item.Unit = this.saleLineItem.InventOrderUnitOfMeasure;
item.ItemName = this.saleLineItem.Description;
Decimal quantity = 0;
Decimal.TryParse(numPad1.EnteredValue, out quantity);
item.Quantity = StockCount.InternalApplication.Services.Rounding.Round(quantity, 3);
AddItem(item);
SetInputMode(NumPadMode.Barcode);
}
// When finished, put focus back into the numpad
numPad1.Select();
}
