private Order ParsedOrder() { DataGridViewRow row = dataGridView1.CurrentCell.OwningRow; var order1 = new Order(); order1.Description = textBox1.Text; order1.Orderno = Convert.ToInt32(row.Cells[0].Value.ToString()); return order1; }
/// <summary> /// Διαγράφει μόνο μία παραγγελία /// </summary> /// <param name="_order"></param> public static void Delete(Order _order) { connection.Open(); try { string query = "DELETE FROM Orders where ORDERNO LIKE @orderno"; SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@orderno", _order.Orderno); cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.ToString()); } finally { connection.Close(); } }
public static void Create(Customer _customer, Order _order) { connection.Open(); try { string query = "INSERT INTO Orders (IDCUSTOMER, DΕSCRIPTION) VALUES (@idcustomer,@description)"; SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@idcustomer", _customer.ID); cmd.Parameters.AddWithValue("@description", _order.Description); cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.ToString()); } finally { connection.Close(); } }
public static void Update(Order _order) { connection.Open(); try { string query = "UPDATE Orders SET DΕSCRIPTION = @description WHERE ORDERNO LIKE @orderno"; SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.AddWithValue("@description", _order.Description); cmd.Parameters.AddWithValue("@orderno", _order.Orderno); cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.ToString()); } finally { connection.Close(); } }