public SqlitefUI(String productTableName, string addProductToMainTransactionTableName, string addProductToTransactionTableName, string databaseLocation)
{
sqlite = new SQLiteConnection(databaseLocation);
DataTable TableWithProducts = InteractWithDatabase.SelectQuery($"Select * From {productTableName}", sqlite);
this.productTableName = productTableName;
this.addProductToTransactionTableName = addProductToTransactionTableName;
this.addProductToTransactionTableName = mainBuyTransactionTableName;
productList = new ListOfProducts(InteractWithDatabase.ProductTableToListOfProducts(TableWithProducts), this);
transactionList = new ListOfTransactions(null);
}
/// <summary>
/// Add main transaction to transaction table
/// </summary>
/// <param name="iD"></param>
/// <param name="productName"></param>
/// <param name="typeOfProduct"></param>
/// <param name="typeOfUnit"></param>
public void AddMainBuyTransactionToTransactionTable(int iD, DateTime date, decimal price, string comment, string place)
{
//Write the new product to table
InteractWithDatabase.SelectQuery($"INSERT INTO {mainBuyTransactionTableName} VALUES({iD},'{place}','{comment}','{price}, '{date}')", sqlite);
}
/// <summary>
/// Add product to list of products
/// </summary>
/// <param name="iD"></param>
/// <param name="productName"></param>
/// <param name="typeOfProduct"></param>
/// <param name="typeOfUnit"></param>
public void AddProductToProductTable(int iD, string productName, string typeOfProduct, string typeOfUnit)
{
//Write the new product to table
InteractWithDatabase.SelectQuery($"INSERT INTO {productTableName} VALUES({iD},'{productName}','{typeOfProduct}','{typeOfUnit}')", sqlite);
}
/// <summary>
/// Add product to main transaction table
/// </summary>
/// <param name="iD"></param>
/// <param name="productName"></param>
/// <param name="typeOfProduct"></param>
/// <param name="typeOfUnit"></param>
public void AddProductToMainBuyTransactionTable(int productID, int transactionID, string productName, int amountOfProduct, string typeOfProduct, decimal discountAmount, decimal price, string comment, decimal amountOfUnitInProduct)
{
//Write the new product to table
InteractWithDatabase.SelectQuery($"INSERT INTO {addProductToTransactionTableName} VALUES({productID},{transactionID},'{comment}',{price},{amountOfProduct},{amountOfUnitInProduct},{discountAmount},'{productName}','{typeOfProduct}')", sqlite);
}