public void GetAllDisabledServiceProductsFromDatabase()
{
string sql = "SELECT * FROM `service_products` WHERE `active` = '0'";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_disabledServiceProductsCount = Result.RowCounter;
AddInformation("Disabled ServiceProduct Antal", Result.RowCounter.ToString());
_disabledServiceProductsQueue = Result.RowData;
_disabledServiceProductsLoaded = true;
}
public void GetAllOrderTransactions()
{
string sql = $"SELECT * FROM `order_transactions`";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_orderTransactionCount = Result.RowCounter;
AddInformation("Order Transaction Antal", Result.RowCounter.ToString());
_orderTransactionsQueue = Result.RowData;
_orderTransactionsLoaded = true;
}
public void GetAllTempProductsFromDatabase()
{
string sql = "SELECT * FROM `temp_products`";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_tempProductCount = Result.RowCounter;
AddInformation("TempProduct Antal", Result.RowCounter.ToString());
_tempProductQueue = Result.RowData;
_tempProductLoaded = true;
}
public void GetAllStorageRoomsFromDatabase()
{
string sql = "SELECT * FROM `storagerooms` WHERE `deactivated` = '0'";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_storageRoomsCount = Result.RowCounter;
AddInformation("StorageRoom Antal", Result.RowCounter.ToString());
_storageRoomQueue = Result.RowData;
_storageRoomLoaded = true;
}
public void GetAllGroupsFromDatabase()
{
string sql = "SELECT * FROM `groups`";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_groupsCount = Result.RowCounter;
AddInformation("Group Antal", Result.RowCounter.ToString());
_groupsQueue = Result.RowData;
_groupsLoaded = true;
}
public void GetAllProductsFromDatabase()
{
string sql = "SELECT * FROM `products` WHERE `id` > '0' AND `active` = '1'";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_productsCount = Result.RowCounter;
AddInformation("Active Products Antal", Result.RowCounter.ToString());
_productQueue = Result.RowData;
_productsLoaded = true;
}
private void UpdateStorageStatus()
{
string sql = "SELECT * FROM `storage_status`";
TableDecodeQueue Result = Mysql.RunQueryWithReturnQueue(sql);
_storageStatusCount = Result.RowCounter;
AddInformation("Storage Status Antal", Result.RowCounter.ToString());
_storageStatusQueue = Result.RowData;
_storageStatusLoaded = true;
}