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