public IActionResult UpdatePendingTrx([FromBody] InventoryOutTrxHeader invOutTrx) { using (var transaction = dbContext.Database.BeginTransaction()) { try { InventoryOutTrxHeader findTrxNum = dbContext.InventoryOutTrxHeaders.Find(invOutTrx.TransactionNo); if (findTrxNum != null) { findTrxNum.Status = invOutTrx.Status; findTrxNum.TransactionNo = invOutTrx.TransactionNo; findTrxNum.IssuedBy = invOutTrx.IssuedBy; findTrxNum.IssuedDate = invOutTrx.IssuedDate; findTrxNum.Department = invOutTrx.Department; findTrxNum.ReferenceNo = invOutTrx.ReferenceNo; findTrxNum.Remarks = invOutTrx.Remarks; dbContext.InventoryOutTrxHeaders.Update(findTrxNum); dbContext.SaveChanges(); transaction.Commit(); return(Json(findTrxNum)); } else { throw new Exception($"User Not found with a user ID of '{invOutTrx.TransactionNo}'."); } } catch (Exception ex) { transaction.Rollback(); return(BadRequest(GetErrorMessage(ex))); } } }
public IActionResult Add([FromBody] InventoryOutTrxHeader inventoryOut) { using (var transaction = dbContext.Database.BeginTransaction()) { try { var ivnList = new InventoryOutTrxHeader(); ivnList.TransactionNo = inventoryOut.TransactionNo; ivnList.TransactionDate = inventoryOut.TransactionDate; ivnList.IssuedBy = ""; var dateFromC = "01/01/0001 00:00:00"; ivnList.IssuedDate = DateTime.Parse(dateFromC); ivnList.ReceivedBy = inventoryOut.ReceivedBy; ivnList.Department = inventoryOut.Department; ivnList.ReferenceNo = inventoryOut.ReferenceNo; ivnList.Remarks = inventoryOut.Remarks; ivnList.Status = inventoryOut.Status; dbContext.InventoryOutTrxHeaders.Add(ivnList); dbContext.SaveChanges(); transaction.Commit(); return(Ok(inventoryOut)); } catch (Exception ex) { transaction.Rollback(); return(BadRequest(GetErrorMessage(ex))); } } }
public IActionResult DeleteAllTrx(string trxNum) { using (var transaction = dbContext.Database.BeginTransaction()) { try { InventoryOutTrxHeader allTrxHeader = dbContext.InventoryOutTrxHeaders.Find(trxNum); if (allTrxHeader != null) { dbContext.InventoryOutTrxHeaders.Remove(allTrxHeader); dbContext.SaveChanges(); transaction.Commit(); return(Json(trxNum)); } else { throw new Exception($"User Not found with a user ID of '{trxNum}'."); } } catch (Exception ex) { transaction.Rollback(); return(BadRequest(GetErrorMessage(ex))); } } }