public string CreateProject(UserProject uservmproject)
{
using (ProjectTrackerContext dbcontxt = new ProjectTrackerContext())
{
dbcontxt.Projects.Add(uservmproject.userProject);
dbcontxt.SaveChanges();
var project = db.Projects.OrderByDescending(p => p.Project_ID).FirstOrDefault();
return(UpdateUser(Convert.ToInt32(uservmproject.employyeId), project.Project_ID));
}
}
public string CreateParentTask(ParentTask parentTask)
{
try
{
using (ProjectTrackerContext dbcontxt = new ProjectTrackerContext())
{
dbcontxt.ParentTasks.Add(parentTask);
dbcontxt.SaveChanges();
}
return("SUCCESS");
}
catch (Exception)
{
return("FAIL");
}
}
public string CreateTask(TaskVm task)
{
using (ProjectTrackerContext dbcontxt = new ProjectTrackerContext())
{
dbcontxt.Tasks.Add(task.task);
dbcontxt.SaveChanges();
//Fetch the TaskId created
var addedtask = dbcontxt.Tasks.OrderByDescending(t => t.Task_ID).FirstOrDefault();
//Fetch the projectid to associate the task
var project = dbcontxt.Projects.FirstOrDefault(p => p.Project_ID == task.projectid);
var parentTask = dbcontxt.ParentTasks.FirstOrDefault(p => p.Parent_ID == task.parentTaskId);
//Revisit the logic tomorrow
if (parentTask == null)
{
return(UpdateTask(project.Project_ID, null, addedtask.Task_ID, task.userId));
}
return(UpdateTask(project.Project_ID, parentTask.Parent_ID, addedtask.Task_ID, task.userId));
}
}
public string CreateParentTask(TaskVm parentTask)
{
try
{
using (ProjectTrackerContext dbcontxt = new ProjectTrackerContext())
{
var pTask = new ParentTask {
Parent_Task = parentTask.task.TaskName
};
dbcontxt.ParentTasks.Add(pTask);
dbcontxt.SaveChanges();
//Fetch the ParentTaskId created
var addedparenttask = dbcontxt.ParentTasks.OrderByDescending(t => t.Parent_ID).FirstOrDefault();
//Fetch the projectid to associate the task
var project = dbcontxt.Projects.FirstOrDefault(p => p.Project_ID == parentTask.projectid);
return(UpdateTaskWithParent(project.Project_ID, addedparenttask.Parent_ID, parentTask.task, parentTask.userId));
}
}
catch (Exception)
{
return("FAIL");
}
}
public IssueController(ProjectTrackerContext context) : base(context)
{
}
public BaseController(ProjectTrackerContext context)
{
_context = context;
}
public ProjectService()
{
db = new ProjectTrackerContext();
}
public User()
{
db = new ProjectTrackerContext();
}
