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();
}
