Question

Hi... I am very new to .net core framework and I have implemented code as bellow

public async Task addItem([FromBody]ImsCoLines model)
{
if (model == null)
{
return BadRequest();
}

using (db)
{
using (var _ctxTransaction = db.Database.BeginTransaction())
{

DateTime today = helper.getISTDate();

model.forEach(obj=>{

db.ImsCoLine.Add(obj);

db.SaveChanges();

ImsInvTxn inv = new ImsInvTxn();

inv.CoLineID=obj.CoLineID; // getting only after creating the record in ImsCoLine table
inv.InvQty = obj.Qty;
inv.BatchId = obj.BatchId;
inv.CreatedBy = obj.CreatedBy;
inv.CreatedDate = today;

db.ImsInvTxn.Add(inv);

var result=helper.updateInventory(obj);

if(result!="OK")

res=result;

});

try

{
if (res == "OK")
{
await db.SaveChangesAsync();
_ctxTransaction.Commit();
}
else
{
_ctxTransaction.Rollback();
}
}
catch (Exception e)
{
_ctxTransaction.Rollback();
throw e;
}

return Ok();

}

updateInventory method in helper class

public string updateInventory(ImsCoLine invObj){

string res="";

var inv = db.ImsInvItem.FirstorDefault(y => y.ItemID== invObj.ItemID);

if(inv != null)

{

inv.Qty=inv.Qty - invObj.Qty;
if(inv.Qty<0)

res="Negative Qty";

else

res="OK";

}

if (res == "OK")
{
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}

return res;

}

When an exception is raised in main method (await savechangesAsync()) the inner method changes are not rolled back
only main method changes are rolling back

if Qty is negative then also the changes has to be rolled back
If db.saveChanges() not included in inner method then the inner method data is not saving to the database.

Please advice If code is wrong