public async Task <User> Create(User user)
{
task2DbContext.User.Add(user);
await task2DbContext.SaveChangesAsync();
return(user);
}
public async Task <(decimal?itemRate, decimal?totalRate)> UpdateOrderItem(NewOrderItemPrice newPrices)
{
var salesOrder = task2DbContext.TABSORDER
.Where(t => t.SORDID == newPrices.SOrdId);
salesOrder.FirstOrDefault().SORDAMNT = newPrices.NewTotalPrice;
var item = task2DbContext.TABSODATA
.Where(t => t.ITEMID == newPrices.ItemId && t.SORDID == newPrices.SOrdId);
item.FirstOrDefault().ITEMRATE = newPrices.NewItemPrice;
await task2DbContext.SaveChangesAsync();
var newSalesOrder = task2DbContext.TABSORDER
.Where(t => t.SORDID == newPrices.SOrdId);
var newItem = task2DbContext.TABSODATA
.Where(t => t.ITEMID == newPrices.ItemId && t.SORDID == newPrices.SOrdId);
return(newItem.FirstOrDefault().ITEMRATE, newSalesOrder.FirstOrDefault().SORDAMNT);
}
