public IActionResult GetByTaskID(int TaskID) { //Get task from database MvcTaskManager.Models.Task task = db.Tasks .Include(temp => temp.CreatedByUser) .Include(temp => temp.AssignedToUser) .Include(temp => temp.Project).ThenInclude(temp => temp.ClientLocation) .Include(temp => temp.TaskStatusDetails) .Include(temp => temp.TaskPriority) .Where(temp => temp.TaskID == TaskID) .FirstOrDefault(); if (task != null) { //Date conversion task.CreatedOnString = task.CreatedOn.ToString("dd/MM/yyyy"); task.LastUpdatedOnString = task.LastUpdatedOn.ToString("dd/MM/yyyy"); foreach (var item2 in task.TaskStatusDetails) { item2.StatusUpdationDateTimeString = item2.StatusUpdationDateTime.ToString("dd/MM/yyyy"); } return(Ok(task)); } else { return(NoContent()); } }
public IActionResult Post([FromBody] MvcTaskManager.Models.Task task) { task.Project = null; task.CreatedByUser = null; task.AssignedToUser = null; task.TaskPriority = null; task.TaskStatusDetails = null; task.CreatedOn = DateTime.Now; task.LastUpdatedOn = DateTime.Now; task.CurrentStatus = "Holding"; task.CurrentTaskStatusID = 1; task.CreatedOnString = task.CreatedOn.ToString("dd/MM/yyyy"); task.LastUpdatedOnString = task.LastUpdatedOn.ToString("dd/MM/yyyy"); task.CreatedBy = User.Identity.Name; db.Tasks.Add(task); db.SaveChanges(); TaskStatusDetail taskStatusDetail = new TaskStatusDetail(); taskStatusDetail.TaskID = task.TaskID; taskStatusDetail.UserID = task.CreatedBy; taskStatusDetail.TaskStatusID = 1; taskStatusDetail.StatusUpdationDateTime = DateTime.Now; taskStatusDetail.TaskStatus = null; taskStatusDetail.User = null; taskStatusDetail.Description = "Task Created"; db.TaskStatusDetails.Add(taskStatusDetail); db.SaveChanges(); MvcTaskManager.Models.Task existingTask = db.Tasks.Where(temp => temp.TaskID == task.TaskID).FirstOrDefault(); return(Ok(existingTask)); }
public IActionResult Updatetask([FromBody] TaskViewModel taskViewModel) { //Update existing task MvcTaskManager.Models.Task existingTask = db.Tasks.Where(temp => temp.TaskID == taskViewModel.TaskID).FirstOrDefault(); if (existingTask != null) { existingTask.TaskName = taskViewModel.TaskName; existingTask.Description = taskViewModel.Description; existingTask.ProjectID = taskViewModel.ProjectID; existingTask.TaskPriorityID = taskViewModel.TaskPriorityID; existingTask.AssignedTo = taskViewModel.AssignedTo; existingTask.LastUpdatedOn = DateTime.Now; db.SaveChanges(); return(Ok(taskViewModel)); } else { return(NoContent()); } }
public IActionResult UpdateTaskStatus([FromBody] TaskStatusDetail taskStatusDetail) { //Insert task status detail taskStatusDetail.UserID = User.Identity.Name; taskStatusDetail.StatusUpdationDateTime = DateTime.Now; taskStatusDetail.StatusUpdationDateTimeString = taskStatusDetail.StatusUpdationDateTime.ToString("dd/MM/yyyy"); taskStatusDetail.TaskStatus = null; taskStatusDetail.User = null; db.TaskStatusDetails.Add(taskStatusDetail); db.SaveChanges(); //Update existing task MvcTaskManager.Models.Task existingTask = db.Tasks.Where(temp => temp.TaskID == taskStatusDetail.TaskID).FirstOrDefault(); existingTask.LastUpdatedOn = DateTime.Now; existingTask.CurrentStatus = db.TaskStatuses.Where(temp => temp.TaskStatusID == taskStatusDetail.TaskStatusID).FirstOrDefault().TaskStatusName; existingTask.CurrentTaskStatusID = taskStatusDetail.TaskStatusID; db.SaveChanges(); return(Ok(taskStatusDetail)); }