public async Task <IActionResult> PostToOrderDetails([FromODataUri] int keyOrderID, [FromBody] OrderDetail orderdetail) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (orderdetail == null) { return(BadRequest()); } var repository = new OrderDetailsRepository(_context); try { await repository.Insert(orderdetail); repository.Save(); return(Created(orderdetail)); } catch (Exception e) { return(BadRequest(new { message = e.Message.Replace('{', '(').Replace('}', ')') })); } }
public async Task <ActionResult> Create([FromBody] OrderDetail orderDetail) { if (ModelState.IsValid) { if (orderDetail == null) { return(BadRequest()); } var repository = new OrderDetailsRepository(_context); try { await repository.Insert(orderDetail); repository.Save(); return(NoContent()); } catch (Exception e) { return(BadRequest(new { message = e.Message.Replace('{', '(').Replace('}', ')') })); } } return(BadRequest(new { message = "ModelState is not valid" })); }
public async Task Insert(OrderDetail item) { using (var context = new NorthwindDbContext(_options)) { var repository = new OrderDetailsRepository(context); await repository.Insert(item); repository.Save(); } }
public async Task Insert(OrderDetail item) { using (var context = new NorthwindDbContext(_options)) { try { var repository = new OrderDetailsRepository(context); await repository.Insert(item); repository.Save(); } catch (Exception e) { throw new GridException("DETSRV-01", e); } } }
public JsonResult Index(OrderViewModel objOrderViewModel) { OrderRepository orderRepository = new OrderRepository(); var order = new Order(); order.OrderDate = DateTime.Now; order.CustomerId = objOrderViewModel.CustomerId; order.FinalTotal = objOrderViewModel.FinalTotal; order.OrderNumber = string.Format("{0:ddmmyyyyhhmmss}", DateTime.Now); order.PaymentTypeId = objOrderViewModel.PaymentTypeId; orderRepository.Insert(order); int OrderId = order.ID; foreach (var item in objOrderViewModel.ListOfOrderDetailsViewModel) { OrderDetailsRepository orderDetailsRepository = new OrderDetailsRepository(); var OrderDetails = new OrderDetail(); OrderDetails.OrderId = OrderId; OrderDetails.Quantity = item.Quantity; OrderDetails.ItemId = item.ItemId; OrderDetails.UnitPrice = item.UnitPrice; OrderDetails.Discount = item.Discount; OrderDetails.Total = item.Total; orderDetailsRepository.Insert(OrderDetails); TransactionRepository transactionRepository = new TransactionRepository(); Transaction transaction = new Transaction(); transaction.ItemId = item.ItemId; transaction.Quantity = item.Quantity; transaction.TransactionDate = DateTime.Now; transaction.TypeId = 2; transactionRepository.Insert(transaction); } return(Json("Order has been Successfully placed", JsonRequestBehavior.AllowGet)); }
public OrderDetail Insert(OrderDetail Order) { _orderRepository.Insert(Order); return(Order); }