public static void Create(Customer _customer)
{
connection.Open();
try
{
SqlCommand cmd = new SqlCommand(@"INSERT INTO Customers (FIRSTNAME, LASTNAME, TELEPHONE, ADDRESS) VALUES (@fname, @lname, @tel, @address)", connection);
cmd.Parameters.AddWithValue("@fname", _customer.FirstName);
cmd.Parameters.AddWithValue("@lname", _customer.LastName);
cmd.Parameters.AddWithValue("@tel", _customer.Telephone);
cmd.Parameters.AddWithValue("@address", _customer.Address);
cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
MessageBox.Show(e.ToString());
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connection.Close();
}
}
private Customer ParsedCustomer()
{
var cust = new Customer();
cust.FirstName = textBox1.Text;
cust.LastName = textBox2.Text;
cust.Telephone = textBox3.Text;
cust.Address = textBox4.Text;
return cust;
}
public UpdateFormCustomer(Customer _existcustomer)
{
InitializeComponent();
IdLabel.Text = "ID Πελάτη : ";
IDBox.Text = _existcustomer.ID.ToString();
ExistFNameBox.Text = _existcustomer.FirstName;
ExistLNameBox.Text = _existcustomer.LastName;
ExistTelBox.Text = _existcustomer.Telephone;
ExistAddressBox.Text = _existcustomer.Address;
}
public OrdersCustomerForm(Customer _customer)
{
InitializeComponent();
label1.Text = _customer.ID.ToString();
label2.Text = _customer.FirstName;
label2.Dock = DockStyle.Left | DockStyle.Top;
label3.Text = _customer.LastName;
label3.Dock = DockStyle.Left | DockStyle.Top;
label4.Text = _customer.Telephone;
label6.Text = _customer.Address;
}
private Customer ParsedCustomer()
{
int id = Convert.ToInt32(label1.Text);
string firstname = label2.Text;
string lastname = label3.Text;
string telephone = label4.Text;
string address = label6.Text;
var Cust = new Customer();
Cust.ID = id;
Cust.FirstName = firstname;
Cust.LastName = lastname;
Cust.Telephone = telephone;
Cust.Address = address;
return Cust;
}
public static void Delete(Customer _customer)
{
connection.Open();
try
{
string query = "DELETE FROM Customers where ID LIKE @CODE";
SqlCommand cmd = new SqlCommand(query, connection);
cmd.Parameters.AddWithValue("@CODE", _customer.ID);
cmd.ExecuteNonQuery();
}
catch (SqlException exception)
{
MessageBox.Show(exception.ToString());
}
finally
{
connection.Close();
}
}
private Customer ParsedCustomer()
{
var cust = new Customer();
cust.ID = Convert.ToInt32(IDBox.Text);
if (ReplaceFNameBox.Text == string.Empty || ReplaceFNameBox == null)
{
ReplaceFNameBox.Text = ExistFNameBox.Text;
cust.FirstName = ReplaceFNameBox.Text;
}
else
{
cust.FirstName = ReplaceFNameBox.Text;
}
if (ReplaceLNameBox.Text == string.Empty || ReplaceLNameBox == null)
{
ReplaceLNameBox.Text = ExistLNameBox.Text;
cust.LastName = ReplaceLNameBox.Text;
}
else
{
cust.LastName = ReplaceLNameBox.Text;
}
if (ReplaceTelBox.Text == string.Empty || ReplaceTelBox == null)
{
ReplaceTelBox.Text = ExistTelBox.Text;
cust.Telephone = ReplaceTelBox.Text;
}
else
{
cust.Telephone = ReplaceTelBox.Text;
}
if (ReplaceAddressBox.Text == string.Empty || ReplaceAddressBox == null)
{
ReplaceAddressBox.Text = ExistAddressBox.Text;
cust.Address = ReplaceAddressBox.Text;
}
else
{
cust.Address = ReplaceAddressBox.Text;
}
return cust;
}
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(Customer _customer)
{
connection.Open();
try
{
SqlCommand cmd = new SqlCommand(@"UPDATE Customers SET FIRSTNAME = @fname, LASTNAME = @lname, TELEPHONE = @telephone, ADDRESS = @address WHERE ID LIKE @ID", connection);
cmd.Parameters.AddWithValue("@ID", _customer.ID);
cmd.Parameters.AddWithValue("@fname", _customer.FirstName);
cmd.Parameters.AddWithValue("@lname", _customer.LastName);
cmd.Parameters.AddWithValue("@telephone", _customer.Telephone);
cmd.Parameters.AddWithValue("@address", _customer.Address);
cmd.ExecuteNonQuery();
}
catch (SqlException e)
{
MessageBox.Show(e.ToString());
}
finally
{
connection.Close();
}
}
private Customer ParsedCustomer()
{
DataGridViewRow row = dataGridView1.CurrentCell.OwningRow;
int id = Convert.ToInt32(row.Cells[0].Value.ToString());
string firstname = row.Cells[1].Value.ToString();
string lastname = row.Cells[2].Value.ToString();
string telephone = row.Cells[3].Value.ToString();
string address = row.Cells[4].Value.ToString();
var Cust = new Customer();
Cust.ID = id;
Cust.FirstName = firstname;
Cust.LastName = lastname;
Cust.Telephone = telephone;
Cust.Address = address;
return Cust;
}
/// <summary>
/// Επιστρέφει στο DataGridView τα στοιχεία του πίνακα που ανήκουν στον συγκεκριμένο Πελάτη _customer
/// </summary>
/// <param name="_datagridview"></param>
/// <param name="_customer"></param>
public static void Read(DataGridView _datagridview, Customer _customer)
{
connection.Open();
try
{
string query = "SELECT * FROM Orders WHERE IDCUSTOMER =" + _customer.ID.ToString();
SqlDataAdapter DA = new SqlDataAdapter(query, connection);
DataTable DT = new DataTable();
DA.Fill(DT);
_datagridview.DataSource = DT;
_datagridview.Columns[0].HeaderText = "Νούμερο Παραγγελίας";
_datagridview.Columns[1].HeaderText = "Κωδικός Πελάτη";
_datagridview.Columns[2].HeaderText = "Περιγραφή";
}
catch (SqlException e)
{
MessageBox.Show(e.ToString());
}
finally
{
connection.Close();
}
}