Unable to get bind search data to view with get using jquery in MVC

Question

0.00/5 (No votes)

See more:

Here is my code
for view

HTML

@model Logs.Models.Fuel

@{
    ViewBag.Title = "Fuel LOG";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2 align="center">
    <u>
        FUEL AND ASH LOG
    </u>
</h2>
<script src="@Url.Content("~/Scripts/jquery.validate.min.js")" type="text/javascript"></script>
<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")" type="text/javascript"></script>

<script type="text/javascript">
    function fn_Search() {
        debugger;      
        var url= '@Url.Action( "Search", "Fuel")';
        $.get(url, {
            EntryDate: $("#EntryDate").val(), Shift: $("#Shift").val()
        }, function (data) {
            $("#Search").html(data);
        });
      

    }
    $(function () { $("#EntryDate").datepicker({ dateFormat: 'dd/mm/yy', changeYear: true }); });
</script>


<style type="text/css">
    td {
        border-color: black;
    }

    th {
        border-color: black;
    }

    .Width1 {
        width: 50px;
    }
</style>

@using (Html.BeginForm())
{
    @Html.ValidationSummary(true)
    <div style="width:100%;overflow-x:scroll;">

        <table>
            <tr>
                <td>
                    <button type="submit" id="btnFirst" name="Command" value="First">First</button>
                </td>
                <td>
                    <button type="submit" id="btnPrevious" name="Command" value="Previous">Previous</button>
                </td>
                <td>
                    <button type="submit" id="btnNext" name="Command" value="Next">Next</button>
                </td>
                <td>
                    <button type="submit" id="btnLast" name="Command" value="Last">Last</button>
                </td>
            </tr>
        </table>
        <br /><br />
        <table border="1" style="width:100%;">
            <tr>
                <td>
                    Name of Incharge Engineer:
                </td>
                <td>
                    @Html.DisplayFor(model => model.UserName)
                </td>
                <td rowspan="2">
                    Date
                    @Html.EditorFor(model => model.EntryDate, null, "EntryDate",null)
                    @Html.ValidationMessageFor(model => model.EntryDate)

                </td>
                <td rowspan="2">
                    Shift
                    @Html.DropDownListFor(model => model.Shift, (IEnumerable<SelectListItem>)TempData["ShiftOption"], "Select One")

                </td>
                <td rowspan="2">
                    <button type="button" id="btnSearch" name="Command" value="Search" onclick="return fn_Search();">Search</button>
                </td>
            </tr>
            <tr>
                <td>
                    Name of Incharge Engineer:
                </td>
                <td>
                    @Html.DisplayFor(model => model.ShiftEngineer)
                </td>
            </tr>
        </table>
        <br />

and in controller

C#

public class FuelController : Controller
   {
       // GET: Fuel
       public ActionResult Index(string shift)
       {
           Fuel f = new Fuel();
           TempData["ShiftOption"] = f.ShiftList();
           f.EntryDate = cl.GetNextDay(4, "", "Fuel",Convert.ToInt16(shift));
           return View(f.GetFuel(f,f.EntryDate,shift));
       }

       [HttpPost]
       public ActionResult Index(Fuel fuel, string command)
       {
           if (command == "Submit")
           {
               if (ModelState.IsValid)
               {
                   DataTable dt = new DataTable();
                   dt.Columns.Add("id");
                   dt.Columns.Add("Name");
                   dt.Columns.Add("Value");



                   dt.Rows.Add("0", "Rake1", fuel.Rake1);
                   dt.Rows.Add("0", "Rake2", fuel.Rake2);
                   // so on



                   // fuel.SaveUpdate(fuel, dt, Convert.ToInt32(Session["UserId"].ToString()));
                   fuel.SaveUpdate(fuel, dt, 1);
               }
               TempData["ShiftOption"] = fuel.ShiftList();
               return View();
           }
           else if (command == "Search")
           {
               string EntryDate = fuel.EntryDate;
               string Shift = fuel.Shift;
               Fuel f = new Fuel();
               TempData["ShiftOption"] = f.ShiftList();
               fuel = f.GetFuel(f, EntryDate, Shift);
               return View(f.GetFuel(f, EntryDate, Shift));
           }
           else
           {
               return View();
           }



       }

       ConnectionStringClass cl = new ConnectionStringClass();



       public ActionResult  Search(string  EntryDate,string Shift)
       {

           Fuel f = new Fuel();
           TempData["ShiftOption"] = f.ShiftList();
           return View("Index",f.GetFuel(f, EntryDate, Shift));

       }


   }

Here the Search method is fired but view is not loading the result data

What I have tried:

I have tried to do in Http post request in
Index(Fuel fuel, string command) but it is not loading the result data to view.

Posted 7-Apr-16 20:48pm

manish.communityhub

Updated 7-Apr-16 22:29pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Accepted Answer · 2016-04-07T22:29:00

$("#Search").html(data);

That puts the results in an element with an id of Search, but there is no such element on your page. You need something on the page like

HTML

<div id="Search"></div>

Index.cshtml

Razor

@model SearchModel
<h1>Search</h1>

@using (Html.BeginForm())
{ 
    <p>
        Search: @Html.TextBoxFor(m => m.SearchText)<br/>
        <input type="submit" value="Search" id="submit"/>
    </p>

    <div id="Search">
        @Html.Partial("_SearchResults", Model)
    </div>
}
<script type="text/javascript">
    $(document).ready(function () {
        $("#submit").click(function (e) {
            e.preventDefault();

            var url = '@Url.Action( "Search", "Home")';
            $.get(url, {
                searchText: $("#SearchText").val()
            }, function (data) {
                $("#Search").html(data);
            });
        });
    });
</script>

_SearchResults.cshtml

Razor

@model TestMVC.Models.SearchModel

@if (Model.Results == null || Model.Results.Count == 0)
{
    <p>No search results</p>
    return;
}

<table>
    @foreach(string result in Model.Results)
    { 
    <tr>
        <td>
            @result
        </td>
    </tr>
    }
</table>

SearchModel

C#

public class SearchModel
{
    public string SearchText { get; set; }
    public List<string> Results { get; set; }

    public void PopulateSearchResults()
    {
        this.Results = new List<string>();

        this.Results.Add("Result 1 for " + this.SearchText);
        this.Results.Add("Result 2 for " + this.SearchText);
        this.Results.Add("Result 3 for " + this.SearchText);
    }
}

Controller

C#

[HttpGet]
public ActionResult Index()
{
    SearchModel model = new SearchModel();

    return View(model);
}

[HttpPost]
public ActionResult Index(SearchModel model)
{
    model.PopulateSearchResults();

    return View(model);
}

public ActionResult Search(string searchText)
{
    SearchModel model = new SearchModel();

    model.SearchText = searchText;
    model.PopulateSearchResults();

    return PartialView("_SearchResults", model);
}