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