LINQ - Where Conditions - "if-else" Cases

Question

I have following Linq query. What I want is if I do search for a particular year, I should get corresponding records of that year. Else just show records of current year. Same way searchtext has also to be done.

    public ActionResult Search(string searchtext, int? year)
    {
                string selyear = year.ToString();
                string curyear = (DateTime.Now.Year).ToString();

                hdms = from t in db.HOLIDAY                           
                       where    
                           (year == null || t.DOH.StartsWith(selyear)) &&
                           (searchtext == "" || t.HOLIDAY_NAME == searchtext)                      
                       select new HOLIDAYDETAILS
                       {
                           DOH = t.DOH,                               
                       };
                       ....
    }

I want to satisfy this also if (year == null) then t.DOH.StartsWith(curyear) and

if (searchtext == "") then t.HOLIDAY_NAME != "Sunday" && t.HOLIDAY_NAME != "Saturday".

Also If both are null at the same time, both conditions should be satisfied together.

How can I give this one too on the above where clause?

SarangK · Accepted Answer · 2016-03-15 07:47:11Z

If checking year is null or not is your problem then you simply can do like this-

public ActionResult Search(int? year)
    {
                string selyear = year.ToString();
                string queryyear = (string.IsNullOrEmpty(selyear)) // checking for null
                                   ? (DateTime.Now.Year).ToString() // current year
                                   : selyear; // year in query

                hdms = from t in db.HOLIDAY
                       join t1 in db.EMPLOYEE on t.UPDATED_BY equals t1.EMP_CODE
                       where    
                           t.DOH.StartsWith(queryyear)  // comparing queryyear        

                       orderby
                           t.DOH
                       select new HOLIDAYDETAILS
                       {
                           DOH = t.DOH,                               
                       };
                       ....
    }

Hope this will works for you...

Backs · Accepted Answer · 2016-03-15 09:36:03Z

2

public ActionResult Search(int? year)
{
    string curyear = (DateTime.Now.Year).ToString();
    string selyear = year!=null? year.ToString() : curyear;

    var query = from t in db.HOLIDAY
                join t1 in db.EMPLOYEE on t.UPDATED_BY equals t1.EMP_CODE
                select new {t,t1};

    query = query.Where(o=>o.t.DOH.StartsWith(selyear));

    if (searchtext == "")
    {
        query = query.Where(o=>o.t.HOLIDAY_NAME != "Sunday" && o.t.HOLIDAY_NAME != "Saturday");
    }

    hdms = query.OrderBy(o=>o.t.DOH).Select(o=> new HOLIDAYDETAILS
           {
               DOH = o.t.DOH,                               
           });
   ....
}

edited Mar 15, 2016 at 9:36

answered Mar 15, 2016 at 7:48

Backs

25k5 gold badges66 silver badges92 bronze badges

2 Comments

Limna Over a year ago

Above code worked for me. Can you give me the condition for searchtext too?

Backs Over a year ago

@LimnaD'silva you can create query step-by-step depending on your conditions

Collectives™ on Stack Overflow

LINQ - Where Conditions - "if-else" Cases

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related