I just don't seem to be able to get this code to work. im trying to pass the value of account.name to a variable. the plugin is registered for create on account
Public Sub Execute(serviceProvider As System.IServiceProvider) Implements Microsoft.Xrm.Sdk.IPlugin.Execute
Dim context As IPluginExecutionContext = DirectCast(serviceProvider.GetService(GetType(IPluginExecutionContext)), IPluginExecutionContext)
If context.InputParameters.Contains("Target") AndAlso TypeOf context.InputParameters("Target") Is Entity Then
Dim entity As Entity = DirectCast(context.InputParameters("Target"), Entity)
Dim strLicence As String = entity.Attributes("name").ToString
Dim SQL_Connection As New SqlClient.SqlConnection
Dim SQL_Command As New SqlClient.SqlCommand
SQL_Connection = New SqlClient.SqlConnection("Data Source=xxxx;Initial Catalog=TestDB;Persist Security Info=True;User ID=sa;password=xxxxx")
Try
SQL_Connection.Open()
SQL_Command.CommandType = CommandType.Text
SQL_Command.CommandText = "INSERT INTO ClientAdmin (Licence) Values ('" & strLicence & "')"
SQL_Command.Connection = SQL_Connection
SQL_Command.ExecuteNonQuery()
Catch ex As Exception
Throw New InvalidPluginExecutionException("Error inserting new customer - " & ex.Message.ToString)
Finally
SQL_Connection.Close()
SQL_Connection.Dispose()
End Try
End If
End Sub
from what I have read, I understood that when I click save on a new account, it would fire the pluggin, but I have also read that a couple of the erros I have been getting was due to 'name' being empty ?
Dont ask me .. i dont know