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