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; }