Events={
    postEvents:function(){
        $("#dialog").empty().html("<div id='events_form'></div>");
        $("#dialog").dialog(
        {
            title:"Post San Shou Events",
            modal: true,
            width:600,
            height:400,
            top:100,
            left:100,
            autoOpen:false,
            overlay: {
                backgroundColor: '#000',
                opacity: 0.90
            }
        }
        );
        $("#dialog").dialog("open");
        var insertForm = new net.nextdb.html.InsertForm(conn,"EVENTS");
        insertForm.insertAndLink(user.PK, "USERS_EVENTS");
        insertForm.expandFields(["description"]);
        insertForm.insertCallback(function(rowId,error){
            $("#dialog").dialog("close");
            Events.getAllEvents();
        })
        insertForm.cancelCallback(function(){
            $("#dialog").dialog("close");
        })
        insertForm.render($("#events_form")[0]);

    },
    getAllEvents: function (){
        $("#events").append(loader);
        var query = new net.nextdb.Query("MY_EVENTS");
        query.setPageSize(100);
        query.setParameters({
            login:user.PK
        });
        conn.executeQuery(query, function(myRows,error){
            if(error){
                alert(error);
                return;
            }
            var query = new net.nextdb.Query("GET_EVENTS");
            query.setPageSize(100);
            conn.executeQuery(query, function(rows,error){
                if(error){
                    alert(error.getMessage());
                }else{
                    $("#events").empty();
                    var html=""
                    for(var i=0;i<rows.length;i++){
                        // find deletable
                        var deleteLink = "";
                        for(var ii=0;ii<myRows.length;ii++){
                            if(myRows[ii].EVENTS.name == rows[i].EVENTS.name){
                                deleteLink="<a href='#' class='events_delete' pk='"+myRows[ii].EVENTS.PK+"'>delete</a>";
                            }
                        }
                        html+=("<div style='height:auto;padding:0px;border-bottom:1px solid #eee;'>")
                        html+=("<div class='events_title_bar'>")
                        html+=("<div class='events_name'>"+rows[i].EVENTS.name+" "+deleteLink+" </div>")
                        html+=("</div>")
                        html+=("</div>")
                        html+=("<div class='events_fields'><b>when</b> : "+net.nextdb.Util.shortDateFormat(net.nextdb.Util.convertFromServerDateFormat(rows[i].EVENTS.when))+"</div>")
                        html+=("<div class='events_fields'><b>where</b> : "+rows[i].EVENTS.where+"</div>")
                        html+=("<div class='events_fields'><b>contact</b> : "+rows[i].EVENTS.contact+"</div>")
                        html+=("<div class='events_fields'><b>website</b> : "+rows[i].EVENTS.url+"</div>")
                        html+=("<div class='events_fields'><b>description</b> : "+rows[i].EVENTS.description+"</div>")
                        html+=("<hr>")
                    }
                    $("#events").append(html);
                    $(".events_delete").unbind("click");
                    $(".events_delete").click(function(){
                        var del = new net.nextdb.Delete("EVENTS");
                        del.setRowId($(this).attr("pk"));
                        conn.executeDelete(del,
                            function(error){
                                if(error){
                                    alert(error);
                                } else {
                                    Events.getAllEvents();
                                }
                            }
                            );
                    });
                }
            });
        })
    }

}