public IHttpActionResult DeleteTask_Table(int id) { Task_Table task_Table = db.Task_Table.Find(id); if (task_Table == null) { return(NotFound()); } db.Task_Table.Remove(task_Table); db.SaveChanges(); return(Ok(task_Table)); }
public void GetSpecificTask() { var mockObj = new Mock <IRepository>(); var businessLayer = new BusinessLayer.TaskManager(mockObj.Object); var tasks = new Task_Table() { Task = "TestTest", Start_Date = DateTime.Now, End_Date = DateTime.Now.AddDays(7), Parent_ID = 5 }; mockObj.Setup(x => x.GetSpecificTask(It.IsAny <int>())).Returns(tasks); //Assert var actualTasks = businessLayer.GetSpecificTask(It.IsAny <int>()); Assert.AreEqual(tasks.Task, actualTasks.Task); }
public void AddTask(TaskModel taskDto) { //Repository repository = new Repository(); var task = new Task_Table(); task.Task = taskDto.Task; if (!string.IsNullOrEmpty(taskDto.ParentTask)) { ParentTask_Table ptask = new ParentTask_Table(); ptask.Parent_Task = taskDto.ParentTask; task.ParentTask_Table = ptask; } task.Priority = taskDto.Priority; task.Start_Date = Convert.ToDateTime(taskDto.StartDate); task.End_Date = Convert.ToDateTime(taskDto.EndDate); _repository.AddTask(task); }
public bool AddTask(TaskModel Task) { try { if (Task.isParentTask) { Parent_Task_Table parentTableData = new Parent_Task_Table(); Parent_Task_Table parentTable = new Parent_Task_Table { Parent_Task = Task.ParentTaskTitle }; parentTableData = dbContext.Parent_Task_Table.Add(parentTable); dbContext.SaveChanges(); } else if (Task.Task_ID == 0) { Parent_Task_Table parentTableData = new Parent_Task_Table(); Task_Table taskData = new Task_Table { Project_ID = Task.Project_ID, Task = Task.Task, Start_Date = Task.isParentTask ? null : Task.Start_Date, End_Date = Task.isParentTask ? null : Task.End_Date, Priority = Task.isParentTask ? null : (Task.Priority == null ? 0 : Task.Priority), Parent_ID = Task.isParentTask ? parentTableData.Parent_ID : Task.Parent_ID, Status = true }; var taskAdded = dbContext.Task_Table.Add(taskData); dbContext.SaveChanges(); var userData = dbContext.Users_Table.Where(c => c.User_ID == Task.User_ID).FirstOrDefault(); if (userData != null) { userData.Task_ID = taskAdded.Task_ID; dbContext.SaveChanges(); } } else { var taskData = dbContext.Task_Table.Where(c => c.Task_ID == Task.Task_ID).First(); if (taskData != null) { taskData.Project_ID = Task.Project_ID; taskData.Task = Task.Task; taskData.Start_Date = Task.isParentTask ? null : Task.Start_Date; taskData.End_Date = Task.isParentTask ? null : Task.End_Date; taskData.Priority = Task.isParentTask ? null : (Task.Priority == null ? 0 : Task.Priority); taskData.Parent_ID = Task.isParentTask ? null : Task.Parent_ID; taskData.Status = true; dbContext.SaveChanges(); var userData = dbContext.Users_Table.Where(c => c.User_ID == Task.User_ID).FirstOrDefault(); if (userData != null) { userData.Task_ID = Task.Task_ID; dbContext.SaveChanges(); } } } } catch (Exception e) { return(false); } return(true); }
public IHttpActionResult PostTask_Table(ParentTaskView pt) { if (pt.IsActive == null) { if (pt.Task_ID == null) { Parent_Task_Table p = new Parent_Task_Table(); Task_Table t = new Task_Table(); //Parent Task Table insert p.Parent_Task = pt.Parent_Task; db.Parent_Task_Table.Add(p); db.SaveChanges(); int latestParentId = Convert.ToInt32(p.Parent_ID); //Task Table insert t.Parent_ID = latestParentId; t.Task = pt.Task; t.Start_Date = Convert.ToDateTime(pt.Start_Date); t.End_Date = pt.End_Date; t.Priority = Convert.ToInt32(pt.Priority); db.Task_Table.Add(t); // System.IO.File.WriteAllText(@"D:\taskapilog2.txt","Add method success"); db.SaveChanges(); } else if (pt.Task_ID != null) { int?latestParentId = null; Parent_Task_Table p = new Parent_Task_Table(); //System.IO.File.WriteAllText(@"D:\taskapilogUp.txt", "Update method"); if (pt.Parent_ID == null) { //Parent Task Table insert p.Parent_Task = pt.Parent_Task; db.Parent_Task_Table.Add(p); db.SaveChanges(); latestParentId = Convert.ToInt32(p.Parent_ID); } else { //System.IO.File.WriteAllText(@"D:\taskapilogUp1.txt", pt.Parent_ID + ""); var ParentTask_TableInDb = db.Parent_Task_Table.SingleOrDefault(p1 => p1.Parent_ID == pt.Parent_ID); if (ParentTask_TableInDb == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } //Parent Task Table update ParentTask_TableInDb.Parent_Task = pt.Parent_Task; db.SaveChanges(); } var Task_TableInDb = db.Task_Table.SingleOrDefault(c => c.Task_ID == pt.Task_ID); if (Task_TableInDb == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } //Task Table update if (latestParentId != null) { Task_TableInDb.Parent_ID = latestParentId; } Task_TableInDb.Task = pt.Task; Task_TableInDb.Start_Date = Convert.ToDateTime(pt.Start_Date); Task_TableInDb.End_Date = pt.End_Date; Task_TableInDb.Priority = Convert.ToInt32(pt.Priority); // System.IO.File.WriteAllText(@"D:\taskapilog2.txt","Add method success"); db.SaveChanges(); } } else if (pt.IsActive == "N") { //End Task Code var Task_TableIndb = db.Task_Table.SingleOrDefault(c1 => c1.Task_ID == pt.Task_ID); if (Task_TableIndb == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } Task_TableIndb.IsActive = pt.IsActive; db.SaveChanges(); } // return CreatedAtRoute("DefaultApi", new { id = t.Task_ID }, pt); return(Ok()); }