public ProjectController InitProjectController(BugTrackingContext context)
{
var controller = new ProjectController(context);
controller.ControllerContext = new ControllerContext();
controller.ControllerContext.HttpContext = new DefaultHttpContext();
return(controller);
}
public TaskController InitTaskController(BugTrackingContext context)
{
var controller = new TaskController(context);
controller.ControllerContext = new ControllerContext();
controller.ControllerContext.HttpContext = new DefaultHttpContext();
return(controller);
}
public async Task <User> Update(User user)
{
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Update(). Updating user: {0}.", user.UserLogin);
ctx.Entry(user).State = EntityState.Modified;
await ctx.SaveChangesAsync();
}
_logger.Debug("Update(). User {0} have updated.", user.UserLogin);
return(user);
}
public async Task <Project> Update(Project project)
{
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Update(). Updating Project: {0}.", project.Name);
ctx.Entry(project).State = EntityState.Modified;
await ctx.SaveChangesAsync();
}
_logger.Debug("Update(). Project {0} have updated.", project.Name);
return(project);
}
public BugTrackingContext InitContext(IEnumerable <ProjectItem> projectItems, string dbName)
{
var builder = new DbContextOptionsBuilder <BugTrackingContext>()
.UseInMemoryDatabase(dbName);
var context = new BugTrackingContext(builder.Options);
context.ProjectItems.AddRange(projectItems);
int changed = context.SaveChanges();
return(context);
}
public async Task <IEnumerable <Project> > GetAll()
{
var result = new List <Project>();
using (var ctx = new BugTrackingContext())
{
_logger.Debug("GetAll(). Getting All Projects.");
result = await ctx.Projects.ToListAsync();
}
_logger.Debug("GetAll(). Get amount {0} projects.", result.Count);
return(result);
}
public async Task <UsersTask> Get(int id)
{
UsersTask result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Get(). Getting task by id: {0}.", id);
result = await ctx.UsersTasks.Include(u => u.Project).Include(u => u.User).FirstOrDefaultAsync(p => p.Id == id);
}
_logger.Debug("Get(). Task Name = {0} have get.", result.Topic);
return(result);
}
public async Task <IEnumerable <UsersTask> > GetAll()
{
var result = new List <UsersTask>();
using (var ctx = new BugTrackingContext())
{
_logger.Debug("GetAll(). Getting All Tasks.");
result = await ctx.UsersTasks.Include(u => u.Project).Include(u => u.User).ToListAsync();
}
_logger.Debug("GetAll(). Get amount {0} tasks.", result.Count);
return(result);
}
public async Task <Project> Get(int id)
{
Project result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Get(). Getting project by id: {0}.", id);
result = await ctx.Projects.FirstOrDefaultAsync(p => p.Id == id);
}
_logger.Debug("Get(). Project Name = {0} have get.", result.Name);
return(result);
}
public async Task Delete(int id)
{
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Delete(). Deleting user by id: {0}.", id);
var user = await ctx.Users.FirstOrDefaultAsync(p => p.Id == id);
ctx.Entry(user).State = EntityState.Deleted;
var a = await ctx.SaveChangesAsync();
}
_logger.Debug("Delete(). User deleted by id: {0}.", id);
}
public async Task <IEnumerable <User> > GetAll()
{
var result = new List <User>();
using (var ctx = new BugTrackingContext())
{
_logger.Debug("GetAll(). Getting All Users.");
result = await ctx.Users.ToListAsync();
_logger.Debug("GetAll(). Get amount {0} users.", result.Count);
}
return(result);
}
public async Task <User> Add(User user)
{
User result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Add(). Adding user: {0}.", user.UserLogin);
result = ctx.Users.Add(user);
await ctx.SaveChangesAsync();
}
_logger.Debug("Add(). User: {0} have added.", user.UserLogin);
return(result);
}
public async Task <User> Get(int id)
{
User result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Get(). Getting user by id: {0}.", id);
result = await ctx.Users.FirstOrDefaultAsync(p => p.Id == id);
}
_logger.Debug("Get(). User UserLogin = {0} have get.", result.UserLogin);
return(result);
}
public async Task <UsersTask> Update(UsersTask usersTask)
{
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Update(). Updating task: {0}.", usersTask.Topic);
ctx.Entry(usersTask).State = EntityState.Modified;
await ctx.SaveChangesAsync();
_logger.Debug("Update(). Task {0} have updated.", usersTask.Topic);
}
return(usersTask);
}
public async Task Delete(int id)
{
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Delete(). Deleting project by id: {0}.", id);
var project = await ctx.Projects.FirstOrDefaultAsync(p => p.Id == id);
ctx.Entry(project).State = EntityState.Deleted;
await ctx.SaveChangesAsync();
_logger.Debug("Delete(). Project deleted by id: {0}.", id);
}
}
public async Task <Project> Add(Project project)
{
Project result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Add(). Adding project {0}.", project.Name);
result = ctx.Projects.Add(project);
await ctx.SaveChangesAsync();
_logger.Debug("Add(). Project {0} have added.", project.Name);
}
return(result);
}
public async Task <UsersTask> Add(UsersTask usersTask)
{
UsersTask result = null;
using (var ctx = new BugTrackingContext())
{
_logger.Debug("Add(). Adding task {0}.", usersTask.Topic);
result = ctx.UsersTasks.Add(usersTask);
await ctx.SaveChangesAsync();
_logger.Debug("Add(). Task {0} have added.", usersTask.Topic);
}
return(result);
}
public ActionResult Configure(string connectionStrings)
{
var config = WebConfigurationManager.OpenWebConfiguration("~");
if (BugTrackingContext.GetConnectionString() != connectionStrings)
{
_logger.Warn("Connection string was changed from {0} to {1}",
WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString,
connectionStrings);
config.AppSettings.Settings["SessionConnectionStrings"].Value = connectionStrings;
config.Save();
}
return(RedirectToAction("Index"));
}
public TaskController(BugTrackingContext context)
{
_context = context;
}
public ApplicationDbContext()
: base(BugTrackingContext.GetConnectionString(), throwIfV1Schema: false)
{
}
public ProjectController(BugTrackingContext context)
{
_context = context;
}
// GET: Configure Connection Strings
public ActionResult Configure()
{
ViewBag.ConnectionStrings = BugTrackingContext.GetConnectionString();
return(View());
}
