private void delivorAddButton_Click(object sender, EventArgs e)
{
Delivor delivor = new Delivor();
delivor.CompanyName = companyNameField.Text;
delivor.Address = addressField.Text;
delivor.PhoneNumber = phoneField.Text;
delivor.EmployeeContact = employeeField.Text;
dbAccess.insertDelivor(delivor);
}
public void insertDelivor(Delivor delivor)
{
String query = "insert into Delivors values(N'" + delivor.CompanyName + "',N'" + delivor.Address + "','"
+ delivor.PhoneNumber + "',N'" + delivor.EmployeeContact + "')";
command = new SqlCommand(query, connection);
try
{
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
MessageBox.Show("Успешно добавен доставчик!");
}
catch (Exception ex)
{
MessageBox.Show("Нещо са прееба брат");
}
}
