public async Task <long> CreateAsync(PharmacyInventoryTable entity)
{
string sqlQuery = @"INSERT INTO PharmacyInventory (IdPharmacy, IdItem, QuantityOnHand, UnitPrice, ReorderQuantity, SellingUnitOfMeasure) " +
"VALUES (@IdPharmacy, @IdItem, @QuantityOnHand, @UnitPrice, @ReorderQuantity, @SellingUnitOfMeasure) " +
"SELECT CAST(SCOPE_IDENTITY() as bigint)";
return(await DbQuerySingleAsync <long>(sqlQuery, entity));
}
public async Task <bool> UpdateAsync(PharmacyInventoryTable entity)
{
string sql = $@"IF EXISTS (SELECT 1 FROM PharmacyInventory WHERE ID = @Id) " +
"UPDATE PharmacyInventory SET IdPharmacy = @IdPharmacy, IdItem = @IdItem, QuantityOnHand = @QuantityOnHand, UnitPrice = @UnitPrice, ReorderQuantity = @ReorderQuantity, " +
"SellingUnitOfMeasure = @SellingUnitOfMeasure " +
"WHERE ID = @Id";
return(await DbExecuteAsync <bool>(sql, entity));
}
private async Task <bool> UpdatePharmacyInventoryTable(PharmacyInventoryTable pharmacyInventoryTable)
{
try
{
return(await _pharmacyInventoryRepository.UpdateAsync(pharmacyInventoryTable));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public PharmacyInventoryTable FakePharmacyInventoryTable1()
{
var fake = new PharmacyInventoryTable()
{
Id = 1,
IdItem = 1,
IdPharmacy = 1,
QuantityOnHand = 2,
UnitPrice = 15.62M,
ReorderQuantity = 12,
SellingUnitOfMeasure = "KG"
};
return(fake);
}
public async Task <bool> UpdateAsync(PharmacyInventoryTable entity)
{
return(await Task.FromResult(true));
}
public async Task <long> CreateAsync(PharmacyInventoryTable entity)
{
return(await Task.FromResult(1));
}
