public bool AddTask(Task task) { try { if (task.ParentTaskID != null) { if (task.ParentTaskID == 0) { task.ParentTaskID = null; task.ParentTaskName = null; } else { task.ParentTaskName = this.GetParentTasks().Where(x => x.Id == task.ParentTaskID).Select(x => x.Text).FirstOrDefault(); } } using (MyContext db = new MyContext()) { db.Tasks.Add(task); db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
public Task GetTaskByID(int taskID) { var Task = new Task(); using (MyContext db = new MyContext()) { var TaskDetails = (from T in db.Tasks where T.TaskID == taskID select new { T.TaskID, T.TaskName, T.ParentTaskID, T.ParentTaskName, T.StartDate, T.EndDate, T.Priority, T.Status }).FirstOrDefault(); if (TaskDetails != null) { Task.TaskID = TaskDetails.TaskID; Task.TaskName = TaskDetails.TaskName; Task.ParentTaskID = TaskDetails.ParentTaskID; Task.ParentTaskName = TaskDetails.ParentTaskName; Task.StartDate = TaskDetails.StartDate; Task.EndDate = TaskDetails.EndDate; Task.Priority = TaskDetails.Priority; Task.Status = TaskDetails.Status; } } return(Task); }
public void UpdateTaskTest_Success() { // Arrange var controller = new TaskController(); var model = new entities.Task { TaskID = 3, TaskName = "Test Task", ParentTaskID = 1, ParentTaskName = "Task1", Priority = 30, StartDate = DateTime.Today, EndDate = DateTime.Today.AddDays(10) }; // Act var response = controller.UpdateTask(model); // Assert var responseResult = response as OkNegotiatedContentResult <string>; Assert.IsNotNull(responseResult); Assert.IsNotNull(responseResult.Content); Assert.IsTrue(responseResult.Content == "Success"); }
public async Task <IActionResult> UpdateTask([FromBody] Task task) { if (await _taskService.GetTaskById(task.TaskId) != null) { return(Ok(await _taskService.UpdateTask(task))); //200+data } return(NotFound()); }
public bool EditTask(Task task) { try { if (task.ParentTaskID != null) { if (task.ParentTaskID == 0) { task.ParentTaskID = null; task.ParentTaskName = null; } else { task.ParentTaskName = this.GetParentTasks().Where(x => x.Id == task.ParentTaskID).Select(x => x.Text).FirstOrDefault(); } } using (MyContext db = new MyContext()) { var taskDB = (from t in db.Tasks where t.TaskID == task.TaskID select t).FirstOrDefault(); var ChildTaskDB = (from t in db.Tasks where t.ParentTaskID == task.TaskID && t.ParentTaskName != task.TaskName select t); if (taskDB != null) { taskDB.TaskName = task.TaskName; taskDB.ParentTaskID = task.ParentTaskID; taskDB.ParentTaskName = task.ParentTaskName; taskDB.StartDate = task.StartDate; taskDB.EndDate = task.EndDate; taskDB.Priority = task.Priority; taskDB.Status = task.Status; db.SaveChanges(); } if (ChildTaskDB != null) { foreach (var item in ChildTaskDB) { item.ParentTaskName = task.TaskName; } db.SaveChanges(); } return(true); } } catch (Exception) { return(false); } }
public IHttpActionResult UpdateTask(entities.Task editTask) { try { if (!ModelState.IsValid) { return(BadRequest()); } _TaskBO = new TaskBO(); _TaskBO.EditTask(editTask); return(Ok("Success")); } catch (Exception) { return(Ok("Error")); } }
public List <Task> SearchTask(TaskSearch search) { var Tasks = new List <Task>(); using (MyContext db = new MyContext()) { var TaskDetails = (from p in db.Tasks where (search.Task == null || search.Task == p.TaskName) && (search.ParentTaskID == null || search.ParentTaskID == 0 || search.ParentTaskID == p.ParentTaskID) && (search.Start_Date == null || search.Start_Date == p.StartDate) && (search.End_Date == null || search.End_Date == p.EndDate) && (search.PriorityFrom == null || search.PriorityFrom == p.Priority) && (search.PriorityTo == null || search.PriorityTo == p.Priority) select new { p.TaskID, p.TaskName, p.ParentTaskID, p.ParentTaskName, p.StartDate, p.EndDate, p.Priority, p.Status }).ToList(); foreach (var item in TaskDetails) { var T = new Task { TaskID = item.TaskID, TaskName = item.TaskName, ParentTaskID = item.ParentTaskID, ParentTaskName = item.ParentTaskName, StartDate = item.StartDate, EndDate = item.EndDate, Priority = item.Priority, Status = item.Status }; Tasks.Add(T); } } return(Tasks); }
public List <Task> GetAllTask() { var Tasks = new List <Task>(); using (MyContext db = new MyContext()) { var TaskDetails = (from p in db.Tasks select new { p.TaskID, p.TaskName, p.ParentTaskID, p.ParentTaskName, p.StartDate, p.EndDate, p.Priority, p.Status }).ToList(); foreach (var item in TaskDetails) { var T = new Task { TaskID = item.TaskID, TaskName = item.TaskName, ParentTaskID = item.ParentTaskID, ParentTaskName = item.ParentTaskName, StartDate = item.StartDate, EndDate = item.EndDate, Priority = item.Priority, Status = item.Status }; Tasks.Add(T); } } return(Tasks); }
static void Main(string[] args) { try { string input; Console.WriteLine("Select the Action No."); Console.WriteLine("1.Add Task"); Console.WriteLine("2.Update Task"); Console.WriteLine("3.Search Task"); Console.WriteLine("4.Delete Task"); Console.WriteLine("5.Exit"); input = Console.ReadLine(); TaskBL obj = new TaskBL(); switch (input) { case "1": obj.AddTask(new TaskManager.Entities.Task() { TaskId = 2, TaskName = "Task22", ParentTask = "Task11", Priority = 2, SDate = DateTime.Now, EDate = DateTime.Now, TaskEndFlag = true }); break; case "2": Console.WriteLine("Enter Task Id"); string ID_Update = Console.ReadLine(); TaskManager.Entities.Task TskUpdate = obj.GetById(Convert.ToInt32(ID_Update)); Console.WriteLine("Task Details Before Update:"); Console.WriteLine("Task ID : " + TskUpdate.TaskId.ToString() + "\n" + "Task Name : " + TskUpdate.TaskName.ToString() + "\n" + "Priority : " + TskUpdate.Priority.ToString() + "\n"); Console.WriteLine("Enter New TaskName"); TskUpdate.TaskName = Console.ReadLine(); obj.UpdateTask(TskUpdate); TskUpdate = obj.GetById(Convert.ToInt32(ID_Update)); Console.WriteLine("Task Details After Update:"); Console.WriteLine("Task ID : " + TskUpdate.TaskId.ToString() + "\n" + "Task Name : " + TskUpdate.TaskName.ToString() + "\n" + "Priority : " + TskUpdate.Priority.ToString() + "\n"); Console.ReadLine(); break; case "3": Console.WriteLine("Enter Task Id to Search"); String ID = Console.ReadLine(); TaskManager.Entities.Task TskSearch = obj.GetById(Convert.ToInt32(ID)); Console.WriteLine("Task Details:"); Console.WriteLine("Task ID : " + TskSearch.TaskId.ToString() + "/n" + "Task Name : " + TskSearch.TaskName.ToString() + "/n" + "Priority : " + TskSearch.Priority.ToString() + "/n" ); break; case "4": Console.WriteLine("Enter Task Id to Delete"); String ID_Del = Console.ReadLine(); obj.DeleteTask(Convert.ToInt32(ID_Del)); break; case "5": break; default: break; } } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }
public async Task <IActionResult> CreateTask([FromBody] Task task) { var createdTask = await _taskService.CreateTask(task); return(CreatedAtAction("Get", new { taskId = createdTask.TaskId }, createdTask)); //201+ data }