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