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