public void AddComment(Comment comment)
{
using (MsgContext context = new MsgContext())
{
var user = new User {Id = comment.UserId};
comment.User = context.Users.Attach(user);
context.Comments.Add(comment);
context.SaveChanges();
}
}
public User SignIn(string username)
{
using (MsgContext context = new MsgContext())
{
if (string.IsNullOrEmpty(username))
return null;
if (!context.Users.Any(x => x.Username == username))
{
context.Users.Add(new User { Username = username, IsAdmin = false });
context.SaveChanges();
}
return context.Users.Single(x => x.Username == username);
}
}
public List<Comment> GetComments(int userId, Guid projectId, int sprint)
{
User user;
using (MsgContext context = new MsgContext())
{
user = context.Users.Find(userId);
}
List<Comment> cmts = null;
using (MsgContext context = new MsgContext())
{
var query = context.Comments.Where(x => x.Project == projectId && x.Sprint == sprint).Include(x => x.SprintActions).AsQueryable();
if (!user.IsAdmin)
query = query.Where(x => x.UserId == user.Id);
cmts = query.ToList();
}
cmts.ForEach(x=> x.User = user);
return cmts;
}
