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