public async void GetInventary_Ok()
{
//Arrange
int id = 1;
InventaryMaster inventaryMaster = new InventaryMaster()
{
Id = 1,
Name = "Sudev",
Description = "Good Boy",
PricePerUnit = 5,
Quantity = 2,
CreatedOn = DateTime.Now,
TotalPrice = 10
};
_inventaryRepositary.Setup(repo => repo.GetInventary(id)).Returns(Task.FromResult(inventaryMaster));
//Act
var response = await _inventaryService.GetInventrary(id);
//Assert
var res = Assert.IsType <SpecificInventary>(response);
Assert.Equal(inventaryMaster.Name, res.Name);
Assert.Equal(inventaryMaster.Description, res.Description);
Assert.Equal(inventaryMaster.PricePerUnit, res.PricePerUnit);
Assert.Equal(inventaryMaster.Quantity, res.Quantity);
}
public async Task <int> UpdateInventrary(InventaryDetail inventaryDetail, int id)
{
InventaryMaster inventaryMaster = new InventaryMaster();
inventaryMaster.InjectFrom(inventaryDetail);
inventaryMaster.TotalPrice = inventaryMaster.Quantity * inventaryMaster.PricePerUnit;
return(await _inventaryRepository.UpdateInventary(inventaryMaster, id));
}
public async Task <int> UpdateInventary(InventaryMaster inventaryMaster, int id)
{
IDbTransaction trans = null;
IDbConnection conn = _dBConnectionRepository.GetConnection;
try
{
trans = conn.BeginTransaction();
parameters = new DynamicParameters();
parameters.Add("@id", id);
parameters.Add("@inventaryName", inventaryMaster.Name);
parameters.Add("@inventaryDescription",
inventaryMaster.Description);
parameters.Add("@inventaryQuantity", inventaryMaster.Quantity);
parameters.Add("@inventaryPricePerUnit",
inventaryMaster.PricePerUnit);
parameters.Add("@inventaryTotalPrice",
inventaryMaster.TotalPrice);
parameters.Add("@inventaryCreatedOn",
inventaryMaster.CreatedOn);
var data = await conn.ExecuteAsync("usp_Update_Inventary",
parameters, trans, null, commandType :
CommandType.StoredProcedure);
if (data == 1)
{
trans.Commit();
conn.Close();
return(data);
}
else
{
trans.Rollback();
conn.Close();
return(0);
}
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
