Unhandled Exception: Not able to BeginEdit, EditItem is already set
15 Replies
I have more or less hijacked this thread because I'm having the same problems.
I don't know Cliffe and I don't know his use-case but I can tell you mine.
I'm working on a very simple cash register:
The textbox with the Barcode label is getting the barcode from my barcode scanner.
On the KeyDown event I check for the Enter key and then get the product from my SQLite database based on the barcode:
private void txtBarcode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyData != Keys.Enter) return;
var product = SqliteService.GetProductByBarcode(txtBarcode.Text) ??
new Product {Barcode = txtBarcode.Text, Price = 1};
AddToOrder(product);
}
This product is added to the datagrid:
private void AddToOrder(Product product)
{
var orderline = _order.OrderLines.FirstOrDefault(x => x.Barcode == product.Barcode);
if (orderline == null)
{
_order.OrderLines.Add(SqliteService.ProductToOrderLine(product));
}
else
{
orderline.Amount++;
}
txtBarcode.Text = string.Empty;
txtBarcode.Focus();
_totalAmountOrder++;
lblTotalAmountOrder.Text = _totalAmountOrder + @" stuks";
_totalPriceOrder += product.Price;
SetLblTotalPriceOrder();
}
Order and OrderLines are defined as:
public class Order: IDisposable
{
public int Id { get; set; }
public DateTime CreatedAt { get; set; }
public double TotalPrice { get; set; }
public ObservableCollection<OrderLine> OrderLines { get; set; }
public Order()
{
CreatedAt = DateTime.Now;
OrderLines = new ObservableCollection<OrderLine>();
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
protected virtual void Dispose(bool isdisposable)
{
OrderLines?.Clear();
}
}
public class OrderLine : INotifyPropertyChanged
{
private double _price;
private string _name;
private int _id;
private int _productId;
private string _barcode;
private int _amount;
[Display(AutoGenerateField = false)]
public int Id
{
get { return _id; }
set
{
if (value == _id) return;
_id = value;
OnPropertyChanged(nameof(Id));
}
}
public int ProductId
{
get { return _productId; }
set
{
if (value == _productId) return;
_productId = value;
OnPropertyChanged(nameof(ProductId));
}
}
[Display(Name = "Name")]
public string Name
{
get { return _name; }
set
{
if (value == _name) return;
_name = value;
OnPropertyChanged(nameof(Name));
}
}
[Display(Name = "Prijs")]
public double Price
{
get { return _price; }
set
{
if (value.Equals(_price)) return;
_price = value;
OnPropertyChanged(nameof(Price));
}
}
public string Barcode
{
get { return _barcode; }
set
{
if (value == _barcode) return;
_barcode = value;
OnPropertyChanged(nameof(Barcode));
}
}
[Display(Name = "Aantal")]
public int Amount
{
get { return _amount; }
set
{
if (value == _amount) return;
_amount = value;
OnPropertyChanged(nameof(Amount));
}
}
// Navigation
public Order Order { get; set; }
public event PropertyChangedEventHandler PropertyChanged;
[NotifyPropertyChangedInvocator]
protected virtual void OnPropertyChanged([CallerMemberName] string propertyName = null)
{
PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
}
}
When the big 'Nieuw' (New) button is clicked. The form is reset, the order is saved to the database and the datagrid source is reset:
private void newOrder()
{
ResetForm();
SaveOrder();
_order = new Order();
sfDataGrid1.DataSource = _order.OrderLines;
}
Because it is possible the price in the database is not right or the product wasn't found in the database, the user must be able to change the price in the datagrid.
In order to let the barcode scanner work correctly, the focus needs to be in the textbox. So when the price is edited (making the datagrid have the focus) I need to move the focus.
I do this using CurrentCellEndEdit:
private void sfDataGrid1_CurrentCellEndEdit(object sender, Syncfusion.WinForms.DataGrid.Events.CurrentCellEndEditEventArgs e)
{
_totalPriceOrder = _order.OrderLines.Sum(x => x.Amount * x.Price);
SetLblTotalPriceOrder();
sfDataGrid1.SelectedIndex = -1;
txtBarcode.Focus();
}
That is all I do.
These are my settings:
this.sfDataGrid1.AccessibleName = "Table";
this.sfDataGrid1.AllowResizingColumns = true;
this.sfDataGrid1.AllowResizingHiddenColumns = true;
this.sfDataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.sfDataGrid1.AutoSizeColumnsMode = Syncfusion.WinForms.DataGrid.Enums.AutoSizeColumnsMode.Fill;
this.sfDataGrid1.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.sfDataGrid1.LiveDataUpdateMode = Syncfusion.Data.LiveDataUpdateMode.AllowSummaryUpdate;
this.sfDataGrid1.Location = new System.Drawing.Point(38, 138);
this.sfDataGrid1.Name = "sfDataGrid1";
this.sfDataGrid1.Size = new System.Drawing.Size(677, 337);
this.sfDataGrid1.TabIndex = 5;
this.sfDataGrid1.Text = "sfDataGrid1";
this.sfDataGrid1.CurrentCellEndEdit += new Syncfusion.WinForms.DataGrid.Events.CurrentCellEndEditEventHandler(this.sfDataGrid1_CurrentCellEndEdit);
Please advise what to do.
Thanks, Paul.
SIGN IN To post a reply.
