private void SetupUserAndTicket(Guid userId, Guid ticketId, TrackilyContext context)
{
var user = new TrackilyUser()
{
Id = userId,
UserName = MockUsername,
CreatedTickets = new List <Ticket>(),
AssignedTo = new List <UserTicket>()
};
context.Users.Add(user);
context.SaveChanges();
var userSaved = context.Users.Find(userId);
var ticket = new Ticket()
{
Project = new Project(),
Creator = userSaved,
TicketId = ticketId,
Assigned = new List <UserTicket>()
};
context.Tickets.Add(ticket);
context.SaveChanges();
}
public ProjectsController(
ProjectService projectService, IAuthorizationService authService, TrackilyContext context)
{
_projectService = projectService;
_authService = authService;
_context = context;
}
private TrackilyContext GetDb()
{
var options = TrackilyContextTest.GetInMemoryDbContextOptions();
var context = new TrackilyContext(options);
context.Database.EnsureCreated();
return(context);
}
public TicketService(UserManager <TrackilyUser> userManager,
TrackilyContext context,
UserTicketService userTicketService,
UserProjectService userProjectService)
{
_userManager = userManager;
_userTicketService = userTicketService;
_context = context;
_userProjectService = userProjectService;
}
// Ticket validation helper methods.
public static bool SomeUsersDoNotExist(List <string> usernames, TrackilyContext context)
{
foreach (string username in usernames.Where(u => u != null))
{
if (!context.Users.Any(u => u.UserName == username))
{
return(true);
}
}
return(false);
}
public TicketsController(
TrackilyContext context,
TicketService ticketService,
CommentService commentService,
IAuthorizationService authService,
UserManager <TrackilyUser> userManager)
{
_context = context;
_ticketService = ticketService;
_commentService = commentService;
_authService = authService;
_userManager = userManager;
}
public void DeletingProject_DeletesAssociatedTickets()
{
var projectId = Guid.NewGuid();
var ticketId = Guid.NewGuid();
var project = new Project
{
ProjectId = projectId,
Tickets = new List <Ticket>()
};
project.Tickets.Add(new Ticket
{
TicketId = ticketId,
});
var options = GetInMemoryDbContextOptions();
using (var context = new TrackilyContext(options))
{
context.Database.EnsureCreated();
context.Projects.Add(project);
context.SaveChanges();
}
using (var context = new TrackilyContext(options))
{
var projectSaved = context.Projects.Include(p => p.Tickets).Single(p => p.ProjectId == projectId);
Assert.NotNull(projectSaved);
var ticketSaved = projectSaved.Tickets.ToList()[0];
Assert.NotNull(ticketSaved);
context.Projects.Remove(projectSaved);
context.SaveChanges();
}
using (var context = new TrackilyContext(options))
{
var projects = context.Projects.ToList();
Assert.Empty(projects);
var tickets = context.Tickets.ToList();
Assert.Empty(tickets);
}
}
public UserTicketService(TrackilyContext context)
{
_context = context;
}
public static bool ProjectTitleInUse(string title, TrackilyContext context)
{
return(context.Projects.Any(p => p.Title == title));
}
// Project validation helper methods.
public static bool NotChangingProjectTitle(string title, Guid projectId, TrackilyContext context)
{
// Load project from database and check whether its current title matches the POSTed title.
return(context.Projects.Single(p => p.ProjectId == projectId).Title == title);
}
public static bool TicketTitleInUse(string title, TrackilyContext context)
{
return(context.Tickets.Any(t => t.Title == title));
}
public static bool NotChangingTicketTitle(string title, Guid ticketId, TrackilyContext context)
{
// Load ticket from database and check whether its current title matches the POSTed title.
return(context.Tickets.Single(t => t.TicketId == ticketId).Title == title);
}
public ProjectDetailsPrivilegesProjectIdHandler(TrackilyContext context, UserManager <TrackilyUser> userManager)
{
_context = context;
_userManager = userManager;
}
public void DeletingTicket_DeletesUserTicket()
{
var ticketId = Guid.NewGuid();
var userId = Guid.NewGuid();
var options = GetInMemoryDbContextOptions();
using (var context = new TrackilyContext(options))
{
context.Database.EnsureCreated();
var user = new TrackilyUser()
{
Id = userId,
CreatedTickets = new List <Ticket>(),
AssignedTo = new List <UserTicket>()
};
context.Users.Add(user); // User must exist in the database before creating a Ticket/UserTicket due to FK constraint.
context.SaveChanges();
}
using (var context = new TrackilyContext(options))
{
var userSaved = context.Users.Find(userId);
Assert.NotNull(userSaved);
var ticket = new Ticket()
{
Project = new Project(),
Creator = userSaved,
TicketId = ticketId,
Assigned = new List <UserTicket>()
};
var userTicket = new UserTicket()
{
Id = userId,
TicketId = ticketId,
Ticket = ticket,
User = userSaved
};
ticket.Assigned.Add(userTicket);
context.Tickets.Add(ticket);
context.SaveChanges();
}
using (var context = new TrackilyContext(options))
{
var ticketSaved = context.Tickets.Find(ticketId);
Assert.NotNull(ticketSaved);
var userTicketSaved = context.UserTickets.Find(userId, ticketId);
Assert.NotNull(userTicketSaved);
context.Tickets.Remove(ticketSaved);
context.SaveChanges();
}
using (var context = new TrackilyContext(options))
{
var tickets = context.Tickets.ToList();
Assert.Empty(tickets);
var userTickets = context.UserTickets.ToList();
Assert.Empty(userTickets);
}
}
public UserProjectService(TrackilyContext context)
{
_context = context;
}
public CommentService(UserManager <TrackilyUser> userManager, TrackilyContext context)
{
_userManager = userManager;
_context = context;
}
