public IActionResult addOrder([FromBody] TblOrderDTO order) { bool isValidToken = ValidateToken(); if (isValidToken) { TblOrderDAO dao = TblOrderDAO.getInstance(); try { if (dao.AddOrder(order)) { return(Ok(true)); } else { return(BadRequest()); } } catch (Exception) { StatusCode(500); } } return(Unauthorized()); }
public bool AddOrder(TblOrderDTO dto) { string sql = "INSERT tblOrder(idOrder, idCustomer, idEmployee, priceSum, discount, priceTotal, orderDate) " + "VALUES(@idOrder, @idCustomer, @idEmp, @price, @discount, @priceTotal, @orderDate) "; try { cn = DBUtil.MakeConnect(); if (cn != null) { cmd = new SqlCommand(sql, cn); cmd.Parameters.AddWithValue("@idOrder", dto.idOrder); cmd.Parameters.AddWithValue("@idCustomer", dto.idCustomer); cmd.Parameters.AddWithValue("@idEmp", dto.idEmployee); cmd.Parameters.AddWithValue("@price", dto.priceSum); cmd.Parameters.AddWithValue("@discount", dto.discount); cmd.Parameters.AddWithValue("@priceTotal", dto.total); cmd.Parameters.AddWithValue("@orderDate", dto.orderDate); return(cmd.ExecuteNonQuery() > 0); } } catch (SqlException e) { throw new Exception(e.Message); } finally { DBUtil.CloseConnection(null, cn); } return(false); }
public bool AddOrder(TblOrderDTO dto) { HttpResponseMessage responseMessage = ApiConnection.loadPostJsonObject("order/add-order", dto, Program.TokenGlobal); if (responseMessage.IsSuccessStatusCode) { return(true); } return(false); }
private void CreateOrder() { //create order id string idOrder = Guid.NewGuid().ToString(); TblOrderDTO order = new TblOrderDTO() { idOrder = idOrder, idEmployee = form.getEmployee().idEmployee, idCustomer = form.getCustomerId().Text, priceSum = float.Parse(form.getAmount().Text), discount = float.Parse(form.getDiscount().Text), total = float.Parse(form.getCurrentAmount().Text), orderDate = DateTime.Now, }; bool isSuccess = orderModel.AddOrder(order); if (isSuccess) { //create order detail dto for insert to database List <TblOrderDetailDTO> itemList = new List <TblOrderDetailDTO>(); foreach (var item in listProductOrder) { TblOrderDetailDTO dto = new TblOrderDetailDTO() { idOrder = idOrder, idProduct = item.idProduct, quantity = item.quantity, price = item.price, }; itemList.Add(dto); } CartDTO cart = new CartDTO(idOrder, itemList); isSuccess = orderModel.AddOrderDetail(cart); if (isSuccess) { updateCustomerPoint(); MessageBox.Show(MessageUtil.CHECKOUT_SUCCESS); } else { MessageBox.Show(MessageUtil.ERROR); } } else { MessageBox.Show(MessageUtil.ERROR); } }