Sunday, June 30, 2013

Jquery Date Picker in dd/mm/yyyy Format.

$(document).ready(function () {
        $('.datepicker').datepicker({
            numberOfMonths: 2,
            dateFormat: 'dd/mm/yy',
            changeMonth: true,
            changeYear: true,
            autoSize: true,
            minDate: new Date(),
            maxDate: '+363d',
            showAnim: 'fadeIn',
            yearRange: '2013:2020',
            showOn: 'focus',
            buttonImage: '/Content/images/calendar.gif',
            buttonImageOnly: 'false'
        });
    })

Sunday, February 24, 2013

Select all Html Element whose ID start with 'txt_'



<!DOCTYPE html>
<html>
<head>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js">
</script>
<script>
    $(document).ready(function () {
        $("button").click(function () {
            $("a[target='_blank']").hide();
            $('[id^="txt_"]').hide();
        });
    });
</script>
</head>
<body>

<h2>This is a heading</h2>
<p id="txt_p">This is a paragraph.</p>
<p id="txt_p1">This is another paragraph.</p>

<button>Click me</button>

</body>
</html>

Thursday, January 10, 2013

Kendo - KnockOut Grid Bind




<link href="@Url.Content("~/Content/Site.css")" rel="stylesheet" type="text/css" />

<link href="@Url.Content("~/Content/kendo.common.min.css")" rel="stylesheet" type="text/css" />

<link href="@Url.Content("~/Content/kendo.blueopal.min.css")" rel="stylesheet" type="text/css" />



<script src="@Url.Content("~/Scripts/jquery-1.8.3.js")" type="text/javascript"></script>

<script src="../../Scripts/knockout-2.2.0.debug.js" type="text/javascript"></script>

<script src="../../Scripts/kendo.all.min.js" type="text/javascript"></script>

<script src="../../Scripts/knockout-kendo.min.js" type="text/javascript"></script>


HTML

                                              


<div data-bind='kendoGrid:gridConfig'></div>  

                                               

JavaScript


<script language="javascript" type="text/javascript">

$(document).ready(function () {
      
        $.ajaxSetup({ async: false });

        //var Data= [{ "ShipCity": "Kolkata", "ShipName": "Pinaki GROUP" }, { "ShipCity": "Mumbai", "ShipName": "Pinaki SOL"}];
        var Data = null;

        function DataFunction() {
            $.post("/BkCode/BookResult", null, function (d) {

                Data = d;
            });
            return Data;

        }
      

        var ViewModel = function () {
            this.gridConfig = {
                data: null,
                dataSource: {
                    type: "odata",
                    data: DataFunction(), //This is use to access data from database using jQuery
                                          //   and return data in Json format
                    //data: Data,
                    schema: {
                        model: {
                            fields: {
                                ShipCity: {
                                    type: "string"
                                   
                                },

                                ShipName: {
                                    type: "string"


                                }
                            }
                        }
                    },
                    pageSize: 10 //,
                    //serverPaging: true,
                    //serverFiltering: true,
                    //serverSorting: true
                },
                columns: [{
                    field: "ShipCity",
                    title: "Id",
                    filterable: false
                },
                {
                    field: "ShipName",
                    title: "Company Name",
                    filterable: true
                },
                {
                    command: ["edit", "destroy"],
                    filterable: false
                }] ,

                height: 550,
                scrollable: false,
                pageable: true,
                sortable: true,
                groupable: true,
                filterable: true,
                editable: "inline", //popup
                save: function () {
                    this.refresh();
                }
            };
        };
        ko.applyBindings(new ViewModel());
    })

</script>

C#

public JsonResult BookResult()
        {
            var result = from s in bk.GetPrmCompanies()
                         select new book{
                             ShipCity = s.Id,
                             ShipName = s.CoNames
                         };
            DB.Configuration.ProxyCreationEnabled = false;

            return Json(result, JsonRequestBehavior.AllowGet); //Content(sd, "text/xml");

        }
 




SQL Optimization

  SQL Optimization  1. Add where on your query  2. If you remove some data after the data return then remove the remove condition in the sel...