Skip to main content

Salesforce CRUD Operation using GRID pattern

 Salesforce CRUD Operation using GRID pattern

Code of Visualforce page:-


<apex:page controller="StuCrudOperation">


<script

  src="https://code.jquery.com/jquery-3.7.1.js"

  integrity="sha256-eKhayi8LEQwp4NKxN+CfCh+3qOVUtJn3QNZ0TciWLP4="

  crossorigin="anonymous"></script>

  <apex:form >

  <apex:pageBlock >

 <apex:inputText id="paramText"/>

 <apex:commandButton value="click" oncomplete="findData()" /> 

</apex:pageBlock>

      <apex:pageBlock id="anyName">

        <apex:pageblocktable value="{!allRec}" var="a">

       

              <apex:column value="{!a.id}" id="stuid"/>

               <apex:column value="{!a.Name}" id="stuname" />

               <apex:column value="{!a.fees__c}" id="stufees"/>

               <apex:column ><a href="" class="edit">Edit</a></apex:column>

               <apex:column ><a href="#" class="del">Delete</a></apex:column>

          </apex:pageblocktable>

          <apex:pageblocktable value="{!allStus}" var="obj">

              <apex:column headerValue="Name">

                  <apex:inputText value="{!obj.Id}" id="txtid"  />

                  <apex:inputtext value="{!obj.Name}" id="txtname"/>

              </apex:column>

              <apex:column headerValue="fees">

                  <apex:inputtext value="{!obj.fees__c}" id="txtfee"/>

                 

                 

              </apex:column>

             

          </apex:pageblocktable>

          

          <apex:commandButton value="addRow" action="{!addRowMethod}" rerender="anyName"/>

          <apex:commandButton value="removeRow" action="{!removeRowMethod}"/>

          

          <apex:commandButton value="save" action="{!saveMethod}"/>

          <apex:commandButton value="edit"  action="{!editMethod}"/>

          <apex:commandButton value="delete" action="{!deleteMethod}" reRender="anyName"/>

          <apex:commandButton value="Clear" action="{!clearMethod}" reRender="anyName"/>

      </apex:pageBlock>

  </apex:form>

    <script>

    $(document).ready(function(){

     $(".del").click(function(){

           var currentRow=$(this).closest("tr"); 

         

         var tid=currentRow.find("td:eq(0)").find("span:first").text(); 

         var name=currentRow.find("td:eq(1)").find("span:first").text(); 

         var fees=currentRow.find("td:eq(2)").find("span:first").text(); 

        

       

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtid').value=tid;

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtname').value=name;

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtfee').value=fees;

        

      

    

     });

      $(".edit").click(function(){

           var currentRow=$(this).closest("tr"); 

         

         var tid=currentRow.find("td:eq(0)").find("span:first").text(); 

         var name=currentRow.find("td:eq(1)").find("span:first").text(); 

         var fees=currentRow.find("td:eq(2)").find("span:first").text(); 

        

       

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtid').value=tid;

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtname').value=name;

        document.getElementById('j_id0:j_id2:anyName:j_id10:0:txtfee').value=fees;

        

      

    

     });

    });

    

    /*function findData()

    {

   

     //  var name=document.getElementById('paramText').value;

        var tid= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stuid').textContent;

       var name= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stuname').textContent;

       var fees= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stufees').textContent;

       document.getElementById('j_id0:j_id1:anyName:j_id9:0:txtid').value=tid;

       document.getElementById('j_id0:j_id1:anyName:j_id9:0:txtname').value=name; 

       document.getElementById('j_id0:j_id1:anyName:j_id9:0:txtfee').value=fees; 

       

        alert('hello' + name);

       

    }*/

    </script>

</apex:page>


Code of Apex Class:-

public class StuCrudOperation {

 public List<stu__c> allStus{get;set;}

 public List<stu__c> allRec{get;set;}

 public stu__c coll;

    public string myid{get;set;}

   

    public StuCrudOperation()

    {

        allRec = [select Id,Name,fees__c from stu__c];

        allStus = new List<stu__c>();

        stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

   

    public void addRowMethod(){

       stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

        

    public void removeRowMethod(){

        integer count = allStus.size();

        allStus.remove(count-1);

    }

    public void saveMethod(){

        insert allStus;

    }

     public void editMethod(){

       coll = [SELECT Id, Name, fees__c FROM stu__c WHERE Id = :allStus[0].Id];

       coll.Name = allStus[0].Name;

       coll.fees__c  = allStus[0].fees__c;

       System.debug('Id is '+allStus[0].Id);

       update coll;

    }

     public void deleteMethod(){

        coll = [SELECT Id FROM stu__c WHERE Id = :allStus[0].Id];

         System.debug('Id is '+allStus[0].Id);

        delete coll;

    }

    public void clearMethod(){

         integer finalCount = allStus.size();

         allStus.clear();

         for(integer i=0;i<finalCount;i++){

            stu__c acc1 = new stu__c();

            allStus.add(acc1);

            

        }

            

        }

    

     

}

Comments

Post a Comment

POST Answer of Questions and ASK to Doubt

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...
Post a Comment
Read more

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...
Post a Comment
Read more

JDBC Database Connectivity using JSP and Servlet, Database connectivity on Java

JDBC Database Connectivity using JSP and Servlet, Database connectivity on Java JDBC:-   JDBC means Java database connectivity, it is used to connect from the front-end(application server) to the back-end(database server) in the case of Java web application. The database provides a set of tables to store records and JDBC will work similarly to the  bridge between the database table and application form. 1)  Class.forName("drivername")  // Manage Drive         Class.formName("com.mysql.jdbc.Driver");  // MYSQL      Class.forName ("oracle.jdbc.driver.OracleDriver"); //Oracle 2)  Manage Connection String     It establish connection from application server to database server, Java provide DriverManage class and getConnection that will return Connection object.    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename","username","password"); 3)  Manage Statement to...
4 comments
Read more