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