public IHttpActionResult PutUser(int id, User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user.User_ID) { return(BadRequest()); } //db.Entry(user).State = EntityState.Modified; db.MarkAsModified(user); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostParent_Task(Parent_Task parent_Task) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Parent_Task.Add(parent_Task); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = parent_Task.Parent_ID }, parent_Task)); }
public IHttpActionResult PutProject(int id, ProjectDetailModel projectModal) { if (id != projectModal.Project_Id) { return(BadRequest()); } var project = new Project(); var config = new MapperConfiguration(cfg => { cfg.CreateMap <ProjectDetailModel, Project>(); }); IMapper iMapper = config.CreateMapper(); project = iMapper.Map <ProjectDetailModel, Project>(projectModal); //db.Entry(project).State = EntityState.Modified; db.MarkAsModified(project); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } var changeUser = db.Users.Where(x => x.Project_ID == project.Project_Id).FirstOrDefault(); changeUser.Project_ID = null; try { db.SaveChanges(); } catch (Exception ex) { throw ex; } var user = db.Users.Find(projectModal.User_ID); user.Project_ID = project.Project_Id; try { db.SaveChanges(); } catch (Exception ex) { throw ex; } return(StatusCode(HttpStatusCode.NoContent)); }
public DbContextFixture() { var options = new DbContextOptionsBuilder <ProjectManagerContext>() .UseInMemoryDatabase("BijithFinalSBA") .Options; dbContext = new ProjectManagerContext(options); dbContext.Tasks.Add(new Task { TaskName = "Test task", Priority = 10, StartDate = DateTime.Now.Date, EndDate = DateTime.Now.AddDays(10).Date }); dbContext.Users.Add(new User { EmployeeId = "1234", FirstName = "Test user", LastName = "Test" }); dbContext.Projects.Add(new Project { ProjectName = "Test project", Priority = 10, StartDate = DateTime.Now.Date, EndDate = DateTime.Now.AddDays(10).Date, ManagerId = 1 }); dbContext.SaveChanges(); }
public IHttpActionResult PutTask(int id, Task task) { db.MarkAsModified(task); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { throw; } var changeUser = db.Users.Where(x => x.Task_ID == task.Task_ID).FirstOrDefault(); changeUser.Task_ID = null; try { db.SaveChanges(); } catch (Exception ex) { throw ex; } var user = db.Users.Find(task.User_ID); user.Task_ID = task.Task_ID; try { db.SaveChanges(); } catch (Exception ex) { throw ex; } return(StatusCode(HttpStatusCode.NoContent)); }
public int AddProject(Project project) { _context.Projects.Add(project); _context.SaveChanges(); return(project.Id); }
public int CreateNewTask(Task taskDetails) { _dataContext.Tasks.Add(taskDetails); _dataContext.SaveChanges(); return(taskDetails.TaskId); }
public int CreateNew(Project objDetails) { _dataContext.Projects.Add(objDetails); _dataContext.SaveChanges(); return(objDetails.ProjectId); }
public void AddTask(Task task) { _context.Tasks.Add(task); _context.SaveChanges(); }
public void AddUser(User user) { _context.Users.Add(user); _context.SaveChanges(); }
public int CreateNew(User objDetails) { _context.Users.Add(objDetails); _context.SaveChanges(); return objDetails.UserId; }
public int AddUser(User user) { _context.Users.Add(user); _context.SaveChanges(); return(user.Id); }
public int AddTask(Task item) { _context.Tasks.Add(item); _context.SaveChanges(); return(item.Id); }
public void AddProject(Entities.Project project) { _context.Projects.Add(project); _context.SaveChanges(); }