Apex Code Development You need to sign in to do that
Don't have an account?
Eduardo Deslandes insert OpportunityLineItem with custom controller
Hi, I trying to create a visualforce page to insert OpportunityLineItems, but it's not working, when I click "Salvar" (save) nothing happens, anyone could help me please?
page:
<apex:page controller="ProdOpController">
<apex:form >
<apex:pageBlock title="Novo Produto da Oportunidade">
<apex:pageBlockSection title="Informações do Produto">
<apex:inputField value="{!prodop.OpportunityId}"/>
<apex:inputField value="{!prodop.Quantity}"/>
<apex:inputField value="{!prodop.UnitPrice}"/>
<apex:selectList multiselect="false" size="1" value="{!prodop.Product2Id}">
<apex:selectOptions value="{!prodOptions}"/>
</apex:selectList>
</apex:pageBlockSection>
<apex:pageBlockButtons >
<apex:commandButton action="{!salvar}" value="Salvar"/>
</apex:pageBlockButtons>
</apex:pageBlock>
</apex:form>
</apex:page>
controller:
public class ProdOpController {
public OpportunityLineItem prodop{ get; private set; }
public ProdOPController(){
prodop = new OpportunityLineItem();
System.debug('Entrei no construtor');
}
public PageReference salvar(){
System.debug('Entrei em salvar');
try{
insert prodop;
}
catch(System.DMLException e){
System.debug('insert prodop falhou');
System.debug(e);
ApexPages.addMessages(e);
return null;
}
PageReference redirectSuccess = new ApexPages.StandardController(prodop).view();
return (redirectSuccess);
}
public List<SelectOption> getProdOptions(){
List<PricebookEntry> prods = Database.query(
'SELECT Id, name FROM PricebookEntry'
);
List<SelectOption> options = new List<SelectOption>();
for(PricebookEntry p : prods){
options.add(new SelectOption(p.Id, p.Name));
}
System.debug('listei as opcoes de produtos');
return options;
}
}
You have written the page and controller correctly, the only thing missing here is the PriceBookEntry ID which you had to assign to the Lineitem instance.Check the below code for the update required:
Controller code:
public class ProdOpController {
public OpportunityLineItem prodop{ get; set; }
public ProdOPController(){
prodop = new OpportunityLineItem();
System.debug('Entrei no construtor');
}
public PageReference save(){
system.debug('---->222 '+prodop.Product2Id);
//PriceBookEntry priceBookList = [SELECT Id FROM PriceBookEntry WHERE Product2Id =: prodop.Product2Id and PriceBook2.isStandard=true LIMIT 1];
prodop.PricebookEntryId = prodop.Product2Id; //'01u28000006fO2V';
System.debug('Entrei em salvar---> '+prodop);
try{
insert prodop;
}
catch(System.DMLException e){
System.debug('insert prodop falhou');
System.debug(e);
ApexPages.addMessages(e);
return null;
}
PageReference redirectSuccess = new ApexPages.StandardController(prodop).view();
return (redirectSuccess);
}
public List<SelectOption> getProdOptions(){
List<PricebookEntry> prods = Database.query(
'SELECT Id, name FROM PricebookEntry'
);
List<SelectOption> options = new List<SelectOption>();
for(PricebookEntry p : prods){
options.add(new SelectOption(p.Id, p.Name));
}
System.debug('listei as opcoes de produtos');
return options;
}
}
All Answers
You have written the page and controller correctly, the only thing missing here is the PriceBookEntry ID which you had to assign to the Lineitem instance.Check the below code for the update required:
Controller code:
public class ProdOpController {
public OpportunityLineItem prodop{ get; set; }
public ProdOPController(){
prodop = new OpportunityLineItem();
System.debug('Entrei no construtor');
}
public PageReference save(){
system.debug('---->222 '+prodop.Product2Id);
//PriceBookEntry priceBookList = [SELECT Id FROM PriceBookEntry WHERE Product2Id =: prodop.Product2Id and PriceBook2.isStandard=true LIMIT 1];
prodop.PricebookEntryId = prodop.Product2Id; //'01u28000006fO2V';
System.debug('Entrei em salvar---> '+prodop);
try{
insert prodop;
}
catch(System.DMLException e){
System.debug('insert prodop falhou');
System.debug(e);
ApexPages.addMessages(e);
return null;
}
PageReference redirectSuccess = new ApexPages.StandardController(prodop).view();
return (redirectSuccess);
}
public List<SelectOption> getProdOptions(){
List<PricebookEntry> prods = Database.query(
'SELECT Id, name FROM PricebookEntry'
);
List<SelectOption> options = new List<SelectOption>();
for(PricebookEntry p : prods){
options.add(new SelectOption(p.Id, p.Name));
}
System.debug('listei as opcoes de produtos');
return options;
}
}
Thanks Sonam,
I managed to make it work by changing the
<apex:selectList multiselect="false" size="1" value="{!prodop.Product2Id}">
by
<apex:selectList multiselect="false" size="1" value="{!prodop.PricebookEntryId}">
too, but that is confused because the pricebookentry field is not showed in the OpportunityLineItem schema, anyway now I know this issue :)