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