public async Task <int> AddItem(ItemDbModel item)
{
var query =
$"INSERT INTO Item (GenericName, BrandName, DosageForm, DosageStrength, Manufacturer, Barcode, Price, TherapeuticClassId) " +
$"VALUES ('{item.GenericName}','{item.BrandName}','{item.DosageForm}','{item.DosageStrength}','{item.Manufacturer}','{item.Barcode}',{item.Price},{item.TherapeuticClassId})";
return(await SqliteDataAccess.ExecuteNonQueryAsync(_connectionString, query));
}
public async Task <int> UpdateInventoryItem(InventoryDbModel inventoryItem)
{
var query = $"UPDATE Inventory " +
$"SET " +
$"BatchNumber = '{inventoryItem.BatchNumber}'," +
$"LotNumber = '{inventoryItem.LotNumber}'," +
$"ExpiryDate = '{inventoryItem.ExpiryDate.ToString("yyyy-MM-dd")}'," +
$"ManufacturingDate = '{inventoryItem.ManufacturingDate.ToString("yyyy-MM-dd")}'," +
$"Quantity = {inventoryItem.Quantity} " +
$"WHERE InventoryId = {inventoryItem.InventoryId}";
return(await SqliteDataAccess.ExecuteNonQueryAsync(_connectionString, query));
}
public async Task <int> AddInventoryItem(InventoryDbModel inventoryItem)
{
var isInventoryItemExists = (await GetInventoryItemsById(new List <int>()
{
inventoryItem.ItemId
})).Any();
if (isInventoryItemExists)
{
return(await UpdateInventoryItem(inventoryItem));
}
var query =
$"INSERT INTO Inventory (ItemId, BatchNumber, LotNumber, ExpiryDate, ManufacturingDate, Quantity) " +
$"VALUES ({inventoryItem.ItemId},'{inventoryItem.BatchNumber}','{inventoryItem.LotNumber}','{inventoryItem.ExpiryDate.ToString("yyyy-MM-dd")}','{inventoryItem.ManufacturingDate.ToString("yyyy-MM-dd")}', {inventoryItem.Quantity})";
return(await SqliteDataAccess.ExecuteNonQueryAsync(_connectionString, query));
}