Search using two dates

Question

1.00/5 (2 votes)

See more:

Hi,

I have two date fields. FROM DATE: and TO DATE: fields. Now I want to use this dates to fire an Action in the controller to retrieve results which have their respective dates falling in between these dates.I would appreciate the use of JQuery.

Thanks in Advance.

Shiv.

Posted 28-Dec-12 2:32am

Shiv19

Add a Solution

Comments

Herman<T>.Instance 28-Dec-12 8:33am

what have you tried?

Sandeep Mewara 28-Dec-12 9:00am

It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.

Shiv19 17-Jan-13 9:47am

Thanks for the heads up!!!As if I did not do anything before posting. It would be better if refrain from commenting and focus more on ANSWERING.

Sandeep Mewara 17-Jan-13 10:06am

If you did anything, your question would have said so. :)

Enjoy.

Shiv19 18-Jan-13 9:46am

Brains are required to understand questions and answer them like those who have already answered.;)
Cheers!!!

Sandeep Mewara 18-Jan-13 10:26am

Yeah Sure. Cheers.

3 solutions

Solution 1

Hi , as far as you would like to get this data with help of JQuery , i suggest to U
instead of Action return Json data.
For example lets assume that we have such entity

C#

public class Exam
    {
        public DateTime To { get; set; }
        public DateTime From{ get; set; }
        public string Description { get; set; }
        public int Score { get; set; }
    
    }

so lets define our controller:

C#

public class ExamController:Controller
{
 
public JsonResult GetExams([FromUri]DateTime from, [FromUri]DateTime to)
 {
  List<exam> exams = Exams.GetExams(from, to); // method will return a list of exams
  return this.Json(exams,JsonRequestBehavior.AllowGet);
 }
}</exam>

and the last thing that remains is to make ajax call with help of jquery:

JavaScript

$.ajax({
           type: 'GET',
           url: '/Exam/GetExams',
           data: json,
           contentType: 'application/json; charset=utf-8',
           success: function (jsonData) {
               //her you provide logic for display data
           }
       });

Posted 28-Dec-12 2:43am

Oleksandr Kulchytskyi

Solution 2

//your method

public JsonResult function_Name(DateTime from, DateTime to)
{
List<nameofclass> Data= // method will return a list of exams
return this.Json(Data,JsonRequestBehavior.AllowGet);
}
and coding in your view
$.ajax({
type: 'Post',
url: 'your Url',
data: json,
contentType: 'application/json; charset=utf-8',
success: function (jsonData) {
//her you provide logic for display data
}
});

and also include jquery plug in that suppoet ajax .
this is running project code please give your review

Posted 30-Dec-12 23:09pm

rizwan muhammed khan gouri

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)

Shiv19 · Accepted Answer · 2013-01-01T21:05:00

Hi,

What I was using was

XML

<!doctype html>

<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>jQuery UI Datepicker - Default functionality</title>
    <link rel="stylesheet" href="http://code.jquery.com/ui/1.9.2/themes/base/jquery-ui.css" />
    <script src="http://code.jquery.com/jquery-1.8.3.js"></script>
    <script src="http://code.jquery.com/ui/1.9.2/jquery-ui.js"></script>
    <link rel="stylesheet" href="/resources/demos/style.css" />
    <script>
    $(function() {
        $( "#datepicker" ).datepicker();
    });
    </script>
</head>
<body>

<p>Date: <input type="text" id="datepicker" /></p>


</body>
</html>

Here instead of using the tag I want to use Razor code...For eg, @Html.TextBoxFor but with razor code the Datepicker does not get displayed.