public int AddItemToOrder(CreateOrderItemDTO entityToCreate)
{
try
{
string query = @"
INSERT INTO OrderItems (OrderHeaderID, ItemID, OrderItemStatusID, OrderItemUnitPrice, OrderItemUnitPriceAfterDiscount, OrderItemQty, OrderItemDescription)
VALUES(@OrderID, @ItemID, 1, @OrderItemUnitPrice, @OrderItemUnitPriceAfterDiscount, @OrderItemQty, @OrderItemDescription)
SELECT SCOPE_IDENTITY()";
var queryParameters = new DynamicParameters();
queryParameters.Add("@OrderID", entityToCreate.OrderID);
queryParameters.Add("@ItemID", entityToCreate.ItemID);
queryParameters.Add("@OrderItemUnitPrice", entityToCreate.OrderItemUnitPrice);
queryParameters.Add("@OrderItemUnitPriceAfterDiscount", entityToCreate.OrderItemUnitPriceAfterDiscount);
queryParameters.Add("@OrderItemQty", entityToCreate.OrderItemQty);
queryParameters.Add("@OrderItemDescription", entityToCreate.OrderItemDescription);
return(Connection.QueryFirst <int>(query, queryParameters, CurrentTrans));
}
catch (Exception ex)
{
throw SqlExceptionHandler.HandleSqlException(ex) ?? ex;
}
}
public OrderItemDTO AddItemToOrder(CreateOrderItemDTO entityToCreate)
{
try
{
var orderItemID = UOW.OrderRepo.AddItemToOrder(entityToCreate);
UOW.SaveChanges();
return(UOW.OrderRepo.GetOrderItemByID(orderItemID));
}
catch (Exception ex)
{
UOW.RollbackChanges();
throw ex;
}
}
public async Task RemoveAttendee(CreateOrderItemDTO item)
{
Order.OrderItems.Remove(item);
await Recalculate();
}
public ActionResult <OrderItemDTO> AddItemToOrder(CreateOrderItemDTO entityToCreate)
{
try { return(_orderManager.AddItemToOrder(entityToCreate)); }
catch (BaseCustomException ex) { return(BadRequest(ex.Message)); }
}
public OrderItemDTO AddItemToOrder(CreateOrderItemDTO entityToCreate)
{
return(_orderService.AddItemToOrder(entityToCreate));
}
