Ajax and getJSon functions to call a method in MVC

Ajax and getJSON functions to call a method in mvc


Ajax function:

<script>

    $(document).ready(function () {

            $.ajax({

                url: '@Url.Action("test","JqGrid")', type: "POST", datatype: "JSON", data: { id: $("#txtMobile").val(), Name: $("#txtName").val() }, success: function (data) {

                    if (data != null) {

                        alert("success");

                        //$.each(data, function (sample, i) {

                        //});

                    }

                }

            });

           

        });

</script>

getJSON function

<script>

    $(document).ready(function () {

           

            $.getJSON('@Url.Action("test","JqGrid")', { id: $("#txtMobile").val(), Name: $("#txtName").val() }, function (data) {

                if (data != null) {

                    alert("success");

                }

            });

        });

</script>

Some Important Queries in SQL Server

Below are some difficult queries in SQL Server

SQL Main Queries using SQL Operators

Between Operation

Get records using between dates

SELECT *

FROM TableName

where   CAST(Date as Date) between '2013-01-22' and '2014-05-22' order by Date desc

Get Records using between Id

SELECT *

FROM TableName

where   ID between 24 and 55 order by id desc

IN Operator

Get records which are having that list of Ids

SELECT *

FROM TableName

where ID in(1,11,22,33,44)  order by id desc

Functions:

Count()

To get Count of Records in a table

SELECT COUNT(*) FROM table_name;

First Record from a table

SELECT TOP 1 CustomerName FROM Customers

ORDER BY CustomerID ASC;

Last record from A table

SELECT TOP 1 CustomerName FROM Customers

ORDER BY CustomerID DESC;

Duplicates are having Or not

select COUNT(no)as count,no from TableName group by No having COUNT(No)>1

Select Top N Records:

SELECT * FROM (

  SELECT

    ROW_NUMBER() OVER (ORDER BY key ASC) AS rownumber,

    columns

  FROM tablename

) AS foo

WHERE rownumber <= n

another

WITH RequireRows AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
    FROM Sales.SalesOrderHeader
)

SELECT *
FROM RequireRows
WHERE RowNumber <= n;

Select nth Record

SELECT * FROM (

  SELECT

    ROW_NUMBER() OVER (ORDER BY key ASC) AS rownumber,

    columns

  FROM tablename

) AS foo

WHERE rownumber = n


another

WITH RequireRows AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
    FROM Sales.SalesOrderHeader 
)  

SELECT * 
FROM RequireRows

WHERE RowNumber = 5;

Insert records into one table to another existing table:

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

Insert records from one table to another new table:

SELECT column_name(s)
INTO newtable [IN externaldb]
FROM table1;

Function to search in function from C#


CREATE FUNCTION [dbo].[iter$simple_intlist_to_tbl] (@list nvarchar(MAX))  
   RETURNS @tbl TABLE (number varchar(50) NOT NULL) AS  
BEGIN  
   DECLARE @pos        int,  
           @nextpos    int,  
           @valuelen   int  
  
   SELECT @pos = 0, @nextpos = 1  
  
   WHILE @nextpos > 0  
   BEGIN  
      SELECT @nextpos = charindex(',', @list, @pos + 1)  
      SELECT @valuelen = CASE WHEN @nextpos > 0  
                              THEN @nextpos  
                              ELSE len(@list) + 1  
                         END - @pos - 1  
      INSERT @tbl (number)  
         VALUES (convert(varchar(50), substring(@list, @pos + 1, @valuelen)))  
      SELECT @pos = @nextpos  
   END  
  RETURN  
END

Important URLS

Some Important Site URLS


Table Sorter:

http://mottie.github.io/tablesorter/docs/index.html#Widget-options 


Captcha Generation in MVC

http://www.c-sharpcorner.com/UploadFile/bd8b0b/how-to-implement-captcha-in-Asp-Net-mvc/

Cascading Dropdowns List In MVC

http://www.c-sharpcorner.com/UploadFile/4d9083/creating-simple-cascading-dropdownlist-in-mvc-4-using-razor/

Crud operations using Dailog

http://www.dotnetcodesg.com/Article/UploadFile/2/286/CRUD%20operation%20using%20Modal%20Popup%20in%20ASP.NET%20MVC%204.aspx

WCF Service Example:

http://www.aspdotnet-suresh.com/2011/06/introduction-to-wcf-wcf-tutorial-wcf.html

Insert CSV type file to Sql server database

http://www.c-sharpcorner.com/uploadfile/0c1bb2/inserting-csv-file-records-into-sql-server-database-using-as/


Check Regular Expressions

http://regexr.com/

How to Disable Mouse Events and KeyBoard cliks functions using Jquery

Disable  Mouse Events and Button Clicks

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

<script type='text/javascript'>

    $(function () {

        $(document).on({

            "contextmenu": function (e) {

                console.log("ctx menu button:", e.which);

                // Stop the context menu

                e.preventDefault();

            },

            "mousedown": function (e) {

                console.log("normal mouse down:", e.which);

            },

            "mouseup": function (e) {

                console.log("normal mouse up:", e.which);

            }

        });

        // Disable all keypress events for all elements

        $(document).keypress(function (e) { e.preventDefault(); return false; });

        $(document).keyup(function (e) { e.preventDefault(); return false; });

        $(document).keydown(function (e) { e.preventDefault(); return false; });

    });

</script>

Crud Operations with Dialog in mvc Jquery

 CRUD Operations Using Dialogue and Jquery in MVC

Model for Properties declaration:

       public class Sample  {

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Location { get; set; }

        public int Id { get; set; }

    }

Controller Operations:

 public ActionResult Dialog()

        {

            Sample sm = null;

            List<Sample> sp = new List<Sample>();

            var data = context.UserInfoes.ToList();

            for (int i = 0; i < data.Count; i++)

            {

                sm = new Sample();

                sm.FirstName = data[i].FirstName;

                sm.LastName = data[i].LastName;

                sm.Location = data[i].Location;

                sm.Id = data[i].Id;

                sp.Add(sm);

            }

            return View(sp);

        }

        public JsonResult DialogUpdate(string Name, string Class, string Subject,int id)

        {

            var con = context.UserInfoes.Where(u => u.Id == id).FirstOrDefault();

            con.FirstName = Name;

            con.LastName = Class;

            con.Location = Subject;

            context.SaveChanges();

            return Json(true,JsonRequestBehavior.AllowGet);

        }

        public JsonResult Dialogassign(int id)

        {

           Sample s=new Sample();

           var con = context.UserInfoes.Where(u => u.Id == id).FirstOrDefault();

           s.FirstName = con.FirstName;

           s.LastName = con.LastName;

           s.Location = con.Location;

           s.Id = con.Id;

            return Json(s,JsonRequestBehavior.AllowGet);

        }

        public JsonResult DialogInsert(string Name, string Class, string Subject)

        {

            UserInfo con = new UserInfo();

            con.FirstName = Name;

            con.LastName = Class;

            con.Location = Subject;

            context.AddToUserInfoes(con);

            context.SaveChanges();

            return Json(true, JsonRequestBehavior.AllowGet);

        }

        public JsonResult Dialogdelete(int id)

        {

            var con = context.UserInfoes.Where(u => u.Id == id).FirstOrDefault();

            context.DeleteObject(con);

            context.SaveChanges();

            return Json(true, JsonRequestBehavior.AllowGet);

        }

View :

@model IEnumerable<JQGridExample.Models.Sample>

@{

    ViewBag.Title = "Dialog";

}

<h2>Dialog</h2>

<!DOCTYPE html>

<html>

<head>

    <link href="../assets/styles.min.css" rel="stylesheet">

    <title>jQuery UI Dialog: Open Dialog on Click</title>

    <link href="~/Content/css/jquery-ui.min.css" rel="stylesheet" />

    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

    <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.11.1/jquery-ui.min.js"></script>

</head>

<body>

    <div id="dialog" title="Dialog">

        <table>

            <tr>

                <td style="color: white">Name:</td>

                <td>

                    <input type="text" id="name" /></td>

            </tr>

            <tr>

                <td style="color: white">Class:</td>

                <td>

                    <input type="text" id="class" /></td>

            </tr>

            <tr>

                <td style="color: white">Subject:</td>

                <td>

                    <input type="text" id="Subject" />

                    <input type="hidden" id="id" />

                </td>

            </tr>

        </table>

        <input type="button" id="button1" value="Update">

    </div>

    <div id="dialog1" title="Dialog">

        <table>

            <tr>

                <td style="color: white">Name:</td>

                <td>

                    <input type="text" id="name1" /></td>

            </tr>

            <tr>

                <td style="color: white">Class:</td>

                <td>

                    <input type="text" id="class1" /></td>

            </tr>

            <tr>

                <td style="color: white">Subject:</td>

                <td>

                    <input type="text" id="Subject1" />

                </td>

            </tr>

        </table>

        <input type="button" id="button2" value="Create">

    </div>

    <table border="1">

        <tr>

            <td>FirstName</td>

            <td>LastName</td>

            <td>Location</td>

            <td></td>

            <td></td>

        </tr>

        @foreach (var m in Model)

        {

            <tr>

                <td>@m.FirstName</td>

                <td>@m.LastName</td>

                <td>@m.Location</td>

                <td><a onclick='return Poup(@m.Id)' href="#">Edit</a></td>

                <td><a onclick='return PoupD(@m.Id)' href="#">Delete</a></td>

            </tr>

        }

    </table>

    <input type="button" id="button" value="Click to create New">

    <script>

        $(function () {

            $("#dialog").dialog({

                autoOpen: false

            });

        });

        function Poup(id) {

            $.getJSON('@Url.Action("Dialogassign", "JQGrid")', { id: id },

             function (data) {

                 $("#name").val(data.FirstName);

                 $("#class").val(data.LastName);

                 $("#Subject").val(data.Location);

                 $("#id").val(data.Id);

             });

            $("#dialog").dialog("open");

        }

        $(function () {

            $("#button1").click(function () {

                var name = $("#name").val();

                var classs = $("#class").val();

                var subject = $("#Subject").val();

                var id = $("#id").val();

                $.getJSON('@Url.Action("DialogUpdate", "JQGrid")',

                {

                    Name: name,

                    Class: classs,

                    Subject: subject,

                    id: id

                }

                , function (result) {

                    alert("Updated");

                    $("#dialog").dialog("close");

                    location.reload();

                });

            });

        });

        $(function () {

            $("#dialog1").dialog({

                autoOpen: false,

                //buttons: { 'add': function () { alert('ra'); } }

            });

            $("#button").click(function () {

                $("#dialog1").dialog("open");

            });

        });

        $(function () {

            $("#button2").click(function () {

                var name = $("#name1").val();

                var classs = $("#class1").val();

                var subject = $("#Subject1").val();

                $.getJSON('@Url.Action("DialogInsert", "JQGrid")',

                    {

                        Name: name,

                        Class: classs,

                        Subject: subject,

                    }

                    , function (result) {

                        alert("Inserted");

                        $("#dialog1").dialog("close");

                        location.reload();

                    });

            });

        });

        function PoupD(id) {

            $.getJSON('@Url.Action("Dialogdelete", "JQGrid")', { id: id },

               function (data) {

                   alert("Deleted");

               })

            location.reload();

        }

    </script>

</body>

</html>