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(); }