public void CreateNewItem(int userID)
        {
            var dbHelper = new DatabaseHelper();

            using (var conn = dbHelper.GetDatabaseConnection())
            {
                using (var command = dbHelper.GetSQLiteCommand(conn))
                {
                    string query = "INSERT INTO InventoryItems (Name, Description, PicturePath, Cost, " +
                                   "CostCurrencyID, Quantity, BarcodeNumber, CreatedByUserID, ProfitPerItem, ProfitPerItemCurrencyID, ItemTypeID, " +
                                   "ItemPurchaseCost, ItemPurchaseCostCurrencyID, ItemsPerPurchase) VALUES " +
                                   "(@name, @description, @picturePath, @cost, @costCurrencyID, @quantity, @barcodeNumber, @createdByUserID," +
                                   " @profitPerItem, @profitPerItemCurrencyID, @itemTypeID," +
                                   " @itemPurchaseCost, @itemPurchaseCostCurrencyID, @itemsPerPurchase)";
                    command.CommandText = query;
                    command.Parameters.AddWithValue("@name", Name);
                    command.Parameters.AddWithValue("@description", Description);
                    command.Parameters.AddWithValue("@picturePath", PicturePath);
                    command.Parameters.AddWithValue("@cost", Cost.ToString());
                    command.Parameters.AddWithValue("@costCurrencyID", CostCurrency?.ID);
                    command.Parameters.AddWithValue("@quantity", Quantity);
                    command.Parameters.AddWithValue("@barcodeNumber", BarcodeNumber);
                    command.Parameters.AddWithValue("@createdByUserID", userID);
                    command.Parameters.AddWithValue("@profitPerItem", ProfitPerItem.ToString());
                    command.Parameters.AddWithValue("@profitPerItemCurrencyID", ProfitPerItemCurrency?.ID);
                    command.Parameters.AddWithValue("@itemTypeID", Type?.ID);
                    command.Parameters.AddWithValue("@itemPurchaseCost", ItemPurchaseCost.ToString());
                    command.Parameters.AddWithValue("@itemPurchaseCostCurrencyID", ItemPurchaseCostCurrency?.ID);
                    command.Parameters.AddWithValue("@itemsPerPurchase", ItemsPerPurchase);
                    command.ExecuteNonQuery();
                    ID = (int)conn.LastInsertRowId;
                    conn.Close();
                }
            }
        }
Esempio n. 2
0
        public void SaveItemUpdates(int userID)
        {
            var dbHelper = new DatabaseHelper();

            using (var conn = dbHelper.GetDatabaseConnection())
            {
                using (var command = dbHelper.GetSQLiteCommand(conn))
                {
                    string query = "UPDATE InventoryItems SET Name = @name, Description = @description, PicturePath = @picturePath, " +
                                   "Cost = @cost, CostCurrencyID = @costCurrencyID, BarcodeNumber = @barcodeNumber, " +
                                   "CreatedByUserID = @createdByUserID, ProfitPerItem = @profitPerItem, ProfitPerItemCurrencyID = @profitPerItemCurrencyID, " +
                                   "ItemTypeID = @itemTypeID " +
                                   " WHERE ID = @id";
                    command.CommandText = query;
                    command.Parameters.AddWithValue("@name", Name);
                    command.Parameters.AddWithValue("@description", Description);
                    command.Parameters.AddWithValue("@picturePath", PicturePath);
                    command.Parameters.AddWithValue("@cost", Cost.ToString());
                    command.Parameters.AddWithValue("@costCurrencyID", CostCurrency?.ID);
                    command.Parameters.AddWithValue("@barcodeNumber", BarcodeNumber);
                    command.Parameters.AddWithValue("@createdByUserID", userID);
                    command.Parameters.AddWithValue("@profitPerItem", ProfitPerItem.ToString());
                    command.Parameters.AddWithValue("@profitPerItemCurrencyID", ProfitPerItemCurrency?.ID);
                    command.Parameters.AddWithValue("@itemTypeID", Type?.ID);
                    command.Parameters.AddWithValue("@id", ID);
                    command.ExecuteNonQuery();
                    conn.Close();
                }
            }
        }