public void AddNew() { try { bool success = false; var parameters = new DynamicParameters(); parameters.Add("@SelectedTable", SelectedTable.Id); parameters.Add("@SelectedOrderItem", SelectedOrderItem.Id); bool existInOrders = TableOrderItems.Any(x => x.TableId == SelectedTable.Id && x.OrderItemId == SelectedOrderItem.Id); if (existInOrders) { TableOrderItems existedItem = TableOrderItems.FirstOrDefault(x => x.TableId == SelectedTable.Id && x.OrderItemId == SelectedOrderItem.Id); Quantity += existedItem.Quantity; parameters.Add("@Quantity", Quantity); success = BistroDatabase.Instance.ExecuteQuery(DBQuery.UPDATE_TABLE_ORDERS_ITEM, parameters); } else { parameters.Add("@Quantity", Quantity); success = BistroDatabase.Instance.ExecuteQuery(DBQuery.INSERT_TABLE_ORDERS_ITEM, parameters); } AfterExecuteAction(success); } catch (Exception ex) { Console.WriteLine(ex); } }
private void ListViewItem_MouseDoubleClick(object sender, MouseButtonEventArgs e) { TableOrderItems tableOrderItems = ((ListViewItem)sender).Content as TableOrderItems; vm.Quantity = tableOrderItems.Quantity; vm.SelectedOrderItem = vm.OrderItems.FirstOrDefault(x => x.Id == tableOrderItems.OrderItemId); vm.SelectedTable = vm.Tables.FirstOrDefault(x => x.Id == tableOrderItems.TableId); vm.IsEditMode = true; vm.TableDropdownEnabled = false; vm.OrderItemsDropdownEnabled = false; vm.UpdateButtonEnabled = vm.CanUpdate(); vm.DeleteButtonEnabled = vm.CanDelete(); }