Trigger cart item

 trigger CartItemTrigger on Cart_Item__c (before insert, before update) {

    // Step 1: Collect all Product Ids from Cart Items

    Set<Id> productIds = new Set<Id>();

    

    for (Cart_Item__c item : Trigger.new) {

        if (item.Product__c != null) {

            productIds.add(item.Product__c);

        }

    }


    // Step 2: Query related Order Line Items

    Map<Id, Order_Line_Item__c> productToOrderLineItemMap = new Map<Id, Order_Line_Item__c>();

    for (Order_Line_Item__c oli : [

        SELECT Product__c, ListPrice__c 

        FROM Order_Line_Item__c 

        WHERE Product__c IN :productIds

        LIMIT 1

    ]) {

        productToOrderLineItemMap.put(oli.Product__c, oli);

    }


    // Step 3: Set ListPrice__c in Cart Items

    for (Cart_Item__c item : Trigger.new) {

        if (item.Product__c != null && productToOrderLineItemMap.containsKey(item.Product__c)) {

            item.ListPrice__c = productToOrderLineItemMap.get(item.Product__c).ListPrice__c;

        }

    }

}

Comments

Post a Comment

Popular posts from this blog

Remove (Clear) and remove Selected element

  ///===========Clear=================         jList1.setListData(new String[]{}); //==============Remove Selected Element =========       // TODO add your handling code here:      int count=0;         DefaultListModel listModel1 = new DefaultListModel();         ListModel<String> tempL=  jList1.getModel();                     //Create New Array and add element          for(int i=0;i<tempL.getSize();i++){             listModel1.add(i, tempL.getElementAt(i));         }                  //===Delete From Array         for(int index : jList1.getSelectedIndices()){                  /// System.out.println(index);           //...
Read more

JSpinner

  🔄 Java Swing JSpinner – Overview & Example JSpinner is a Swing component that allows users to select a number or object value from a sequence by clicking up/down arrows or typing. ✅ Key Features Method / Property Description setModel(SpinnerModel) Set a value model (number, list, date, etc.) getValue() Get current spinner value setValue(Object) Set spinner value addChangeListener(...) Listen to value changes 📦 Types of Spinner Models Spinner Model Description SpinnerNumberModel Integer/double values SpinnerListModel List of strings or objects SpinnerDateModel Dates (with min/max & step size) ✅ Example 1: Spinner with Numbers import javax.swing.*; import java.awt.*; public class NumberSpinnerExample { public static void main(String[] args) { JFrame frame = new JFrame("JSpinner Number Example"); frame.setSize(300, 100); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); ...
Read more

🛢️ MySQL Connection & CRUD Operations in Java

🛢️ MySQL Connection & CRUD Operations in Java In this guide, you will learn how to connect Java applications to a MySQL database and perform basic CRUD (Create, Read, Update, Delete) operations using JDBC (Java Database Connectivity). 🔌 1. Setting up MySQL Connector First, download the MySQL Connector/J (JDBC driver) and add the JAR file to your project’s build path or dependencies. 📡 2. Connecting to MySQL Database import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { private static final String URL = "jdbc:mysql://localhost:3306/testdb"; private static final String USER = "root"; private static final String PASSWORD = "your_password"; public static Connection getConnection() { try { return DriverManager.getConnection(URL, USER, PASSWORD); } catch (SQLException e) { System.out.println("Connection Failed!"); e.printStackTrace(); ...
Read more