public ProductCount GetProductCount(string code)
{
Item item = _dataContext.Items.SingleOrDefault(p => p.ItemLookupCode.Equals(code) && p.Inactive == false);
if (item == null)
{
Alias alias = _dataContext.Aliases.SingleOrDefault(p => p.Alias1.Equals(code));
if (alias != null)
{
item = alias.Item;
}
}
ProductCount product = new ProductCount(_inventoryRef, item, Bin, _user);
product.Sku = item.ItemLookupCode;
product.Brand = item.SubDescription1;
product.Department = item.Department.Name;
product.Expected = (int)item.Quantity;
product.ExpectedBin = item.BinLocation;
product.Aliases.AddRange(item.Aliases.Select(p => p.Alias1));
return(product);
}
private void dgvProducts_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridViewRow row = dgvProducts.Rows[e.RowIndex];
ProductCount productCount = row.DataBoundItem as ProductCount;
if (productCount.HasChanges())
{
dgvProducts.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightYellow;
}
else
{
dgvProducts.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.White;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!Regex.IsMatch(tbQuantity.Text, "[0-9]"))
{
MessageBox.Show("Qty field must be a numeric value. Try Again !");
return;
}
int count = int.Parse(tbQuantity.Text);
string code = tbSKU.Text.ToUpper().Trim();
if (string.IsNullOrWhiteSpace(code))
{
MessageBox.Show("Invalid product code. Try again !");
return;
}
ProductCount productCount = _productCounts.SingleOrDefault(p => p.Sku.Equals(code) || p.Aliases.Any(s => s.Equals(code)));
if (productCount == null)
{
try
{
productCount = _productCountRepository.GetProductCount(code);
_productCounts.Add(productCount);
}
catch (Exception)
{
ShowNotFoundMessage(code);
return;
}
}
productCount.Counted = productCount.Counted + count;
dgvProducts.CurrentCell = dgvProducts.Rows.Cast <DataGridViewRow>().SingleOrDefault(r => r.DataBoundItem.Equals(productCount)).Cells[1];
UpdateBinTotalQty();
tbSKU.SelectAll();
}
