//Delete the Project on the basis of the projectID
public static List<ProjectTask> DeleteProject(ProjectTask p)
{
var proj = (from projectTask in dataContext.ProjectTasks
where projectTask.ProjectTaskID == p.ProjectTaskID
select projectTask).SingleOrDefault();
dataContext.ProjectTasks.Remove(proj);
dataContext.SaveChanges();
return GetAllProjectTasks();
}
//Update the Project on the basis of the projectID
public static List<ProjectTask> UpdateProject(ProjectTask p)
{
//get the details of the project
var proj = (from projectTask in dataContext.ProjectTasks
where projectTask.ProjectTaskID == p.ProjectTaskID
select projectTask).SingleOrDefault();
proj.AssignedTo = p.AssignedTo;
proj.TaskStartDate = p.TaskStartDate;
proj.TaskEndDate = p.TaskEndDate;
proj.TaskCompletion = p.TaskCompletion;
proj.UserStoryID = p.UserStoryID;
dataContext.SaveChanges();
return GetAllProjectTasks();
}
//Insert Project
public static List<ProjectTask> InsertProjectTask(ProjectTask p)
{
dataContext.ProjectTasks.Add(p);
dataContext.SaveChanges();
return GetAllProjectTasks();
}
