public async Task <TABSODATA> AdditemToOrder(TABSODATA newItem) { var checkItem = task2DbContext.TABSODATA .Where(t => t.SORDID == newItem.SORDID && t.ITEMID == newItem.ITEMID); if (checkItem.FirstOrDefault() == null) { var addeditem = task2DbContext.TABSODATA.Add(newItem); var order = task2DbContext.TABSORDER .Where(t => t.SORDID == newItem.SORDID); order.FirstOrDefault().SORDAMNT += newItem.ITEMRATE; await task2DbContext.SaveChangesAsync(); return(newItem); } else { checkItem.FirstOrDefault().DATAEXST = "EXT"; await task2DbContext.SaveChangesAsync(); return(checkItem.FirstOrDefault()); } }
public IActionResult CreateItem([FromBody] TABSODATA newItem) { var newAddedItem = salesOrderRepository.AdditemToOrder(newItem); if (newAddedItem.Result != null) { return(new CreatedAtActionResult("GetOrderItem", "Salesorder", new { orderId = newAddedItem.Result.SORDID, itemId = newAddedItem.Result.ITEMID }, newAddedItem.Result)); } return(BadRequest("Not created due to some errors")); }