public List <PNEW> ListOfNews(String Search)
{
EdPicker.Edlooker_DevEntities1 _database = new EdPicker.Edlooker_DevEntities1();
DateTime now = DateTime.Now;
String timeStamp = now.ToString();
var SearchTerm = Search;
var Query = "";
if (SearchTerm == null || SearchTerm == "")
{
Query = "SELECT * FROM PNews";
}
else
{
Query = "SELECT * FROM PNews where Tags like '%" + SearchTerm + "%'";
}
List <PNEW> NewsList = _database.PNEWS.SqlQuery(Query).ToList();
return(NewsList);
}
public List <PCALENDER> ListOfCalenderData(String Search)
{
EdPicker.Edlooker_DevEntities1 _database = new EdPicker.Edlooker_DevEntities1();
DateTime now = DateTime.Now;
String timeStamp = now.ToString();
var SearchTerm = Search;
var Query = "";
if (SearchTerm == null || SearchTerm == "")
{
Query = "SELECT * FROM PCalender";
}
else
{
Query = "SELECT * FROM PCalender where Tags like '%" + SearchTerm + "%'";
}
List <PCALENDER> CalenderList = _database.PCALENDERs.SqlQuery(Query).ToList();
return(CalenderList);
}
