//Get task details by id public TaskParentDetail Get(int id) { TaskParentDetail objtaskParentDetailNew = new TaskParentDetail(); using (CapsuleEntities1 db = new CapsuleEntities1()) { List <ParentTask> listParent = db.ParentTasks.ToList(); List <TaskDetail> listTask = db.TaskDetails.ToList(); var r4 = from i in listTask join i2 in listParent on i.Parent_Id equals i2.Parent_Id where i.Id == id select new { i.Id, i.Parent_Id, i.Range, i.Start_Date, i.End_Date, i.Task_Name, i2.Parent_Task_Name }; foreach (var item in r4) { objtaskParentDetailNew.id = item.Id; objtaskParentDetailNew.Parent_Id = item.Parent_Id.Value; objtaskParentDetailNew.parentTaskName = item.Parent_Task_Name; objtaskParentDetailNew.Range = item.Range.Value; objtaskParentDetailNew.Start_Date = item.Start_Date.Value; objtaskParentDetailNew.End_Date = item.End_Date.Value; objtaskParentDetailNew.Task_Name = item.Task_Name; } } return(objtaskParentDetailNew); }
public void GetTaskDetailByIdPass() { TaskParentDetail objTaskParentDetail = new TaskParentDetail(); objTaskParentDetail.Parent_Id = 2; objTaskParentDetail.Range = 30; objTaskParentDetail.Task_Name = "Task 3"; objTaskParentDetail.parentTaskName = "Parent Task 2"; objTaskParentDetail.Start_Date = DateTime.Parse("Jan 1, 2017"); objTaskParentDetail.End_Date = DateTime.Parse("Jan 1, 2018"); TaskBusiness objTaskBusiness = new TaskBusiness(); TaskParentDetail objTaskParentDetailNew = new TaskParentDetail(); objTaskParentDetailNew = objTaskBusiness.GetTask(3); Assert.AreEqual(objTaskParentDetailNew, objTaskParentDetail); }
public void GetTaskDetailsFail() { List <TaskParentDetail> li1 = new List <TaskParentDetail>(); TaskParentDetail objTaskParentDetail = new TaskParentDetail(); objTaskParentDetail.id = 1; objTaskParentDetail.Parent_Id = 1; objTaskParentDetail.Range = 10; objTaskParentDetail.Task_Name = "Task 1"; objTaskParentDetail.parentTaskName = "Parent Task 1"; objTaskParentDetail.Start_Date = DateTime.Parse("Jan 1, 2018"); objTaskParentDetail.End_Date = DateTime.Parse("Jan 1, 2019"); li1.Add(objTaskParentDetail); TaskBusiness objTaskBusiness = new TaskBusiness(); li = objTaskBusiness.GetTasks(); Assert.AreEqual(li1, li); }