public async Task <IEnumerable <ItemDbModel> > GetItemsById(IEnumerable <int> itemIds) { var searchParameter = string.Join(",", itemIds); var query = $"SELECT * FROM Item WHERE ItemId IN ({searchParameter})"; return(await SqliteDataAccess.ExecuteQueryAsync <ItemDbModel>(_connectionString, query)); }
public async Task <IEnumerable <InventoryDbModel> > GetInventoryItemsById(IEnumerable <int> itemIds, string batchNumber = "", string lotNumber = "") { var itemIdSearchParameter = string.Join(",", itemIds); var searchParameters = GetSearchParameter(itemIdSearchParameter, batchNumber, lotNumber); var searchParameterQuery = string.Join(" AND ", searchParameters); if (string.IsNullOrWhiteSpace(searchParameterQuery)) { return(null); } var query = $"SELECT InventoryId, ItemId, BatchNumber, LotNumber, SUM(Quantity) AS Quantity, ManufacturingDate, ExpiryDate " + $"FROM Inventory " + $"WHERE {searchParameterQuery} " + $"GROUP BY ItemId, BatchNumber, LotNumber, ManufacturingDate, ExpiryDate"; return(await SqliteDataAccess.ExecuteQueryAsync <InventoryDbModel>(_connectionString, query)); }
public async Task <IEnumerable <ItemDbModel> > GetItems(string genericName = "", string brandName = "", string manufacturer = "", string barcode = "", TherapeuticClassDbModel therapeuticClass = null) { var searchParameters = GetSearchParameters(genericName, brandName, manufacturer, barcode, therapeuticClass); string query = ""; if (searchParameters.Count == 0) { query = "SELECT * FROM Item"; } else { var searchQuery = string.Join(" AND ", searchParameters); query = $"SELECT * FROM Item WHERE {searchQuery}"; } return(await SqliteDataAccess.ExecuteQueryAsync <ItemDbModel>(_connectionString, query)); }
public async Task <IEnumerable <TherapeuticClassDbModel> > GetTherapeuticClass() { var query = "SELECT * FROM TherapeuticClass"; return(await SqliteDataAccess.ExecuteQueryAsync <TherapeuticClassDbModel>(_connectionString, query)); }