public List<VIEW_TOUR_MASTER> GetTour(int startIndex, int maximumRows, string sortExpression, string filterExpression,string searchExpression) { if (!String.IsNullOrEmpty(filterExpression)) { Tour = Tour.Where(filterExpression); } if (!String.IsNullOrEmpty(sortExpression)) { Tour = Tour.OrderBy(sortExpression); } if (!String.IsNullOrEmpty(searchExpression)) { TourMasterDataBaseDataContext db = new TourMasterDataBaseDataContext(); Tour = db.VIEW_TOUR_MASTERs.Where(p => (p.COUNTRIES_FOR_VISA_TEXT.Contains(searchExpression) || p.TOUR_LONG_DESC.Contains(searchExpression))); } else { Tour = Tour.OrderBy("TOUR_ID DESC"); } return Tour.Skip(startIndex).Take(maximumRows).ToList(); }
public List<VIEW_TOUR_MASTER> GetSearchTour(string param) { TourMasterDataBaseDataContext db=new TourMasterDataBaseDataContext(); Tour = db.VIEW_TOUR_MASTERs.Where(p => p.COUNTRIES_FOR_VISA_TEXT.Contains(param)); return Tour.ToList(); }