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