コード例 #1
0
        private async void AddInventoryBtn_Executed(object sender, ExecutedRoutedEventArgs e)
        {
            AddInventoryModel context = this.DataContext as AddInventoryModel;

            if (context.IsNull())
            {
                CustomMessageBox.ShowOK("Not enough information for inventory. Please try again.", "Error", "OK", MessageBoxImage.Error);
                return;
            }

            Inventory inventory = GetInventoryFromContext();

            using (SQLiteConnection connection = new SQLiteConnection(SqlHelpers.ConnectionString))
            {
                connection.Open();
                using (var cmd = connection.CreateCommand())
                {
                    cmd.CommandText = "SELECT Number FROM Inventory WHERE Number = @Number";
                    cmd.Parameters.AddWithValue("Number", inventory.Number);
                    using (var reader = await cmd.ExecuteReaderAsync())
                    {
                        if (reader.HasRows)
                        {
                            CustomMessageBox.ShowOK("The Inventory has already existed", "Error", "OK", MessageBoxImage.Error);
                            return;
                        }
                    }

                    cmd.CommandText = "INSERT INTO Inventory ([Number], [Object], [Incoming Date], [Repack], [Price]) VALUES (@Number, @Object, @InDate, @Repack, @Price)";
                    cmd.Parameters.AddWithValue("Number", inventory.Number);
                    cmd.Parameters.AddWithValue("Object", inventory.Object);
                    cmd.Parameters.AddWithValue("InDate", inventory.InDate);
                    cmd.Parameters.AddWithValue("Repack", inventory.Repack);
                    cmd.Parameters.AddWithValue("Price", inventory.Price);

                    var res = await cmd.ExecuteNonQueryAsync();

                    if (res != -1)
                    {
                        CustomMessageBox.ShowOK("Inventory added successfully.", "Information", "OK", MessageBoxImage.Information);
                        context.ObjectNumbers.Insert(0, inventory.Number);
                        ClearContext();
                        return;
                    }

                    CustomMessageBox.ShowOK("Something wrong while adding inventory. Please try again later.", "Error", "OK", MessageBoxImage.Error);
                }
            }
        }
コード例 #2
0
        private void AddInventoryBtn_CanExecute(object sender, CanExecuteRoutedEventArgs e)
        {
            AddInventoryModel context = this.DataContext as AddInventoryModel;

            e.CanExecute = context.IsNull() == false;
        }