How to filter search by 2 fields(eg. Name and date)

Question

1.00/5 (1 vote)

See more:

I am trying to filter my search by consultant name and date created for records. i am using a datepicker for my calendar and a drop down list for selection on the consultant name. At the moment I have the search working for just the consultant, i cannot figure out how to add the date as a filter.

[HttpPost]
    public ActionResult TimesheetHistroy(Timesheet timesheet)
    {

        ViewBag.ConsultantNum = new SelectList(db.Consultants, "ConsultantNum", "FullName", timesheet.ConsultantNum);
        var timesheets = db.Timesheets.Include(t => t.Client).Include(t => t.Consultant).Where(a=>a.ConsultantNum==timesheet.ConsultantNum && EnterDate == timesheet.CaptureDate) ;
        var r = timesheets.ToList();
        return View(r);
    }

What I have tried:

I have tried using it independently, but i need them to work together

Posted 27-May-17 10:55am

Member 13215299

Updated 27-May-17 18:55pm

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)

Bryian Tan · Answer 1 · 2017-05-27T18:55:00

I'm assuming a.EnterDate is a DateTime or Date type, timesheet.CaptureDate is the string return by the datepicker plugin

You didn't mention what the issue was. I further assume that the code threw error??? because the code is trying to compare a string and a Date?

There are couple of things to look at.

1. The datepicker date format. Make sure you coded it to return date format like 05/28/2017 or however the requirements are.

JavaScript

$(function () {
            $('#CaptureDate').datepicker({
                dateFormat: 'mm/dd/yy' //somehow this return 05/28/2017 vs 05/28/17
            });
        });

2. Here is one of the option. Convert the EnterDate into string with format mm/dd/yyyy and compare it with CaptureDate. Again, I further assumed that the EnterDate does not allow null. If it does, change the code to get the month to "a.EnterDate.Value.Month"

C#

var timesheets = db.Timesheets.Include(t => t.Client).Include(
                t => t.Consultant).Where(a => a.ConsultantNum == timesheet.ConsultantNum &&
         SqlFunctions.Replicate("", 2 - SqlFunctions.StringConvert((double)a.EnterDate.Month).TrimStart().Length) +
         SqlFunctions.Replicate("0", 2 - SqlFunctions.StringConvert((double)a.EnterDate.Month).TrimStart().Length) +
                        SqlFunctions.StringConvert((double)a.EnterDate.Month).TrimStart() +

         SqlFunctions.Replicate("/", 2 - SqlFunctions.StringConvert((double)a.EnterDate.Month).TrimStart().Length) +
         SqlFunctions.Replicate("0", 2 - SqlFunctions.DateName("dd", a.EnterDate).Trim().Length) +
         SqlFunctions.DateName("dd", a.EnterDate).Trim() + "/" +

         SqlFunctions.DateName("year", a.EnterDate) == timesheet.CaptureDate).ToList();