public IActionResult UpdateINVInRemainingCount(string trxNum, string minCount)
{
using (var transaction = dbContext.Database.BeginTransaction())
{
try
{
InventoryInTrxDetail invd = dbContext.InventoryInTrxDetails.Find(trxNum);
if (invd != null)
{
invd.RemainigCount = int.Parse(minCount);
dbContext.InventoryInTrxDetails.Update(invd);
dbContext.SaveChanges();
transaction.Commit();
return(Json(trxNum));
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(BadRequest(GetErrorMessage(ex)));
}
}
}
public IActionResult Add_Trx_Detail([FromBody] InventoryInTrxDetail InvInTrxDetail)
{
try
{
InventoryInTrxDetail invtoadd = new InventoryInTrxDetail()
{
TransactionNo = InvInTrxDetail.TransactionNo,
ItemID = InvInTrxDetail.ItemID,
Unit = InvInTrxDetail.Unit,
Quantity = InvInTrxDetail.Quantity,
LotNumber = InvInTrxDetail.LotNumber,
ExpirationDate = InvInTrxDetail.ExpirationDate,
Count = InvInTrxDetail.Count,
RemainigCount = InvInTrxDetail.RemainigCount,
};
dbContext.InventoryInTrxDetails.Add(invtoadd);
dbContext.SaveChanges();
return(Json(InvInTrxDetail));
}
catch (Exception ex)
{
return(BadRequest(GetErrorMessage(ex)));
}
}
public IActionResult Update_Trx_Detail([FromBody] InventoryInTrxDetail InvInTrxDetail)
{
try
{
InventoryInTrxDetail invtrxlist = new InventoryInTrxDetail()
{
TransactionNo = InvInTrxDetail.TransactionNo,
ItemID = InvInTrxDetail.ItemID,
Unit = InvInTrxDetail.Unit,
Quantity = InvInTrxDetail.Quantity,
LotNumber = InvInTrxDetail.LotNumber,
ExpirationDate = InvInTrxDetail.ExpirationDate,
Count = InvInTrxDetail.Count,
RemainigCount = InvInTrxDetail.RemainigCount,
};
if (invtrxlist != null)
{
dbContext.InventoryInTrxDetails.Update(invtrxlist);
dbContext.SaveChanges();
return(Json(InvInTrxDetail));
}
else
{
throw new Exception($"Transaction Not found with transaction no. of '{invtrxlist.TransactionNo}'.");
}
}
catch (Exception ex)
{
return(BadRequest(GetErrorMessage(ex)));
}
}
public IActionResult Delete_Trx_Detail(string trxno)
{
try
{
InventoryInTrxDetail invtrxdtl = dbContext.InventoryInTrxDetails.Find(trxno);
if (invtrxdtl != null)
{
dbContext.InventoryInTrxDetails.Remove(invtrxdtl);
dbContext.SaveChanges();
return(Json(trxno));
}
else
{
throw new Exception($"Transaction Not found with a user transaction number of '{trxno}'.");
}
}
catch (Exception ex)
{
return(BadRequest(GetErrorMessage(ex)));
}
}
