public List <Navigation> GetTopMenu() { using (var context = new Entity.pycloudinEntities()) return((from _content in context.AppMenus where _content.MeneType == "Top" select new Navigation { MenuLink = _content.MenuLink, MenuText = _content.MenuText, }).ToList()); }
public TopicContent GetContent(string url) { using (var context = new Entity.pycloudinEntities()) { var result = (from _content in context.AppMenus join _blog in context.AppBlogs on _content.MenuId equals _blog.MenuId where _content.MenuLink == url select new { _content, _blog }).FirstOrDefault(); TopicContent topicContent = new TopicContent(); FileStorage fileStorage = new FileStorage(AppSetting.StorageConnectionString, this.ShareName.ToLower()); var folderpath = result._content.MenuSection.ToLower(); var filename = $"{result._content.MenuLink.Replace("-", "").ToLower()}.html"; var content = fileStorage.ReadFile(folderpath, filename); topicContent.ContentText = content; topicContent.HeaderText = result._blog.BlogTitle; return(topicContent); } }
public List <Navigation> GetSideMenu(string section) { using (var context = new Entity.pycloudinEntities()) { var result = (from _content in context.AppMenus where _content.MeneType == "Side" && _content.MenuSection == section select new Navigation { MenuId = _content.MenuId, MenuLink = string.IsNullOrEmpty(_content.MenuLink) ? "NA" : _content.MenuLink, MenuText = _content.MenuText, MenuSection = _content.MenuSection, MeneType = _content.MeneType, ParentMenuId = _content.ParentMenuId }).ToList(); return(result); } }
public List <ListItem> GetArea() { List <ListItem> returnResult = new List <ListItem>(); returnResult.Add(new ListItem { Text = "Select", Value = "" }); using (var context = new Entity.pycloudinEntities()) { var result = (from _content in context.AppMenus select new { _content.MenuSection }).ToList().Distinct(); foreach (var item in result) { returnResult.Add(new ListItem { Text = item.MenuSection, Value = item.MenuSection }); } } return(returnResult); }
public List <ListItem> GetBlog(string section) { List <ListItem> returnResult = new List <ListItem>(); returnResult.Add(new ListItem { Text = "Select", Value = "" }); using (var context = new Entity.pycloudinEntities()) { var result = (from _content in context.AppMenus where _content.MenuLink != null && _content.MenuSection == section select new { _content.MenuText, _content.MenuLink }).ToList().Distinct(); foreach (var item in result) { returnResult.Add(new ListItem { Text = item.MenuText, Value = item.MenuLink }); } } return(returnResult); }