Skip to content

Details On The ExtJS Application to Build Simple CRUD operation Using Models and Stores

Updated: at 02:12 PM


Part 1 Basics (mostly server side)
Part 2 (this) ExtJS Client Side Details


*For those who are intersted in this, I just posted a 3 part series on using ExtJS 4.2 with Microsoft's new WebAPI Restful Interface.  The new WebAPI is more efficient on the server side and the coding to REST makes the ExtJS side simpler. (March 13, 2013)    Part 1

In the first article, a very simple updater was build using Sencha’s ExtJS and Microsoft’s Entity Framework Code First.  The focus was really on the server side while the client side project was included for reference.  The client side app was barely discussed.  In this article, we are going to discuss in more detail what is happening on the client side and how the Sencha ExtJS JavaScript library helps us to implement these updates.


The Basics

Let’s start out with some basics rather than jump right in to the real project.   I think we can all assume the displaying of the data is pretty simple. We just create a store, add some fields, hook it up to a Ext.grid.Panel and set the store to autoload and it all just works.  Updating though does add a little more complexity and for that, we are going to add some structure.  So, let’s take a look at the very basics without any UI at all.

Just by way of reminders, we create two simple services in our project.  One that reads and the other that updates.  For the purpose of this article, those are the three (of four) CRUD operations we are going to implement (read,insert and update).  Let’s first implement those operations directly.  Below is a very straight forward JavaScript which basically represents a completely working ExtJS app with a single button in the viewport.  Here is the code below.

Ext.Loader.setConfig({ enabled: true });

Ext.application({ name: ‘AM’,

controllers: [
    <span class="str">'Users'</span>

launch: <span class="kwrd">function</span>() {
    Ext.create(<span class="str">'Ext.container.Viewport'</span>, {
        layout: <span class="str">'border'</span>,
        items: [
                xtype: <span class="str">'button'</span>,
                region: <span class="str">'center'</span>,
                text: <span class="str">'Insert a Record'</span>,
                handler: <span class="kwrd">function</span> () {
                    <span class="kwrd">var</span> writer = <span class="kwrd">new</span>{
                        type: <span class="str">'json'</span>,
                        encode: <span class="kwrd">false</span>,
                        listful: <span class="kwrd">true</span>,
                        writeAllFields: <span class="kwrd">true</span>,
                        returnJson: <span class="kwrd">true</span>

                    <span class="kwrd">var</span> reader = <span class="kwrd">new</span>{
                        totalProperty: <span class="str">'total'</span>,
                        successProperty: <span class="str">'success'</span>,
                        idProperty: <span class="str">'Id'</span>,
                        root: <span class="str">'Data'</span>,
                        messageProperty: <span class="str">'message'</span>

                    <span class="kwrd">var</span> proxy = <span class="kwrd">new</span>{
                        reader: reader,
                        writer: writer,
                        type: <span class="str">'ajax'</span>,
                        api: {
                            read: <span class="str">'/UserInfo/Get'</span>,
                            create: <span class="str">'/UserInfo/Create'</span>,
                            update: <span class="str">'/UserInfo/Update'</span>,
                            destroy: <span class="str">'/UserInfo/Delete'</span>
                        headers: {
                            <span class="str">'Content-Type'</span>: <span class="str">'application/json; charset=UTF-8'</span>

                    Ext.define(<span class="str">'MyModel'</span>, {
                        extend: <span class="str">''</span>,
                        fields: [<span class="str">'Id'</span>, <span class="str">'Name'</span>, <span class="str">'Email'</span>],
                        proxy: proxy

                    Ext.define(<span class="str">'MyStore'</span>, {
                        extend: <span class="str">''</span>,
                        model: <span class="str">'MyModel'</span>,
                        autoLoad: <span class="kwrd">true</span>,
                        paramsAsHash: <span class="kwrd">true</span>,
                        proxy: proxy

                    <span class="kwrd">var</span> myStore = Ext.create(<span class="str">'MyStore'</span>, {

                        Name: <span class="str">'TestName'</span>,
                        Email: <span class="str">''</span>



Without going into to much detail, basically, what has been done above is a to create a simple model (myModel) which contains a JsonReader and JsonWriter and proxy of course. This model has a couple fields in it (Id,Name and Email), then a simple store is created that uses this model called myStore.  Once this store has been created, we simply call the store’s “add” method with a config object that represents the data, then calling sync() on that store forces an insert (or create) to be executed through the proxy.  If I look at Chrome’s JavaScript debugger (network tab), you can see from the picture below that indeed, the servers UserInfo/Create method has been called passing in the parameters Name and Email.




It’s important to understand these steps because we will be using the store and model in a similar way when we update the data in our next section.


Implementation in Grid and Editor Panel


We are using the ExtJS MVC architecture for this app so all our procedural code is in the controller.  For the Ext.grid.Panel, all we have for the view is the following (app/view/List.js).




Ext.define('AM.view.user.List', {
    extend: 'Ext.grid.Panel',
    alias: 'widget.userlist',
title: <span class="str">'All Users'</span>,
store: <span class="str">'Users'</span>,

columns: [
{ header: <span class="str">'Name'</span>, dataIndex: <span class="str">'Name'</span>, flex: 1 },
{ header: <span class="str">'Email'</span>, dataIndex: <span class="str">'Email'</span>, flex: 1 }


Then, in our controller (app/controller/Users.js) we have the working code that actually does the editing and updating of the record.  the code is below:

Ext.define('AM.controller.Users', {
    extend: '',
    stores: ['Users'],
    models: ['User'],
    views: ['user.Edit', 'user.List'],
    refs: [
            ref: 'usersPanel',
            selector: 'panel'
    init: function() {
            'viewport > userlist dataview': {
                itemdblclick: this.editUser
            'useredit button[action=save]': {
                click: this.updateUser
    editUser: function(grid, record) {
        var edit = Ext.create('AM.view.user.Edit').show();
    edit.down(<span class="str">'form'</span>).loadRecord(record);
updateUser: <span class="kwrd">function</span>(button) {
    <span class="kwrd">var</span> win    = button.up(<span class="str">'window'</span>),
        form   = win.down(<span class="str">'form'</span>),
        record = form.getRecord(),
        values = form.getValues();
    <span class="kwrd">this</span>.getUsersStore().sync();


Basically, this follows the exact same method we described above for implementing the CRUD.  Note getUsersStore().sync.  This does the same thing as shown above to force the appropriate call the back end.



Hope this helps give you a little more understanding into updating with the ExtJS library. If you are looking for the source, it’s in part 1 of this series.

* for the record, this ExtJS code is taken very closely from samples on the Sencha web site.  The premise of the article is and not how to right sencha code.

Check out the ORM (Object Relational Mapper) PRISMA. The database access method I use in all my projects