4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
# File 'app/models/concerns/contacts_procedures.rb', line 4
def write_procedure(user_name:)
raise ActiveRecord::RecordInvalid.new(self) unless valid?
result = ActiveRecord::Base.connection.execute_procedure(
:pr_insert_update_contact,
contact_id,
company_id,
reference,
reference_id,
position,
first_name,
last_name,
full_name,
address1,
address2,
city,
province_id,
postal_code,
language,
phone_no,
extension,
cell_phone_no,
other_phone_no,
email,
photo,
erp_user_id,
memo,
active ? 1 : 0,
user_name
)[0]
Contact.find(result['contact_id'])
end
|