public void InsertCustomer(E_Customers _customer)
{
SqlCommand cmd = new SqlCommand("SP_create_customers", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
cmd.Parameters.AddWithValue("@name_Client", _customer.CustomerName);
cmd.Parameters.AddWithValue("@last_name_client", _customer.ClientLastName);
cmd.Parameters.AddWithValue("@mothers_last_name_client", _customer.ClientMaternalSurname);
cmd.Parameters.AddWithValue("@dni_client", _customer.DniClient);
cmd.Parameters.AddWithValue("@email_client", _customer.CustomerEmail);
cmd.Parameters.AddWithValue("@phone_client", _customer.PhoneClient);
cmd.Parameters.AddWithValue("@civil_status_client", _customer.CustomerCivilStatus);
cmd.Parameters.AddWithValue("@gender_client", _customer.CustomerGender);
cmd.Parameters.AddWithValue("@address_employee_client", _customer.CustomerAddress);
cmd.Parameters.AddWithValue("@registration_date_client", _customer.CustomerRegistrationDate);
cmd.ExecuteNonQuery();
connection.Close();
}
public void UpdateCustomer(E_Customers _customers)
{
objCustomer.UpdateCustomer(_customers);
}
public void InsertCustomer(E_Customers _customers)
{
objCustomer.InsertCustomer(_customers);
}
