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