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))); } }