Sub saveiteminfo(sql As SQL,info As Map)
Dim querySaveInfo As String = utils.prepareInsertQuery($"
INSERT INTO assets (
[id]
,[customer_id]
,[insurance_company_id]
,[item_name]
,[item_description]
,[item_cost]
,[policy_number]
,[serial_number]
,[claim_number]
,[brand]
,[extra_info]
)
"$)
Dim paramsInfo(querySaveInfo.Length - querySaveInfo.Replace("?","").Length) As String
paramsInfo(0) =info.Get("masteritem")
paramsInfo(1) =info.Get("user_id")
paramsInfo(2) =info.Get("insurancecomany")
paramsInfo(3) =info.Get("model")
paramsInfo(4) =info.Get("description")
paramsInfo(5) =0
paramsInfo(6) =info.Get("policynumber")
paramsInfo(7) =info.Get("serial")
paramsInfo(8) =""
paramsInfo(9) =info.Get("brand")
paramsInfo(10) =""
sql.ExecNonQuery2(querySaveInfo,paramsInfo)
sql.close
End Sub