public static bool AddOrder(OrderClass order, List <Order_Products> products) { SqlConnection connection = CompanyDB_Class.GetConnection(); string insertStatement = "INSERT INTO orders " + "( date, subtotal, tax, total, status_order_id, client_id) " + "VALUES ( @date, @subtotal, @tax, @total, @status_order_id, @client_id)"; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.Parameters.AddWithValue("@date", order.dateOrder); insertCommand.Parameters.AddWithValue("@subtotal", order.subtotalOrders); insertCommand.Parameters.AddWithValue("@tax", order.taxOrder); insertCommand.Parameters.AddWithValue("@total", order.totalOrder); insertCommand.Parameters.AddWithValue("@status_order_id", order.statusOrderId); insertCommand.Parameters.AddWithValue("@client_id", order.client_id); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { connection.Close(); int order_id = Order_Products(); // method 1 Insers_Products(products, order_id); // method 2 return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
private void btnPrintOrder_Click(object sender, EventArgs e) { OrderClass reportOrder = new OrderClass(); if (lstOrder.SelectedItems.Count > 0) { ListViewItem item = lstOrder.SelectedItems[0]; reportOrder.idOrders = Convert.ToInt32(item.SubItems[0].Text); reportOrder.dateOrder = Convert.ToDateTime(item.SubItems[1].Text); reportOrder.subtotalOrders = Convert.ToDecimal(item.SubItems[2].Text); reportOrder.taxOrder = Convert.ToDecimal(item.SubItems[3].Text); reportOrder.totalOrder = Convert.ToDecimal(item.SubItems[4].Text); reportOrder.statusOrderId = Convert.ToInt32(item.SubItems[5].Text); PrintOrder printOrder = new PrintOrder(reportOrder, reportOrder.idOrders); printOrder.Show(); } else { MessageBox.Show("Please select an order "); } }
private void btnAddOrder_Click(object sender, EventArgs e) { AddOrder addOrderClick = new AddOrder(); var result = addOrderClick.ShowDialog(); if (result == DialogResult.OK) { OrderClass orderClass = addOrderClick.getOrder; List <Order_Products> products = addOrderClick.getProducts; bool returnedResult = OrderDB_Class.AddOrder(orderClass, products); if (returnedResult) { FillListViewOrders(); MessageBox.Show("Order added"); } else { MessageBox.Show("Error"); } } }
public static List <OrderClass> GetOrders() { SqlConnection connection = CompanyDB_Class.GetConnection(); string selectStatement = "SELECT id, date, subtotal, tax, total, status_order_id, client_id " + "FROM orders"; SqlCommand selectcommand = new SqlCommand(selectStatement, connection); try { connection.Open(); SqlDataReader custReader = selectcommand.ExecuteReader(); List <OrderClass> orders = new List <OrderClass>(); while (custReader.Read()) { OrderClass order = new OrderClass(); order.idOrders = (int)custReader["id"]; order.dateOrder = Convert.ToDateTime(custReader["date"]); order.subtotalOrders = Convert.ToDecimal(custReader["subtotal"]); order.taxOrder = Convert.ToDecimal(custReader["tax"]); order.totalOrder = Convert.ToDecimal(custReader["total"]); order.statusOrderId = Convert.ToInt32(custReader["status_order_id"]); order.client_id = Convert.ToInt32(custReader["client_id"]); orders.Add(order); } custReader.Close(); return(orders); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool ChangeStatusOrder(OrderClass order) { SqlConnection connection = CompanyDB_Class.GetConnection(); string updateStatement = "UPDATE orders SET " + "status_order_id = @status_order_id " + " WHERE id = @id "; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.Parameters.AddWithValue( "@id", order.idOrders); updateCommand.Parameters.AddWithValue( "@status_order_id", order.statusOrderId); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public PrintOrder(OrderClass order, int order_id) { orderID = order_id; orders = order; InitializeComponent(); }