public List <tblEvent> GetEventsListforEventPage()
{
using (dbSiteEntities objContext = new dbSiteEntities())
{
//tblEe obj = new tblText();
//string obj = objContext.tblTexts.OrderByDescending(t => t.TextType_ID.Equals(1)).First().TextDetail;
return(objContext.tblEvents.ToList());
}
}
public bcChiefMessage Get1ChairMessage(int id)
{
using (objContext = new dbSiteEntities())
{
return(objContext.tblTexts.Where(t => t.TextID.Equals(id)).Select(p => new bcChiefMessage {
MessageID = p.TextID, MessageTitle = p.TextTitle, MessageDetails = p.TextDetail, MessageActive = p.IsActive
}).First());
}
}
public string GetAboutMessageforAboutPage()
{
using (dbSiteEntities objContext = new dbSiteEntities())
{
tblText obj = new tblText();
//string obj = objContext.tblTexts.OrderByDescending(t => t.TextType_ID.Equals(1)).First().TextDetail;
return(objContext.tblTexts.Where(t => t.TextType_ID == 10).OrderByDescending(t => t.TextID).First().TextDetail);
// return obj.TextDetail;
}
}