public List <Story> GetAllStories() { using (var dbContext = new MomentsEntities()) { var allNodes = dbContext.Stories.ToList(); return(allNodes); } }
public UserProfile GetUserByProfileId(string userId) { using (var dbContext = new MomentsEntities()) { var user = dbContext.UserProfiles.FirstOrDefault(o => o.Id.ToString() == userId); return(user); } }
public Story GetStoryById(string storyId) { using (var dbContext = new MomentsEntities()) { var obj = dbContext.Stories.FirstOrDefault(o => o.Id.ToString() == storyId); return(obj); } }
public List <Node> GetStoryNodes(string storyId) { using (var dbContext = new MomentsEntities()) { var allNodes = dbContext.Nodes.Where(node => node.StoryId.ToString() == storyId).ToList(); return(allNodes); } }
public void ChnageStoryStatus(string storyId) { using (var dbContext = new MomentsEntities()) { var story = dbContext.Stories.FirstOrDefault(obj => obj.Id.ToString() == storyId); story.IsFeatured = !story.IsFeatured; dbContext.SaveChanges(); } }
public long AddNewNode(Node source) { using (var dbContext = new MomentsEntities()) { dbContext.Nodes.Add(source); dbContext.SaveChanges(); return(source.Id); } }
public NodeModel GetNodeById(string nodeId) { using (var dbContext = new MomentsEntities()) { var obj = dbContext.Nodes.FirstOrDefault(o => o.Id.ToString() == nodeId); if (obj != null) { return(NodeMapper(obj)); } } return(null); }
public void DeleteStory(string storyId) { using (var dbContext = new MomentsEntities()) { var allnodes = dbContext.Nodes.Where(n => n.StoryId.ToString() == storyId).ToList(); dbContext.Nodes.RemoveRange(allnodes); dbContext.SaveChanges(); var story = dbContext.Stories.FirstOrDefault(obj => obj.Id.ToString() == storyId); dbContext.Stories.Remove(story); dbContext.SaveChanges(); } }
public ReportingModel GetReporting(GetNetworkRequestModel model) { var nodes = new List <NodeModel>(); var rels = new List <Relation>(); var ownerName = ""; var storyName = ""; var img = ""; using (var dbContext = new MomentsEntities()) { var story = dbContext.Stories.FirstOrDefault(sto => sto.Id.ToString() == model.StoryId); if (story != null) { storyName = story.Name; img = story.Path; var bunda = dbContext.UserProfiles.FirstOrDefault(user => user.Id == story.CreatedBy); if (bunda != null) { ownerName = bunda.FirstName + " " + bunda.LastName; } } var allNodes = dbContext.Nodes.Where(node => node.StoryId.ToString() == model.StoryId).ToList(); if (allNodes != null && allNodes.Any()) { foreach (var item in allNodes) { var n_ = NodeMapper(item); var author = GetUserByProfileId(item.CreatedBy.ToString()); if (author != null) { n_.NodeAuthor = author.FirstName + " " + author.LastName; n_.label = n_.label; } nodes.Add(n_); if (item.ParentId != 0) { rels.Add(new Relation { from = item.ParentId.ToString(), to = item.Id.ToString(), color = "#6c757d" }); } } } } return(new ReportingModel { Nodes = nodes, Relation = rels, Owner = ownerName, Image = img, StoryName = storyName }); }